Across the HRI, there are shared employee fields that are fed in nightly through an integration with HCM. Specific apps in the HRI may only see a portion of the fields depending on the unit’s business needs. Below are employee data fields available in the HRI, along with the field name in the HRI and the corresponding name in HCM.
HRI Field Name | HCM Field Name | Description |
|---|---|---|
EMPLOYEE_FIRST_NAME | ||
EMPLOYEE_MIDDLE_NAME | ||
EMPLOYEE_LAST_NAME | ||
EMPLOYEE_NAME_SUFFIX | ||
EMPLOYEE_ID | ||
EMPLOYEE_HOME_PHONE_NUM | ||
EMPLOYEE_CELL_PHONE_NUM | ||
EMPLOYEE_CAMPUS1_PHONE_NUM | ||
EMPLOYEE_CAMPUS_EMAIL_ADDR | ||
EMPLOYEE_HOME_EMAIL_ADDR | ||
EMPLOYEE_OTHER_EMAIL_ADDR | ||
EMPLOYEE_COUNTRY_CODE | ||
EMPLOYEE_CITY_NAME | ||
EMPLOYEE_STATE_CODE | ||
EMPLOYEE_POSTAL_CODE | ||
EMPLOYEE_LINE1_ADDR | ||
EMPLOYEE_LINE2_ADDR | ||
EMPLOYEE_LINE3_ADDR | ||
EMPLOYEE_SEX_CODE | ||
EMPLOYEE_BIRTH_DATE | ||
EMPLOYEE_ETHNICITY_DESC | ||
EMPLOYEE_CITIZENSHIP_DESC | ||
EMPLOYEE_DISABILITY_YESNO | ||
EMPLOYEE_I9_EFFECTIVE_DATE | ||
EMPLOYEE_I9_EXPIRATION_DATE | ||
EMPLOYEE_I9_VERIFIED_BY_ID | ||
IWHPR2 (IRM database): RECORDTYPE | ||
CIW: EMPLOYEE_ID || EMPLOYMENT_REC_NUM | ||
IWHPR2 (IRM database): ACTION | ||
EMPLOYMENT_REC_NUM | ||
JOB_POSITION_NUM | ||
JOB_PRIMARY_JOB_IND | ||
JOB_LAST_HIRE_DATE | ||
JOB_ENTRY_DATE | ||
EMPLOYMENT_TERMINATION_DATE | ||
CIW: JB_GROUP_CODE | ||
CIW: JB_GROUP_DESC | ||
JOB_JB_CODE | ||
JB_DESC | ||
POSN_DESC | ||
JOB_DEPT_ID | ||
CIW: DEPT_DESC | ||
CIW: DEPTTREE_LEVEL04_DESC,DEPTTREE_LEVEL05_DESC | ||
CIW: DEPT_CAMPUS_NUM | ||
CIW: DEPT_CAMPUS_DESC | ||
JOB_FLSA_STATUS | ||
JOB_FLSA_STATUS_DESC | ||
EMPLOYEE_ID AS SUPERVISOR_EMPLOYEE_ID | ||
CIW: EMPLOYEE_CAMPUS_BOX_ADDR | ||
JOB_MONTHLY_RATE | ||
JOB_HOURLY_RATE | ||
POSN_FTE_AMT | ||
EMPLOYEE_ETHNICITY_CODE | ||
EMPLOYEE_CITIZENSHIP_CODE | ||
JB_STATUS_CODE | ||
POSN_STATUS_CODE | ||
JOB_EMPLOYEE_CLASS_CODE | ||
JOB_EMPLOYEE_CLASS_DESC | ||
JOB_EFFECTIVE_DATE | ||
JOB_POSITION_ENTRY_DATE | ||
JOB_JB_EFFECTIVE_DATE | ||
JOB_EMPLMNT_STATUS_DATE | ||
N/A | ||
POSN_EFFECTIVE_DATE | ||
EMPLOYEE_NAME | ||
EMPLOYMENT_PHONE_NUM | ||
EMPLOYEE_MAIN_PHONE_NUM | ||
EMPLOYEE_NAME | ||
EMPLOYMENT_REPORTS_TO_NUM | ||
JB_COMP_FREQUENCY_CODE | ||
JB_FLSA_STATUS_CODE | ||
POSN_FLSA_STATUS_CODE | ||
EMPLOYEE_MILITARY_CODE | ||
EMPLOYEE_MILITARY_DESC | ||
EMPLOYEE_PREF_FIRST_NAME | ||
EMPLOYEE_PREF_MIDDLE_NAME | ||
EMPLOYEE_PREF_LAST_NAME | ||
EMPLOYEE_PREF_NAME | ||
EMPLOYEE_COUNTY_NAME | ||
COMP_RATE_CODE | ||
COMP_RATE | ||
JOB_EFFECTIVE_SEQ | ||
JOB_ACTN_CODE | ||
JOB_ACTN_DATE | ||
JOB_ACTN_REASON_CODE | ||
JOB_EMPLMNT_STATUS_END_DATE | ||
JOB_EMPLMNT_STATUS_ACTN_CODE | ||
JOB_EMPLMNT_STATUS_ACTN_DESC | ||
JOB_COMP_FREQUENCY_CODE | ||
JOB_COMP_RATE | ||
VISAP_COUNTRY_CODE | ||
VISAP_TYPE_CODE | ||
VISAP_EFFECTIVE_DATE | ||
VISAP_TYPE_DESC | ||
VISAP_CLASSIFICATION_CODE | ||
VISAP_CODE | ||
VISAP_STATUS_CODE | ||
VISAP_STATUS_DATE | ||
VISAP_ISSUED_DATE | ||
VISAP_PLACE_ISSUED_NOTE | ||
VISAP_DURATION_AMT | ||
VISAP_DURATION_UNIT_CODE | ||
VISAP_ENTRY_DATE | ||
VISAP_EXPIRE_DATE | ||
VISAP_PCNT | ||
VISAP_EXTRACT_AS_OF_DATE | ||
TRAINING_COURSE_START_DATE | ||
TRAINING_COURSE_CODE | ||
TRAINING_SESSION_NUM | ||
TRAINING_COURSE_TITLE | ||
TRAINING_COURSE_END_DATE | ||
TRAINING_INTRNL_EXTRNL_CODE | ||
TRAINING_ATTENDANCE_CODE | ||
TRAINING_STATUS_DATE | ||
TRAINING_COURSE_GRADE_CODE | ||
TRAINING_eXTRACT_AS_OF_DATE | ||
JOB_ANNUAL_RATE | ||
JOB_LOCN_CODE | ||
IWHPR2 (IRM database): SOURCE | ||
CIW: JOB_COMPANY_CODE | ||
CIW: JOB_OFFICER_CODE | ||
CIW: JOB_PAYGROUP_CODE |