DEPBEN

UPDATED BY
BS30.1 BS31.1 BS531 HR11.1 HR13.1 HR513
PA115 PA218

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DEP-COMPANY
Element: Company Hr		Numeric 4
BS30.1
DEP-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BS30.1
DEP-DEPENDENT
Element: Dependent		Numeric 4
BS30.1
DEP-PLAN-TYPE
Element: Plan Type		Alpha 2
BS30.1
DEP-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a benefit plan.
BS30.1
DEP-EMP-START
Element: Emp Start		Numeric 8 (yyyymmdd)
BS30.1
DEP-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
BS30.1
DEP-STOP-DATE
Element: Stop Date		Numeric 8 (yyyymmdd)
BS30.1
DEP-FC
Element: Fc		Alpha 1
BS30.1
DEP-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BS30.1
DEP-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BS30.1
DEP-USER-ID
Element: User		Alpha 10 (Lower Case)
BS30.1
DEP-CREATE-TRANS
Element: Create Trans		Alpha 1

Y = Yes
N = No
BS30.1
DEP-TRAN-REASON
Element: Reason		Alpha 10
BS30.1
DEP-MEMBER-ID
Element: Member Id		Numeric 1
BS30.1
DEP-BN-TYPE
Element: Bn Type		Alpha 1

1 = Annual
2 = Life Event
3 = New Hire
BS30.1
DEP-HOLD-FLAG
Element: Hold Flag		Alpha 1

N = No
Y = Yes


DEPBEN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DEPSET1 COMPANY
EMPLOYEE
DEPENDENT
PLAN-TYPE
PLAN-CODE
EMP-START
START-DATE
BS30.1 BS31.1
HR11.1 HR13.1
HR513 PA115
PA218
DEPSET3 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
EMP-START
DEPENDENT
START-DATE
BS531


DEPBEN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Bnben BNBEN Required
DEP-COMPANY->BNB-COMPANY
DEP-EMPLOYEE->BNB-EMPLOYEE
DEP-PLAN-TYPE->BNB-PLAN-TYPE
DEP-PLAN-CODE->BNB-PLAN-CODE
DEP-EMP-START->BNB-START-DATE
Company PRSYSTEM Required
DEP-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Dependent EMDEPEND Required
DEP-COMPANY->EMD-COMPANY
DEP-EMPLOYEE->EMD-EMPLOYEE
DEP-DEPENDENT->EMD-SEQ-NBR
Employee EMPLOYEE Required
DEP-COMPANY->EMP-COMPANY
DEP-EMPLOYEE->EMP-EMPLOYEE
Plan PLAN Required
DEP-COMPANY->PLN-COMPANY
DEP-PLAN-TYPE->PLN-PLAN-TYPE
DEP-PLAN-CODE->PLN-PLAN-CODE
Reason Code PCODES Required
When DEP-TRAN-REASON !=Spaces
"BT"->PCO-TYPE
DEP-TRAN-REASON->PCO-CODE

File created: Wed Jun 08 20:48:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.