Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

UKNITP


                              UKNITP FILE

REFERENCED BY

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

UPDATED BY

BN66.1    PR140     PR189     PR195     PR300     PR80.1
PR82.1    PR82.3    PR89.1    UK560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

UKI-COMPANY            Numeric 4                                 BN66.1  PR140
Element: Company Hr                                              PR189   PR195
                                                                 PR80.1  PR82.1
                                                                 PR89.1  UK560

UKI-EMPLOYEE           Numeric 9                                 BN66.1  PR140
Element: Employee      Contains the employee number. Each        PR189   PR195
                       person employed by the company is         PR80.1  PR82.1
                       assigned a unique number. The system      PR89.1  UK560
                       uses the employee number to correlate
                       all of the information related to that
                       person.

UKI-CHECK-ID           Numeric 12                                BN66.1  PR140
Element: Check Id      Contains the payment identification       PR189   PR195
                       number (unique payment identifier used    PR80.1  PR82.1
                       in tracking payment information).         PR89.1  UK560

UKI-REPORT-ENTITY      Alpha 5                                   BN66.1  PR140
Element: Report Entity                                           PR189   PR195
                                                                 PR80.1  PR82.1
                                                                 PR89.1

UKI-PROCESS-LEVEL      Alpha 5                                   BN66.1  PR140
Element: Process Lev Hr                                          PR189   PR195
                                                                 PR80.1  PR89.1

UKI-WAGE-TO-LEL        Signed 7.2                                BN66.1  PR140
Element: Wage To Lel                                             PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560

UKI-WAGE-TO-ET         Signed 7.2                                BN66.1  PR140
Element: Wage To Et                                              PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560

UKI-WAGE-TO-UEL        Signed 7.2                                BN66.1  PR140
Element: Wage To Uel                                             PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560

UKI-EENI-REBATE        Signed 7.2                                BN66.1  PR140
Element: Eeni Rebate                                             PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560

UKI-ERNI-REBATE        Signed 7.2                                BN66.1  PR140
Element: Erni Rebate                                             PR189   PR195
                                                                 PR80.1  PR82.3
                                                                 PR89.1  UK560

                         UKNITP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UKISET1   COMPANY                                                BN66.1  ET530
          EMPLOYEE                                               PR139   PR140
          CHECK-ID                                               PR160   PR180
          REPORT-ENTITY                                          PR189   PR195
                                                                 PR197   PR300
                                                                 PR80.1  PR80.2
                                                                 PR82.1  PR82.3
                                                                 PR85.1  PR89.1
                                                                 UK141   UK145
                                                                 UK201   UK202
                                                                 UK50.3  UK560

                         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