| Data element |
Definition |
BLDG_CODE
Indexed - yes
Format - varchar2(16)
May be null? no |
Unique identifier for a building. Four digits, zero filled, for older buildings; five digits for newer buildings constructed since the implementation of FacilityCenter.
|
CATEGORY_TYPE
Indexed - yes
Format - varchar2(1)
May be null? no |
Indicates whether the record contains actual (A) or budget (B) balances.
|
| FISCAL_MONTH_SEQ
Indexed - yes
Format - char(2)
May be null? no
|
The month (or accounting period) of the fiscal year. This field is used for sorting.
Examples: 01 (July); 11 (May). See also FISCAL_YEAR
Values:
01 July
02 August
03 September
04 October
05 November
06 December
07 January
08 February
09 March
10 April
11 May
12 June
13 Adjustment period
|
| FISCAL_YEAR
Indexed - yes
Format - char(4)
May be null? no
|
The financial year in which the ACCOUNTING_PERIOD falls. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.
Example: 2000 (fiscal year that began July 1, 1999, and ended June 30, 2000)
Values:
List of values not available.
|
FYTD
Indexed - no
Format - number(18)
May be null? yes |
The fiscal year-to-date dollar amount.
|
FY_TOTAL
Indexed - no
Format - number(18)
May be null? yes |
The fiscal year total dollar amount. Applies only to rows with the B (budget) category type, as actuals are not known in advance.
|
MTD
Indexed - no
Format - number(18)
May be null? yes |
The month-to-date dollar amount.
|
OFFSETSUB_CODE
Indexed - yes
Format - varchar2(4)
May be null? no |
The offset sub_code - indicates whether the record is for Housekeeping, Trades or Utilites ORGs.. |
ORDER_TYPE
Indexed - yes
Format - varchar2(1)
May be null? no |
The work order type (e.g. COM - Customer Building O&M, CPW - Customer Project Work, NON - Allocated Cost Building, Utilities). |
PR_FYTD
Indexed - no
Format - number(18)
May be null? yes |
The fiscal year-to-date dollar amount for the same period in the pervious fiscal year. |
PR_MTD
Indexed - no
Format - number(18)
May be null? yes |
The month-to-date dollar amount for the same period in the pervious fiscal year. |
SUBLEDGER
Indexed - yes
Format - varchar2(1)
May be null? no |
The Facilities subledger code. |
SUBLEDGER_DESC
Indexed - yes
Format - varchar2(1)
May be null? no |
The description corresponding to the subledger code (e.g., C - Contract, M - Materials, O - Labor Overtime, R - Labor Regular). |
