Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRCTRYCODE


                            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    HGLM.1    HPOS.1    HPQC.1    HPRS.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
Element: 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
Element: 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
Element: Hrctry Code                                             HR91.2  HR91.3
                                                                 HR91.4

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

CTC-ACTIVE-FLAG        Alpha 1                                   HR03.2  HR91.1
Element: 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
Element: 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
Element: 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
Element: User                                                    HR91.2  HR91.3
                                                                 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                                            HGLM.1  HPOS.1
          COUNTRY-CODE                                           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
                                                                 HR650   HR70.1
                                                                 HR91.1  HR91.2
                                                                 HR91.3  HR91.4
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 ...

                         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