EP_APPR_CHKPTVW (SQL View)	Index Back
Track Progress Checkpoints Document Checkpoints

EP_APPR_CHKPTVW

(SQL View)

Track Progress Checkpoints

Document Checkpoints

SELECT EP_APPRAISAL_ID , EP_CHKPT_NBR , EP_CHKPT_DUE_DT , EP_CHKPT_COMP_DTTM , EP_CHKPT_TYPE , EP_CHKPT_COMPLETE , EP_CHKPT_STORED_SW FROM PS_EP_APPR_CHECKPT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

2 EP_CHKPT_NBR Number(2,0) SMALLINT NOT NULL the number of the checkpoint during the track progress step

3 EP_CHKPT_DUE_DT Date(10) DATE Checkpoint Due date

4 EP_CHKPT_COMP_DTTM DateTime(26) TIMESTAMP Checkpoint Commpleted

5 EP_CHKPT_TYPE Character(1) VARCHAR2(1) NOT NULL Checkpoint Type
A=Approved
C=Completed
S=Scheduled

6 EP_CHKPT_COMPLETE Character(1) VARCHAR2(1) NOT NULL Completed
C=Completed
S=Skipped

7 EP_CHKPT_STORED_SW Character(1) VARCHAR2(1) NOT NULL whether or not the checkpoint data was stored

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EP_CHKPT_NBR	Number(2,0)	SMALLINT NOT NULL	the number of the checkpoint during the track progress step
3	EP_CHKPT_DUE_DT	Date(10)	DATE	Checkpoint Due date
4	EP_CHKPT_COMP_DTTM	DateTime(26)	TIMESTAMP	Checkpoint Commpleted
5	EP_CHKPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Checkpoint Type A=Approved C=Completed S=Scheduled
6	EP_CHKPT_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Completed C=Completed S=Skipped
7	EP_CHKPT_STORED_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the checkpoint data was stored