EP_APPRAISAL_IDEP_CHKPT_NBRC=Completed
S=Skipped
Y/N Table Edit
Default Value: N
A=Approved
C=Completed
S=Scheduled
Default Value: S
EP_APPR_CHECKPT(SQL Table) |
Index Back |
|---|---|
Track Progress CheckpointsDocument Checkpoints |
| # | 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_COMPLETE | Character(1) | VARCHAR2(1) NOT NULL |
Completed
C=Completed S=Skipped |
| 5 | EP_CHKPT_COMP_DTTM | DateTime(26) | TIMESTAMP | Checkpoint Commpleted |
| 6 | EP_CHKPT_COMP_ID | Character(50) | VARCHAR2(50) NOT NULL | Checkpoint completed by emplid |
| 7 | 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 |
| 8 | EP_CHKPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Checkpoint Type
A=Approved C=Completed S=Scheduled Default Value: S |