SUMMARY STATEMENT DETAIL Table
Summary Statement reporting table which contains data from July 1999 through the current fiscal period. It is similar to Balances by Fiscal Period, except that it contains calculated overhead for those fiscal period(s) where costing sheets have not been run yet. Field RECORD_TYPE contains values "Posted" or "Calculated" and should be used in reports to clarify what the entries are.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
The total actual dollar amount charged for the fiscal period or periods selected. In GRADUATE AWARDS, this field contains the graduate award (RA, TA, etc.) amount. |
NUMBER |
|
ANNUAL_FORECAST_BUDGET |
XXX |
NUMBER |
|
COMMITMENT_AMOUNT |
The dollars committed (set aside) but not yet paid for the line item. |
NUMBER |
13,2 |
COMMITMENT_AMOUNT_FY |
Commitment amount which excludes commitments whose expected debit fiscal period if in the future fiscal year(s). |
NUMBER |
13,2 |
COST_COLLECTOR_FP_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances by Fiscal Period, Summary Statement Detail) when you want to bring up the cost collector data matching the fiscal period on the fact table. For the current fiscal period, the most recent data will be brought in. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances, Balances by Fiscal Period, Summary Statement Detail) when you want to bring in cost collector data as it was at the end of fiscal year of the fact data. For the current fiscal year, the most recent data will be brought in. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
CUMULATIVE_AMOUNT |
The total actual dollar amount charged since the inception of the cost collector, G/L account or Profit Center. |
NUMBER |
|
DEPARTMENT_BUDGET |
The department-specified budget for the fiscal period or periods selected. |
NUMBER |
|
FYTD_AMOUNT |
The total dollar amount charged for the fiscal year to date. |
NUMBER |
|
FYTD_DEPARTMENT_BUDGET |
The Department-specified budget for the fiscal period to date. |
NUMBER |
|
FYTD_INSTITUTE_BUDGET |
The Institute budget for the fiscal period to date. |
NUMBER |
|
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
INSTITUTE_BUDGET |
The Institute budget for the fiscal period or periods selected. The Institute Budget is currently spread evenly across fiscal periods 1 through 12 of a particular fiscal year. |
NUMBER |
|
NON_BL_ORDER_COMMITMENT_AMOUNT |
Non-blanket order commitment amount. |
NUMBER |
13,2 |
NON_BL_ORDER_COMMIT_AMOUNT_FY |
Non-blanket order commitment amount excluding those commitments whose expected debit period is in the future fiscal year(s). |
NUMBER |
13,2 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
|
RECORD_TYPE |
This field can contain different values in different tables. In the Summary Statement Detail table, it contains either "Posted" or "Calculated", referring to the nature of the record. In the Estimated Surcharges table, field values are "ACT"(actual) or "EST" (estimated). |
VARCHAR2 |
10 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
TOTAL_DEPARTMENT_BUDGET |
The total Department-specified budget for a particular cost collector for the specified fiscal year. |
NUMBER |
|
TOTAL_INSTITUTE_BUDGET |
The total Institute budget for a particular cost collector for the specified fiscal year. For WBS elements, the cumulative authorized total in effect during a particular fiscal year is carried in period 1 of that fiscal year. Throughout the fiscal year, if the authorized total is updated, the Institue budget in period 1 of that fiscal year will be updated. After June 30, that total remains in period 1 for that fiscal year and also copied into period 1 of the next fiscal year. Updates after June 30 are not made to previous year's authorized total, but only to the current year. Therefore, the authorized total amount in a fiscal year that has ended can be used as a historical record of the amount of authorized total on June 30 of that year. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |