HRCTRYCODE

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

REFERENCED BY
HCDL.1 HCEM.1 HAP3.1 HCRE.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR15.1 HR155 HR156 HR206
HR211 HR22.1 HR222 HR515 HR54.1 HR55.2
HRS1.1 HRSC.1 LT11.5 ZH156 LP100 LP101
PA113 PA14.1 PA16.1 PA18.1 PA20.1 PA21.1
PA22.1 PA24.1 PA27.1 PA272 PA311 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 ZE521 ZE531 ZE540


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTC-TYPE
Element: Type		Alpha 2
Select the 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
HR28.1 HR511
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
CTC-COUNTRY-CODE
Element: Country Code		Alpha 2
Select the country for which the code is valid.
BN305 HR03.2
HR11.1 HR11.2
HR28.1 HR511
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
CTC-HRCTRY-CODE
Element: Hrctry Code		Alpha 4 (Lower Case)
BN305 HR03.2
HR11.1 HR11.2
HR28.1 HR511
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
CTC-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
BN305 HR03.2
HR11.1 HR11.2
HR28.1 HR511
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
CTC-ACTIVE-FLAG
Element: Active Flag		Alpha 1
Select whether the code is active or inactive.
A = Active
I = Inactive
BN305 HR03.2
HR11.1 HR11.2
HR28.1 HR511
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA28.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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
HR28.1 HR511
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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
HR28.1 HR511
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
CTC-USER-ID
Element: User		Alpha 10 (Lower Case)
BN305 HR03.2
HR11.1 HR11.2
HR28.1 HR511
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
CTC-RECRUIT-AVAIL
Element: Recruit Avail		Alpha 1

1 = Not available for use
2 = Available for use
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
CTC-US-ET-BEHAVIOR
Element: Us Et Behavior		Alpha 1
This flag defines how US ethnicity codes behave in Lawson and EMSS
H = Hispanic
M = Multiple
U = Unknown
HR03.2 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6


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 HR28.1
HR403 HR511
HR70.1 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA14.1
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
HR228 HR28.1
HR30.1 HR403
HR51.2 HR511
HR513 HR515
HR54.1 HR55.2
HR70.1 HR91.1
HR91.2 HR91.3
CTCSET3 COUNTRY-CODE
TYPE
ACTIVE-FLAG
US-ET-BEHAVIOR
HRCTRY-CODE
KeyChange
...
BN305 HR03.2
HR11.1 HR11.2
HR228 HR28.1
HR511 HR91.1
LT101 ZH510
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA228 PA28.1
PA31.1 PA390
PA391 PA392
PA495 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110


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: Thu Jun 09 11:14:52 2016

Home
Contact Us



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