Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RESTRANS


                             RESTRANS FILE

                     Spending Account Transactions

The Spending Account Transactions file contains reimbursement records for
spending accounts. These transactions are maintained in BN59.1 (Spending
Account Transactions).

REFERENCED BY

BN232     BN258     BN100     BN101     BN102     BN103
BN105     BN259     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN531     BN70.1    BN71.1    BN72.1    BS32.1
HR170     HR70.1

UPDATED BY

BN430     BN59.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RTR-COMPANY            Numeric 4                                 BN59.1
Element: Company       Contains the company number.

RTR-START-DATE         Numeric 8  (yyyymmdd)                     BN59.1
Element: Date          Contains the start date for an
                       employee's spending account benefit. It
                       is equal to the BEN-START-DATE in the
                       BENEFIT file.

RTR-EMPLOYEE           Numeric 9                                 BN59.1
Element: Employee      Contains the employee number.

RTR-PLAN-CODE          Alpha 4                                   BN59.1
Element: Plan          Contains the user-defined plan code
                       tied to a plan type of "RS" (Spending
                       Account).

RTR-DATE               Numeric 8  (yyyymmdd)                     BN59.1
Element: Date          Contains a date equal or later than
                       RTR-START-DATE.

RTR-CHECK-NBR          Numeric 8                                 BN59.1
Element: Payment NumberContains a check number tied to the
                       employee's reimbursement of expenses.

RTR-TRANS-AMT          Signed 11.2                               BN59.1
Element: Transaction AmContains the eligible expense the
                       employee submitted to the employer for
                       reimbursement from his/her reserve
                       account.  If the PLN-PAY-EXP-FLG is
                       equal to "C," the total of the
                       transaction amounts cannot exceed the
                       BEN-YTD-CONT.  If the PLN-PAY-EXP-FLG is
                       equal to "A," the total transactions
                       cannot exceed the BEN-EMP-PRE-CONT plus
                       BEN-CMP-FLX-CONT.

RTR-DESC               Alpha 30  (Lower Case)                    BN59.1
Element: Description   Contains a description of the
                       transaction. It can be a description of
                       services provided.

                         RESTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTRSET1   COMPANY                                                BN232   BN258
          START-DATE                                             BN430
          EMPLOYEE
          PLAN-CODE
          DATE
          CHECK-NBR

RTRSET2   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN-CODE                                              BN105   BN259
          START-DATE                                             BN31.1  BN31.2
          DATE                                                   BN32.1  BN32.2
          CHECK-NBR                                              BN32.3  BN531
                                                                 BN59.1  BN59.2
                                                                 BN59.3  BN70.1
                                                                 BN71.1  BN72.1
                                                                 BS32.1  HR170
                                                                 HR70.1

                         RESTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT      Required

                            RTR-COMPANY       -> BEN-COMPANY
                            "RS"              -> BEN-PLAN-TYPE
                            RTR-EMPLOYEE      -> BEN-EMPLOYEE
                            RTR-START-DATE    -> BEN-START-DATE
                            RTR-PLAN-CODE     -> BEN-PLAN-CODE

Company        BNCOMPANY    Required

                            RTR-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            RTR-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            RTR-COMPANY       -> EMP-COMPANY
                            RTR-EMPLOYEE      -> EMP-EMPLOYEE

Plan           PLAN         Required

                            RTR-COMPANY       -> PLN-COMPANY
                            "RS"              -> PLN-PLAN-TYPE
                            RTR-PLAN-CODE     -> PLN-PLAN-CODE