OPRIDROWSECCLASSEMPLIDEMPL_RCDDefault Value: %date
0=Ready Now
1=1 - 2 Years
2=3 - 5 Years
E=Emergency
R=Retirement
HR_PERS_AMETR(SQL View) |
Index Back |
|---|---|
Career Planning Summary ReportView used for Career Planning Summary Reports. (Key persons) |
| SELECT A.OPRID , A.ROWSECCLASS , A.EMPLID , A.EMPL_RCD , B.EFFDT , B.NEXT_CAREERPLAN_DT , B.READINESS , A.BUSINESS_UNIT , A.COMPANY , A.DEPTID , A.LOCATION , A.SETID_DEPT , A.SETID_LOCATION FROM PS_HR_CP_PERS_PJOB A LEFT OUTER JOIN PS_HR_CP_PATH_VW B ON A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | ROWSECCLASS |
Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | NEXT_CAREERPLAN_DT | Date(10) | DATE | Career Plan Review Date |
| 7 | READINESS | Character(1) | VARCHAR2(1) NOT NULL |
Readiness
0=Ready Now 1=1 - 2 Years 2=3 - 5 Years E=Emergency R=Retirement |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 12 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 13 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |