|
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
Element: Company Hr Contains the company number. The number
correlates all information about the
company.
BNF-EMPLOYEE Numeric 9 BN47.1 BN547
Element: Employee Contains the employee's number. The
number correlates all information about
the employee.
BNF-PLAN-TYPE Alpha 2 BN47.1 BN547
Element: Plan 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
Element: Plan Code Contains the plan code.
BNF-SEQ-NBR Numeric 4 BN47.1 BN547
Element: Seq Nbr 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
Element: Last Name Contains the beneficiary's last name.
BNF-FIRST-NAME Alpha 15 (Lower Case) BN47.1 BN547
Element: First Name Contains the beneficiary's first name.
BNF-MIDDLE-INIT Alpha 1 BN47.1 BN547
Element: Middle Init Contains the beneficiary's middle
initial.
BNF-PCT-AMT-FLAG Alpha 1 BN47.1 BN547
Element: Pct Amt Flag Indicates whether the payment to the
beneficiary is a percent or a flat
dollar amount.
A = Amount
P = Percent
BNF-PMT-AMT Signed 11.2 BN47.1 BN547
Element: Pmt Amt Contains the percent or dollar amount
to be paid to the beneficiary.
BNF-PRIM-CNTGNT Numeric 1 BN47.1 BN547
Element: Prim Cntgnt Indicates whether the beneficiary is
primary or contingent.
1 = Primary
2 = Contingent
BNF-BENEF-TYPE Numeric 1 BN47.1 BN547
Element: Benef Type 0 = Individual
1 = Trust
BNF-TRUST Alpha 60 (Lower Case) BN47.1 BN547
Element: Trust
BNF-LAST-NAME-PRE Alpha 30 (Lower Case) BN47.1 BN547
Element: Last Name Pre
BNF-NAME-SUFFIX Alpha 4 (Lower Case) BN47.1 BN547
Element: Name Suffix
BNF-REL-CODE Alpha 10 BN47.1 BN547
Element: Rel Code
BNF-FICA-NBR Alpha 20 BN47.1 BN547
Element: Social Number
BNF-EMP-ADDRESS Alpha 1 BN47.1 BN547
Element: Emp Address H = Home Address
S = Supplemental Address
BNF-ADDR1 Alpha 30 (Lower Case) BN47.1 BN547
Element: Addr1 This field contains the first line of
address information.
BNF-ADDR2 Alpha 30 (Lower Case) BN47.1 BN547
Element: Addr1 This field contains the first line of
address information.
BNF-ADDR3 Alpha 30 (Lower Case) BN47.1 BN547
Element: Addr1 This field contains the first line of
address information.
BNF-ADDR4 Alpha 30 (Lower Case) BN47.1 BN547
Element: Addr1 This field contains the first line of
address information.
BNF-CITY Alpha 18 (Lower Case) BN47.1 BN547
Element: City This field contains the city of the
address.
BNF-STATE Alpha 2 BN47.1 BN547
Element: State This field contains the two-character
state code of the address.
BNF-ZIP Alpha 10 BN47.1 BN547
Element: Zip This field contains the postal code of
the address.
BNF-COUNTRY-CODE Alpha 2 BN47.1 BN547
Element: 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
Element: Cmt Text The text associated with the sequence
number.
BNF-LAST-PRE-SUF Derived
Element: Last Pre Suf
BNF-LAST-PRE Derived
Element: Last Pre
BNF-LAST-SUF Derived
Element: Last Suf
BNF-LAST-NAME-EXP Derived
Element: Last Name Exp
BNF-FIRST-MI Derived
Element: First Mi
BNF-FIRST-MI-EXP Derived
Element: First Mi Exp
BNF-FULL-NAME Derived
Element: Full Name
BNF-LABEL-NAME-1 Derived
Element: Label Name 1
BNF-BENEF-NAME-1 Derived
Element: Benef Name 1
BNF-BENEF-NAME-2 Derived
Element: Benef Name 2
BNF-DATE-STAMP Numeric 8 (yyyymmdd) BN47.1 BN547
Element: 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
Element: 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
Element: User
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
|