Lawson Insight Technical Documentation |
|
HRCTRYCODE
HRCTRYCODE FILE
Contains country-specific codes: Ethnicity, (name) Prefix, and (name) suffix.
REFERENCED BY
HCDL.1 HCEM.1 HR11.1 HR11.2 HR170 HR206
HR211 HR22.1 HR222 HR403 HR511 HR70.1
PA02.1 PA100 PA102 PA115 PA18.1 PA218
PA311 PA495 PA502 PA52.1 PA52.3 PA52.4
PA52.5 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8 HAP3.1 HCTC.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR13.1 HR15.1 HR155 HR30.1
HR513 HR515 HR54.1 HR55.2 HRS1.1 HRSC.1
PA113 PA120 PA13.1 PA13.2 PA16.1 PA20.1
PA21.1 PA22.1 PA231 PA24.1 PA27.1 PA272
PA31.1 PA34.1 PA35.1 PA36.1 PA38.1 PA390
PA391 PA513 PA520 PA53.1 PA531 PA54.1
PA66.3 TR21.1 TR22.1 TR26.1 TR500 PRSC.1
UPDATED BY
HR03.2 HR91.1 HR91.2 HR91.3 HR91.4 HR91.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTC-TYPE Alpha 2 HR03.2 HR91.1
Element: Type Indicates type of country code. HR91.2 HR91.3
ET = Ethnicity HR91.4 HR91.5
PR = Prefix
SU = Suffix
CI = Citizen
JO = Job Occupation Code
CTC-COUNTRY-CODE Alpha 2 HR03.2 HR91.1
Element: Country Code Indicates the country for which the HR91.2 HR91.3
code is valid. HR91.4 HR91.5
CTC-HRCTRY-CODE Alpha 4 (Lower Case) HR03.2 HR91.1
Element: Hrctry Code HR91.2 HR91.3
HR91.4 HR91.5
CTC-DESCRIPTION Alpha 30 (Lower Case) HR03.2 HR91.1
Element: Description This field displays the description. HR91.2 HR91.3
HR91.4 HR91.5
CTC-ACTIVE-FLAG Alpha 1 HR03.2 HR91.1
Element: Status Indicates whether the code is active or HR91.2 HR91.3
inactive. HR91.4 HR91.5
A = Active
I = Inactive
CTC-DATE-STAMP Numeric 8 (yyyymmdd) HR03.2 HR91.1
Element: Date Stamp This field contains the server date HR91.2 HR91.3
(month, date, and year) of the last HR91.4 HR91.5
change to this record.
CTC-TIME-STAMP Numeric 6 (hhmmss) HR03.2 HR91.1
Element: Time Stamp Contains the server time (hour, minute, HR91.2 HR91.3
and second) when the record was last HR91.4 HR91.5
changed.
CTC-USER-ID Alpha 10 (Lower Case) HR03.2 HR91.1
Element: User Contains the user ID of the person who HR91.2 HR91.3
last changed this record. HR91.4 HR91.5
HRCTRYCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTCSET1 TYPE HCDL.1 HCEM.1
COUNTRY-CODE HR03.2 HR11.1
HRCTRY-CODE HR11.2 HR170
HR206 HR211
HR22.1 HR222
HR403 HR511
HR70.1 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
PA02.1 PA100
PA102 PA115
PA18.1 PA218
PA311 PA495
PA502 PA52.1
PA52.3 PA52.4
...
CTCSET2 TYPE HAP3.1 HCTC.1
HRCTRY-CODE HEP4.1 HPOS.1
COUNTRY-CODE HPQC.1 HPRS.1
HR03.2 HR11.1
HR11.2 HR13.1
HR15.1 HR155
HR170 HR30.1
HR403 HR511
HR513 HR515
HR54.1 HR55.2
HR70.1 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HRS1.1 HRSC.1
PA02.1 PA100
...
HRCTRYCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Country INSTCTRYCD Required
When CTC-COUNTRY-CODE != Spaces
CTC-COUNTRY-CODE -> INT-COUNTRY-CODE
HRCTRYCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hr Occup Code HROCCUPCD Delete Cascades
Valid When (CTC-TYPE = "JO" )
CTC-COUNTRY-CODE -> HOP-COUNTRY-CODE
CTC-HRCTRY-CODE -> HOP-OCCUPTN-CODE
HOP-COMPANY
HOP-JOB-CODE
|