CHRS Knowledge Base

What Data Goes between CS/CHRS and CFS/CHRS (High Level)

Updated on

This document is intended to help campuses understand what data goes between CS/CHRS and CFS/CHRS.

CHRS to CS

Expand or collapse content When added or updated in CHRS these Bio/Demo types flow to CS
  • Address-HOME (Home)
  • Address-MAIL (Mail)
  • Address-OFFC (Office)
  • Date of Birth (DOB)
  • Email Type-HOME (Home)
  • Email Type-OTHR (Other)
  • Name- PRI (Primary)
  • Name- PRF (Preferred)
  • Name Prefix- All Types
  • Name Suffix- All Types
  • Phone-BUSN (Business 1)
  • Phone-BUS2 (Business 2)
  • Phone-CELL (Cell)
  • Phone-FAX (Fax)
  • Phone-HOME (Home)
  • Phone-OTR (Other)
  • Phone-PGR1 (Pager 1)
  • Phone-TDD (TDD/TDY)
  • Social Security Number
Expand or collapse content When added or updated in CHRS these Bio/Demo types do NOT flows to CS
  • Citizenship/ Passport/ Visa/Permits
  • Disability/Disability Accommodation
  • Date of Death
  • Email Type-Business
  • Emergency Contact
  • Ethnicity/Diversity
  • Gender
  • Military Status
  • ITIN

CS to CHRS

Expand or collapse content When added or updated in CS these Bio/Demo types flow to CHRS
  • Email Type-Business
Expand or collapse content When added or updated in CS these Bio/Demo types do NOT flows to CHRS
  • Address-HOME (Home)
  • Address-MAIL (Mail)
  • Address-OFFC (Office)
  • Citizenship/ Passport/ Visa/Permits
  • Date of Birth (DOB)
  • Disability/Disability Accommodation
  • Date of Death
  • Email Type-HOME (Home)
  • Email Type-OTHR (Other)
  • Emergency Contact
  • Ethnicity/Diversity
  • Gender
  • Military Status
  • Name Prefix- All Types
  • Name Suffix- All Types
  • Phone-BUSN (Business 1)
  • Phone-BUS2 (Business 2)
  • Phone-CELL (Cell)
  • Phone-FAX (Fax)
  • Phone-HOME (Home)
  • Phone-OTR (Other)
  • Phone-PGR1 (Pager 1)
  • Phone-TDD (TDD/TDY)
  • Social Security Number
  • ITIN

CHRS to CFS

