DEPBEN FILE
UPDATED BY
BS30.1 BS31.1 BS531 HR13.1 HR513 PA218
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DEP-COMPANY Numeric 4 BS30.1
Company The company number represents an
established company and is entered on
all function codes.
DEP-EMPLOYEE Numeric 9 BS30.1
Employee 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.
DEP-DEPENDENT Numeric 4 BS30.1
Dependent Number
DEP-PLAN-TYPE Alpha 2 BS30.1
Type
DEP-PLAN-CODE Alpha 4 BS30.1
Plan Contains the user-defined code that
represents a benefit plan.
DEP-EMP-START Numeric 8 (yyyymmdd) BS30.1
Emp Start
DEP-START-DATE Numeric 8 (yyyymmdd) BS30.1
Start Date
DEP-STOP-DATE Numeric 8 (yyyymmdd) BS30.1
Stop Date
DEP-FC Alpha 1 BS30.1
Fc
DEP-DATE-STAMP Numeric 8 (yyyymmdd)
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
DEP-TIME-STAMP Numeric 6 (hhmmss)
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
DEP-USER-ID Alpha 10 (Lower Case)
User ID Name Contains the user ID of the person who
last changed this record.
DEPBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DEPSET1 COMPANY BS30.1 BS31.1
EMPLOYEE BS531 HR13.1
DEPENDENT HR513 PA218
PLAN-TYPE
PLAN-CODE
EMP-START
START-DATE
DEPSET2 COMPANY
PLAN-TYPE
PLAN-CODE
START-DATE
EMP-START
EMPLOYEE
DEPENDENT
DEPSET3 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
EMP-START
DEPENDENT
START-DATE
DEPSET4 COMPANY
EMPLOYEE
DEPENDENT
PLAN-TYPE
PLAN-CODE
EMP-START
START-DATE*
DEPBEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bnben BNBEN Required
DEP-COMPANY -> BNB-COMPANY (BNBSET1)
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
|
