|
|
BNCOMMENTS FILE
Benefit Comments
The Benefits Comments file contains comments about benefit plans, flex plans,
employee benefits, COBRA participant benefits, and retiree benefits.
REFERENCED BY
BN215 BN231 BN232 BN233 BN258 HR55.1
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCM-COMPANY Numeric 4 BN90.1
Company Contains the company number. The number
correlates all information about the
company.
BCM-CMT-TYPE Alpha 2 BN90.1
Comment Type Contains the kind of comment.
EM = Employee
FL = Flex Benefits
PL = Plan
PT = Participant
BCM-EMPLOYEE Numeric 9 BN90.1
Employee Contains comments about the employee.
This is valid in the Employee file.
BCM-PARTICIPNT Numeric 9 BN90.1
Participant Number Contains comments about COBRA
participants. This is valid in the COBRA
Participant Master file.
BCM-PLAN-TYPE Alpha 2 BN90.1
Type 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
BCM-PLAN-CODE Alpha 4 BN90.1
Plan Contains the plan code for PL types.
For all other types, this field is
blank.
BCM-GROUP-NAME Alpha 10 BN90.1
Group Name Contains the employee group for which
the comments apply.
BCM-START-DATE Numeric 8 (yyyymmdd) BN90.1
Start Date Contains the flex dollar start date for
the flex year of the comments.
BCM-SEQ-NBR Numeric 4 BN90.1
Sequence Number Contains a system-generated number used
to track the order in which comment
records are related.
BCM-CMT-TEXT Alpha 60 (Lower Case) BN90.1
Comment Text Contains comment text.
BCM-DATE Numeric 8 (yyyymmdd) BN90.1
Date Contains the system date when comments
were typed.
BNCOMMENTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCMSET1 COMPANY BN00.1 BN100
CMT-TYPE BN101 BN102
EMPLOYEE BN103 BN105
PARTICIPNT BN15.1 BN215
PLAN-TYPE BN231 BN232
PLAN-CODE BN233 BN258
GROUP-NAME BN31.1 BN31.2
START-DATE BN32.1 BN32.2
SEQ-NBR BN32.3 BN430
BN531 BN71.1
BN72.1 BN90.1
BS32.1 HR55.1
BNCOMMENTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
And BCM-CMT-TYPE != "FL"
BCM-COMPANY -> PLN-COMPANY
BCM-PLAN-TYPE -> PLN-PLAN-TYPE
BCM-PLAN-CODE -> PLN-PLAN-CODE
|