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.

Field / column	Type	Description & values	Updated by
`OTB-COMPANY` PK COMPANY	Numeric 4	—	PA92.1
`OTB-ESTABLISHMENT` PK ESTABLISHMENT	Alpha 10	—	PA92.1
`OTB-EST-NAME` EST_NAME	Alpha 30 (Lower Case)	Establishment Name.	PA92.1
`OTB-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	The Active flag of the credit card type.	PA92.1
`OTB-EST-ADDR1` EST_ADDR1	Alpha 30 (Lower Case)	Establishment Address One.	PA92.1
`OTB-EST-ADDR2` EST_ADDR2	Alpha 30 (Lower Case)	Establishment address two.	PA92.1
`OTB-EST-ADDR3` EST_ADDR3	Alpha 30 (Lower Case)	—	PA92.1
`OTB-EST-ADDR4` EST_ADDR4	Alpha 30 (Lower Case)	—	PA92.1
`OTB-EST-CITY` EST_CITY	Alpha 58 (Lower Case)	Establishment city.	PA92.1
`OTB-EST-STATE` EST_STATE	Alpha 2	Establishment state.	PA92.1
`OTB-EST-ZIP` EST_ZIP	Alpha 10	Establishment zip.	PA92.1
`OTB-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	PA92.1
`OTB-CONTACT-LAST` CONTACT_LAST	Alpha 30 (Lower Case)	—	PA92.1
`OTB-CONTACT-FIRST` CONTACT_FIRST	Alpha 15 (Lower Case)	—	PA92.1
`OTB-CONTACT-MI` CONTACT_MI	Alpha 1	—	PA92.1
`OTB-PHONE-COUNTRY` PHONE_COUNTRY	Alpha 6	This field contains the prefix of the telephone number. For example, the country or city code.	PA92.1
`OTB-PHONE` PHONE	Alpha 15	Phone number.	PA92.1
`OTB-PHONE-EXT` PHONE_EXT	Alpha 5	This field contains the telephone extension number.	PA92.1
`OTB-FAX-COUNTRY` FAX_COUNTRY	Alpha 6	This field contains the prefix of the telephone number. For example, the country or city code.	PA92.1
`OTB-FAX-NBR` FAX_NBR	Alpha 15	—	PA92.1
`OTB-FAX-EXT` FAX_EXT	Alpha 5	This field contains the telephone extension number.	PA92.1
`OTB-EMAIL-ADDRESS` EMAIL_ADDRESS	Alpha 60 (Lower Case)	e-mail address.	PA92.1
`OTB-USER1` USER1	Alpha 10	—	PA92.1
`OTB-USER2` USER2	Alpha 10	—	PA92.1
`OTB-NUMERIC1` NUMERIC1	Signed 15.4	—	PA92.1
`OTB-NUMERIC2` NUMERIC2	Signed 15.4	—	PA92.1
`OTB-SIC-CD` SIC_CD	Alpha 6 (Lower Case)	—	PA92.1
`OTB-INDUSTRY-DESC` INDUSTRY_DESC	Alpha 30 (Lower Case)	—	PA92.1
`OTB-AVG-NBR-EMPS` AVG_NBR_EMPS	Numeric 6	—	PA92.1
`OTB-ADDL-NBR-EMPS` ADDL_NBR_EMPS	Numeric 6	—	PA92.1
`OTB-TOT-HRS-WORKED` TOT_HRS_WORKED	Numeric 10	—	PA92.1
`OTB-ADDL-HRS-WRKED` ADDL_HRS_WRKED	Numeric 10	—	PA92.1
`OTB-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	—
`OTB-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	—
`OTB-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`OTBSET1`	`COMPANY`, `ESTABLISHMENT`	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		`OTB-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Country	INSTCTRYCD	Required	When OTB-COUNTRY-CODE != Spaces	`OTB-COUNTRY-CODE` → `INT-COUNTRY-CODE`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

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