EP_TP_NO_HISTVW(SQL View) |
Index Back |
---|
SELECT EP_APPRAISAL_ID , EP_CHKPT_NBR , EP_CHKPT_DUE_DT FROM PS_EP_APPR_CHECKPT WHERE 1 = 2 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |