| 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 PROJECT_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.
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 not including any encumbered
funds for a specific 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 for a specific 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 for a specific Account_Number
and Subcode. The committed amount represents funds that have been set aside
but have not yet been expended for a specific planned expenditure. Note
that the committed amount 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 within the current month for
a specific 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 for a specific Account_Number and Subcode.
The encumbered balance represents funds that have been encumbered but
have not yet been expended for a specific planned approved expenditure.
Note that the encumbered amount 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.
|
PROPOSED_BUDGET
Indexed - no
Format - number (11,2)
May be null? yes |
The original budget for a specific Account_Number and Subcode.
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
|
QTR_1_EXPENDED
Indexed - no
Format - number (11,2)
May be null? yes |
The dollars expended to date within the first quarter of the fiscal year
for a specific Account_Number and Subcode. The first quarter consists
of July, August, and September. Note that expenditures cannot exceed the
total project budget.
Values:
$0.00 to $999,999,999.99
|
QTR_2_EXPENDED
Indexed - no
Format - number (11,2)
May be null? yes |
The dollars expended to date within the second quarter of
the fiscal year for a specific Account_Number and Subcode. The second quarter
consists of October, November, and December. Note that expenditures cannot
exceed the total project budget.
Values:
$0.00 to $999,999,999.99
|
QTR_3_EXPENDED
Indexed - no
Format - number (11,2)
May be null? yes |
The dollars expended to date within the third quarter of the
fiscal year for a specific Account_Number and Subcode. The third quarter
consists of January, February, and March. Note that expenditures cannot
exceed the total project budget.
Values:
$0.00 to $999,999,999.99
|
QTR_4_EXPENDED
Indexed - no
Format - number (11,2)
May be null? yes |
The dollars expended to date within the fourth quarter of
the fiscal year for a specific Account_Number and Subcode. The fourth quarter
consists of April, May, and June. Note that 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 PROJECT_EXPENDITURE Table.
Values:
100 to 899 Sponsored Projects Account Expenditures
|
