Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OSHESTAB


                             OSHESTAB FILE

REFERENCED BY

PA290     PA292     PA372     PA490     PA590     PA90.1
PA90.2    PA90.3    PA91.1

UPDATED BY

PA92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OTB-COMPANY            Numeric 4                                 PA92.1
Element: Company Hr

OTB-ESTABLISHMENT      Alpha 10                                  PA92.1
Element: Establishment

OTB-EST-NAME           Alpha 30  (Lower Case)                    PA92.1
Element: Est Name      Establishment Name.

OTB-ACTIVE-FLAG        Alpha 1                                   PA92.1
Element: Active Flag   The Active flag of the credit card
                       type.

OTB-EST-ADDR1          Alpha 30  (Lower Case)                    PA92.1
Element: Est Addr1     Establishment Address One.

OTB-EST-ADDR2          Alpha 30  (Lower Case)                    PA92.1
Element: Est Addr2     Establishment address two.

OTB-EST-ADDR3          Alpha 30  (Lower Case)                    PA92.1
Element: Est Addr3

OTB-EST-ADDR4          Alpha 30  (Lower Case)                    PA92.1
Element: Est Addr4

OTB-EST-CITY           Alpha 18  (Lower Case)                    PA92.1
Element: Est City      Establishment city.

OTB-EST-STATE          Alpha 2                                   PA92.1
Element: Est State     Establishment state.

OTB-EST-ZIP            Alpha 10                                  PA92.1
Element: Est Zip       Establishment zip.

OTB-COUNTRY-CODE       Alpha 2                                   PA92.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

OTB-CONTACT-LAST       Alpha 30  (Lower Case)                    PA92.1
Element: Contact Last

OTB-CONTACT-FIRST      Alpha 15  (Lower Case)                    PA92.1
Element: Contact First

OTB-CONTACT-MI         Alpha 1                                   PA92.1
Element: Contact Mi

OTB-PHONE-COUNTRY      Alpha 6                                   PA92.1
Element: Phone Country This field contains the prefix of the
                       telephone number. For example, the
                       country or city code.


OTB-PHONE              Alpha 15                                  PA92.1
Element: Phone         Phone number.

OTB-PHONE-EXT          Alpha 5                                   PA92.1
Element: Phone Ext     This field contains the telephone
                       extension number.

OTB-FAX-COUNTRY        Alpha 6                                   PA92.1
Element: Phone Country This field contains the prefix of the
                       telephone number. For example, the
                       country or city code.


OTB-FAX-NBR            Alpha 15                                  PA92.1
Element: Fax Nbr

OTB-FAX-EXT            Alpha 5                                   PA92.1
Element: Phone Ext     This field contains the telephone
                       extension number.

OTB-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    PA92.1
Element: Email Address e-mail address.

OTB-USER1              Alpha 10                                  PA92.1
Element: User1

OTB-USER2              Alpha 10                                  PA92.1
Element: User2

OTB-NUMERIC1           Signed 15.4                               PA92.1
Element: Numeric1

OTB-NUMERIC2           Signed 15.4                               PA92.1
Element: Numeric2

OTB-SIC-CD             Alpha 6  (Lower Case)                     PA92.1
Element: Sic Cd

OTB-INDUSTRY-DESC      Alpha 30  (Lower Case)                    PA92.1
Element: Industry Desc

OTB-AVG-NBR-EMPS       Numeric 6                                 PA92.1
Element: Avg Nbr Emps

OTB-ADDL-NBR-EMPS      Numeric 6                                 PA92.1
Element: Addl Nbr Emps

OTB-TOT-HRS-WORKED     Numeric 10                                PA92.1
Element: Tot Hrs Worked

OTB-ADDL-HRS-WRKED     Numeric 10                                PA92.1
Element: Addl Hrs Wrked

OTB-DATE-STAMP         Numeric 8  (yyyymmdd)
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

OTB-TIME-STAMP         Numeric 6  (hhmmss)
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

OTB-USER-ID            Alpha 10  (Lower Case)
Element: User

                         OSHESTAB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OTBSET1   COMPANY                                                PA290   PA292
          ESTABLISHMENT                                          PA372   PA490
                                                                 PA590   PA90.1
                                                                 PA90.2  PA90.3
                                                                 PA91.1  PA92.1
                                                                 PA92.2

                         OSHESTAB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            OTB-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Country        INSTCTRYCD   Required
                            When OTB-COUNTRY-CODE != Spaces

                            OTB-COUNTRY-CODE     -> INT-COUNTRY-CODE

                         OSHESTAB FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Osha           OSHA         Delete Cascades

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

Osha Detail    OSHESTDTL    Delete Cascades

                            OTB-COMPANY          -> ODT-COMPANY
                            OTB-ESTABLISHMENT    -> ODT-ESTABLISHMENT
                                                    ODT-PROCESS-LEVEL
                                                    ODT-DEPARTMENT
                                                    ODT-LOCAT-CODE