EP_APPRAISAL_IDPrompt Table: EP_APPR
EP_SECTION_TYPEPrompt Table: EP_SECTION_DEFN
EP_ROLEPrompt Table: EP_ROLE_TBL
EP_APPRBROLE_VW(SQL View) |
Index Back |
|---|---|
Document Role - BaselineDocument Role - Baseline |
| SELECT EP_APPRAISAL_ID ,EP_SECTION_TYPE ,EP_ROLE FROM PS_EP_APPR_B_ROLE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL |
Document ID
Prompt Table: EP_APPR |
| 2 | EP_SECTION_TYPE |
Character(8) | VARCHAR2(8) NOT NULL |
Section type
Prompt Table: EP_SECTION_DEFN |
| 3 | EP_ROLE |
Character(8) | VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table: EP_ROLE_TBL |