PSCDBLOADSTATUS

index back

Initial Load Status

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

PeopleSoft Field Name Field Type Column Type Description
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.
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
PT_CDB_FACT_GRP Character(30) VARCHAR2(30) NOT NULL Fact Group Name
PT_CDB_DIM_GRP Character(30) VARCHAR2(30) NOT NULL Dimension Group Name
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
PT_CDB_STARTDTTM DateTime(26) TIMESTAMP Initial Load Start Date Time.
PT_CDB_ENDDTTM DateTime(26) TIMESTAMP Initial Load End Date Time.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19