Lawson Insight Technical Documentation |
|
HRCTRYCODE
HRCTRYCODE FILE
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 HCTC.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR13.1 HR15.1 HR155 HR30.1
HR513 HR515 HR54.1 HR55.2 HRS1.1 HRSC.1
LP100 LP101 PA113 PA120 PA16.1 PA20.1
PA21.1 PA22.1 PA231 PA239 PA24.1 PA27.1
PA272 PA31.1 PA34.1 PA35.1 PA36.1 PA38.1
PA39.1 PA390 PA391 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 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTC-TYPE Alpha 2 BN305 HR03.2
Element: Type Indicates type of country code. HR11.1 HR11.2
ET = Ethnicity HR511 HR91.1
PR = Prefix HR91.2 HR91.3
SU = Suffix HR91.4 HR91.5
CI = Citizen HR91.6 PA02.1
JO = Job Occupation Code PA100 PA102
VS = Veteran Status 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
CTC-COUNTRY-CODE Alpha 2 BN305 HR03.2
Element: Country Code Indicates the country for which the HR11.1 HR11.2
code is valid. 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
CTC-HRCTRY-CODE Alpha 4 (Lower Case) BN305 HR03.2
Element: Hrctry Code 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
CTC-DESCRIPTION Alpha 30 (Lower Case) BN305 HR03.2
Element: Description This field displays the description. 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
CTC-ACTIVE-FLAG Alpha 1 BN305 HR03.2
Element: Active Flag Indicates whether the code is active or HR11.1 HR11.2
inactive. HR511 HR91.1
A = Active HR91.2 HR91.3
I = Inactive 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
CTC-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HR03.2
Element: Date Stamp This field contains the server date HR11.1 HR11.2
(month, date, and year) of the last HR511 HR91.1
change to this record. 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
CTC-TIME-STAMP Numeric 6 (hhmmss) BN305 HR03.2
Element: Time Stamp Contains the server time (hour, minute, HR11.1 HR11.2
and second) when the record was last HR511 HR91.1
changed. 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
CTC-USER-ID Alpha 10 (Lower Case) BN305 HR03.2
Element: User 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
CTC-RECRUIT-AVAIL Alpha 1 BN305 HR11.1
Element: Recruit Avail 1 = Not available for use HR11.2 HR511
2 = Available for use 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
HRCTRYCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTCSET1 TYPE BN305 HCDL.1
COUNTRY-CODE HCEM.1 HR03.2
HRCTRY-CODE 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 BN305 HAP3.1
HRCTRY-CODE HCTC.1 HEP4.1
COUNTRY-CODE HPOS.1 HPQC.1
HPRS.1 HR03.2
HR11.1 HR11.2
HR13.1 HR15.1
HR155 HR170
HR30.1 HR403
HR511 HR513
HR515 HR54.1
HR55.2 HR70.1
HR91.1 HR91.2
HR91.3 HR91.4
HR91.5 HR91.6
HRS1.1 HRSC.1
...
HRCTRYCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|