|
|
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
BN08.1 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
Element: Company Hr Contains the company number. The number
correlates all information about the
company.
BCM-CMT-TYPE Alpha 2 BN90.1
Element: Comment Type Contains the kind of comment.
EM = Employee
FL = Flex Benefits
PL = Plan
PT = Participant
BCM-EMPLOYEE Numeric 9 BN90.1
Element: Employee Contains comments about the employee.
This is valid in the Employee file.
BCM-PARTICIPNT Numeric 9 BN90.1
Element: Participant NuContains comments about COBRA
participants. This is valid in the COBRA
Participant Master file.
BCM-PLAN-TYPE Alpha 2 BN90.1
Element: 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
Element: Plan Contains the plan code for PL types.
For all other types, this field is
blank.
BCM-GROUP-NAME Alpha 10 BN90.1
Element: Group Name Contains the employee group for which
the comments apply.
BCM-START-DATE Numeric 8 (yyyymmdd) BN90.1
Element: Start Date Contains the flex dollar start date for
the flex year of the comments.
BCM-SEQ-NBR Numeric 4 BN90.1
Element: Sequence NumbeContains a system-generated number used
to track the order in which comment
records are related.
BCM-CMT-TEXT Alpha 60 (Lower Case) BN90.1
Element: Comment Text Contains comment text.
BCM-DATE Numeric 8 (yyyymmdd) BN90.1
Element: Date Contains the system date when comments
were typed.
BNCOMMENTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCMSET1 COMPANY BN00.1 BN08.1
CMT-TYPE BN100 BN101
EMPLOYEE BN102 BN103
PARTICIPNT BN105 BN15.1
PLAN-TYPE BN215 BN231
PLAN-CODE BN232 BN233
GROUP-NAME BN258 BN31.1
START-DATE BN31.2 BN32.1
SEQ-NBR BN32.2 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
|
