HRCTRYCODE FILE
HR Country-Specific Codes
Contains country-specific codes: Ethnicity, (name) Prefix, and (name) suffix.
REFERENCED BY
HCEC.1 HCEM.1 HCOP.1 HR11.1 HR211 HR403
HR511 PA02.1 PA100 PA102 PA115 PA311
PA502 PA52.1 PA52.3 PA52.4 PA52.5 PR13.1
HC02.1 HCTC.1 HR15.1 HR155 HR170 HR30.1
HR54.1 HR55.2 HR70.1 HR700 HRS1.1 HRSC.1
PA120 PA13.1 PA13.2 PA16.1 PA20.1 PA21.1
PA22.1 PA231 PA24.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 TR500
UPDATED BY
HR03.2 HR91.1 HR91.2 HR91.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTC-TYPE Alpha 2 HR03.2 HR91.1
Type Indicates type of country code. HR91.2 HR91.3
ET = Ethnicity
PR = Prefix
SU = Suffix
CTC-COUNTRY-CODE Alpha 2 HR03.2 HR91.1
Country Code Indicates the country for which the code HR91.2 HR91.3
is valid.
CTC-HRCTRY-CODE Alpha 4 (Lower Case) HR03.2 HR91.1
Hrctry Code HR91.2 HR91.3
CTC-DESCRIPTION Alpha 30 (Lower Case) HR03.2 HR91.1
Description This field contains the description. HR91.2 HR91.3
CTC-ACTIVE-FLAG Alpha 1 HR03.2 HR91.1
Status Indicates whether the code is active or HR91.2 HR91.3
inactive.
A = Active
I = Inactive
CTC-DATE-STAMP Numeric 8 (yyyymmdd) HR03.2 HR91.1
Date Stamp Contains the server date (month, date, HR91.2 HR91.3
and year) of the last change to this
record.
CTC-TIME-STAMP Numeric 6 (hhmmss) HR03.2 HR91.1
Time Stamp Contains the server time (hour, minute, HR91.2 HR91.3
and second) when the record was last
changed.
CTC-USER-ID Alpha 10 (Lower Case) HR03.2 HR91.1
User ID Name Contains the user ID of the person who HR91.2 HR91.3
last changed this record.
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 HR211
HR403 HR511
HR91.1 HR91.2
HR91.3 PA02.1
PA100 PA102
PA115 PA311
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
CTCSET2 TYPE HC02.1 HCTC.1
HRCTRY-CODE HR03.2 HR11.1
COUNTRY-CODE HR15.1 HR155
HR170 HR30.1
HR403 HR511
HR54.1 HR55.2
HR70.1 HR700
HR91.1 HR91.2
HR91.3 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA120 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA231
...
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
|