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
| BN430 | BN47.1 | BN547 |
| 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. |
|
||
| BNF-EMPLOYEE Element: Employee | Numeric 9 Contains the employee's number. The number correlates all information about the employee. |
|
||
| 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 |
|
||
| BNF-PLAN-CODE Element: Plan Code | Alpha 4 Contains the plan code. |
|
||
| 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. |
|
||
| BNF-LAST-NAME Element: Last Name | Alpha 30 (Lower Case) Contains the beneficiary's last name. |
|
||
| BNF-FIRST-NAME Element: First Name | Alpha 15 (Lower Case) Contains the beneficiary's first name. |
|
||
| BNF-MIDDLE-INIT Element: Middle Init | Alpha 1 Contains the beneficiary's middle initial. |
|
||
| 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 |
|
||
| BNF-PMT-AMT Element: Pmt Amt | Signed 11.2 Contains the percent or dollar amount to be paid to the beneficiary. |
|
||
| BNF-PRIM-CNTGNT Element: Prim Cntgnt | Numeric 1 Indicates whether the beneficiary is primary or contingent. 1 = Primary 2 = Contingent |
|
||
| BNF-BENEF-TYPE Element: Benef Type | Numeric 1 0 = Individual 1 = Trust |
|
||
| BNF-TRUST Element: Trust | Alpha 60 (Lower Case) |
|
||
| BNF-LAST-NAME-PRE Element: Last Name Pre | Alpha 30 (Lower Case) |
|
||
| BNF-NAME-SUFFIX Element: Name Suffix | Alpha 4 (Lower Case) |
|
||
| BNF-REL-CODE Element: Rel Code | Alpha 10 |
|
||
| BNF-FICA-NBR Element: Social Number | Alpha 20 |
|
||
| BNF-EMP-ADDRESS Element: Emp Address | Alpha 1 H = Home Address S = Supplemental Address |
|
||
| BNF-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
| BNF-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
| BNF-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
| BNF-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
| BNF-CITY Element: Hr City | Alpha 58 (Lower Case) This field contains the city of the address. |
|
||
| BNF-STATE Element: State | Alpha 2 This field contains the two-character state code of the address. |
|
||
| BNF-ZIP Element: Zip | Alpha 10 This field contains the postal code of the address. |
|
||
| 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). |
|
||
| BNF-CMT-TEXT Element: Cmt Text | Alpha 60 (Lower Case) The text associated with the sequence number. |
|
||
| 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. |
|
||
| BNF-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
| BNF-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||
| BNF-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||
| BNF-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||
| BNF-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BNFSET1 |
COMPANY EMPLOYEE PLAN-TYPE PLAN-CODE SEQ-NBR |
|
|||||||||
| BNFSET2 |
COMPANY EMPLOYEE PLAN-TYPE PLAN-CODE PRIM-CNTGNT SEQ-NBR |
|
| ||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | BNCOMPANY |
Required
| |||||||||
| Company Name | PRSYSTEM |
Required
| |||||||||
| Country | INSTCTRYCD |
Required
| |||||||||
| Employee | EMPLOYEE |
Required
| |||||||||
| Paemployee | PAEMPLOYEE |
Required
| |||||||||
| Pcodes | PCODES |
Required
| |||||||||
| Plan | PLAN |
Required
| |||||||||
| Relation | PCODES |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Name Suffix | HRCTRYCODE |
|
All trademarks and registered trademarks are the property of their
respective owners.