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
BN430 BN47.1 BN547 BN100 BN101 BN102
BN103 BN105 BN245 BN247 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN531 BS32.1 BN232

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
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: Wed Jun 08 20:48:03 2016

Home
Contact Us



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