|
|
BNWAIT FILE
Benefit Waiting Period
Contains all plan eligibility rules for employees. It includes all initial
and re-enrollment rules used for benefit entry and all add, change, and
termination rules used by BN100 (Employee Change Benefit Update).
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN216 BN232 BN245 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN320 BN331 BN340 BN345
BN45.1 BN531 BN65.1 BN71.1 BN72.1 BS09.1
BS10.1 BS11.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 HR55.1
UPDATED BY
BN15.1 BN16.1 BN16.2 BN16.3 BN16.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BWT-COMPANY Numeric 4 BN16.1 BN16.2
Element: Company Hr Contains the company number. BN16.3 BN16.4
BWT-RULE-TYPE Alpha 1 BN16.1 BN16.2
Element: Rule Type Contains waiting period rules used at BN16.3 BN16.4
benefit entry. Add, change, and
termination rules are used by BN100
(Employee Change Benefit Update).
" " = Waiting Periods
A = Add Rules
C = Change Rules
T = Termination Rules
BWT-PLAN-TYPE Alpha 2 BN16.1 BN16.2
Element: Type Contains the benefit plan type. BN16.3 BN16.4
HL = Health
DN = Dental
DI = Disability
EL = Life
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
FL = Flex
BWT-PLAN-CODE Alpha 4 BN16.1 BN16.2
Element: Plan Contains the user-defined code that BN16.3 BN16.4
represents a benefit plan.
BWT-START-DATE Numeric 8 (yyyymmdd) BN16.1 BN16.2
Element: Start Date Contains the start date for the rule. BN16.3 BN16.4
BWT-GROUP-NAME Alpha 10 BN16.1 BN16.2
Element: Group Name Contains the employee group for which BN16.3 BN16.4
the rule applies. If the group is blank,
the system will use this rule for all
employees.
BWT-ACTION-CODE Alpha 10 BN16.1 BN16.2
Element: Action Code This field contains the personnel BN16.3 BN16.4
action code for add, change, and
termination rules.
BWT-ENTRY-AGE Numeric 2 BN16.1 BN16.2
Element: Entry Age Contains the entry age if eligibility BN16.3 BN16.4
rules require a minimum age for entry
into the plan.
BWT-FROM-DATE Alpha 2 BN16.1 BN16.2
Element: From Date Indicates the date from which the BN16.3 BN16.4
waiting period is calculated.
HI = Hire Date
AJ = Adjusted Hire Date
AN = Anniversary Date
PA = Personnel Action Eff Date
SN = Seniority Date
WP = Work Period Begin Date
B1 = Benefit Date 1
B2 = Benefit Date 2
B3 = Benefit Date 3
B4 = Benefit Date 4
B5 = Benefit Date 5
X = Custom Calculation
BWT-MNTHS-SERV Numeric 2 BN16.1 BN16.2
Element: Months Indicates the number of months of BN16.3 BN16.4
service used to determine the initial
eligibility date.
BWT-HOURS-SERV Signed 7.2 BN16.1 BN16.2
Element: Hours Indicates the hours of service used to BN16.3 BN16.4
determine the initial eligibility date.
BWT-QUAL-PERIOD Numeric 3 BN16.1 BN16.2
Element: Qual Period Contains the number of days used to BN16.3 BN16.4
determine the initial eligibility date.
BWT-PAY-CLASS Alpha 3 BN16.1 BN16.2
Element: Payment Class If hours are used to determine BN16.3 BN16.4
eligibility, this field contains the pay
class used to determine which hours are
used to determine eligibility.
BWT-INIT-ENT-POINT Alpha 1 BN16.1 BN16.2
Element: Init Ent PointIndicates the initial entry point at BN16.3 BN16.4
which employees begin to receive
benefits.
0 = No Entry Points
1 = Prior Entry Point
2 = Next Entry Point
3 = Prior Pay Period
4 = Next Pay Period
5 = Prior Work Period
6 = Next Work Period
BWT-ENTRY-MMDD Numeric 4 Occurs 12 Times BN16.1 BN16.2
Element: Entry Month DaIf entry points are used, this field BN16.3 BN16.4
contains the specific month and day
initial eligibility date.
BWT-SUB-FROM Alpha 2 BN16.1 BN16.2
Element: Sub From If re-enrollment rules are used, this BN16.3 BN16.4
field contains the beginning date used
calculate re-enrollment eligibility.
HI = Hire Date
AJ = Adjusted Hire Date
AN = Anniversary Date
SN = Seniority Date
B1 = Benefit Date 1
B2 = Benefit Date 2
B3 = Benefit Date 3
B4 = Benefit Date 4
B5 = Benefit Date 5
X = Custom Calculation
BWT-SUB-MOS Numeric 2 BN16.1 BN16.2
Element: Sub Mos If re-enrollment rules are used, this BN16.3 BN16.4
field contains the number of months from
the beginning date used to calculate
re-enrollment eligibility.
BWT-SUB-DAYS Numeric 3 BN16.1 BN16.2
Element: Sub Days If re-enrollment rules are used, this BN16.3 BN16.4
field contains
the number of days from the beginning
date used to calculate re-enrollment
eligibility.
BWT-SUB-CLASS Alpha 3 BN16.1 BN16.2
Element: Sub Class If re-enrollment rules are used, this BN16.3 BN16.4
field contains the pay class used to
determine which hours are used for
re-enrollment.
BWT-SUB-HOURS Signed 7.2 BN16.1 BN16.2
Element: Sub Hours If re-enrollment rules are used, this BN16.3 BN16.4
field contains the number of hours from
the subsequent enrollment date used to
calculate re-enrollment eligibility.
BWT-SUB-ENT-POINT Alpha 1 BN16.1 BN16.2
Element: Sub Ent Point If re-enrollment rules are used, this BN16.3 BN16.4
field determines if the re-enrollment
point has specific entry points.
0 = No Entry Points
1 = Prior Entry Point
2 = Next Entry Point
3 = Prior Pay Period
4 = Next Pay Period
5 = Prior Work Period
6 = Next Work Period
BWT-SUB-POINTS Numeric 4 Occurs 12 Times BN16.1 BN16.2
Element: Sub Points If re-enrollment rules are used with BN16.3 BN16.4
entry points, this field contains the
months and days used as entry points.
BWT-TERM-STOP-DATE Alpha 2 BN16.1 BN16.2
Element: Term Stop DateIf termination rules are used, this BN16.3 BN16.4
field contains the beginning date used
to calculate the benefit termination
date.
TM = Termination Date
PA = Personnel Action Date
WP = Work Period End Date
PP = Pay Period End Date
ME = End of Month
UE = Custom Calculation
BWT-TERM-MOS Numeric 2 BN16.1 BN16.2
Element: Term Mos If termination rules are used, this BN16.3 BN16.4
field contains the number of months used
to calculate the benefit termination
date.
BWT-TERM-DAYS Numeric 3 BN16.1 BN16.2
Element: Term Days If termination rules are used, this BN16.3 BN16.4
field contains the number of days from
the termination stop date that benefits
will terminate.
BWT-CHG-WAIT Alpha 1 BN16.1 BN16.2
Element: Chg Wait This field is not used. BN16.3 BN16.4
0 = Not Updated
1 = Updated
BWT-COBRA-OCC Alpha 1 BN16.1 BN16.2
Element: Cobra Occ If termination rules are used, this BN16.3 BN16.4
field defines whether this benefit
termination is a COBRA occurrence.
Y = Yes
N = No
BWT-COBRA-TYPE Alpha 2 BN16.1 BN16.2
Element: Cobra Type If this benefit termination is a COBRA BN16.3 BN16.4
occurrence, this field defines the of
occurrence.
BWT-RE-ENROLL-DATE Alpha 2
Element: Re Enroll DateIf the rule type is " " for the waiting
period, this field contains the
beginning date used to calculate the
re-enrollment date.
HI = Hire Date
AJ = Adjusted Hire Date
AN = Anniversary Date
PA = Personnel Action Eff Date
SN = Seniority Date
WP = Work Period Begin Date
B1 = Benefit Date 1
B2 = Benefit Date 2
B3 = Benefit Date 3
B4 = Benefit Date 4
B5 = Benefit Date 5
X = Custom Calculation
BWT-CHANGE-EFFECT Alpha 2 BN16.1 BN16.2
Element: Change Effect If change rules are used, this field BN16.3 BN16.4
contains the date the change is
effective.
PA = Personnel Action Eff Date
NM = First of Next Month
PM = First of Prior Month
DC = Date of Change
PP = Prior Pay Period
NP = Next Pay Period
PW = Prior Work Period
NW = Next Work Period
BWT-TRAN-REASON Alpha 10 BN16.1 BN16.2
Element: Reason BN16.3 BN16.4
BNWAIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BWTSET1 COMPANY BN100 BN101
RULE-TYPE BN102 BN103
PLAN-TYPE BN105 BN145
PLAN-CODE BN15.1 BN16.1
START-DATE BN16.2 BN16.3
GROUP-NAME BN16.4 BN16.5
ACTION-CODE BN16.6 BN216
BN232 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN345 BN45.1
BN531 BN65.1
BN71.1 BN72.1
...
BWTSET2 COMPANY BN100 BN101
RULE-TYPE BN102 BN103
PLAN-TYPE BN105 BN145
PLAN-CODE BN232 BN245
START-DATE* BN31.1 BN31.2
GROUP-NAME BN32.1 BN32.2
ACTION-CODE BN32.3 BN320
BN331 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
BWTSET3 COMPANY BN100 BN101
RULE-TYPE BN102 BN103
PLAN-TYPE BN105 BN145
PLAN-CODE BN232 BN245
ACTION-CODE BN31.1 BN31.2
START-DATE* BN32.1 BN32.2
GROUP-NAME BN32.3 BN320
BN331 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
BWTSET4 COMPANY BN15.1 BN216
PLAN-TYPE
PLAN-CODE
RULE-TYPE
START-DATE
GROUP-NAME
ACTION-CODE
BNWAIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Add Rules PLAN Required
When BWT-RULE-TYPE = "A"
BWT-COMPANY -> PLN-COMPANY
BWT-PLAN-TYPE -> PLN-PLAN-TYPE
BWT-PLAN-CODE -> PLN-PLAN-CODE
Change Rules PLAN Required
When BWT-RULE-TYPE = "C"
BWT-COMPANY -> PLN-COMPANY
BWT-PLAN-TYPE -> PLN-PLAN-TYPE
BWT-PLAN-CODE -> PLN-PLAN-CODE
Cobra Occur OCCURTYPE Required
BWT-COMPANY -> OCC-COMPANY
BWT-COBRA-TYPE -> OCC-OCCUR-TYPE
Payclass PAYCLASS Required
BWT-COMPANY -> PCL-COMPANY
BWT-PAY-CLASS -> PCL-PAY-CLASS
Persgroup PERSGROUP Not Required
BWT-COMPANY -> PRG-COMPANY
BWT-GROUP-NAME -> PRG-GROUP-NAME
Plan PLAN Required
BWT-COMPANY -> PLN-COMPANY
BWT-PLAN-TYPE -> PLN-PLAN-TYPE
BWT-PLAN-CODE -> PLN-PLAN-CODE
Prsystem PRSYSTEM Required
BWT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Reason Code PCODES Not Required
"BT" -> PCO-TYPE
BWT-TRAN-REASON -> PCO-CODE
Term Rules PLAN Required
When BWT-RULE-TYPE = "T"
BWT-COMPANY -> PLN-COMPANY
BWT-PLAN-TYPE -> PLN-PLAN-TYPE
BWT-PLAN-CODE -> PLN-PLAN-CODE
Wait Rules PLAN Required
When BWT-RULE-TYPE = Spaces
BWT-COMPANY -> PLN-COMPANY
BWT-PLAN-TYPE -> PLN-PLAN-TYPE
BWT-PLAN-CODE -> PLN-PLAN-CODE
|
