HROCCUPCD

REFERENCED BY
PA594


UPDATED BY
HR22.1 HR00.1 HR01.1 HR06.1 HR206 HR222
HR506 HR03.2 HR91.1 HR91.2 HR91.3 HR91.4
HR91.5 HR91.6

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


HROCCUPCD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
HOP-COMPANY->PRS-COMPANY (PRSSET1)
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: Wed Jun 08 20:49:09 2016

Home
Contact Us



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