|
|
HROCCUPCD FILE
REFERENCED BY
HR206 HR222 PA594 HR03.2 HR91.1 HR91.2
HR91.3 HR91.4 HR91.5 HR91.6 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
UPDATED BY
HR22.1 HR00.1 HR01.1 HR06.1 HR506
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HOP-COMPANY Numeric 4 HR22.1
Element: Company Hr
HOP-JOB-CODE Alpha 9 HR22.1
Element: Job Code Contains a user-defined code that
represents a type of job.
HOP-COUNTRY-CODE Alpha 2 HR22.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
HOP-OCCUPTN-CODE Alpha 4 (Lower Case) HR22.1
Element: Hrctry Code
HOP-OCCUPTN-TYPE Alpha 10 HR22.1
Element: Code Code that is valid for the specified
record type.
HOP-ACTIVE-FLAG Alpha 1 HR22.1
Element: Active Flag The Active flag of the credit card
type.
A = Active
I = Inactive
HOP-COMMENT Alpha 40 (Lower Case) HR22.1
Element: Comment This field contains the comment
narrative.
HOP-DATE-STAMP Numeric 8 (yyyymmdd) HR22.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
HOP-TIME-STAMP Numeric 6 (hhmmss) HR22.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
HOP-USER-ID Alpha 10 (Lower Case) HR22.1
Element: User
HROCCUPCD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HOPSET1 COMPANY HR00.1 HR01.1
JOB-CODE HR06.1 HR206
COUNTRY-CODE HR22.1 HR222
OCCUPTN-CODE HR506 PA594
HOPSET2 COUNTRY-CODE HR03.2 HR91.1
OCCUPTN-CODE HR91.2 HR91.3
COMPANY HR91.4 HR91.5
JOB-CODE HR91.6
HOPSET3 COMPANY KeyChange, Subset HR04.2 HR04.3
OCCUPTN-TYPE Where (OCCUPTN-TYPE != Spaces ) HR04.7 HR04.8
COUNTRY-CODE HR80.1 HR80.2
OCCUPTN-CODE HR80.3 HR80.4
JOB-CODE 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 RELATED
NAME 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
|
