Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRCONTNBR


                             HRCONTNBR FILE

REFERENCED BY

PA390     PA93.2    HR170     HR211     HR220     HR70.1
PA311

UPDATED BY

HR11.1    HR20.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HCN-COMPANY            Numeric 4                                 HR20.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

HCN-REQ-TYPE           Alpha 1                                   HR20.1
Element: Req Type      Contains the type of person the contact
                       number belongs to.
                       1 = Employee
                       2 = Applicant
                       3 = COBRA Participant
                       4 = Dependent
                       5 = Instructor

HCN-ID-NBR             Numeric 10                                HR20.1
Element: Id Nbr        Contains an identification number (for
                       example, an employee number) for this
                       type of record.

HCN-DEPENDENT          Numeric 4                                 HR20.1
Element: Dependent NumbContains the dependent if Req-Type =
                       Dependent.

HCN-SEQ-NBR            Numeric 4                                 HR20.1
Element: Sequence NumbeSequential number that allows unlimited
                       phone records per
                       Company:Req-Type:ID-Nbr:Dependent.

HCN-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HR20.1
Element: Date          Beginning date related to the contact
                       number.

HCN-END-DATE           Numeric 8  (yyyymmdd)                     HR20.1
Element: Date          The ending date in a range of dates.

HCN-DATE               Numeric 8  (yyyymmdd)                     HR20.1
Element: Date          This field contains the system date when
                       this was created. Internal date used for
                       record sorting/display.

HCN-CONTACT-TYPE       Alpha 10                                  HR20.1
Element: Contact Type  User-defined type of number (for
                       example, cell  phone, pager, vacation
                       residence, and so on).

HCN-PHONE-COUNTRY      Alpha 6                                   HR20.1
Telephone Country      This field contains the prefix of the
Code                   telephone number. For example, the
                       country or city code.


HCN-PHONE              Alpha 15                                  HR20.1
Element: Telephone NumbContains the phone number.

HCN-PHONE-EXT          Alpha 5                                   HR20.1
Element: Telephone ExteThis field contains the telephone
                       extension number.

HCN-COMMENT            Alpha 40  (Lower Case)                    HR20.1
Element: Comment Line  This field contains the comment
                       narrative.

HCN-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR20.1
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

HCN-TIME-STAMP         Numeric 6  (hhmmss)                       HR20.1
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

HCN-USER-ID            Alpha 10  (Lower Case)                    HR20.1
Element: User

                         HRCONTNBR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HCNSET1   COMPANY                                                HR11.1  HR20.1
          REQ-TYPE                                               PA115   PA390
          ID-NBR                                                 PA93.2
          DEPENDENT
          SEQ-NBR

HCNSET2   REQ-TYPE      KeyChange, Subset
          ID-NBR        Where REQ-TYPE = "5"
          DATE*
          COMPANY
          DEPENDENT
          SEQ-NBR

HCNSET3   COMPANY       KeyChange, Subset                        HR170   HR20.1
          REQ-TYPE      Where REQ-TYPE != "5"                    HR211   HR220
          ID-NBR                                                 HR70.1  PA115
          DEPENDENT                                              PA311
          DATE*
          SEQ-NBR

                         HRCONTNBR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When HCN-REQ-TYPE = "2"

                            HCN-COMPANY         -> APL-COMPANY
                            HCN-ID-NBR          -> APL-APPLICANT

Company        PRSYSTEM     Required

                            HCN-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Contact Type   PCODES       Required
                            When HCN-CONTACT-TYPE != Spaces

                            "NT"                -> PCO-TYPE
                            HCN-CONTACT-TYPE    -> PCO-CODE

Dependent      EMDEPEND     Required
                            When HCN-REQ-TYPE = "4"

                            HCN-COMPANY         -> EMD-COMPANY
                            HCN-ID-NBR          -> EMD-EMPLOYEE
                            HCN-DEPENDENT       -> EMD-SEQ-NBR

Employee       EMPLOYEE     Required
                            When HCN-REQ-TYPE = "1"

                            HCN-COMPANY         -> EMP-COMPANY
                            HCN-ID-NBR          -> EMP-EMPLOYEE

Instructor     PAINSTRUCT   Required
                            When HCN-REQ-TYPE = "5"

                            HCN-ID-NBR          -> INS-INSTRUCT

Paemployee     PAEMPLOYEE   Required
                            When HCN-REQ-TYPE = "1"

                            HCN-COMPANY         -> PEM-COMPANY
                            HCN-ID-NBR          -> PEM-EMPLOYEE

Participnt     PARTICIPNT   Required
                            When HCN-REQ-TYPE = "3"

                            HCN-COMPANY         -> PAR-COMPANY
                            HCN-ID-NBR          -> PAR-PARTICIPNT