CU Boulder Human Resources
Knowledgebase
Employee Data Fields (Integration Data with HCM and SIS)
- Stephen Lewis
This page is currently a work in progress. Check back for future udpates.
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 |  |