BNCOMMENTS

Benefit Comments

The Benefits Comments file contains comments about benefit plans, flex plans, employee benefits, COBRA participant benefits, and retiree benefits.
UPDATED BY
BN00.1 BN100 BN101 BN102 BN103 BN105
BN15.1 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN430 BN531 BN71.1 BN72.1 BN90.1 BS32.1
BN08.1 BN215 BN231 BN232 BN233 BN258
HR55.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCM-COMPANY
Element: Company Hr		Numeric 4
Contains the company number. The number correlates all information about the company.
BN90.1
BCM-CMT-TYPE
Element: Comment Type		Alpha 2
Contains the kind of comment.
EM = Employee
FL = Flex Benefits
PL = Plan
PT = Participant
BN90.1
BCM-EMPLOYEE
Element: Employee		Numeric 9
Contains comments about the employee. This is valid in the Employee file.
BN90.1
BCM-PARTICIPNT
Element: Participnt		Numeric 9
Contains comments about COBRA participants. This is valid in the COBRA Participant Master file.
BN90.1
BCM-PLAN-TYPE
Element: Plan Type		Alpha 2
Contains the benefit type.
DB = Defined Benefit
DC = Defined Contribution
DI = Disability
DL = Dependent Life
DN = Dental
EL = Employee Life
HL = Health
RS = Spending Account
SB = Savings Bond
VA = Vacation
BN90.1
BCM-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the plan code for PL types. For all other types, this field is blank.
BN90.1
BCM-GROUP-NAME
Element: Group Name		Alpha 10
Contains the employee group for which the comments apply.
BN90.1
BCM-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the flex dollar start date for the flex year of the comments.
BN90.1
BCM-SEQ-NBR
Element: Sequence Number		Numeric 4
Contains a system-generated number used to track the order in which comment records are related.
BN90.1
BCM-CMT-TEXT
Element: Comment Text		Alpha 60 (Lower Case)
Contains comment text.
BN90.1
BCM-DATE
Element: Date		Numeric 8 (yyyymmdd)
Contains the system date when comments were typed.
BN90.1


BNCOMMENTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCMSET1 COMPANY
CMT-TYPE
EMPLOYEE
PARTICIPNT
PLAN-TYPE
PLAN-CODE
GROUP-NAME
START-DATE
SEQ-NBR
BN00.1 BN08.1
BN100 BN101
BN102 BN103
BN105 BN15.1
BN215 BN231
BN232 BN233
BN258 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN531
BN71.1 BN72.1
BN90.1 BS32.1
HR55.1


BNCOMMENTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
BCM-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
BCM-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When BCM-EMPLOYEE !=Zeroes
BCM-COMPANY->EMP-COMPANY
BCM-EMPLOYEE->EMP-EMPLOYEE
Participant PARTICIPNT Required
When BCM-PARTICIPNT !=Zeroes
BCM-COMPANY->PAR-COMPANY
BCM-PARTICIPNT->PAR-PARTICIPNT
Plan PLAN Required
When BCM-PLAN-CODE !=Spaces
AndBCM-CMT-TYPE !="FL"
BCM-COMPANY->PLN-COMPANY
BCM-PLAN-TYPE->PLN-PLAN-TYPE
BCM-PLAN-CODE->PLN-PLAN-CODE

File created: Wed Jun 08 20:48:05 2016

Home
Contact Us



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