|
|
HROCCUPCD FILE
REFERENCED BY
HR206 HR222 PA594 HR03.2 HR91.1 HR91.2
HR91.3 HR91.4 HR91.5 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 PBIP.1
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HOP-COMPANY Numeric 4 HR22.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.
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
HOP-ACTIVE-FLAG Alpha 1 HR22.1
Element: Status The Active flag of the credit card
type.
A = Active
I = Inactive
HOP-COMMENT Alpha 40 (Lower Case) HR22.1
Element: Comment Line 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 Contains the user ID of the person who
last changed this record.
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
PBIP.1 PR197
HOPSET2 COUNTRY-CODE HR03.2 HR91.1
OCCUPTN-CODE HR91.2 HR91.3
COMPANY HR91.4 HR91.5
JOB-CODE
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
|
