Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRCORRESP

                             HRCORRESP FILE

REFERENCED BY

HR230

UPDATED BY

HR130     HR30.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HCP-COMPANY            Numeric 4                                 HR30.1
Element: Company Hr    Contains the company that received the
                       request.

HCP-REQ-TYPE           Alpha 1                                   HR30.1
Element: Req Type      Indicates the type of individual
                       requesting the information.
                       1 = Employee
                       2 = Applicant
                       3 = COBRA Participant
                       4 = Dependent
                       5 = Instructor
                       6 = Other

HCP-ID-NBR             Numeric 10                                HR30.1
Element: Id Nbr        Contains the number of the individual
                       making the request.

HCP-DEPENDENT          Numeric 4                                 HR30.1
Element: Dependent     Contains the number for the dependent.

HCP-SEQ-NBR            Numeric 4                                 HR30.1
Element: Seq Nbr       An automatically assigned sequence
                       number.

HCP-LAST-NAME-PRE      Alpha 30  (Lower Case)                    HR30.1
Element: Last Name Pre Contains the prefix of the individual's
                       last name.

HCP-LAST-NAME          Alpha 30  (Lower Case)                    HR30.1
Element: Last Name     Contains the last name of the
                       individual requesting the information.

HCP-NAME-SUFFIX        Alpha 4  (Lower Case)                     HR30.1
Element: Name Suffix   Contains the suffix used by the
                       individual.

HCP-FIRST-NAME         Alpha 15  (Lower Case)                    HR30.1
Element: First Name    Contains the first name of the
                       individual requesting the information.

HCP-MIDDLE-NAME        Alpha 15  (Lower Case)                    HR30.1
Element: Middle Name   Contains the middle name of the
                       individual requesting the information.

HCP-NAME-PREFIX        Alpha 4  (Lower Case)                     HR30.1
Element: Name Prefix   Contains the title used by the
                       individual.

HCP-HM-PHONE-CNTRY     Alpha 6                                   HR30.1
Element: Hm Phone CntryContains the home telephone country
                       code.

HCP-HM-PHONE-NBR       Alpha 15                                  HR30.1
Element: Hm Phone Nbr  Contains the home telephone number.

HCP-WK-PHONE-CNTRY     Alpha 6                                   HR30.1
Element: Wk Phone CntryContains the work telephone country
                       code.

HCP-WK-PHONE-NBR       Alpha 15                                  HR30.1
Element: Wk Phone Nbr  Contains the work telephone number.

HCP-WK-PHONE-EXT       Alpha 5                                   HR30.1
Element: Wk Phone Ext  Contains the work telephone extension.

HCP-FAX-COUNTRY        Alpha 6                                   HR30.1
Element: Phone Country This field contains the prefix of the
                       telephone number. For example, the
                       country or city code.


HCP-FAX-NBR            Alpha 15                                  HR30.1
Element: Fax Nbr       Contains the fax telephone number.

HCP-FAX-EXT            Alpha 5                                   HR30.1
Element: Phone Ext     Contains the fax telephone number
                       extension.

HCP-EMP-ADDRESS        Alpha 1                                   HR30.1
Element: Emp Address   Indicates whether the system should use
                       the employee's home address,
                       supplemental address, or neither
                       address.
                       H = Home
                       S = Supplemental
                       N = Neither

HCP-ADDR1              Alpha 30  (Lower Case)                    HR30.1
Element: Addr1         Contains the first line of address
                       information.

HCP-ADDR2              Alpha 30  (Lower Case)                    HR30.1
Element: Addr1         Contains the second line of address
                       information.

HCP-ADDR3              Alpha 30  (Lower Case)                    HR30.1
Element: Addr1         Contains the third line of address
                       information.

HCP-ADDR4              Alpha 30  (Lower Case)                    HR30.1
Element: Addr1         Contains the fourth line of address
                       information.

HCP-CITY               Alpha 18  (Lower Case)                    HR30.1
Element: City          Contains the city or fifth line of the
                       address.

HCP-STATE              Alpha 2                                   HR30.1
Element: State         Contains the two-character state code
                       of the address.

HCP-ZIP                Alpha 10                                  HR30.1
Element: Zip           Contains the postal code of the
                       address.



HCP-COUNTRY-CODE       Alpha 2                                   HR30.1
Element: Country Code  Contains the country code for the
                       address.

HCP-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    HR30.1
Element: Email Address Contains the requestor's email address.

HCP-TYPE               Alpha 2                                   HR30.1
Element: Type          Indicates the type of data request.
                       1 = Data Privacy/Other
                       2 = ERISA
                       3 = Applicant Correspondence
                       4 = Employee Correspondence
                       5 = COBRA Correspondence
                       6 = Dependent Correspondence
                       7 = Instructor Correspondence

HCP-REQUEST-DATE       Numeric 8  (yyyymmdd)                     HR30.1
Element: Request Date  Contains the date the request was
                       received.

HCP-DATA-REQUESTED     Alpha 10                                  HR30.1
Element: Data RequestedIndicates the type of information
                       requested.

HCP-COST               Signed 11.2                               HR30.1
Element: Cost          Contains the cots charged for the
                       information.

HCP-CURRENCY-CODE      Alpha 5                                   HR30.1
Element: Currency Code Contains the currency in which the cost
                       is recorded.

HCP-CURR-ND            Numeric 1                                 HR30.1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


HCP-BASE-CURRENCY      Alpha 5                                   HR30.1
Element: Base Currency Contains the company's base currency.

HCP-BASE-ND            Numeric 1                                 HR30.1
Element: Base Nd       The number of decimal positions defined
                       for the company base currency.

HCP-BASE-AMOUNT        Signed 15.2                               HR30.1
Element: Base Amt      Contains the amount in the company's
                       base currency.

HCP-EXTENSION-SENT     Numeric 8  (yyyymmdd)                     HR30.1
Element: Extension SentContains the date a notification of
                       extension on fulfilling the request was
                       sent.

HCP-EXTENSION-DATE     Numeric 8  (yyyymmdd)                     HR30.1
Element: Extension DateContains the date the request
                       fulfillment is pushed to.

HCP-EXTENSION-RSN      Alpha 10                                  HR30.1
Element: Extension Rsn Contains a user-defined reason for the
                       extension.

HCP-DATE-SENT          Numeric 8  (yyyymmdd)                     HR30.1
Element: Date Sent     Contains the date the information is
                       sent.

HCP-COMM-METHOD        Alpha 10                                  HR30.1
Element: Comm Method   Contains a user-defined communication
                       method used to send the information to
                       the requestor.

HCP-CHANGE-RECD        Numeric 8  (yyyymmdd)                     HR30.1
Element: Change Recd   Contains the date a request was
                       received to change the information.

HCP-CHANGE-REQUEST     Alpha 10                                  HR30.1
Element: Change RequestIndicates the type of change that was
                       requested.

HCP-CHANGE             Alpha 1                                   HR30.1
Element: Change        Indicates whether the change was made.
                       Y = Yes
                       N = No

HCP-REASON             Alpha 10                                  HR30.1
Element: Reason        Indicates the reason for the change.

HCP-CHANGED-DATE       Numeric 8  (yyyymmdd)                     HR30.1
Element: Changed Date  Indicates the date the information was
                       changed and/or communicated to the
                       requestor.

HCP-DATE-CHG-SENT      Numeric 8  (yyyymmdd)                     HR30.1
Element: Date Chg Sent Contains the date notification of the
                       change was sent to the requestor.

HCP-COMM-METH-CHG      Alpha 10                                  HR30.1
Element: Comm Meth Chg Indicates the communication method used
                       to get information to the requestor on
                       the outcome of the change request.

                         HRCORRESP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HCPSET1   COMPANY       KeyChange                                HR130   HR230
          REQ-TYPE                                               HR30.1
          ID-NBR
          DEPENDENT
          SEQ-NBR

