EP_APPR_PART_VW(SQL View) |
Index Back |
|---|---|
Document Participants |
| SELECT A.EP_APPRAISAL_ID ,A.EP_ROLE ,B.EP_DESCR ,%subrec(EP_PARTIC_SBR, A) ,A.EP_DUE_DT FROM PS_EP_APPR_PARTIC A , PS_EP_ROLE_TBL B WHERE A.EP_ROLE = B.EP_ROLE AND A.EP_ROLE <> 'E' AND A.EP_ROLE <> 'M' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EP_ROLE_TBL B1 WHERE B1.EP_ROLE = B.EP_ROLE AND B1.EFFDT <= %CurrentDateIn) |
| # | 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_ROLE |
Character(8) | VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table: EP_ROLE_TBL |
| 3 | EP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description field used in ePerformance. |
| 4 | EP_DOCUMENT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch that determines if a role has a document.
Y/N Table Edit Default Value: N |
| 5 | EP_PRIMARY_DOC_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch that determines if a document is the primary document.
Y/N Table Edit Default Value: N |
| 6 | EP_DUE_DAYS | Number(3,0) | SMALLINT NOT NULL | Amount of days in which a review is due |
| 7 | EP_DUE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of due date - Before or After the period end date
A=After Period End Date B=Before Period End Date |
| 8 | EP_NOM_MIN | Number(3,0) | SMALLINT NOT NULL | Number that determines what the minimum number of participants can be for a role. |
| 9 | EP_NOM_MAX | Number(3,0) | SMALLINT NOT NULL | Number that determines what the maximum number of participants can be for a role. |
| 10 | EP_NOM_ANM_EE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch that determines if an employee is kept anonymous to identities of participants during the tracking of the nomination acceptance/denial/cancellation during the nominate participants process.
Y/N Table Edit Default Value: N |
| 11 | EP_NOM_ANM_MGR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch that determines if an employee is kept anonymous to identities of participants during the tracking of the nomination acceptance/denial/cancellation during the nominate participants process.
Y/N Table Edit Default Value: N |
| 12 | EP_TRK_ANM_EE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch that determines if anonymity is maintained during the track participant feedback process for the employee.
Y/N Table Edit Default Value: N |
| 13 | EP_TRK_ANM_MGR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch that determines if anonymity is maintained during the track participant feedback process for the manager.
Y/N Table Edit Default Value: N |
| 14 | EP_DUE_DT | Date(10) | DATE | Date a review is due |