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.