BENEFICRY FILE
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.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN245
BN247 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN531 BS32.1 BN232
UPDATED BY
BN430 BN47.1 BN547
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNF-COMPANY Numeric 4 BN47.1 BN547
Company Contains the company number. The number
correlates all information about the
company.
BNF-EMPLOYEE Numeric 9 BN47.1 BN547
Employee Contains the employee's number. The
number correlates all information about
the employee.
BNF-PLAN-TYPE Alpha 2 BN47.1 BN547
Type Contains the kind of plan the
beneficiary is associated with.
DB = Defined Benefit
DC = Defined Contribution
DI = Disability
EL = Employee Life
BNF-PLAN-CODE Alpha 4 BN47.1 BN547
Plan Contains the plan code.
BNF-SEQ-NBR Numeric 4 BN47.1 BN547
Sequence Number Contains the sequence number of the
beneficiary. It is auto sequenced based
on PEM-LAST-BNF-SEQ.
BNF-LAST-NAME Alpha 30 (Lower Case) BN47.1 BN547
Last Name Contains the beneficiary's last name.
BNF-FIRST-NAME Alpha 15 (Lower Case) BN47.1 BN547
First Name Contains the beneficiary's first name.
BNF-MIDDLE-INIT Alpha 1 BN47.1 BN547
Middle Initial Contains the beneficiary's middle
initial.
BNF-PCT-AMT-FLAG Alpha 1 BN47.1 BN547
Percent or Amount Indicates whether the payment to the
Indicator beneficiary is a percent or a flat
dollar amount.
A = Amount
P = Percent
BNF-PMT-AMT Signed 11.2 BN47.1 BN547
Payment Amount Contains the percent or dollar amount
to be paid to the beneficiary.
BNF-PRIM-CNTGNT Numeric 1 BN47.1 BN547
Primary Contingent Indicates whether the beneficiary is
Indicator primary or contingent.
1 = Primary
2 = Contingent
BNF-BENEF-TYPE Numeric 1 BN47.1 BN547
Benef Type 0 = Individual
1 = Trust
BNF-TRUST Alpha 60 (Lower Case) BN47.1 BN547
Trust
BNF-LAST-NAME-PRE Alpha 30 (Lower Case) BN47.1 BN547
Last Name Pre
BNF-NAME-SUFFIX Alpha 4 (Lower Case) BN47.1 BN547
Name Suffix
BNF-REL-CODE Alpha 10 BN47.1 BN547
Relocation Code
BNF-FICA-NBR Alpha 15 BN47.1 BN547
Social Number
BNF-EMP-ADDRESS Alpha 1 BN47.1 BN547
Employee Address H = Home Address
S = Supplemental Address
BNF-ADDR1 Alpha 30 (Lower Case) BN47.1 BN547
Address 1 This field contains the first line of
address information.
BNF-ADDR2 Alpha 30 (Lower Case) BN47.1 BN547
Address 2 This field contains the second line of
address information.
BNF-ADDR3 Alpha 30 (Lower Case) BN47.1 BN547
Address 3 This field contains the third line of
address information.
BNF-ADDR4 Alpha 30 (Lower Case) BN47.1 BN547
Address 4 This field contains the fourth line of
address information.
BNF-CITY Alpha 18 (Lower Case) BN47.1 BN547
City This field contains the city of the
address.
BNF-STATE Alpha 2 BN47.1 BN547
State or Province This field contains the two-character
state code of the address.
BNF-ZIP Alpha 10 BN47.1 BN547
Postal Code This field contains the postal code of
the address.
BNF-COUNTRY-CODE Alpha 2 BN47.1 BN547
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
BNF-CMT-TEXT Alpha 60 (Lower Case) BN47.1 BN547
Comment Text The text associated with the sequence
number.
BNF-LAST-PRE-SUF Derived
Last Pre Suf
BNF-LAST-PRE Derived
Last Pre
BNF-LAST-SUF Derived
Last Suf
BNF-LAST-NAME-EXP Derived
Last Name Exp
BNF-FIRST-MI Derived
First Mi
BNF-FIRST-MI-EXP Derived
First Mi Exp
BNF-FULL-NAME Derived
Full Name
BNF-LABEL-NAME-1 Derived
Label Name 1
BNF-BENEF-NAME-1 Derived
Benef Name 1
BNF-BENEF-NAME-2 Derived
Benef Name 2
BNF-DATE-STAMP Numeric 8 (yyyymmdd) BN47.1 BN547
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
BNF-TIME-STAMP Numeric 6 (hhmmss) BN47.1 BN547
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BNF-USER-ID Alpha 10 (Lower Case) BN47.1 BN547
User ID Name Contains the user ID of the person who
last changed this record.
BENEFICRY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNFSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN-TYPE BN105 BN245
PLAN-CODE BN247 BN31.1
SEQ-NBR BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN47.1
BN531 BN547
BS32.1
BNFSET2 COMPANY KeyChange BN232 BN47.1
EMPLOYEE
PLAN-TYPE
PLAN-CODE
PRIM-CNTGNT
SEQ-NBR
BENEFICRY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Name Suffix HRCTRYCODE
"SU" -> CTC-TYPE
BNF-NAME-SUFFIX -> CTC-HRCTRY-CODE
CTC-COUNTRY-CODE
|
