HRCTRYCODE

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

REFERENCED BY
HCDL.1 HCEM.1 HR170 HR206 HR211 HR22.1
HR222 HR403 HR70.1 PA14.1 PA18.1 PA218
PA311 PA495 HAP3.1 HCRE.1 HCTC.1 HEP4.1
HPOS.1 HPQC.1 HPRS.1 HR13.1 HR15.1 HR155
HR156 HR228 HR30.1 HR51.2 HR513 HR515
HR54.1 HR55.2 HRS1.1 HRSC.1 LT11.5 LT13.5
LT13.6 LT28.1 ZH156 LP100 LP101 PA113
PA120 PA16.1 PA20.1 PA21.1 PA22.1 PA228
PA231 PA239 PA24.1 PA27.1 PA272 PA31.1
PA34.1 PA35.1 PA36.1 PA38.1 PA39.1 PA390
PA391 PA392 PA393 PA520 PA53.1 PA531
PA54.1 PA66.3 TR21.1 TR22.1 TR26.1 TR500


UPDATED BY
BN305 HR03.2 HR11.1 HR11.2 HR11.4 HR28.1
HR511 HR91.1 HR91.2 HR91.3 HR91.4 HR91.5
HR91.6 LT101 LT111 ZH510 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 PR512 PA28.1

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
HR11.4 HR28.1
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
LT111 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 PR512
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
HR11.4 HR28.1
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
LT111 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 PR512
ZH510
CTC-HRCTRY-CODE
Element: Hrctry Code		Alpha 4 (Lower Case)
BN305 HR03.2
HR11.1 HR11.2
HR11.4 HR28.1
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
LT111 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 PR512
ZH510
CTC-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
BN305 HR03.2
HR11.1 HR11.2
HR11.4 HR28.1
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
LT111 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 PR512
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
HR11.4 HR28.1
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
LT111 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
PR512 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
HR11.4 HR28.1
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
LT111 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 PR512
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
HR11.4 HR28.1
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
LT111 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 PR512
ZH510
CTC-USER-ID
Element: User		Alpha 10 (Lower Case)
BN305 HR03.2
HR11.1 HR11.2
HR11.4 HR28.1
HR511 HR91.1
HR91.2 HR91.3
HR91.4 HR91.5
HR91.6 LT101
LT111 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 PR512
ZH510
CTC-RECRUIT-AVAIL
Element: Recruit Avail		Alpha 1

1 = Not available for use
2 = Available for use
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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
PR512 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
HR11.4 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 LT111
ZH510 PA02.1
PA100 PA102
PA115 PA13.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 HR11.4
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
CTCSET3 COUNTRY-CODE
TYPE
ACTIVE-FLAG
US-ET-BEHAVIOR
HRCTRY-CODE
KeyChange
...
BN305 HR03.2
HR11.1 HR11.2
HR11.4 HR28.1
HR511 HR91.1
LT101 LT111
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 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 02:16:10 2016

Home
Contact Us



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