Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNEMPEXER


                             BNEMPEXER FILE

REFERENCED BY

BN223     BN234     BN33.1    BN33.2    BN33.3    BN33.4
BN533     HR170     HR70.1    BN01.2

UPDATED BY

BN107     BN137     BN534     HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BXR-COMPANY            Numeric 4                                 BN534
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

BXR-EMPLOYEE           Numeric 9                                 BN534
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

BXR-OPT-GRANT-NBR      Alpha 10                                  BN534
Element: Opt Grant Nbr

BXR-EXERCISE-DATE      Numeric 8  (yyyymmdd)                     BN534
Element: Exercise Date

BXR-SEQ-NBR            Numeric 4                                 BN534
Element: Sequence NumbeAn automatically assigned sequence
                       number.

BXR-SHARES-EXE         Numeric 9                                 BN107   BN534
Element: Shares Exe

BXR-EXERCISE-PRICE     Signed 9.4                                BN107   BN534
Element: Exercise Price

BXR-PENDING            Alpha 1                                   BN534
Element: Pending       1 = Pending
                       2 = Completed

BXR-TRANSAC-VALUE      Signed 13.2
Element: Transac Value

BXR-GAIN-LOST-VAL      Signed 13.2
Element: Gain Lost Val

BXR-TAX-WAGE-UPD       Signed 13.2                               BN534
Element: Tax Wage Upd

BXR-EMP-TAX-AMT        Signed 13.2                               BN534
Element: Emp Tax Amt

BXR-FORFEIT-SHARES     Numeric 9                                 BN107   BN534
Element: Forfeit Shares

BXR-BROKER             Alpha 4                                   BN534
Element: Broker

BXR-EXERCISE-COST      Signed 13.2
Element: Exercise Cost

BXR-DATE-STAMP         Numeric 8  (yyyymmdd)                     BN107   BN534
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

BXR-TIME-STAMP         Numeric 6  (hhmmss)                       BN107   BN534
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

BXR-USER-ID            Alpha 10  (Lower Case)                    BN107   BN534
Element: User          Contains the user ID of the person who
                       last changed this record.

BXR-APPROVAL-FLAG      Alpha 1
Element: Approval      N = No
                       Y = Yes

BXR-PAYROLL-UPDATE     Alpha 1
Element: Payroll UpdateN = No
                       Y = Yes

BXR-FAIR-MKT-VAL       Signed 9.4                                BN107   BN534
Element: Fair Mkt Val

BXR-MKT-VAL-DATE       Numeric 8  (yyyymmdd)                     BN534
Element: Mkt Val Date

BXR-CURRENCY-CODE      Alpha 5                                   BN534
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

BXR-CURR-ND            Numeric 1                                 BN534
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

BXR-STOCK-FEES         Signed 13.2                               BN534
Element: Stock Fees

BXR-BASE-EXER-PRIC     Signed 9.4                                BN107   BN534
Element: Base Exer Pric

BXR-BASE-TRANS-VAL     Signed 13.2                               BN534
Element: Base Trans Val

BXR-BASE-GAIN-LOST     Signed 13.2                               BN534
Element: Base Gain Lost

BXR-BASE-TAX-WAGE      Signed 13.2                               BN534
Element: Base Tax Wage

BXR-BASE-EMP-TAX       Signed 13.2                               BN534
Element: Base Emp Tax

BXR-BASE-EXER-COST     Signed 13.2                               BN534
Element: Base Exer Cost

BXR-BASE-FR-MKT-VL     Signed 9.4                                BN107   BN534
Element: Base Fr Mkt Vl

BXR-BASE-STOCK-FEE     Signed 13.2                               BN534
Element: Base Stock Fee

BXR-EMP-EXER-PRICE     Signed 9.4                                BN107   BN534
Element: Emp Exer Price

BXR-EMP-TRANS-VAL      Signed 13.2                               BN534
Element: Emp Trans Val

BXR-EMP-GAIN-LOST      Signed 13.2                               BN534
Element: Emp Gain Lost

BXR-EMP-TAX-WAGE       Signed 13.2                               BN534
Element: Emp Tax Wage

BXR-EMP-EMP-TAX        Signed 13.2                               BN534
Element: Emp Emp Tax

BXR-EMP-EXER-COST      Signed 13.2                               BN534
Element: Emp Exer Cost

BXR-EMP-FR-MKT-VAL     Signed 9.4                                BN107   BN534
Element: Emp Fr Mkt Val

BXR-EMP-STOCK-FEES     Signed 13.2                               BN534
Element: Emp Stock Fees

BXR-BASE-CURRENCY      Alpha 5                                   BN534
Element: Base Currency The company base currency.

BXR-BASE-ND            Numeric 1                                 BN534
Base Number Of         The number of decimal positions defined
Decimals               for the company base currency.

BXR-EMP-CURRENCY       Alpha 5                                   BN534
Element: Emp Currency

BXR-EMP-ND             Numeric 1                                 BN534
Element: Emp Nd

BXR-EXER-TYPE          Alpha 1                                   BN534
Element: Exer Type     1 = Exercise and Sell
                       2 = Exercise and Hold
                       3 = Sell to Cover Exercise
                       4 = Stock Swap
                       5 = Forfeit

BXR-STOCK-CTF          Alpha 10                                  BN534
Element: Stock Ctf

                         BNEMPEXER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BXRSET1   COMPANY                                                BN137   BN223
          EMPLOYEE                                               BN234   BN33.1
          OPT-GRANT-NBR                                          BN33.2  BN33.3
          STOCK-CTF                                              BN533   BN534
          EXERCISE-DATE                                          HR11.1  HR170
          SEQ-NBR                                                HR70.1  PA115

BXRSET2   COMPANY       KeyChange                                BN33.4
          EMPLOYEE
          OPT-GRANT-NBR
          STOCK-CTF
          EXERCISE-DATE*
          SEQ-NBR

BXRSET3   BROKER        KeyChange                                BN01.2
          COMPANY
          EMPLOYEE
          OPT-GRANT-NBR
          STOCK-CTF
          EXERCISE-DATE
          SEQ-NBR

BXRSET4   COMPANY                                                BN107
          OPT-GRANT-NBR
          STOCK-CTF
          EXERCISE-DATE
          EMPLOYEE
          SEQ-NBR

BXRSET5   COMPANY       KeyChange, Subset                        BN234
          EMPLOYEE      Where (PENDING = "1" )
          OPT-GRANT-NBR
          STOCK-CTF
          EXERCISE-DATE
          SEQ-NBR

                         BNEMPEXER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Base Currency  CUCODES      Required

                            BXR-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Bnempgrnt      BNEMPGRNT    Required

                            BXR-COMPANY          -> BEG-COMPANY
                            BXR-EMPLOYEE         -> BEG-EMPLOYEE
                            BXR-OPT-GRANT-NBR    -> BEG-OPT-GRANT-NBR
                            BXR-STOCK-CTF        -> BEG-STOCK-CTF

Broker         BNBROKER     Required
                            When (BXR-BROKER != Spaces )

                            BXR-BROKER           -> BRK-BROKER

Company        PRSYSTEM     Required

                            BXR-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required

                            BXR-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Emp Currency   CUCODES      Required

                            BXR-EMP-CURRENCY     -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required

                            BXR-COMPANY          -> EMP-COMPANY
                            BXR-EMPLOYEE         -> EMP-EMPLOYEE

Option         BNSTKGNT     Required

                            BXR-COMPANY          -> BSG-COMPANY
                            BXR-OPT-GRANT-NBR    -> BSG-OPT-GRANT-NBR