HRCORRESP – No description in the Lawson data dictionary

System: Human Resources (HR)
Prefix: HCP
Primary key: COMPANY, REQ-TYPE, ID-NBR, DEPENDENT, SEQ-NBR
Fields: 50
Updated by: 2 programs
Referenced by: 1 program

HRCORRESP is a Lawson Human Resources table (prefix HCP); no description in the lawson data dictionary. It is indexed by COMPANY, REQ-TYPE, ID-NBR, DEPENDENT, SEQ-NBR (HCPSET1); alternate indexes: HCPSET2. It is related 1:1 to APPLICANT, CUCODES, PCODES, PARTICIPNT, PRSYSTEM, INSTCTRYCD, EMDEPEND, EMPLOYEE and 2 more and 1:M to HRCTRYCODE. It is updated by HR130 and HR30.1 and referenced by HR230. The table has 50 fields, 2 indexes and 21 documented relations.

About HRCORRESP

No description in the Lawson data dictionary.

Fields (50)

Column = COBOL field name without the HCP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`HCP-COMPANY` PK COMPANY	Numeric 4	Contains the company that received the request.	HR30.1
#`HCP-REQ-TYPE` PK REQ_TYPE	Alpha 1	Indicates the type of individual requesting the information. `1` Employee `2` Applicant `3` COBRA Participant `4` Dependent `5` Instructor `6` Other	HR30.1
#`HCP-ID-NBR` PK ID_NBR	Numeric 10	Contains the number of the individual making the request.	HR30.1
#`HCP-DEPENDENT` PK DEPENDENT	Numeric 4	Contains the number for the dependent.	HR30.1
#`HCP-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	HR30.1
#`HCP-LAST-NAME-PRE` LAST_NAME_PRE	Alpha 30 (Lower Case)	Contains the prefix of the individual's last name.	HR30.1
#`HCP-LAST-NAME` LAST_NAME	Alpha 30 (Lower Case)	Contains the last name of the individual requesting the information.	HR30.1
#`HCP-NAME-SUFFIX` NAME_SUFFIX	Alpha 4 (Lower Case)	Contains the suffix used by the individual.	HR30.1
#`HCP-FIRST-NAME` FIRST_NAME	Alpha 15 (Lower Case)	Contains the first name of the individual requesting the information.	HR30.1
#`HCP-MIDDLE-NAME` MIDDLE_NAME	Alpha 15 (Lower Case)	Contains the middle name of the individual requesting the information.	HR30.1
#`HCP-NAME-PREFIX` NAME_PREFIX	Alpha 4 (Lower Case)	Contains the title used by the individual.	HR30.1
#`HCP-HM-PHONE-CNTRY` HM_PHONE_CNTRY	Alpha 6	Contains the home telephone country code.	HR30.1
#`HCP-HM-PHONE-NBR` HM_PHONE_NBR	Alpha 15	Contains the home telephone number.	HR30.1
#`HCP-WK-PHONE-CNTRY` WK_PHONE_CNTRY	Alpha 6	Contains the work telephone country code.	HR30.1
#`HCP-WK-PHONE-NBR` WK_PHONE_NBR	Alpha 15	Contains the work telephone number.	HR30.1
#`HCP-WK-PHONE-EXT` WK_PHONE_EXT	Alpha 5	Contains the work telephone extension.	HR30.1
#`HCP-FAX-COUNTRY` FAX_COUNTRY	Alpha 6	This field contains the prefix of the telephone number. For example, the country or city code.	HR30.1
#`HCP-FAX-NBR` FAX_NBR	Alpha 15	Contains the fax telephone number.	HR30.1
#`HCP-FAX-EXT` FAX_EXT	Alpha 5	Contains the fax telephone number extension.	HR30.1
#`HCP-EMP-ADDRESS` EMP_ADDRESS	Alpha 1	Indicates whether the system should use the employee's home address, supplemental address, or neither address. `H` Home `S` Supplemental `N` Neither	HR30.1
#`HCP-ADDR1` ADDR1	Alpha 30 (Lower Case)	Contains the first line of address information.	HR30.1
#`HCP-ADDR2` ADDR2	Alpha 30 (Lower Case)	Contains the second line of address information.	HR30.1
#`HCP-ADDR3` ADDR3	Alpha 30 (Lower Case)	Contains the third line of address information.	HR30.1
#`HCP-ADDR4` ADDR4	Alpha 30 (Lower Case)	Contains the fourth line of address information.	HR30.1
#`HCP-CITY` CITY	Alpha 58 (Lower Case)	Contains the city or fifth line of the address.	HR30.1
#`HCP-STATE` STATE	Alpha 2	Contains the two-character state code of the address.	HR30.1
#`HCP-ZIP` ZIP	Alpha 10	Contains the postal code of the address.	HR30.1
#`HCP-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	Contains the country code for the address.	HR30.1
#`HCP-EMAIL-ADDRESS` EMAIL_ADDRESS	Alpha 60 (Lower Case)	Contains the requestor's email address.	HR30.1
#`HCP-TYPE` TYPE	Alpha 2	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	HR30.1
#`HCP-REQUEST-DATE` REQUEST_DATE	Numeric 8 (yyyymmdd)	Contains the date the request was received.	HR30.1
#`HCP-DATA-REQUESTED` DATA_REQUESTED	Alpha 10	Select the type of information requested.	HR30.1
#`HCP-COST` COST	Signed 11.2	Contains the cots charged for the information.	HR30.1
#`HCP-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency in which the cost is recorded.	HR30.1
#`HCP-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	HR30.1
#`HCP-BASE-CURRENCY` BASE_CURRENCY	Alpha 5	Contains the company's base currency.	HR30.1
#`HCP-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	HR30.1
#`HCP-BASE-AMOUNT` BASE_AMOUNT	Signed 15.2	Contains the amount in the company's base currency.	HR30.1
#`HCP-EXTENSION-SENT` EXTENSION_SENT	Numeric 8 (yyyymmdd)	Contains the date a notification of extension on fulfilling the request was sent.	HR30.1
#`HCP-EXTENSION-DATE` EXTENSION_DATE	Numeric 8 (yyyymmdd)	Contains the date the request fulfillment is pushed to.	HR30.1
#`HCP-EXTENSION-RSN` EXTENSION_RSN	Alpha 10	Contains a user-defined reason for the extension.	HR30.1
#`HCP-DATE-SENT` DATE_SENT	Numeric 8 (yyyymmdd)	Contains the date the information is sent.	HR30.1
#`HCP-COMM-METHOD` COMM_METHOD	Alpha 10	Contains a user-defined communication method used to send the information to the requestor.	HR30.1
#`HCP-CHANGE-RECD` CHANGE_RECD	Numeric 8 (yyyymmdd)	Contains the date a request was received to change the information.	HR30.1
#`HCP-CHANGE-REQUEST` CHANGE_REQUEST	Alpha 10	Indicates the type of change that was requested.	HR30.1
#`HCP-CHANGE` CHANGE	Alpha 1	Indicates whether the change was made. `Y` Yes `N` No	HR30.1
#`HCP-REASON` REASON	Alpha 10	Indicates the reason for the change.	HR30.1
#`HCP-CHANGED-DATE` CHANGED_DATE	Numeric 8 (yyyymmdd)	Indicates the date the information was changed and/or communicated to the requestor.	HR30.1
#`HCP-DATE-CHG-SENT` DATE_CHG_SENT	Numeric 8 (yyyymmdd)	Contains the date notification of the change was sent to the requestor.	HR30.1
#`HCP-COMM-METH-CHG` COMM_METH_CHG	Alpha 10	Indicates the communication method used to get information to the requestor on the outcome of the change request.	HR30.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`HCPSET1`	`COMPANY` `REQ-TYPE` `ID-NBR` `DEPENDENT` `SEQ-NBR`	Primary, KeyChange		HR130, HR230, HR30.1
`HCPSET2`	`REQ-TYPE` `ID-NBR` `COMPANY` `DEPENDENT` `SEQ-NBR`	KeyChange		—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (19) — lookups and parents

Relation Table Rules Condition Field map

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`

One to many (2) — child tables

Relation Table Rules Condition Field map

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`

HRCORRESP – No description in the Lawson data dictionary

About HRCORRESP

Fields (50)

Indexes (2)

Relations

One to one (19) — lookups and parents

One to many (2) — child tables

Programs

Updated by (2)

Referenced by (1)

HRCORRESP – No description in the Lawson data dictionary

About HRCORRESP

Fields (50) Copy as SQL

Indexes (2)

Relations

One to one (19) — lookups and parents

One to many (2) — child tables

Programs

Updated by (2)

Referenced by (1)

Fields (50)