Lawson Insight Technical Documentation

                            HRCTRYCODE FILE

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

REFERENCED BY

HCEC.1    HCEM.1    HCOP.1    HR11.1    HR11.2    HR170
HR211     HR403     HR511     HR650     HR70.1    PA02.1
PA100     PA102     PA115     PA18.1    PA218     PA311
PA502     PA52.1    PA52.3    PA52.4    PA52.5    PR110
PR113     PR120     PR13.1    PR13.5    PR13.6    PR13.8
HC02.1    HCTC.1    HR13.1    HR15.1    HR155     HR30.1
HR513     HR515     HR54.1    HR55.2    HRS1.1    HRSC.1
PA113     PA120     PA13.1    PA13.2    PA16.1    PA20.1
PA21.1    PA22.1    PA231     PA24.1    PA27.1    PA272
PA31.1    PA34.1    PA35.1    PA36.1    PA38.1    PA390
PA391     PA513     PA520     PA53.1    PA531     PA54.1
PA66.3    TR21.1    TR22.1    TR26.1    TR500     PRSC.1

UPDATED BY

HR03.2    HR91.1    HR91.2    HR91.3    HR91.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CTC-TYPE             Alpha 2                                     HR03.2  HR91.1
Type                 Indicates type of country code.             HR91.2  HR91.3
                     ET = Ethnicity                              HR91.4
                     PR = Prefix
                     SU = Suffix
                     CI = Citizen

CTC-COUNTRY-CODE     Alpha 2                                     HR03.2  HR91.1
Country Code         Indicates the country for which the         HR91.2  HR91.3
                     code is valid.                              HR91.4

CTC-HRCTRY-CODE      Alpha 4  (Lower Case)                       HR03.2  HR91.1
Hrctry Code                                                      HR91.2  HR91.3
                                                                 HR91.4

CTC-DESCRIPTION      Alpha 30  (Lower Case)                      HR03.2  HR91.1
Description          This field displays the description.        HR91.2  HR91.3
                                                                 HR91.4

CTC-ACTIVE-FLAG      Alpha 1                                     HR03.2  HR91.1
Status               Indicates whether the code is active or     HR91.2  HR91.3
                     inactive.                                   HR91.4
                     A = Active
                     I = Inactive

CTC-DATE-STAMP       Numeric 8  (yyyymmdd)                       HR03.2  HR91.1
Date Stamp           This field contains the server date         HR91.2  HR91.3
                     (month, date, and year) of the last         HR91.4
                     change to this record.


CTC-TIME-STAMP       Numeric 6  (hhmmss)                         HR03.2  HR91.1
Time Stamp           Contains the server time (hour, minute,     HR91.2  HR91.3
                     and second) when the record was last        HR91.4
                     changed.

CTC-USER-ID          Alpha 10  (Lower Case)                      HR03.2  HR91.1
User ID Name         Contains the user ID of the person who      HR91.2  HR91.3
                     last changed this record.                   HR91.4

                         HRCTRYCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CTCSET1   TYPE                                                   HCEC.1  HCEM.1
          COUNTRY-CODE                                           HCOP.1  HR03.2
          HRCTRY-CODE                                            HR11.1  HR11.2
                                                                 HR170   HR211
                                                                 HR403   HR511
                                                                 HR650   HR70.1
                                                                 HR91.1  HR91.2
                                                                 HR91.3  HR91.4
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA18.1  PA218
                                                                 PA311   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 ...

CTCSET2   TYPE                                                   HC02.1  HCTC.1
          HRCTRY-CODE                                            HR03.2  HR11.1
          COUNTRY-CODE                                           HR11.2  HR13.1
                                                                 HR15.1  HR155
                                                                 HR170   HR30.1
                                                                 HR403   HR511
                                                                 HR513   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HR70.1
                                                                 HR91.1  HR91.2
                                                                 HR91.3  HR91.4
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA120   PA13.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