EP_A_ROLE_HST(SQL Table) |
Index Back |
|---|---|
Document Role ArchiveePerformance table used to store Evaluation Role information. |
| # | 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
Prompt Table: EP_APPR |
| 4 | EP_ROLE |
Character(8) | VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table: EP_ROLE_TBL |
| 5 | EP_REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Reviewer ID
Prompt Table: EP_REVWR_ID_VW |
| 6 | EP_DUE_DT | Date(10) | DATE | Date a review is due |
| 7 | 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 Default Value: IP |
| 8 | EP_SHOW_TO_EE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates when a Manager's review document is available for Employee review and comment.
Y/N Table Edit Default Value: N |
| 9 | EP_CREATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was created. |
| 10 | EP_CREATE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which created a document. |
| 11 | 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. |
| 12 | 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. |
| 13 | EP_ACKNOWLEDG_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was Acknowleged |
| 14 | EP_ACKNOWLED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which Acknowledged a document. |
| 15 | EP_COMPLETE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 16 | EP_COMPLETE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 17 | EP_TRANSFROM_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was transfer from a manager to another |
| 18 | EP_MANAGER_FROM | Character(11) | VARCHAR2(11) NOT NULL | Manager Transferred From |
| 19 | EP_TRANSFTO_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was transfer from a manager to another |
| 20 | EP_TRANSFBY_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which transfers a document By |
| 21 | EP_TRANSFBY_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was transfer from a manager to another |
| 22 | EP_MANAGER_TO | Character(11) | VARCHAR2(11) NOT NULL | Manager Transfer To |
| 23 | EP_CANCEL_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was Canceled |
| 24 | EP_CANCEL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which Canceled a document. |
| 25 | EP_REOPEN_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which Reopens a document. |
| 26 | EP_REOPEN_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was Reopened |
| 27 | EP_TP_COMPL_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 28 | EP_TP_COMPL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 29 | EP_CHKPT_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 30 | EP_CHKPT_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 31 | EP_CHKPT1_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 32 | EP_CKPT1_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 33 | EP_CHKPT2_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 34 | EP_CKPT2_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 35 | EP_CHKPT3_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 36 | EP_CKPT3_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 37 | EP_CHKPT4_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 38 | EP_CKPT4_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 39 | EP_CHKPT5_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 40 | EP_CKPT5_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 41 | EP_CHKPT6_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 42 | EP_CKPT6_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 43 | EP_CHKPT7_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 44 | EP_CKPT7_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 45 | EP_CHKPT8_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 46 | EP_CKPT8_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 47 | EP_CHKPT9_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 48 | EP_CKPT9_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 49 | EP_CHKPT10_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 50 | EP_CKPT10_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 51 | EP_CHKPT11_RD_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 52 | EP_CKPT11_RD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 53 | EP_TP_REOPEN_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was completed |
| 54 | EP_TP_REOPEN_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which completed a document. |
| 55 | EP_ESIGN_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time a document was esigned |
| 56 | EP_ESIGN_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the Oprid who eSigned a document. |