HROCCUPCD

REFERENCED BY
HR206 HR222 ZE532 HR03.2


UPDATED BY
HR22.1 HR00.1 HR01.1 HR06.1 HR506 LT101
LT111 PA594 HR91.7 HR04.2 HR04.3 HR04.7
HR04.8 HR80.1 HR80.2 HR80.3 HR80.4 HR80.5
HR80.6 HR80.7 HR80.8 HR80.9 HR81.1 HR81.2
HR81.3 HR81.4 HR81.5 HR81.6 HR81.7 HR81.8
HR81.9 HR82.1 HR82.2 HR82.3 HR82.4 HR82.5
HR82.6 HR82.7 HR82.8 HR82.9 HR83.1 HR83.2
HR83.3 HR83.4 HR83.5 HR83.6 HR83.7 HR83.8
HR83.9 HR84.1 HR84.2 HR84.3 HR84.4 HR84.5
HR84.6 HR84.7 HR84.8 HR84.9 HR85.1 HR85.2
HR85.3 HR85.4 HR85.5 HR85.6 HR85.7 HR85.8
HR86.1 HR86.2 HR86.3 HR86.4 HR86.5 HR86.6
HR86.7 HR86.8 HR86.9 HR87.1 HR87.2 HR87.3
HR87.4 HR87.5 HR87.6 HR87.7 HR87.8 HR87.9
HR88.1 HR88.2 HR88.3 HR88.4 HR88.5 HR88.6
HR88.7 HR89.1 HR89.2 HR89.3 HR89.4 HR89.5
HR89.6 HR89.7 HR89.8 HR89.9 HR92.1 HR92.2
HR92.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HOP-COMPANY
Element: Company Hr		Numeric 4
HR22.1
HOP-JOB-CODE
Element: Job Code		Alpha 9
Contains a user-defined code that represents a type of job.
HR22.1
HOP-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
HR22.1
HOP-OCCUPTN-CODE
Element: Hrctry Code		Alpha 4 (Lower Case)
HR22.1 ZE532
HOP-OCCUPTN-TYPE
Element: Code		Alpha 10
Code that is valid for the specified record type.
HR22.1
HOP-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
HR22.1
HOP-COMMENT
Element: Comment		Alpha 40 (Lower Case)
This field contains the comment narrative.
HR22.1
HOP-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
HR22.1
HOP-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR22.1
HOP-USER-ID
Element: User		Alpha 10 (Lower Case)
HR22.1


HROCCUPCD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HOPSET1 COMPANY
JOB-CODE
COUNTRY-CODE
OCCUPTN-CODE
HR00.1 HR01.1
HR06.1 HR206
HR22.1 HR222
HR506 LT101
LT111 PA594
ZE532
HOPSET2 COUNTRY-CODE
OCCUPTN-CODE
COMPANY
JOB-CODE
HR03.2 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6
HOPSET3 COMPANY
OCCUPTN-TYPE
COUNTRY-CODE
OCCUPTN-CODE
JOB-CODE
KeyChange, Subset
Where(OCCUPTN-TYPE !=Spaces)
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8


HROCCUPCD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
HOP-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Country Code INSTCTRYCD Required
HOP-COUNTRY-CODE->INT-COUNTRY-CODE
Job Code JOBCODE Required
HOP-COMPANY->JBC-COMPANY
HOP-JOB-CODE->JBC-JOB-CODE
Occuptn Code HRCTRYCODE Required
"JO"->CTC-TYPE
HOP-COUNTRY-CODE->CTC-COUNTRY-CODE
HOP-OCCUPTN-CODE->CTC-HRCTRY-CODE
Occuptn Type PCODES Required
When (HOP-OCCUPTN-TYPE !=Spaces )
"JT"->PCO-TYPE
HOP-OCCUPTN-TYPE->PCO-CODE

File created: Thu Jun 09 02:16:20 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.