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

System
Human Resources (HR)
Prefix
CTC
Primary key
TYPE, COUNTRY-CODE, HRCTRY-CODE
Fields
10
Updated by
40 programs
Referenced by
72 programs

HRCTRYCODE is the Contains country-specific codes: Ethnicity, (name) Prefix, and (name) suffix. table in Lawson Human Resources (prefix CTC). It is indexed by TYPE, COUNTRY-CODE, HRCTRY-CODE (CTCSET1); alternate indexes: CTCSET2 and CTCSET3. It is related 1:1 to INSTCTRYCD and 1:M to HROCCUPCD, PAAEEORACE and PAEEEORACE. It is updated by BN305, HR03.2, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR91.1 and 32 more and referenced by HAP3.1, HCDL.1, HCEM.1, HCRE.1, HCTC.1, HEP4.1, HPOS.1, HPQC.1 and 64 more. The table has 10 fields, 3 indexes and 4 documented relations.

About HRCTRYCODE

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

Fields (10)

Column = COBOL field name without the CTC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CTC-TYPE PK
TYPE		Alpha 2Select 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 +31 more
#CTC-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2Select the country for which the code is valid.BN305, HR03.2, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR91.1 +31 more
#CTC-HRCTRY-CODE PK
HRCTRY_CODE		Alpha 4 (Lower Case)—BN305, HR03.2, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR91.1 +31 more
#CTC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.BN305, HR03.2, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR91.1 +31 more
#CTC-ACTIVE-FLAG SET3
ACTIVE_FLAG		Alpha 1Select 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 +32 more
#CTC-DATE-STAMP
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 +31 more
#CTC-TIME-STAMP
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 +31 more
#CTC-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN305, HR03.2, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR91.1 +31 more
#CTC-RECRUIT-AVAIL
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 +24 more
#CTC-US-ET-BEHAVIOR SET3
US_ET_BEHAVIOR		Alpha 1This 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

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CTCSET1
  1. TYPE
  2. COUNTRY-CODE
  3. HRCTRY-CODE
PrimaryBN305, HCDL.1, HCEM.1, HR03.2, HR11.1, HR11.2, HR11.4, HR170 +22 more (list truncated in source)
CTCSET2
  1. TYPE
  2. HRCTRY-CODE
  3. COUNTRY-CODE
BN305, HAP3.1, HCRE.1, HCTC.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
CTCSET3
  1. COUNTRY-CODE
  2. TYPE
  3. ACTIVE-FLAG
  4. US-ET-BEHAVIOR
  5. HRCTRY-CODE
KeyChangeBN305, HR03.2, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR91.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
INSTCTRYCDHROCCUPCDPAAEEORACEPAEEEORACEHRCTRYCODE

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CountryINSTCTRYCDRequiredWhen CTC-COUNTRY-CODE != Spaces
CTC-COUNTRY-CODE→INT-COUNTRY-CODE

One to many (3) — child tables

RelationTableRulesConditionField map
Hr Occup CodeHROCCUPCDDelete CascadesValid When (CTC-TYPE = "JO")
CTC-COUNTRY-CODE→HOP-COUNTRY-CODE
CTC-HRCTRY-CODE→HOP-OCCUPTN-CODE
—→HOP-COMPANY
—→HOP-JOB-CODE
Race ApplicantPAAEEORACE
CTC-COUNTRY-CODE→AEO-RACE
—→AEO-COMPANY
—→AEO-APPLICANT
Race EmployeePAEEEORACE
CTC-HRCTRY-CODE→EER-RACE
—→EER-COMPANY
—→EER-EMPLOYEE

Programs

Updated by (40)

Referenced by (72)