EP_A_CHKPT_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
4	EP_CHKPT_NBR	Number(2,0)	SMALLINT NOT NULL	the number of the checkpoint during the track progress step
5	EP_CHKPT_DUE_DT	Date(10)	DATE	Checkpoint Due date
6	EP_CHKPT_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Completed C=Completed S=Skipped
7	EP_CHKPT_COMP_DTTM	DateTime(26)	TIMESTAMP	Checkpoint Commpleted
8	EP_CHKPT_COMP_ID	Character(50)	VARCHAR2(50) NOT NULL	Checkpoint completed by emplid
9	EP_CHKPT_STORED_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the checkpoint data was stored Y/N Table Edit Default Value: N
10	EP_CHKPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Checkpoint Type A=Approved C=Completed S=Scheduled Default Value: S