BUILDING PROJECT EXP DETAIL Table
View exposing facilities building project expenditure detail records associated with project financial activity and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount as provided by the source. |
NUMBER |
13,2 |
ANNUAL_FORECAST_BUDGET |
Annual forecast budget as provided by the source. |
NUMBER |
13,2 |
AUTH_CONSTRUCTION_COST |
Auth construction cost as provided by the source. |
NUMBER |
16,2 |
BUILDING_PROJECT_KEY |
Surrogate key identifying the building project. |
NUMBER |
38 |
BUILDING_PROJECT_TYPE_KEY |
Surrogate key identifying the building project type. |
VARCHAR2 |
10 |
COST_COLLECTOR_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CUMULATIVE_AMOUNT |
Cumulative amount as provided by the source. |
NUMBER |
13,2 |
DEPARTMENT_BUDGET |
Department budget as provided by the source. |
NUMBER |
13,2 |
FYTD_AMOUNT |
Fytd amount as provided by the source. |
NUMBER |
13,2 |
FYTD_DEPARTMENT_BUDGET |
Fytd department budget as provided by the source. |
NUMBER |
13,2 |
FYTD_INSTITUTE_BUDGET |
Fytd institute budget as provided by the source. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
INSTITUTE_BUDGET |
Institute budget as provided by the source. |
NUMBER |
13,2 |
MONTH_END_COMMITMENT_AMOUNT |
Month end commitment amount as provided by the source. |
NUMBER |
13,2 |
MONTH_END_COMMIT_AMOUNT_FY |
Month end commit amount fy as provided by the source. |
NUMBER |
13,2 |
MONTH_END_NON_BL_COMMIT_AMT_FY |
Month end non bl commit amt fy as provided by the source. |
NUMBER |
13,2 |
MONTH_END_NON_BL_ORDER_COM_AMT |
Month end non bl order com amt as provided by the source. |
NUMBER |
13,2 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
11 |
RECORD_COUNTER |
Record counter as provided by the source. |
NUMBER |
1 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
TOTAL_DEPARTMENT_BUDGET |
Total department budget as provided by the source. |
NUMBER |
13,2 |
TOTAL_INSTITUTE_BUDGET |
Total institute budget as provided by the source. |
NUMBER |
13,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |