EMPLIDEMPL_RCDHIGHEST_EDUC_LVLLANGUAGE_CDHR_PG_ED_LV_LVW(SQL View) |
Index Back |
|---|---|
Highest Education LevelHighest Education Level View for HR Analytics |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD , B.HIGHEST_EDUC_LVL , A.LANGUAGE_CD , A.HR_STATUS_DESCR , A.NAME , A.JOBCODE_DESCR , A.POSN_DESCR , A.JOB_DESCR , A.LOCATION_DESCR , A.DEPT_DESCR , A.BUSINESS_DESCR , A.COMPANY_DESCR , A.EMPL_TYPE_DESCR , A.REG_REGION_DESCR , A.MANAGER_NAME FROM PS_HR_PG_WF_DV_LNG A , PS_HR_PG_WF_DIVERS B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | HIGHEST_EDUC_LVL |
Character(2) | VARCHAR2(2) NOT NULL | Highest Education Level |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | HR_STATUS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | HR Status |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 8 | POSN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Position Description |
| 9 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 10 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 11 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 12 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |
| 13 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 14 | EMPL_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Employee Type |
| 15 | REG_REGION_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Regulatory Region |
| 16 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Manager Name |