PT_CDB_APP_CODEC=Completed
DC=Dimensions Completed
DP=Dimensions In Process
P=In Process
PSCDBLOADSTATUS(SQL Table) |
Index Back |
|---|---|
Initial Load StatusIntial Load Status Table. It records the initial load status for each dashboard application. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PT_CDB_APP_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Code of the application message to the dashboard. This may be used by the messaging framework as a mechanism to distribute messages to a JMS server. |
| 2 | PT_CDB_LOAD_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
The Status for initial load. "C" is completed, 'E" is error, and "P" is in process.
C=Completed DC=Dimensions Completed DP=Dimensions In Process P=In Process |
| 3 | PT_CDB_FACT_GRP | Character(30) | VARCHAR2(30) NOT NULL | Fact Group Name |
| 4 | PT_CDB_DIM_GRP | Character(30) | VARCHAR2(30) NOT NULL | Dimension Group Name |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | PT_CDB_STARTDTTM | DateTime(26) | TIMESTAMP | Initial Load Start Date Time. |
| 7 | PT_CDB_ENDDTTM | DateTime(26) | TIMESTAMP | Initial Load End Date Time. |