|
|
DEPBEN FILE
UPDATED BY
BS30.1 BS31.1 BS531 HR11.1 HR13.1 HR513
PA115 PA218
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DEP-COMPANY Numeric 4 BS30.1
Element: Company Hr
DEP-EMPLOYEE Numeric 9 BS30.1
Element: 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
Element: Dependent
DEP-PLAN-TYPE Alpha 2 BS30.1
Element: Plan Type
DEP-PLAN-CODE Alpha 4 BS30.1
Element: Plan Code Contains the user-defined code that
represents a benefit plan.
DEP-EMP-START Numeric 8 (yyyymmdd) BS30.1
Element: Emp Start
DEP-START-DATE Numeric 8 (yyyymmdd) BS30.1
Element: Start Date
DEP-STOP-DATE Numeric 8 (yyyymmdd) BS30.1
Element: Stop Date
DEP-FC Alpha 1 BS30.1
Element: Fc
DEP-DATE-STAMP Numeric 8 (yyyymmdd) BS30.1
Element: 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) BS30.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
DEP-USER-ID Alpha 10 (Lower Case) BS30.1
Element: User
DEP-CREATE-TRANS Alpha 1 BS30.1
Element: Create Trans Y = Yes
N = No
DEP-TRAN-REASON Alpha 10 BS30.1
Element: Reason
DEP-MEMBER-ID Numeric 1 BS30.1
Element: Member Id
DEP-BN-TYPE Alpha 1 BS30.1
Element: Bn Type 1 = Annual
2 = Life Event
3 = New Hire
DEPBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DEPSET1 COMPANY BS30.1 BS31.1
EMPLOYEE HR11.1 HR13.1
DEPENDENT HR513 PA115
PLAN-TYPE PA218
PLAN-CODE
EMP-START
START-DATE
DEPSET3 COMPANY BS531
EMPLOYEE
PLAN-TYPE
PLAN-CODE
EMP-START
DEPENDENT
START-DATE
DEPBEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