HCPSET2   REQ-TYPE      KeyChange
          ID-NBR
          COMPANY
          DEPENDENT
          SEQ-NBR

                         HRCORRESP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

                            HCP-COMPANY           -> APL-COMPANY
                            HCP-ID-NBR            -> APL-APPLICANT

Base Currency  CUCODES      Not Required
                            Valid When HCP-BASE-CURRENCY != Spaces

                            HCP-BASE-CURRENCY     -> CUC-CURRENCY-CODE

Change Reason  PCODES       Not Required
                            Valid When HCP-REASON != Spaces

                            "CR"                  -> PCO-TYPE
                            HCP-REASON            -> PCO-CODE

Change Request PCODES       Not Required
                            Valid When HCP-CHANGE-REQUEST != Spaces

                            "CQ"                  -> PCO-TYPE
                            HCP-CHANGE-REQUEST    -> PCO-CODE

Cobra Part     PARTICIPNT   Required
                            When HCP-REQ-TYPE = "3"

                            HCP-COMPANY           -> PAR-COMPANY
                            HCP-ID-NBR            -> PAR-PARTICIPNT

Comm Meth Chg  PCODES       Not Required
                            Valid When HCP-COMM-METH-CHG != Spaces

                            "CM"                  -> PCO-TYPE
                            HCP-COMM-METH-CHG     -> PCO-CODE

Comm Meth Req  PCODES       Not Required
                            Valid When HCP-COMM-METHOD != Spaces

                            "CM"                  -> PCO-TYPE
                            HCP-COMM-METHOD       -> PCO-CODE

Company        PRSYSTEM     Required

                            HCP-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Country        INSTCTRYCD   Not Required
                            Valid When HCP-COUNTRY-CODE != Spaces

                            HCP-COUNTRY-CODE      -> INT-COUNTRY-CODE

Currency       CUCODES      Not Required
                            Valid When HCP-CURRENCY-CODE != Spaces

                            HCP-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Data Request   PCODES       Not Required
                            Valid When HCP-DATA-REQUESTED != Spaces

                            "DR"                  -> PCO-TYPE
                            HCP-DATA-REQUESTED    -> PCO-CODE

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

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

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

                            HCP-COMPANY           -> EMP-COMPANY
                            HCP-ID-NBR            -> EMP-EMPLOYEE

Extension Rsn  PCODES       Not Required
                            Valid When HCP-EXTENSION-RSN != Spaces

                            "ER"                  -> PCO-TYPE
                            HCP-EXTENSION-RSN     -> PCO-CODE

External Instr PAINSTRUCT   Required
                            When INS-         = HCP-
                            And  INS-EMPLOYEE = Zeroes

                            HCP-ID-NBR            -> INS-INSTRUCT

Instruct Home  EMPLOYEE     Required
                            When INS-         =  HCP-
                            And  INS-EMPLOYEE != Zeroes

                            INS-COMPANY           -> EMP-COMPANY
                            INS-EMPLOYEE          -> EMP-EMPLOYEE

Instruct Pem   PAEMPLOYEE   Required
                            When INS-         =  HCP-
                            And  INS-EMPLOYEE != Zeroes

                            INS-COMPANY           -> PEM-COMPANY
                            INS-EMPLOYEE          -> PEM-EMPLOYEE

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

                            HCP-ID-NBR            -> INS-INSTRUCT

Paemployee     PAEMPLOYEE   Not Required

                            HCP-COMPANY           -> PEM-COMPANY
                            HCP-ID-NBR            -> PEM-EMPLOYEE

                         HRCORRESP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Name Prefix    HRCTRYCODE
                            Valid When (HCP-NAME-PREFIX != Spaces )

                            "PR"                  -> CTC-TYPE
                            HCP-NAME-PREFIX       -> CTC-HRCTRY-CODE
                                                     CTC-COUNTRY-CODE

Name Suffix    HRCTRYCODE
                            Valid When (HCP-NAME-SUFFIX != Spaces )

                            "SU"                  -> CTC-TYPE
                            HCP-NAME-SUFFIX       -> CTC-HRCTRY-CODE
                                                     CTC-COUNTRY-CODE