EMPLOYEE-BDOE-OVERRIDE

DWH Archive Name: B__EMP_BDOE_OVERRIDE

Contains employee BDOE one-time overrides, used to explicitly control the amount of a BDOE for an employee for a payroll. Once an override is attempted to be applied, the Unattempted-Override-Cd is reset to null. This code will remain on for employees who were not paid on the specified payroll. Overrides may be attempted but not taken, resulting in a 'deduction not taken'.

Data Element Definitions for EMPLOYEE-BDOE-OVERRIDE (U-131)

Type & Level		Field Name & Attributes	Format & Length		Comp Opt	Index	Field Definition
Primary record identifiers
	1	EMP-ID DB=AA CS=UA	P	6.0	F		UA employee identification number, assigned uniquely to all new employees. Use of this value is encouraged in order to ensure the privacy of the employee's SSN. The SSN can be determined from the Emp ID and the Emp ID can be determined from the SSN (when the operator has been authorized for one of the budgetary units in which the employee works).
	1	BDOE-CD DB=AB CS=HR	A	4.0	F		A code used to identify a specific Benefit paid by the University on behalf of the employee, Deduction taken from the employee's gross pay, Other taxable earnings attributed to the employee and for which taxes are subject, Exempt earnings attributed to the employee for which taxes are not subject, or Earned income credit.
	1	DATE-PAY DB=AC CS=HR	D		F		The pay date associated with a pay activity, always corresponding with a scheduled payroll (all pay for a payroll is effective the same date). This value is normally system assigned and is the effective date of payment (check date). However, for all adjustments this is the adjustment payroll date while the manual check date (for typed vouchers) or the original pay date is identified via the Date-Payroll-Adj-Check.
	1	PAYROLL-TYPE DB=AD CS=HR	A	2.0	F		A two character code identifying a 'payroll' as one of the following: M = Monthly, regular appointed H = Hourly (run semi-monthly) O = Overtime/Supplement A = Adjustment (no one paid) EA = End of Academic term (special 9-mo. payroll) ES = End of Summer (special payroll at the end of the summer for 9-mo. folks being paid summer research) S = Semi-Monthly (for future use)
	1	BASE27-EMP-NAME DB=AE CS=HR	B	10.0	F		The first 16 characters of the employee's preferred name at the point in time an employee related data base record is created, converted to a base 27 value. This is used in descriptors (indexes) to provide lists of employees in alphabetical name sequence. Note that name changes performed on the employee file are not reflected in the value of this field for existing records. Base 27 values are provided by routine HRNENB27.
Override descriptive info
	1	SHORT-COMMENT DB=AI CS=HR	A	15.0	N		A short comment associated with a BDOE and displayed on the employee's earnings statment to assist in explaining the benefit, deduction, other earning, exempt earning, or EIC. This value may also be a specific code identifying a certain option or election for the BDOE (i.e., 'Classic Family' for health insurance). Such coded values can define a tablized rate and used in analysis of data.
	1	BDOE-OVERRIDE-TYPE DB=AF CS=HR	A	1.0	F		Identifies the type of BDOE override as: R = Replacement, use this amount instead of any benefit or setup derived amount I = Incrimental, add this amount to any benefit or setup derived amount
	1	BDOE-OVERRIDE-AMT DB=AG CS=HR	P	6.2	F		The specified, fixed amount of an override to be used as a replacement for or in addition to any BDOE amount derived from benefits or a BDOE setup (defined by type). This amount may be negative. Any of the resulting amount not applied is stored as a Deduction Not Taken.
	1	WITHHOLDING-CD DB=AJ CS=HR	A	1.0	N		Identifies circumstances where taxes should not be calculated and withheld on other taxable wages (other earnings). Values are coded as: = Normal taxing/withholding (or not an other taxable wage) B = Both federal and state tax calculation and withholding should exclude these 'other earnings'
