EP_APPR_C_HST(SQL Table) |
Index Back |
|---|---|
Checkpoint Header tableHistory Table for EP_APPR_C |
| # | 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_ACKNOWLEDG_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was Acknowleged |
| 6 | EP_ACKNOWLED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which Acknowledged a document. |
| 7 | EP_COMPLETE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 8 | EP_COMPLETE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 9 | EP_TRANSFROM_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was transfer from a manager to another |
| 10 | EP_MANAGER_FROM | Character(11) | VARCHAR2(11) NOT NULL | Manager Transferred From |
| 11 | EP_TRANSFTO_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was transfer from a manager to another |
| 12 | EP_TRANSFBY_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which transfers a document By |
| 13 | EP_TRANSFBY_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was transfer from a manager to another |
| 14 | EP_MANAGER_TO | Character(11) | VARCHAR2(11) NOT NULL | Manager Transfer To |
| 15 | EP_CANCEL_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was Canceled |
| 16 | EP_CANCEL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which Canceled a document. |
| 17 | EP_REOPEN_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which Reopens a document. |
| 18 | EP_REOPEN_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was Reopened |
| 19 | EP_TP_COMPL_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 20 | EP_TP_COMPL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 21 | EP_CHKPT_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 22 | EP_CHKPT_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 23 | EP_CHKPT1_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 24 | EP_CKPT1_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 25 | EP_CHKPT2_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 26 | EP_CKPT2_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 27 | EP_CHKPT3_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 28 | EP_CKPT3_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 29 | EP_CHKPT4_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 30 | EP_CKPT4_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 31 | EP_CHKPT5_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 32 | EP_CKPT5_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 33 | EP_CHKPT6_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 34 | EP_CKPT6_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 35 | EP_CHKPT7_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 36 | EP_CKPT7_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 37 | EP_CHKPT8_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 38 | EP_CKPT8_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 39 | EP_CHKPT9_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 40 | EP_CKPT9_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 41 | EP_CHKPT10_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 42 | EP_CKPT10_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 43 | EP_CHKPT11_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 44 | EP_CKPT11_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 45 | EP_TP_REOPEN_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 46 | EP_TP_REOPEN_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 47 | EP_ESIGN_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was esigned |
| 48 | EP_ESIGN_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the Oprid who eSigned a document. |
| 49 | EP_REVIEW_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged AR=Shared with Employee CA=Canceled CO=Completed EC=Define Criteria IP=Evaluation in Progress NS=Not Started PA=Approval RH=Pending Acknowledgement TP=Track Progress |
| 50 | EP_EST_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Translate field that determines the state (status) of the establish criteria step.
CO=Completed IP=In Progress NA=Not Applicable NS=Not Started |
| 51 | EP_TRKPROG_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Status of the Track Progress step in the process
CO=Completed IP=In Progress NA=Not Applicable NS=Not Started |
| 52 | EP_TP_SUB_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Sub Status for the Track Progress step in the process.
The value will be 1-11 or 99 for Finalize.
1=1 10=10 11=11 2=2 3=3 4=4 5=5 6=6 7=7 8=8 9=9 F=F |
| 53 | EP_TP_CURR_DUE_DT | Date(10) | DATE | The Due Date of the current Track Progress Checkpoint |
| 54 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 55 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 56 | EP_EE_CMNT_SHARED | Character(1) | VARCHAR2(1) NOT NULL |
whether or not the emplyee comments are shared
Y/N Table Edit Default Value: N |
| 57 | EP_MGR_CMNT_SHARED | Character(1) | VARCHAR2(1) NOT NULL |
whether or not the Manager's comments are shared
Y/N Table Edit Default Value: N |