EP_MANAGER_IDPrompt Table: PERSON
EP_REVIEW_TYPEEP_APPRAISAL_IDEP_SOURCEADM=Admin Approve Documents
APR=Approve Documents
CP=Career Planning
SP=Succession Planning
STS=View Approval Status
TP=Talent Pool
EP_RPT_MGR_DTL(SQL Table) |
Index Back |
|---|---|
Mgr Report Snapshot Dtl RecStores detail review information extracted during the Manager Report Snapshot Summary process. The drill-down for the Status Summary and Rating Distribution charts is references this data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_MANAGER_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Manager/Mentor ID.
Prompt Table: PERSON |
| 2 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 3 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 4 | EP_SOURCE |
Character(4) | VARCHAR2(4) NOT NULL |
This field tracks which application requests Performance documents
ADM=Admin Approve Documents APR=Approve Documents CP=Career Planning SP=Succession Planning STS=View Approval Status TP=Talent Pool |
| 5 | EP_PRELIM_GRP | Number(3,0) | SMALLINT NOT NULL | Preliminary Rating Grp |
| 6 | EP_FINAL_GRP | Number(3,0) | SMALLINT NOT NULL | Final Rating Group |