OSHESTAB – No description in the Lawson data dictionary
- System
- Personnel (PA)
- Prefix
OTB- Primary key
COMPANY,ESTABLISHMENT- Fields
- 35
- Updated by
- 1 program
- Referenced by
- 9 programs
OSHESTAB is a Lawson Personnel table (prefix OTB); no description in the lawson data dictionary. It is indexed by COMPANY, ESTABLISHMENT (OTBSET1). It is related 1:1 to PRSYSTEM and INSTCTRYCD and 1:M to OSHA and OSHESTDTL. It is updated by PA92.1 and referenced by PA290, PA292, PA372, PA490, PA590, PA90.1, PA90.2, PA90.3 and 1 more. The table has 35 fields, 1 index and 4 documented relations.
About OSHESTAB
No description in the Lawson data dictionary.
Fields (35)
Column = COBOL field name without the OTB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#OTB-COMPANY PKCOMPANY | Numeric 4 | — | PA92.1 |
#OTB-ESTABLISHMENT PKESTABLISHMENT | Alpha 10 | — | PA92.1 |
#OTB-EST-NAMEEST_NAME | Alpha 30 (Lower Case) | Establishment Name. | PA92.1 |
#OTB-ACTIVE-FLAGACTIVE_FLAG | Alpha 1 | The Active flag of the credit card type. | PA92.1 |
#OTB-EST-ADDR1EST_ADDR1 | Alpha 30 (Lower Case) | Establishment Address One. | PA92.1 |
#OTB-EST-ADDR2EST_ADDR2 | Alpha 30 (Lower Case) | Establishment address two. | PA92.1 |
#OTB-EST-ADDR3EST_ADDR3 | Alpha 30 (Lower Case) | — | PA92.1 |
#OTB-EST-ADDR4EST_ADDR4 | Alpha 30 (Lower Case) | — | PA92.1 |
#OTB-EST-CITYEST_CITY | Alpha 58 (Lower Case) | Establishment city. | PA92.1 |
#OTB-EST-STATEEST_STATE | Alpha 2 | Establishment state. | PA92.1 |
#OTB-EST-ZIPEST_ZIP | Alpha 10 | Establishment zip. | PA92.1 |
#OTB-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | PA92.1 |
#OTB-CONTACT-LASTCONTACT_LAST | Alpha 30 (Lower Case) | — | PA92.1 |
#OTB-CONTACT-FIRSTCONTACT_FIRST | Alpha 15 (Lower Case) | — | PA92.1 |
#OTB-CONTACT-MICONTACT_MI | Alpha 1 | — | PA92.1 |
#OTB-PHONE-COUNTRYPHONE_COUNTRY | Alpha 6 | This field contains the prefix of the telephone number. For example, the country or city code. | PA92.1 |
#OTB-PHONEPHONE | Alpha 15 | Phone number. | PA92.1 |
#OTB-PHONE-EXTPHONE_EXT | Alpha 5 | This field contains the telephone extension number. | PA92.1 |
#OTB-FAX-COUNTRYFAX_COUNTRY | Alpha 6 | This field contains the prefix of the telephone number. For example, the country or city code. | PA92.1 |
#OTB-FAX-NBRFAX_NBR | Alpha 15 | — | PA92.1 |
#OTB-FAX-EXTFAX_EXT | Alpha 5 | This field contains the telephone extension number. | PA92.1 |
#OTB-EMAIL-ADDRESSEMAIL_ADDRESS | Alpha 60 (Lower Case) | e-mail address. | PA92.1 |
#OTB-USER1USER1 | Alpha 10 | — | PA92.1 |
#OTB-USER2USER2 | Alpha 10 | — | PA92.1 |
#OTB-NUMERIC1NUMERIC1 | Signed 15.4 | — | PA92.1 |
#OTB-NUMERIC2NUMERIC2 | Signed 15.4 | — | PA92.1 |
#OTB-SIC-CDSIC_CD | Alpha 6 (Lower Case) | — | PA92.1 |
#OTB-INDUSTRY-DESCINDUSTRY_DESC | Alpha 30 (Lower Case) | — | PA92.1 |
#OTB-AVG-NBR-EMPSAVG_NBR_EMPS | Numeric 6 | — | PA92.1 |
#OTB-ADDL-NBR-EMPSADDL_NBR_EMPS | Numeric 6 | — | PA92.1 |
#OTB-TOT-HRS-WORKEDTOT_HRS_WORKED | Numeric 10 | — | PA92.1 |
#OTB-ADDL-HRS-WRKEDADDL_HRS_WRKED | Numeric 10 | — | PA92.1 |
#OTB-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | This field contains the server date (month, date, and year) of the last change to this record. | — |
#OTB-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | — |
#OTB-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OTBSET1 |
| Primary | PA290, PA292, PA372, PA490, PA590, PA90.1, PA90.2, PA90.3 +3 more |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
| |||||||
| Country | INSTCTRYCD | Required | When OTB-COUNTRY-CODE != Spaces |
|
One to many (2) — child tables
Programs
Updated by (1)
- PA92.1 Incident Establishment
Referenced by (9)
- PA290 Health and Safety Incident Listing
- PA292 Incident Establishment Listing
- PA372 Health and Safety Incident Purge
- PA490 OSHA Log, Summary Report
- PA590 Health and Safety Incident Conversion
- PA90.1 Health and Safety Incident
- PA90.2 Incident Follow Up
- PA90.3 Incident Costs
- PA91.1 Health and Safety Incident Inquiry