Lawson Insight Technical Documentation

                            HRCTRYCODE FILE

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

REFERENCED BY

HCEC.1    HCEM.1    HCOP.1    HR170     HR211     HR403
HR511     HR650     HR70.1    PA18.1    PA218     PA311
PA502     PR13.1    PR13.5    PR13.6    PR13.8    HC02.1
HCTC.1    HR13.1    HR15.1    HR155     HR30.1    HR513
HR54.1    HR55.2    HRS1.1    HRSC.1    PA120     PA16.1
PA231     PA272     PA31.1    PA390     PA391     PA513
PA53.1    PA531     PA54.1    PA66.3    TR22.1    TR500

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                                            HR170   HR211
                                                                 HR403   HR511
                                                                 HR650   HR70.1
                                                                 HR91.1  HR91.2
                                                                 HR91.3  HR91.4
                                                                 PA18.1  PA218
                                                                 PA311   PA502
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

CTCSET2   TYPE                                                   HC02.1  HCTC.1
          HRCTRY-CODE                                            HR03.2  HR13.1
          COUNTRY-CODE                                           HR15.1  HR155
                                                                 HR170   HR30.1
                                                                 HR403   HR511
                                                                 HR513   HR54.1
                                                                 HR55.2  HR650
                                                                 HR70.1  HR91.1
                                                                 HR91.2  HR91.3
                                                                 HR91.4  HRS1.1
                                                                 HRSC.1  PA120
                                                                 PA16.1  PA218
                                                                 PA231   PA272
                                                                 PA31.1  PA390
                                                                 PA391   PA502
                                                                 ...

                         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