HRCTRYCODE

Contains country-specific codes: Ethnicity, (name) Prefix, and (name) suffix.

REFERENCED BY
HCDL.1 HCEM.1 HR206 HR211 HR22.1 HR222
PA14.1 PA18.1 PA311 PA495 HAP3.1 HCRE.1
HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR15.1 HR155
HR156 HR515 HR54.1 HR55.2 HRS1.1 HRSC.1
LP100 LP101 PA113 PA16.1 PA20.1 PA21.1
PA22.1 PA24.1 PA27.1 PA272 PA34.1 PA35.1
PA36.1 PA38.1 PA39.1 PA393 PA520 PA53.1
PA54.1 PA66.3 TR21.1 TR22.1 TR26.1 TR500


UPDATED BY
BN305 HR03.2 HR11.1 HR11.2 HR511 HR91.1
HR91.2 HR91.3 HR91.4 HR91.5 HR91.6 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 HR170 HR403 HR70.1 PA218 HCTC.1
HR13.1 HR30.1 HR51.2 HR513 PA120 PA231
PA239 PA31.1 PA390 PA391 PA392 PA531

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTC-TYPE
Element: Type		Alpha 2
Indicates type of country code.
ET = Ethnicity
PR = Prefix
SU = Suffix
CI = Citizen
JO = Job Occupation Code
VS = Veteran Status
BN305 HR03.2
HR11.1 HR11.2
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CTC-COUNTRY-CODE
Element: Country Code		Alpha 2
Indicates the country for which the code is valid.
BN305 HR03.2
HR11.1 HR11.2
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CTC-HRCTRY-CODE
Element: Hrctry Code		Alpha 4 (Lower Case)
BN305 HR03.2
HR11.1 HR11.2
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CTC-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
BN305 HR03.2
HR11.1 HR11.2
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CTC-ACTIVE-FLAG
Element: Active Flag		Alpha 1
Indicates whether the code is active or inactive.
A = Active
I = Inactive
BN305 HR03.2
HR11.1 HR11.2
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CTC-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.
BN305 HR03.2
HR11.1 HR11.2
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CTC-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN305 HR03.2
HR11.1 HR11.2
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CTC-USER-ID
Element: User		Alpha 10 (Lower Case)
BN305 HR03.2
HR11.1 HR11.2
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CTC-RECRUIT-AVAIL
Element: Recruit Avail		Alpha 1

1 = Not available for use
2 = Available for use
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
CTC-US-ET-BEHAVIOR
Element: Us Et Behavior		Alpha 1

H = Hispanic
M = Multiple
U = Unknown


HRCTRYCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTCSET1 TYPE
COUNTRY-CODE
HRCTRY-CODE
...
BN305 HCDL.1
HCEM.1 HR03.2
HR11.1 HR11.2
HR170 HR206
HR211 HR22.1
HR222 HR403
HR511 HR70.1
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA18.1
PA218 PA311
CTCSET2 TYPE
HRCTRY-CODE
COUNTRY-CODE
...
BN305 HAP3.1
HCRE.1 HCTC.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR03.2 HR11.1
HR11.2 HR13.1
HR15.1 HR155
HR156 HR170
HR30.1 HR403
HR51.2 HR511
HR513 HR515
HR54.1 HR55.2
HR70.1 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
CTCSET3 COUNTRY-CODE
TYPE
ACTIVE-FLAG
US-ET-BEHAVIOR
HRCTRY-CODE
KeyChange
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9


HRCTRYCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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
Race Applicant PAAEEORACE
CTC-COUNTRY-CODE->AEO-RACE
  AEO-COMPANY
  AEO-APPLICANT
Race Employee PAEEEORACE
CTC-HRCTRY-CODE->EER-RACE
  EER-COMPANY
  EER-EMPLOYEE

File created: Wed Jun 08 20:49:07 2016

Home
Contact Us



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