Expand or collapse content When added or updated in CHRS these table values populate CFS
  • CSU_LABOR_DIST-BUSINESS_UNIT
  • CSU_LABOR_DIST-EMPLID
  • CSU_LABOR_DIST-DEDCD
  • CSU_LABOR_DIST-POSITION_NBR
  • CSU_LABOR_DIST-PLAN_TYPE
  • CSU_LABOR_DIST-DEPTID
  • CSU_LABOR_DIST-DESCR
  • CSU_LABOR_DIST-EMPL_RCD
  • CSU_LABOR_DIST-NAME
  • CSU_LABOR_DIST-EMPL_CLASS
  • CSU_LABOR_DIST-COMPRATE_USED
  • CSU_LABOR_DIST-COMP_FREQUENCY
  • CSU_LABOR_DIST-COMPRATE
  • CSU_LABOR_DIST-CSU_CHARGE_PD
  • CSU_LABOR_DIST-PAY_END_DT
  • CSU_LABOR_DIST-RUN_ID
  • CSU_LABOR_DIST-CSU_CLEARANCE_NO
  • CSU_LABOR_DIST-PAYCHECK_NBR
  • CSU_LABOR_DIST-PAYGROUP
  • CSU_LABOR_DIST-COMPANY
  • CSU_LABOR_DIST-DESCR3
  • CSU_LABOR_DIST-POSITION_POOL_ID
  • CSU_LABOR_DIST-JOBCODE
  • CSU_LABOR_DIST-JOB_FUNCTION
  • CSU_LABOR_DIST-CSU_EARNINGS
  • CSU_LABOR_DIST-FTE
  • CSU_LABOR_DIST-RATE
  • CSU_LABOR_DIST-ERNCD
  • CSU_LABOR_DIST-DESCR1
  • CSU_LABOR_DIST-TRC
  • CSU_LABOR_DIST-DESCR2
  • CSU_LABOR_DIST-PAID_DAYS
  • CSU_LABOR_DIST-PAID_HRS
  • CSU_LABOR_DIST-DED_CUR
  • CSU_LABOR_DIST-DESCR_DED
  • CSU_LABOR_DIST-DED_CLASS
  • CSU_LABOR_DIST-BENEFIT_PLAN
  • CSU_LABOR_DIST-TAX_CUR
  • CSU_LABOR_DIST-TAX_CLASS
  • CSU_LABOR_DIST-DESCR_AC
  • CSU_LABOR_DIST-STATE
  • CSU_LABOR_DIST-LOCALITY
  • CSU_LABOR_DIST-ACCT_CD
  • CSU_LABOR_DIST-FISCAL_YEAR
  • CSU_LABOR_DIST-CSU_ACCT_CD_LEVEL
  • CSU_LABOR_DIST-CSU_CHG_FUND
  • CSU_LABOR_DIST-CSU_CHG_ACCOUNT
  • CSU_LABOR_DIST-CSU_CHG_DEPTID
  • CSU_LABOR_DIST-CSU_CHG_PROGRAM
  • CSU_LABOR_DIST-CSU_CHG_CLASS
  • CSU_LABOR_DIST-CSU_CHG_PROJECT
  • CSU_LABOR_DIST-CSU_CHG_BUD_PER
  • CSU_LABOR_DIST-JOURNAL_ID
  • CSU_LABOR_DIST-JOURNAL_DATE
  • CSU_LABOR_DIST-JOURNAL_LINE
  • CSU_LABOR_DIST-JRNL_LN_REF
  • CSU_LABOR_DIST-LINE_DESCR
  • CSU_LABOR_DIST-ACCOUNTING_PERIOD
  • CSU_LABOR_DIST-LEDGER
  • CSU_LABOR_DIST-TYPE
  • CSU_LABOR_DIST-REFERENCE_NUM
  • CSU_LABOR_DIST-ADJ_REASON
  • CSU_LABOR_DIST-CSU_DEP_BUD_ADJMNT
  • CSU_LABOR_DIST-POSTED_TOTAL_AMT
  • CSU_LABOR_DIST-BUDGET_AMT
  • CSU_LABOR_DIST-ENCUMBERED_AMT
  • CSU_LABOR_DIST-ADJUST_AMOUNT
  • CSU_LABOR_DIST-UNION_CD
  • CSU_LABOR_DIST-ALTER_EMPLID
  • CSU_LABOR_DIST-CSU_NVS_KEY1
  • CSU_LABOR_DIST-CSU_NVS_KEY2
  • CSU_LABOR_DIST-CSU_NVS_KEY3
  • CSU_LABOR_DIST-PROCESS_INSTANCE
  • CSU_LABOR_DIST-AUDIT_ACTN
  • CSU_LABOR_DIST-IN_PROCESS_FLG
  • HR_ACCTG_LINE-RUN_DT
  • HR_ACCTG_LINE-SEQNUM
  • HR_ACCTG_LINE-LINE_NBR
  • HR_ACCTG_LINE-KK_AMOUNT_TYPE
  • HR_ACCTG_LINE-AUDIT_ACTN
  • HR_ACCTG_LINE-IN_PROCESS_FLG
  • HR_ACCTG_LINE-BUDGET_LINE_STATUS
  • HR_ACCTG_LINE-BUDGET_DT
  • HR_ACCTG_LINE-BUSINESS_UNIT_GL
  • HR_ACCTG_LINE-JOURNAL_ID
  • HR_ACCTG_LINE-JOURNAL_DATE
  • HR_ACCTG_LINE-JOURNAL_LINE
  • HR_ACCTG_LINE-ACCOUNT
  • HR_ACCTG_LINE-DEPTID
  • HR_ACCTG_LINE-PROJECT_ID
  • HR_ACCTG_LINE-PRODUCT
  • HR_ACCTG_LINE-FUND_CODE
  • HR_ACCTG_LINE-PROGRAM_CODE
  • HR_ACCTG_LINE-CLASS_FLD
  • HR_ACCTG_LINE-AFFILIATE
  • HR_ACCTG_LINE-OPERATING_UNIT
  • HR_ACCTG_LINE-ALTACCT
  • HR_ACCTG_LINE-BUDGET_REF
  • HR_ACCTG_LINE-CHARTFIELD1
  • HR_ACCTG_LINE-CHARTFIELD2
  • HR_ACCTG_LINE-CHARTFIELD3
  • HR_ACCTG_LINE-AFFILIATE_INTRA1
  • HR_ACCTG_LINE-AFFILIATE_INTRA2
  • HR_ACCTG_LINE-BUSINESS_UNIT_PC
  • HR_ACCTG_LINE-ACTIVITY_ID
  • HR_ACCTG_LINE-RESOURCE_TYPE
  • HR_ACCTG_LINE-RESOURCE_CATEGORY
  • HR_ACCTG_LINE-RESOURCE_SUB_CAT
  • HR_ACCTG_LINE-STATISTICS_CODE
  • HR_ACCTG_LINE-MONETARY_AMOUNT
  • HR_ACCTG_LINE-FOREIGN_AMOUNT
  • HR_ACCTG_LINE-FOREIGN_CURRENCY
  • HR_ACCTG_LINE-RT_TYPE
  • HR_ACCTG_LINE-RATE_MULT
  • HR_ACCTG_LINE-RATE_DIV
  • HR_ACCTG_LINE-STATISTIC_AMOUNT
  • HR_ACCTG_LINE-JRNL_LN_REF
  • HR_ACCTG_LINE-OPEN_ITEM_STATUS
  • HR_ACCTG_LINE-LINE_DESCR
  • HR_ACCTG_LINE-JRNL_LINE_STATUS
  • HR_ACCTG_LINE-JOURNAL_LINE_DATE
  • HR_ACCTG_LINE-BUSINESS_UNIT
  • HR_ACCTG_LINE-APPL_JRNL_ID
  • HR_ACCTG_LINE-ACCOUNTING_DT
  • HR_ACCTG_LINE-GL_DISTRIB_STATUS
  • HR_ACCTG_LINE-PROCESS_INSTANCE
  • HR_ACCTG_LINE-CURRENCY_CD
  • HR_ACCTG_LINE-ACCOUNTING_PERIOD
  • HR_ACCTG_LINE-FISCAL_YEAR
  • HR_ACCTG_LINE-LEDGER
  • HR_ACCTG_LINE-LEDGER_GROUP
  • HR_ACCTG_LINE-USE_DISTRIBUTION

