EP_TMPL_CHECKPT (SQL Table)	Index Back
Template Checkpoints Template Checkpoints for Track Progress step. This table will only be populated for Templates that have the Track Progress step and also do not use the Template Calendar. If they use the Calendar, then the TP dates will be stored in the calendar instead of in this table.

EP_TMPL_CHECKPT

(SQL Table)

Template Checkpoints

Template Checkpoints for Track Progress step. This table will only be populated for Templates that have the Track Progress step and also do not use the Template Calendar. If they use the Calendar, then the TP dates will be stored in the calendar instead of in this table.

Parent record: EP_TMPL_DEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

2 EP_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Template unique identifier

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

5 EP_CHKPT_DUE_DAYS Number(4,0) SMALLINT NOT NULL Number of days when the checkpoint is due

6 EP_CHKPT_DUE_TYPE Character(1) VARCHAR2(1) NOT NULL Checkpoint Period Basis
A=After Period End Date
B=Before Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type
2	EP_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Template unique identifier
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EP_CHKPT_NBR	Number(2,0)	SMALLINT NOT NULL	the number of the checkpoint during the track progress step
5	EP_CHKPT_DUE_DAYS	Number(4,0)	SMALLINT NOT NULL	Number of days when the checkpoint is due
6	EP_CHKPT_DUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Checkpoint Period Basis A=After Period End Date B=Before Period End Date