Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

UKNITP


                              UKNITP FILE

REFERENCED BY

PR160     PR180     PR197     PR82.1    PR85.1    UK141
UK145     UK201     UK202     UK50.3

UPDATED BY

PR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

UKI-COMPANY            Numeric 4
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.

UKI-EMPLOYEE           Numeric 9
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.

UKI-CHECK-ID           Numeric 12
Internal Check ID      Contains the payment identification
Number                 number (unique payment identifier used
                       in tracking payment information).

UKI-REPORT-ENTITY      Alpha 5
Element: Report Entity

UKI-PROCESS-LEVEL      Alpha 5
Element: Process Lev HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

UKI-WAGE-TO-LEL        Signed 7.2
Element: Wage To Lel

UKI-WAGE-TO-ET         Signed 7.2
Element: Wage To Et

UKI-WAGE-TO-UEL        Signed 7.2
Element: Wage To Uel

UKI-EENI-REBATE        Signed 7.2
Element: Eeni Rebate

UKI-ERNI-REBATE        Signed 7.2
Element: Erni Rebate

                         UKNITP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UKISET1   COMPANY                                                PR160   PR180
          EMPLOYEE                                               PR197   PR300
          CHECK-ID                                               PR82.1  PR85.1
          REPORT-ENTITY                                          UK141   UK145
                                                                 UK201   UK202
                                                                 UK50.3

                         UKNITP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            UKI-COMPANY     -> EMP-COMPANY
                            UKI-EMPLOYEE    -> EMP-EMPLOYEE