BENEFITS-ER-CONTRIBUTION

DWH Archive Name: B__BENE_ER_CONT

Effective dated table of the employer contribution percents for benefits. Percentages are defined for up to 4 levels of employee appointment percent. Each ERCP-Group entry is for a benefit and one or more enrollment options, family coverage codes, and benefit locations. Only as many entries as necessary need to be defined, though the current maximum allowed is 48.

Data Element Definitions for BENEFITS-ER-CONTRIBUTION (U-303)

Type & Level		Field Name & Attributes	Format & Length		Comp Opt	Index	Field Definition
Primary Identifiers
	1	DATE-PERIOD-BEGIN DB=AK CS=HR	D		N		Begin date for the period of time an entity is effective.
	1	DATE-PERIOD-END DB=AL CS=HR	D		N	U	End date for the period of time an entity is effective.
Attributes
MU	1	EMP-APPT-PCT DB=AM CS=HR Max Occ=4 HD=__EMP_APPT_PCT	P	3.0	N		DWH Archive Name: B__BENE_ER_CONT__EMP_APPT_PCT The employee appointment percent used to define different employer benefit contribution percents -- the University may pay higher percentage cost of a benefit based upon full time versus different levels of part time employment.
PE	1	ERCP-GROUP DB=AN CS=* Max Occ=48 HD=__ERCP_GROUP					DWH Archive Name: B__BENE_ER_CONT__ERCP_GROUP A periodic repeating group that defines the employer contribution for a benefit, enrollment option, coverage, and location. Multiple values may be specified for the same entry, which eliminates any requirement for duplicate entries (when the percentages are the same across enrollment options, coverages, and locations).
	2	BENEFIT-CD DB=AO CS=HR PE=ERCP-GROUP	A	1.0	N		A code used to identify a specific benefit. Benefits are catagorized as major insurance (health, dental and vision), basic insurance (basic life, basic LTD, basic STD, and AD&D), flexible spending, other insurance (optional life, optional LTD, optional STD, and dependent life), voluntary products, and retirement.
MU	2	ENROLLMENT-OPTION DB=AP CS=HR Max Occ=3 HD=__ENROLL_OPT PE=ERCP-GROUP	A	1.0	N		DWH Archive Name: B__BENE_ER_CONT__ENROLL_OPT Identifies an employee selected option offered for a benefit. Options are defined within a system maintained table, and are not available for all benefits.
MU	2	FAMILY-COVERAGE-CD DB=AQ CS=HR Max Occ=4 PE=ERCP-GROUP	A	1.0	N		A code that identifies who within an employee's family is to be covered by a benefit. The possible codes are provided below, but not all codes are available for all benefits, nor is a family coverage option applicable to all benefits. I = Employee (individual), S = Employee and spouse, C = Employee and children (excludes spouse), or F = Family.
MU	2	BENEFIT-LOC-CD DB=AR CS=HR Max Occ=5 HD=__BENE_LOC_CD PE=ERCP-GROUP	A	4.0	N		DWH Archive Name: B__BENE_ER_CONT__BENE_LOC_CD Identifies the location for which rates and employer contributions are applicable. This location is derived from the appropriation location an employee's appointement. (It currently is the same except that AUX is translated to FAY.) Current values are: AES = Ag Experiment Station, ARCH = Archilogical Survey, CJI = Criminal Justice, FAY = Fayetteville, or SYS = System.
MU	2	ER-CONTRIBUTION-PCT DB=AS CS=HR Max Occ=4 HD=__ER_CONTRIB_PCT PE=ERCP-GROUP	P	3.4	N		DWH Archive Name: B__BENE_ER_CONT__ER_CONTRIB_PCT The percentage that a particular benefit location contributes to the cost of a specific benefit for an enrollment option and family coverage code. This defines the employer cost (benefit) versus the employee cost (deduction) for the benefit. The value may vary from 0% to 100%.
MU	1	COMMENT DB=AB CS=HR Max Occ=2 HD=__COMMENT	A	72.0	N		DWH Archive Name: B__BENE_ER_CONT__COMMENT A comment or brief note which may be associated with an entity. This field is maintained in mixed case.
Audit and Control Data
PE	1	UPDATE-HISTORY-GROUP DB=AC CS=* Max Occ=1 HD=__HIST_GRP					DWH Archive Name: B__BENE_ER_CONT__HIST_GRP The periodic repeating group which identifies the time and user that entered/updated a record: 1 = Initial entry or last update.
	2	TIME-OF-UPDATE DB=AD CS=UA PE=UPDATE-HISTORY-GROUP	T		N		Date and time that a record or associated item was last updated on the data base.
	2	UPDATED-BY-USER DB=AE CS=UA PE=UPDATE-HISTORY-GROUP	A	8.0	N		The Natural user ID (USER-ID) of the last user to update a record or associated item.
	2	UPDATED-BY-PROGRAM DB=AF CS=UA PE=UPDATE-HISTORY-GROUP	A	8.0	N		The Natural program name that updated a record or associated entity.
	1	TIME-STAMP DB=AA CS=UA	B	8.0	N		This field is used to uniquely identify each update to a record. Each time a record is updated, this field should be assigned the value of the Natural function *TIMESTMP. Programs should check to see if this field has changed from the time they first read a record until the time they read the record with hold. This will determine if someone else has altered the record.