BENEFICRY

Beneficiary

The Beneficiary file contains information about the employee's primary and contingent beneficiaries for disability, employee life/AD&D, defined contribution, and defined benefit plans. The employee must have a benefit of the type and plan code to add the beneficiary record. BN47.1 (Beneficiary) is the primary program that updates this file.
UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN232
BN245 BN247 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN430 BN47.1 BN531 BN547 BS32.1
ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNF-COMPANY
Element: Company Hr
Numeric 4
Contains the company number. The number correlates all information about the company.
BN47.1 BN547
BNF-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee's number. The number correlates all information about the employee.
BN47.1 BN547
BNF-PLAN-TYPE
Element: Plan Type
Alpha 2
Contains the kind of plan the beneficiary is associated with.
DB = Defined Benefit
DC = Defined Contribution
DI = Disability
EL = Employee Life
BN47.1 BN547
BNF-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the plan code.
BN47.1 BN547
BNF-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the sequence number of the beneficiary. It is auto sequenced based on PEM-LAST-BNF-SEQ.
BN47.1 BN547
BNF-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Contains the beneficiary's last name.
BN47.1 BN547
BNF-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Contains the beneficiary's first name.
BN47.1 BN547
BNF-MIDDLE-INIT
Element: Middle Init
Alpha 1
Contains the beneficiary's middle initial.
BN47.1 BN547
BNF-PCT-AMT-FLAG
Element: Pct Amt Flag
Alpha 1
Indicates whether the payment to the beneficiary is a percent or a flat dollar amount.
A = Amount
P = Percent
BN47.1 BN547
BNF-PMT-AMT
Element: Pmt Amt
Signed 11.2
Contains the percent or dollar amount to be paid to the beneficiary.
BN47.1 BN547
BNF-PRIM-CNTGNT
Element: Prim Cntgnt
Numeric 1
Indicates whether the beneficiary is primary or contingent.
1 = Primary
2 = Contingent
BN47.1 BN547
BNF-BENEF-TYPE
Element: Benef Type
Numeric 1

0 = Individual
1 = Trust
BN47.1 BN547
BNF-TRUST
Element: Trust
Alpha 60 (Lower Case)
BN47.1 BN547
BNF-LAST-NAME-PRE
Element: Last Name Pre
Alpha 30 (Lower Case)
BN47.1 BN547
BNF-NAME-SUFFIX
Element: Name Suffix
Alpha 4 (Lower Case)
BN47.1 BN547
BNF-REL-CODE
Element: Rel Code
Alpha 10
BN47.1 BN547
BNF-FICA-NBR
Element: Social Number
Alpha 20
BN47.1 BN547
BNF-EMP-ADDRESS
Element: Emp Address
Alpha 1

H = Home Address
S = Supplemental Address
BN47.1 BN547
BNF-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN47.1 BN547
BNF-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN47.1 BN547
BNF-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN47.1 BN547
BNF-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN47.1 BN547
BNF-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
BN47.1 BN547
BNF-STATE
Element: State
Alpha 2
This field contains the two-character state code of the address.
BN47.1 BN547
BNF-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the address.
BN47.1 BN547
BNF-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
BN47.1 BN547
BNF-CMT-TEXT
Element: Cmt Text
Alpha 60 (Lower Case)
The text associated with the sequence number.
BN47.1 BN547
BNF-LAST-PRE-SUF
Element: Last Pre Suf
Derived
BNF-LAST-PRE
Element: Last Pre
Derived
BNF-LAST-SUF
Element: Last Suf
Derived
BNF-LAST-NAME-EXP
Element: Last Name Exp
Derived
BNF-FIRST-MI
Element: First Mi
Derived
BNF-FIRST-MI-EXP
Element: First Mi Exp
Derived
BNF-FULL-NAME
Element: Full Name
Derived
BNF-LABEL-NAME-1
Element: Label Name 1
Derived
BNF-BENEF-NAME-1
Element: Benef Name 1
Derived
BNF-BENEF-NAME-2
Element: Benef Name 2
Derived
BNF-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN47.1 BN547
BNF-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN47.1 BN547
BNF-USER-ID
Element: User
Alpha 10 (Lower Case)
BN47.1 BN547


BENEFICRY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNFSET1 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
SEQ-NBR
BN100 BN101
BN102 BN103
BN105 BN245
BN247 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN47.1
BN531 BN547
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BNFSET2 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
PRIM-CNTGNT
SEQ-NBR
KeyChange
BN232 BN47.1


BENEFICRY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
BNF-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
BNF-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
BNF-COUNTRY-CODE->INT-COUNTRY-CODE
Employee EMPLOYEE Required
BNF-COMPANY->EMP-COMPANY
BNF-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
BNF-COMPANY->PEM-COMPANY
BNF-EMPLOYEE->PEM-EMPLOYEE
Pcodes PCODES Required
"DP"->PCO-TYPE
BNF-REL-CODE->PCO-CODE
Plan PLAN Required
BNF-COMPANY->PLN-COMPANY
BNF-PLAN-TYPE->PLN-PLAN-TYPE
BNF-PLAN-CODE->PLN-PLAN-CODE
Relation PCODES Required
"DP"->PCO-TYPE
BNF-REL-CODE->PCO-CODE


BENEFICRY FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Name Suffix HRCTRYCODE
"SU"->CTC-TYPE
BNF-NAME-SUFFIX->CTC-HRCTRY-CODE
  CTC-COUNTRY-CODE


File created: Thu Jun 09 11:09:48 2016

Home
Contact Us



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