Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBJOBCDTRN


                            PBJOBCDTRN FILE

UPDATED BY

PR197     PR85.1    PR36.1    PR45.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PJT-COMPANY            Numeric 4                                 PR197   PR85.1
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.

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

PJT-EMPLOYEE           Numeric 9                                 PR197   PR85.1
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.

PJT-JOB-CODE           Alpha 9                                   PR197   PR85.1
Element: Job Code      Contains a user-defined code that
                       represents a type of job.

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

PJT-BILLABLE-AMT       Signed 15.2                               PR197   PR85.1
Element: Billable Amt

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

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

                         PBJOBCDTRN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PJTSET1   COMPANY
          PROCESS-LEVEL
          EMPLOYEE
          JOB-CODE
          CHECK-ID

PJTSET2   COMPANY                                                PR197   PR36.1
          EMPLOYEE                                               PR45.1
          CHECK-ID
          JOB-CODE
          PROCESS-LEVEL

                         PBJOBCDTRN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            PJT-COMPANY     -> EMP-COMPANY
                            PJT-EMPLOYEE    -> EMP-EMPLOYEE