|
|
OSHESTAB FILE
REFERENCED BY
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 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.
OTB-ESTABLISHMENT Alpha 10 PA92.1
Element: Establishment
OTB-EST-NAME Alpha 30 (Lower Case) PA92.1
Element: Establishment Establishment Name.
OTB-ACTIVE-FLAG Alpha 1 PA92.1
Element: Status The Active flag of the credit card
type.
OTB-EST-ADDR1 Alpha 30 (Lower Case) PA92.1
Establishment Establishment Address One.
Address 1
OTB-EST-ADDR2 Alpha 30 (Lower Case) PA92.1
Establishment Establishment address two.
Address 2
OTB-EST-ADDR3 Alpha 30 (Lower Case) PA92.1
Element: Address 3
OTB-EST-ADDR4 Alpha 30 (Lower Case) PA92.1
Element: Address 4
OTB-EST-CITY Alpha 18 (Lower Case) PA92.1
Element: Establishment Establishment city.
OTB-EST-STATE Alpha 2 PA92.1
Element: Establishment Establishment state.
OTB-EST-ZIP Alpha 10 PA92.1
Establishment Zip Establishment zip.
Code
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
Telephone Country This field contains the prefix of the
Code telephone number. For example, the
country or city code.
OTB-PHONE Alpha 15 PA92.1
Element: Telephone NumbPhone number.
OTB-PHONE-EXT Alpha 5 PA92.1
Element: Telephone ExteThis field contains the telephone
extension number.
OTB-FAX-COUNTRY Alpha 6 PA92.1
Telephone Country This field contains the prefix of the
Code fax number. For example, the country or
city code.
OTB-FAX-NBR Alpha 15 PA92.1
Element: Fax Number
OTB-FAX-EXT Alpha 5 PA92.1
Element: Telephone ExteThis field contains the fax number
extension.
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 Contains the user ID of the person who
last changed this record.
OSHESTAB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OTBSET1 COMPANY PA292 PA372
ESTABLISHMENT 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
|
