|
|
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
|
