EMPLIDEMPL_RCDHR_DIV_TYPEA=Age
D=Disability
E=Ethnicity
G=Gender
V=Veteran Status
LANGUAGE_CDHR_PG_WF_DV_LVW(SQL View) |
Index Back |
|---|---|
Workforce DiversityWorkforce Diversity View for HR Analytics |
| SELECT EMPLID , EMPL_RCD , HR_DIV_TYPE , LANGUAGE_CD , DESCR100 , HR_STATUS_DESCR , NAME , JOBCODE_DESCR , POSN_DESCR , JOB_DESCR , LOCATION_DESCR , DEPT_DESCR , BUSINESS_DESCR , COMPANY_DESCR , EMPL_TYPE_DESCR , REG_REGION_DESCR , MANAGER_NAME FROM PS_HR_PG_WF_DV_LNG |
| # | 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 | HR_DIV_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Field used to list Diversity Types.
A=Age D=Disability E=Ethnicity G=Gender V=Veteran Status |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | HR_STATUS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | HR Status |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 9 | POSN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Position Description |
| 10 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 11 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 12 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 13 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |
| 14 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 15 | EMPL_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Employee Type |
| 16 | REG_REGION_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Regulatory Region |
| 17 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Manager Name |