FINANCIAL PROCESSING STATUS Table
Table containing data which displays the current status of several financial processing areas. Examples: costing sheets, payroll, facilities processing, fiscal period complete, etc.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPLETE_DATE |
Date indicating when a particular financial process was completed. |
DATE |
8 |
IS_PROCESS_COMPLETE |
Flag indicating whether a financial process has been completed. Values: Y or N. |
VARCHAR2 |
1 |
PROCESS_NAME |
Name of the process in the financial processing status table. Examples: costing sheets, payroll, facilities processing, fiscal period complete. |
VARCHAR2 |
30 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
USERNAME |
Kerberos ID |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |