The notification of when different components of the Payroll Personnel Data Warehouse were last updated and whether the update process is still in progress. A more detailed write-up covers the update schedule including further explanation of what is included in each part of the system.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ACTIVITY_DATE | DATE OF LAST ACTIVITY | DATE | The date of the last update activity. |
| EXTRACT_NAME | EXTRACT SYSTEM NAME | VARCHAR2(10) | The name of the component/part of the PPS Data Warehouse that was updated. (ie. EDB is the Employee Data Base containing PAF information.) |
| UPDATE_IN_PROGRESS | UPDATE IN PROGRESS FLAG | CHAR(1) | The flag that indicates whether the update process is currently running. (values are Y=yes-in progress, N=no-not in progress). |
| UPDATE_MESSAGE | UPDATE MESSAGE | VARCHAR2(45) | The translation of the UPDATE_IN_PROGRESS flag. |
| Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: February 24, 1999