PE	1	BD-PAYEE-GROUP DB=AV CS=* Max Occ=4 HD=__PAYEE_GRP					DWH Archive Name: B__EMP_BDOE_OVERRIDE__PAYEE_GRP The periodic repeating group identifying the recepient of a benefit or deduction (not wire transfered) identified by the vendor information necessary to process a check for the benefit or deduction amount through AP. The amount deducted can be split between up to four payees as defined by the accompanying percent, which must total 100.
	2	BD-PAYEE-VENDOR-NO DB=AW CS=HR PE=BD-PAYEE-GROUP	P	6.0	N		The UPS vendor number of the desired recepient of a benefit or deduction that is not being handled via wire transfer or deposited in the appropriate UA account. The vendor data from the BDOE table is used when present, otherwise the vendor data from the Setup or Override is used.
	2	BD-PAYEE-VENDOR-NAME-NO DB=AX CS=HR PE=BD-PAYEE-GROUP	P	2.0	N		The UPS vendor name number of the recepient of a benefit or deduction that is not being paid via a wire transfer.
	2	BD-PAYEE-VENDOR-ADDR-NO DB=AY CS=HR PE=BD-PAYEE-GROUP	P	3.0	N		The UPS vendor address number of the recepient of a benefit or deduction that is not being paid via a wire transfer.
	2	BD-PAYEE-PCT DB=AZ CS=* PE=BD-PAYEE-GROUP	P	3.0	N		The percentage defining how a benefit or deduction is to be divided when there are multiple recepients (payees).
	2	VENDOR-EMP-REFERENCE-ID DB=BA CS=HR PE=BD-PAYEE-GROUP	A	20.0	N		This is the identifier of an employee used by a deduction vendor (payee). It is how that vendor knows the employee so that the deduction, when received, can be properly credited. This is the employees case number, account, or employee ID with that vendor and is provided to the vendor with the payment via the remittance advice.
	2	CHECK-HANDLING-CD DB=BC CS=HR PE=BD-PAYEE-GROUP	P	1.0	N		The code identifying how a deduction check is to be generated and handled. This value is used to set the UPS Payment-Handling-Cd. Possible values are: 0 = Combine multiple payments on the same check, 1 = Combine multiple payments and hold the check, 2 = Produce a separate check for this payment, or 3 = Produce a separate check and have that check held.
MU	1	COMMENT DB=AL CS=HR Max Occ=2 HD=__COMMENT	A	72.0	N		DWH Archive Name: B__EMP_BDOE_OVERRIDE__COMMENT A comment or brief note which may be associated with an entity. This field is maintained in mixed case.
Audit and control data
	1	UNATTEMPTED-OVERRIDE-CD DB=AK CS=HR	A	1.0	N		Indicates whether a BDOE override has been attempted to be applied. It is only unattempted if the employee is not paid on the payroll, or the payroll has not yet run. Values are: Y = The override has not been attempted = The override was applied or resulted in a deduction not taken
PE	1	AUDIT-LOG-GROUP DB=AQ CS=* Max Occ=2 HD=__HIST_GRP					DWH Archive Name: B__EMP_BDOE_OVERRIDE__HIST_GRP The periodic repeating group used to record audit information. Occurrences represent the following maintenance activity: 1 - Creation or last update 2 - Removal of Unattempted flag
	2	TIME-OF-UPDATE DB=AR CS=UA PE=AUDIT-LOG-GROUP	T		N		Date and time that a record or associated item was last updated on the data base.
	2	UPDATED-BY-USER DB=AS CS=UA PE=AUDIT-LOG-GROUP	A	8.0	N		The Natural user ID (USER-ID) of the last user to update a record or associated item.
	1	TIME-STAMP DB=AH CS=UA	B	8.0	F		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.
Super-descriptors
SP	1	EMP-DATE-TYPE-BDOE-KEY DB=S1 CS=*	A	14.0		U	The super-descriptor composed of Emp-ID, Date-Pay, Payroll-Type, and BDOE-CD. This is the unique index used to define BDOE overrides and to determine the overrides defined for an employee for a payroll.
SP	1	DATE-TYPE-BDOE-B27-KEY DB=S2 CS=*	A	20.0		D	The super-descriptor composed of Date-Pay, Payroll-Type, BDOE-CD, and Base27-Emp-Name. This index is used to list the overrides for a specific payroll and BDOE by employee name.
SP	1	UNATTEMPTED-DATE-TYPE-EMP-KEY DB=S3 CS=*	A	11.0	N	D	The super-descriptor composed of Unattempted-Override-Cde, Date-Pay, Payroll-Type, and Emp-ID. This index is used to list the employees that were not paid and yet BDOE overrides were defined.