Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OSHESTDTL


                             OSHESTDTL FILE

REFERENCED BY

PA292     PA490

UPDATED BY

PA92.2    PA92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ODT-COMPANY            Numeric 4                                 PA92.2
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.

ODT-ESTABLISHMENT      Alpha 10                                  PA92.2
Element: Establishment

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

ODT-DEPARTMENT         Alpha 5                                   PA92.2
Element: Department    Contains the department.

ODT-LOCAT-CODE         Alpha 10                                  PA92.2
Element: Location

                         OSHESTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ODTSET1   COMPANY                                                PA292   PA490
          ESTABLISHMENT                                          PA92.1  PA92.2
          PROCESS-LEVEL
          DEPARTMENT
          LOCAT-CODE

ODTSET2   COMPANY                                                PA92.2
          ESTABLISHMENT
          LOCAT-CODE
          DEPARTMENT
          PROCESS-LEVEL

ODTSET3   COMPANY                                                PA92.2
          ESTABLISHMENT
          LOCAT-CODE
          PROCESS-LEVEL
          DEPARTMENT

ODTSET4   COMPANY                                                PA92.2
          PROCESS-LEVEL
          DEPARTMENT
          LOCAT-CODE
          ESTABLISHMENT

                         OSHESTDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            ODT-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When ODT-DEPARTMENT != Spaces

                            ODT-COMPANY          -> DPT-COMPANY
                            ODT-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            ODT-DEPARTMENT       -> DPT-DEPARTMENT

Establishment  OSHESTAB     Required

                            ODT-COMPANY          -> OTB-COMPANY
                            ODT-ESTABLISHMENT    -> OTB-ESTABLISHMENT

Pcodes         PCODES       Required
                            When ODT-LOCAT-CODE != Spaces

                            "LO"                 -> PCO-TYPE
                            ODT-LOCAT-CODE       -> PCO-CODE

Process Level  PRSYSTEM     Required
                            When ODT-PROCESS-LEVEL != Spaces

                            ODT-COMPANY          -> PRS-COMPANY
                            ODT-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         OSHESTDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Osha           OSHA

                            ODT-COMPANY          -> OSH-COMPANY
                            ODT-ESTABLISHMENT    -> OSH-ESTABLISHMENT
                                                    OSH-SEQ-NBR
                                                    OSH-EMPLOYEE