Data element |
Definition |
ACCOUNT_NUMBER
Indexed - yes
Format - char (6)
May be null? no |
A 6-digit number that identifies the account against which the project
expenditures were charged under the financial system in use before July
1, 1996. For budgetary purposes, Penn organized its financial records
by Account_Number and Subcode. The first digit of the Account_Number is
known as the ledger number. All Sponsored Project account numbers begin
with the ledger number five.
See also Subcode in the MONTHLY_EXPENDITURE Table.
Values:
520000 to 527999 Sponsored Projects Accounts
|
ADMIN_DEPT_CODE
Indexed - yes
Format - char (4)
May be null? yes |
Not currently used.
Values:
List of values not available.
|
ADMIN_SCHOOL_CODE
Indexed - yes
Format - char (4)
May be null? yes |
Not currently used.
Values:
List of values not available.
|
APPROVED_BUDGET
Indexed - no
Format - number (11,2)
May be null? yes |
The current budget for a specific Account_Number and Subcode.
For Sponsored Project accounts (accounts that begin with ledger number 5),
this is the current project budget.
Values:
$0.00 to $999,999,999.99
|
BBA_UNENCUMBERED_AMOUNT
Indexed - no
Format - number (11,2)
May be null? yes |
The balance of available funds as of the indicated month
not including any encumbered funds for an Account_Number and Subcode. The
project budget minus the expenditures and the encumbered funds is the budget
balance available unencumbered amount. Note that the balance of available
funds cannot exceed the total project budget minus the expenditures and
encumbrances.
Values:
$0.00 to $999,999,999.99
|
BUDGET_BALANCE_AVAILABLE
Indexed - no
Format - number (11,2)
May be null? yes |
The balance of available funds as of the indicated month
for an Account_Number and Subcode. The project budget minus the expenditures
is the budget balance available. Note that the budget balance available
cannot exceed the total project budget minus the expenditures.
Values:
$0.00 to $999,999,999.99
|
COMMITTED_AMOUNT
Indexed - no
Format - number (11,2)
May be null? yes |
The balance of committed dollars as of the indicated month
for an Account_Number and Subcode. The committed balance represents funds
that have been set aside but have not yet been expended for a specific planned
expenditure. Note that the commitment range cannot exceed the total project
budget.
Values:
$0.00 to $999,999,999.99
|
CURRENT_MONTH_EXPENDED
Indexed - no
Format - number (11,2)
May be null? yes |
The dollars expended-to-date for the indicated month for
an Account_Number and Subcode. Note that expenditures cannot exceed the
total project budget.
Values:
$0.00 to $999,999,999.99
|
DELETE_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether an Account_Number and Subcode are deleted.
Values:
Y Account_Number/Subcode flagged for deletion
[Null] Account_Number/Subcode reinstated or never
deleted
|
ENCUMBERED_AMOUNT
Indexed - no
Format - number (11,2)
May be null? yes |
The balance of encumbered dollars as of the indicated month for an Account_Number
and Subcode. The encumbered balance represents funds that have been encumbered
but have not yet been expended for a specific approved planned expenditure.
These funds cannot be used for any other purpose, unless the encumbrance
is removed. Note that the encumbrance range cannot exceed the total project
budget.
Values:
$0.00 to $999,999,999.99
|
FIN_DEPT_CODE
Indexed - yes
Format - char (5)
May be null? yes
|
The 5-character code identifying the department that is responsible for
administering the Account_Number and Subcode. FIN_DEPT_CODE is stored
in the format used to identify departments in the financial system that
was used at Penn before July 1, 1996. Note: This is not the same as the
Organization code used in the present General Ledger accounting structure
(in use at Penn since July 1, 1996). Example: 11057 (MARKETING)
Values:
Refer to the FINANCIAL_DEPARTMENT Table for values.
|
FIN_SCHOOL_CODE
Indexed - yes
Format - char (2)
May be null? yes
|
The 2-character code identifying the school or center that is responsible
for administering the Account_Number and Subcode. FIN_SCHOOL_CODE is stored
in the format used to identify schools and centers in the financial system
that was used at Penn before July 1, 1996. Note: This is not the same
as the school/center code in the present General Ledger accounting structure
(in use at Penn since July 1, 1996). Example: 35 (SOCIAL WORK).
Values:
Refer to the FINANCIAL_SCHOOL Table for values.
|
FISCAL_YEAR
Indexed - yes
Format - char (4)
May be null? no |
The fiscal year. Penn's fiscal year begins July 1 of one year and ends
June 30 of the next year. For example: fiscal year 1995 began July 1,
1994 and ended June, 30, 1995.
Values:
Any year since the founding of Penn.
|
FREEZE_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether an Account_Number and Subcode are frozen. No activity
is processed against a frozen Account_Number and Subcode.
Values:
Y Account_Number/Subcode are frozen
[Null] Account_Number/Subcode have been reinstated
or were never frozen
|
FYTD_DOLLARS_EXPENDED
Indexed - no
Format - number (11,2)
May be null? yes |
The fiscal year-to-date dollars expended for an Account_Number and Subcode.
Note that expenditures cannot exceed the total project budget.
Values:
$0.00 to $999,999,999.99
|
LAST_EXTRACT_DATE
Indexed - no
Format - date
May be null? yes |
The date on which this row of data was last extracted from the source
database. This information is stored in the Warehouse in date format.
In Business Objects, it is displayed as specified in the desktop operating
system settings. It is recommended that users specify a date format that
includes 4 digits for the year. (To specify the date format in Windows
95, choose the Regional Settings of the Control Panel, select the Date
tab and specify the Short date style. In Windows, use the International
option of the Control Panel. On the Macintosh, use the Date & Time
Control Panel.) Example: 09/28/1995
Values:
List of values not available.
|
MONTH
Indexed - yes
Format - char (2)
May be null? no |
A 2-digit number that identifies the month-end closing that the financial
data represents. The month that is identified is the actual calendar month
and the year that is identified is the fiscal year and not the calendar
year.
In the following examples, because Penn's fiscal year begins July 1 of
one year and ends June 30 of the next year, the month-end closing expenditures
represented for fiscal year 1995 and month 07 would be identified as calendar
month July and calendar year 1994 and month-end closing expenditures represented
for fiscal year 1995 and month 01 would be identified as calendar month
January and calendar year 1995.
Values:
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
13 13th Month Financial Close (occurs mid-July)
14 14th Month Financial Close (occurs mid-Sept.)
|
PROPOSED_BUDGET
Indexed - no
Format - number (11,2)
May be null? yes |
The original budget for a specific Account_Number and Subcode. For Sponsored
Project accounts (accounts that begin with ledger number 5), this is the
project budget.
Values:
$0.00 to $999,999,999.99
|
PTD_DOLLARS_EXPENDED
Indexed - no
Format - number (11,2)
May be null? yes |
The project-to-date dollars expended for an Account_Number and Subcode.
Note that project dollar expenditures cannot exceed the total project
budget.
Values:
$0.00 to $999,999,999.99
|
REVIEW_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether an Account_Number and Subcode are under review.
Values:
Y Account_Number/Subcode are under review
[Null] Account_Number/Subcode have been reinstated
or were never under review
|
SUBCODE
Indexed - yes
Format - char (3)
May be null? no |
A 3-digit number that categorizes individual revenues and expenses for
a specific Account_Number under the financial system in use before July
1, 1996.. For budgetary purposes, Penn organized its financial records
by Account_Number and Subcode.
See also Account_Number in the MONTHLY_EXPENDITURE Table.
Values:
100 to 899 Sponsored Projects Account Expenditures
|