CFS to CHRS

Expand or collapse content When added or updated in CFS these table values populate CHRS
  • HR_ACCTG_LINE-JOURNAL_ID
  • HR_ACCTG_LINE-JOURNAL_DATE
  • HR_ACCTG_LINE-JOURNAL_LINE
  • HR_ACCTG_LINE-ACCOUNTING_PERIOD
  • HR_ACCTG_LINE-FISCAL_YEAR
Expand or collapse content When added or updated in CFS these table values do NOT populate CHRS
  • CSU_LABOR_DIST-BUSINESS_UNIT
  • CSU_LABOR_DIST-EMPLID
  • CSU_LABOR_DIST-DEDCD
  • CSU_LABOR_DIST-POSITION_NBR
  • CSU_LABOR_DIST-PLAN_TYPE
  • CSU_LABOR_DIST-DEPTID
  • CSU_LABOR_DIST-DESCR
  • CSU_LABOR_DIST-EMPL_RCD
  • CSU_LABOR_DIST-NAME
  • CSU_LABOR_DIST-EMPL_CLASS
  • CSU_LABOR_DIST-COMPRATE_USED
  • CSU_LABOR_DIST-COMP_FREQUENCY
  • CSU_LABOR_DIST-COMPRATE
  • CSU_LABOR_DIST-CSU_CHARGE_PD
  • CSU_LABOR_DIST-PAY_END_DT
  • CSU_LABOR_DIST-RUN_ID
  • CSU_LABOR_DIST-CSU_CLEARANCE_NO
  • CSU_LABOR_DIST-PAYCHECK_NBR
  • CSU_LABOR_DIST-PAYGROUP
  • CSU_LABOR_DIST-COMPANY
  • CSU_LABOR_DIST-DESCR3
  • CSU_LABOR_DIST-POSITION_POOL_ID
  • CSU_LABOR_DIST-JOBCODE
  • CSU_LABOR_DIST-JOB_FUNCTION
  • CSU_LABOR_DIST-CSU_EARNINGS
  • CSU_LABOR_DIST-FTE
  • CSU_LABOR_DIST-RATE
  • CSU_LABOR_DIST-ERNCD
  • CSU_LABOR_DIST-DESCR1
  • CSU_LABOR_DIST-TRC
  • CSU_LABOR_DIST-DESCR2
  • CSU_LABOR_DIST-PAID_DAYS
  • CSU_LABOR_DIST-PAID_HRS
  • CSU_LABOR_DIST-DED_CUR
  • CSU_LABOR_DIST-DESCR_DED
  • CSU_LABOR_DIST-DED_CLASS
  • CSU_LABOR_DIST-BENEFIT_PLAN
  • CSU_LABOR_DIST-TAX_CUR
  • CSU_LABOR_DIST-TAX_CLASS
  • CSU_LABOR_DIST-DESCR_AC
  • CSU_LABOR_DIST-STATE
  • CSU_LABOR_DIST-LOCALITY
  • CSU_LABOR_DIST-ACCT_CD
  • CSU_LABOR_DIST-FISCAL_YEAR
  • CSU_LABOR_DIST-CSU_ACCT_CD_LEVEL
  • CSU_LABOR_DIST-CSU_CHG_FUND
  • CSU_LABOR_DIST-CSU_CHG_ACCOUNT
  • CSU_LABOR_DIST-CSU_CHG_DEPTID
  • CSU_LABOR_DIST-CSU_CHG_PROGRAM
  • CSU_LABOR_DIST-CSU_CHG_CLASS
  • CSU_LABOR_DIST-CSU_CHG_PROJECT
  • CSU_LABOR_DIST-CSU_CHG_BUD_PER
  • CSU_LABOR_DIST-JOURNAL_ID
  • CSU_LABOR_DIST-JOURNAL_DATE
  • CSU_LABOR_DIST-JOURNAL_LINE
  • CSU_LABOR_DIST-JRNL_LN_REF
  • CSU_LABOR_DIST-LINE_DESCR
  • CSU_LABOR_DIST-ACCOUNTING_PERIOD
  • CSU_LABOR_DIST-LEDGER
  • CSU_LABOR_DIST-TYPE
  • CSU_LABOR_DIST-REFERENCE_NUM
  • CSU_LABOR_DIST-ADJ_REASON
  • CSU_LABOR_DIST-CSU_DEP_BUD_ADJMNT
  • CSU_LABOR_DIST-POSTED_TOTAL_AMT
  • CSU_LABOR_DIST-BUDGET_AMT
  • CSU_LABOR_DIST-ENCUMBERED_AMT
  • CSU_LABOR_DIST-ADJUST_AMOUNT
  • CSU_LABOR_DIST-UNION_CD
  • CSU_LABOR_DIST-ALTER_EMPLID
  • CSU_LABOR_DIST-CSU_NVS_KEY1
  • CSU_LABOR_DIST-CSU_NVS_KEY2
  • CSU_LABOR_DIST-CSU_NVS_KEY3
  • CSU_LABOR_DIST-PROCESS_INSTANCE
  • CSU_LABOR_DIST-AUDIT_ACTN
  • CSU_LABOR_DIST-IN_PROCESS_FLG
  • HR_ACCTG_LINE-RUN_DT
  • HR_ACCTG_LINE-SEQNUM
  • HR_ACCTG_LINE-LINE_NBR
  • HR_ACCTG_LINE-KK_AMOUNT_TYPE
  • HR_ACCTG_LINE-AUDIT_ACTN
  • HR_ACCTG_LINE-IN_PROCESS_FLG
  • HR_ACCTG_LINE-BUDGET_LINE_STATUS
  • HR_ACCTG_LINE-BUDGET_DT
  • HR_ACCTG_LINE-BUSINESS_UNIT_GL
  • HR_ACCTG_LINE-ACCOUNT
  • HR_ACCTG_LINE-DEPTID
  • HR_ACCTG_LINE-PROJECT_ID
  • HR_ACCTG_LINE-PRODUCT
  • HR_ACCTG_LINE-FUND_CODE
  • HR_ACCTG_LINE-PROGRAM_CODE
  • HR_ACCTG_LINE-CLASS_FLD
  • HR_ACCTG_LINE-AFFILIATE
  • HR_ACCTG_LINE-OPERATING_UNIT
  • HR_ACCTG_LINE-ALTACCT
  • HR_ACCTG_LINE-BUDGET_REF
  • HR_ACCTG_LINE-CHARTFIELD1
  • HR_ACCTG_LINE-CHARTFIELD2
  • HR_ACCTG_LINE-CHARTFIELD3
  • HR_ACCTG_LINE-AFFILIATE_INTRA1
  • HR_ACCTG_LINE-AFFILIATE_INTRA2
  • HR_ACCTG_LINE-BUSINESS_UNIT_PC
  • HR_ACCTG_LINE-ACTIVITY_ID
  • HR_ACCTG_LINE-RESOURCE_TYPE
  • HR_ACCTG_LINE-RESOURCE_CATEGORY
  • HR_ACCTG_LINE-RESOURCE_SUB_CAT
  • HR_ACCTG_LINE-STATISTICS_CODE
  • HR_ACCTG_LINE-MONETARY_AMOUNT
  • HR_ACCTG_LINE-FOREIGN_AMOUNT
  • HR_ACCTG_LINE-FOREIGN_CURRENCY
  • HR_ACCTG_LINE-RT_TYPE
  • HR_ACCTG_LINE-RATE_MULT
  • HR_ACCTG_LINE-RATE_DIV
  • HR_ACCTG_LINE-STATISTIC_AMOUNT
  • HR_ACCTG_LINE-JRNL_LN_REF
  • HR_ACCTG_LINE-OPEN_ITEM_STATUS
  • HR_ACCTG_LINE-LINE_DESCR
  • HR_ACCTG_LINE-JRNL_LINE_STATUS
  • HR_ACCTG_LINE-JOURNAL_LINE_DATE
  • HR_ACCTG_LINE-BUSINESS_UNIT
  • HR_ACCTG_LINE-APPL_JRNL_ID
  • HR_ACCTG_LINE-ACCOUNTING_DT
  • HR_ACCTG_LINE-GL_DISTRIB_STATUS
  • HR_ACCTG_LINE-PROCESS_INSTANCE
  • HR_ACCTG_LINE-CURRENCY_CD
  • HR_ACCTG_LINE-LEDGER
  • HR_ACCTG_LINE-LEDGER_GROUP
  • HR_ACCTG_LINE-USE_DISTRIBUTION

End of Article

Previous Article (job aid) DB Link Details
Next Article (job aid) CS/CFS/CHRS Cross Database Impacts
To request a new article or update: Contact Us