Lawson Insight Technical Documentation |
|
HRCTRYCODE
HRCTRYCODE FILE
Contains country-specific codes: Ethnicity, (name) Prefix, and (name) suffix.
REFERENCED BY
HCEC.1 HCEM.1 HCOP.1 HR11.1 HR11.2 HR170
HR211 HR403 HR511 HR650 HR70.1 PA02.1
PA100 PA102 PA115 PA18.1 PA218 PA311
PA502 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
HC02.1 HCTC.1 HGLM.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
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
PR = Prefix
SU = Suffix
CI = Citizen
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
CTC-HRCTRY-CODE Alpha 4 (Lower Case) HR03.2 HR91.1
Element: Hrctry Code HR91.2 HR91.3
HR91.4
CTC-DESCRIPTION Alpha 30 (Lower Case) HR03.2 HR91.1
Element: Description This field displays the description. HR91.2 HR91.3
HR91.4
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
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
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
changed.
CTC-USER-ID Alpha 10 (Lower Case) HR03.2 HR91.1
Element: User HR91.2 HR91.3
HR91.4
HRCTRYCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTCSET1 TYPE HCEC.1 HCEM.1
COUNTRY-CODE HCOP.1 HR03.2
HRCTRY-CODE HR11.1 HR11.2
HR170 HR211
HR403 HR511
HR650 HR70.1
HR91.1 HR91.2
HR91.3 HR91.4
PA02.1 PA100
PA102 PA115
PA18.1 PA218
PA311 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
...
CTCSET2 TYPE HC02.1 HCTC.1
HRCTRY-CODE HGLM.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
HR650 HR70.1
HR91.1 HR91.2
HR91.3 HR91.4
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
|