index back

Initial Load Status

Intial Load Status Table. It records the initial load status for each dashboard application.

PeopleSoft Field NameField TypeColumn TypeDescription
PT_CDB_APP_CODECharacter(4)VARCHAR2(4) NOT NULLCode 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.
PT_CDB_LOAD_STATUSCharacter(4)VARCHAR2(4) NOT NULLThe Status for initial load. "C" is completed, 'E" is error, and "P" is in process.
DC=Dimensions Completed
DP=Dimensions In Process
P=In Process
PT_CDB_FACT_GRPCharacter(30)VARCHAR2(30) NOT NULLFact Group Name
PT_CDB_DIM_GRPCharacter(30)VARCHAR2(30) NOT NULLDimension Group Name
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
PT_CDB_STARTDTTMDateTime(26)TIMESTAMPInitial Load Start Date Time.
PT_CDB_ENDDTTMDateTime(26)TIMESTAMPInitial Load End Date Time.
index back(c)David Kurtz 2019, 8.54
PTRef generated on 09-JUN-19