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.

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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CTCSET1TYPE, COUNTRY-CODE, HRCTRY-CODEPrimaryBN305, HCDL.1, HCEM.1, HR03.2, HR11.1, HR11.2, HR11.4, HR170 +22 more (list truncated in source)
CTCSET2TYPE, HRCTRY-CODE, COUNTRY-CODEBN305, HAP3.1, HCRE.1, HCTC.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
CTCSET3COUNTRY-CODE, TYPE, ACTIVE-FLAG, US-ET-BEHAVIOR, HRCTRY-CODEKeyChangeBN305, HR03.2, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR91.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CountryINSTCTRYCDRequiredWhen CTC-COUNTRY-CODE != SpacesCTC-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 ApplicantPAAEEORACECTC-COUNTRY-CODE → AEO-RACE, → AEO-COMPANY, → AEO-APPLICANT
Race EmployeePAEEEORACECTC-HRCTRY-CODE → EER-RACE, → EER-COMPANY, → EER-EMPLOYEE

Programs

Updated by (40)

Referenced by (72)