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.

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 marked * are descending. 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

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)