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_DIV_OV(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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | ENTRY_DATE | Date(10) | DATE | Date Entered |
| 10 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 11 | HRS_PRM_PST_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 12 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 13 | POSN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Position Description |
| 14 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 15 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 16 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 17 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |
| 18 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 19 | RECRUITER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Recruiter Name |
| 20 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Manager Name |
| 21 | HRS_MGR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Hiring Manager |
| 22 | DISABILITY_STS_USA | Character(1) | VARCHAR2(1) NOT NULL |
Disability (Section 503) Status USA
N=Not Disabled X=Not Indicated Y=Disabled |
| 23 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 24 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 25 | HRS_HR_EFFDT | Date(10) | DATE | HR Record EFFDT |
| 26 | MILITARY_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Veteran Status / Military Status |
| 27 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 28 | HRS_FROM_DATE | Date(10) | DATE | From Application Date |
| 29 | HRS_TODATE | Date(10) | DATE | To Date |