BNWAIT

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
BN216 BN345 HR55.1


UPDATED BY
BN15.1 BN16.1 BN16.2 BN16.3 BN16.4 BN100
BN101 BN102 BN103 BN105 BN145 BN232
BN245 BN260 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN320 BN331 BN340 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 ZB01.1
ZB10.1 ZB10.2 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BWT-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-RULE-TYPE
Element: Rule Type		Alpha 1
Contains waiting period rules used at 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
BN16.1 BN16.2
BN16.3 BN16.4
BWT-PLAN-TYPE
Element: Plan Type		Alpha 2
Contains the benefit plan type.
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
BN16.1 BN16.2
BN16.3 BN16.4
BWT-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a benefit plan.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the start date for the rule.
BN100 BN101
BN102 BN103
BN105 BN145
BN16.1 BN16.2
BN16.3 BN16.4
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB01.1 ZB10.1
ZB10.2 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BWT-GROUP-NAME
Element: Group Name		Alpha 10
Contains the employee group for which the rule applies. If the group is blank, the system will use this rule for all employees.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-ACTION-CODE
Element: Action Code		Alpha 10
This field contains the personnel action code for add, change, and termination rules.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-ENTRY-AGE
Element: Entry Age		Numeric 2
Contains the entry age if eligibility rules require a minimum age for entry into the plan.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-FROM-DATE
Element: From Date		Alpha 2
Indicates the date from which the 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
BN16.1 BN16.2
BN16.3 BN16.4
BWT-MNTHS-SERV
Element: Mnths Serv		Numeric 2
Indicates the number of months of service used to determine the initial eligibility date.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-HOURS-SERV
Element: Hours Serv		Signed 7.2
Indicates the hours of service used to determine the initial eligibility date.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-QUAL-PERIOD
Element: Qual Period		Numeric 3
Contains the number of days used to determine the initial eligibility date.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-PAY-CLASS
Element: Pay Class		Alpha 3
If hours are used to determine eligibility, this field contains the pay class used to determine which hours are used to determine eligibility.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-INIT-ENT-POINT
Element: Init Ent Point		Alpha 1
Indicates the initial entry point at 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
BN16.1 BN16.2
BN16.3 BN16.4
BWT-ENTRY-MMDD
Element: Entry Mmdd		Numeric 4 Occurs 12 Times
If entry points are used, this field contains the specific month and day initial eligibility date.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-SUB-FROM
Element: Sub From		Alpha 2
If re-enrollment rules are used, this 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
BN16.1 BN16.2
BN16.3 BN16.4
BWT-SUB-MOS
Element: Sub Mos		Numeric 2
If re-enrollment rules are used, this field contains the number of months from the beginning date used to calculate re-enrollment eligibility.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-SUB-DAYS
Element: Sub Days		Numeric 3
If re-enrollment rules are used, this field contains the number of days from the beginning date used to calculate re-enrollment eligibility.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-SUB-CLASS
Element: Sub Class		Alpha 3
If re-enrollment rules are used, this field contains the pay class used to determine which hours are used for re-enrollment.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-SUB-HOURS
Element: Sub Hours		Signed 7.2
If re-enrollment rules are used, this field contains the number of hours from the subsequent enrollment date used to calculate re-enrollment eligibility.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-SUB-ENT-POINT
Element: Sub Ent Point		Alpha 1
If re-enrollment rules are used, this 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
BN16.1 BN16.2
BN16.3 BN16.4
BWT-SUB-POINTS
Element: Sub Points		Numeric 4 Occurs 12 Times
If re-enrollment rules are used with entry points, this field contains the months and days used as entry points.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-TERM-STOP-DATE
Element: Term Stop Date		Alpha 2
If termination rules are used, this 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
BN16.1 BN16.2
BN16.3 BN16.4
BWT-TERM-MOS
Element: Term Mos		Numeric 2
If termination rules are used, this field contains the number of months used to calculate the benefit termination date.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-TERM-DAYS
Element: Term Days		Numeric 3
If termination rules are used, this field contains the number of days from the termination stop date that benefits will terminate.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-CHG-WAIT
Element: Chg Wait		Alpha 1
This field is not used.
0 = Not Updated
1 = Updated
BN16.1 BN16.2
BN16.3 BN16.4
BWT-COBRA-OCC
Element: Cobra Occ		Alpha 1
If termination rules are used, this field defines whether this benefit termination is a COBRA occurrence.
Y = Yes
N = No
BN16.1 BN16.2
BN16.3 BN16.4
BWT-COBRA-TYPE
Element: Cobra Type		Alpha 2
If this benefit termination is a COBRA occurrence, this field defines the of occurrence.
BN16.1 BN16.2
BN16.3 BN16.4
BWT-RE-ENROLL-DATE
Element: Re Enroll Date		Alpha 2
If 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
Element: Change Effect		Alpha 2
If change rules are used, this field 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
BN16.1 BN16.2
BN16.3 BN16.4
BWT-TRAN-REASON
Element: Reason		Alpha 10
BN16.1 BN16.2
BN16.3 BN16.4
BWT-SUB-TYPE
Element: Ben Sub Type		Alpha 1

1 = By Benefit Type
2 = By Plan
BWT-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN16.1 BN16.2
BN16.3 BN16.4
BWT-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN16.1 BN16.2
BN16.3 BN16.4
BWT-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN16.1 BN16.2
BN16.3 BN16.4
BWT-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN16.1 BN16.2
BN16.3 BN16.4
BWT-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BN16.1 BN16.2
BN16.3 BN16.4
BWT-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN16.1 BN16.2
BN16.3 BN16.4


BNWAIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BWTSET1 COMPANY
RULE-TYPE
PLAN-TYPE
PLAN-CODE
START-DATE
GROUP-NAME
ACTION-CODE
...
BN100 BN101
BN102 BN103
BN105 BN145
BN15.1 BN16.1
BN16.2 BN16.3
BN16.4 BN16.5
BN16.6 BN216
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 BN345
BN45.1 BN531
BN65.1 BN71.1
BWTSET2 COMPANY
RULE-TYPE
PLAN-TYPE
PLAN-CODE
START-DATE*
GROUP-NAME
ACTION-CODE
...
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 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
RULE-TYPE
PLAN-TYPE
PLAN-CODE
ACTION-CODE
START-DATE*
GROUP-NAME
...
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN340 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
PLAN-TYPE
PLAN-CODE
RULE-TYPE
START-DATE
GROUP-NAME
ACTION-CODE
BN15.1 BN216


BNWAIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:10:05 2016

Home
Contact Us



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