HRS_PERSON_IDHRS_RCMNT_IDHRS_PROFILE_SEQHRS_DIV_TYPED=Disability
E=Ethnicity
G=Gender
V=Veterans
A=External Applicant
E=Employee
N=Non-Employee
N=Not Disabled
X=Not Indicated
Y=Disabled
F=Female
M=Male
U=Unknown
HRS_PG_DA_APPLN(SQL Table) |
Index Back |
|---|---|
Diversity Analytics Overview |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_RCMNT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 3 | HRS_PROFILE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 4 | HRS_DIV_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Field used to list diversity Types.
D=Disability E=Ethnicity G=Gender V=Veterans |
| 5 | HRS_DESCR90 | Character(90) | VARCHAR2(90) NOT NULL | content item description |
| 6 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 7 | APP_PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant E=Employee N=Non-Employee |
| 8 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | ENTRY_DATE | Date(10) | DATE | Date Entered |
| 11 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 12 | HRS_PRM_PST_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 13 | HRS_PRM_JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Primary Job Code of Job Opening. |
| 14 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 15 | HRS_PRM_POSITION | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 16 | POSN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Position Description |
| 17 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 18 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 19 | HRS_PRM_LOC_AREA | Number(15,0) | DECIMAL(15) NOT NULL | Primary recruiting location area |
| 20 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 21 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 22 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 23 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 24 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |
| 25 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 26 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 27 | RECRUITER_ID | Character(11) | VARCHAR2(11) NOT NULL | Recruiter ID |
| 28 | RECRUITER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Recruiter Name |
| 29 | MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | Manager ID |
| 30 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Manager Name |
| 31 | HRS_MGR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Hiring Manager |
| 32 | DISABILITY_STS_USA | Character(1) | VARCHAR2(1) NOT NULL |
Disability (Section 503) Status USA
N=Not Disabled X=Not Indicated Y=Disabled |
| 33 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 34 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 35 | HRS_HR_EFFDT | Date(10) | DATE | HR Record EFFDT |
| 36 | MILITARY_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Veteran Status / Military Status |
| 37 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 38 | HRS_DA_MON_YR | Character(20) | VARCHAR2(20) NOT NULL | Application Month |
| 39 | HRS_DA_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Application Year |
| 40 | HRS_FROM_DATE | Date(10) | DATE | From Application Date |
| 41 | HRS_TODATE | Date(10) | DATE | To Date |