Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BENEFICRY


                             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: 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          Contains the plan code.

BNF-SEQ-NBR            Numeric 4                                 BN47.1  BN547
Element: Sequence NumbeContains 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 InitialContains 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
Element: Payment AmountContains 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
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: Relocation Code

BNF-FICA-NBR           Alpha 20                                  BN47.1  BN547
Element: Social Number

BNF-EMP-ADDRESS        Alpha 1                                   BN47.1  BN547
Element: Employee AddreH = Home Address
                       S = Supplemental Address

BNF-ADDR1              Alpha 30  (Lower Case)                    BN47.1  BN547
Element: Address 1     This field contains the first line of
                       address information.

BNF-ADDR2              Alpha 30  (Lower Case)                    BN47.1  BN547
Element: Address 1     This field contains the second line of
                       address information.

BNF-ADDR3              Alpha 30  (Lower Case)                    BN47.1  BN547
Element: Address 1     This field contains the third line of
                       address information.

BNF-ADDR4              Alpha 30  (Lower Case)                    BN47.1  BN547
Element: Address 1     This field contains the fourth 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 or ProviThis field contains the two-character
                       state code of the address.

BNF-ZIP                Alpha 10                                  BN47.1  BN547
Element: Postal Code   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: Comment 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          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