HRCORRESP FILE
REFERENCED BY
HR230
UPDATED BY
HR130 HR30.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HCP-COMPANY Numeric 4 HR30.1
Company Contains the company that received the
request.
HCP-REQ-TYPE Alpha 1 HR30.1
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
Id Nbr Contains the number of the individual
making the request.
HCP-DEPENDENT Numeric 4 HR30.1
Dependent Number Contains the number for the dependent.
HCP-SEQ-NBR Numeric 4 HR30.1
Sequence Number An automatically assigned sequence
number.
HCP-LAST-NAME-PRE Alpha 30 (Lower Case) HR30.1
Last Name Pre Contains the prefix of the individual's
last name.
HCP-LAST-NAME Alpha 30 (Lower Case) HR30.1
Last Name Contains the last name of the
individual requesting the information.
HCP-NAME-SUFFIX Alpha 4 (Lower Case) HR30.1
Name Suffix Contains the suffix used by the
individual.
HCP-FIRST-NAME Alpha 15 (Lower Case) HR30.1
First Name Contains the first name of the
individual requesting the information.
HCP-MIDDLE-NAME Alpha 15 (Lower Case) HR30.1
Middle Name Contains the middle name of the
individual requesting the information.
HCP-NAME-PREFIX Alpha 4 (Lower Case) HR30.1
Name Prefix Contains the title used by the
individual.
HCP-HM-PHONE-CNTRY Alpha 6 HR30.1
Hm Phone Cntry Contains the home telephone country
code.
HCP-HM-PHONE-NBR Alpha 15 HR30.1
Hm Phone Nbr Contains the home telephone number.
HCP-WK-PHONE-CNTRY Alpha 6 HR30.1
Work Telephone Contains the work telephone country
Country code.
HCP-WK-PHONE-NBR Alpha 15 HR30.1
Work Telephone Contains the work telephone number.
HCP-WK-PHONE-EXT Alpha 5 HR30.1
Work Telephone Contains the work telephone extension.
Extension
HCP-FAX-COUNTRY Alpha 6 HR30.1
Fax Country This field contains the prefix of the
fax number. For example, the country or
city code.
HCP-FAX-NBR Alpha 15 HR30.1
Fax Number Contains the fax telephone number.
HCP-FAX-EXT Alpha 5 HR30.1
Fax Extension Contains the fax telephone number
extension.
HCP-EMP-ADDRESS Alpha 1 HR30.1
Employee 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
Address 1 Contains the first line of address
information.
HCP-ADDR2 Alpha 30 (Lower Case) HR30.1
Address 2 Contains the second line of address
information.
HCP-ADDR3 Alpha 30 (Lower Case) HR30.1
Address 3 Contains the third line of address
information.
HCP-ADDR4 Alpha 30 (Lower Case) HR30.1
Address 4 Contains the fourth line of address
information.
HCP-CITY Alpha 18 (Lower Case) HR30.1
City Contains the city or fifth line of the
address.
HCP-STATE Alpha 2 HR30.1
State or Province Contains the two-character state code
of the address.
HCP-ZIP Alpha 10 HR30.1
Postal Code Contains the postal code of the
address.
HCP-COUNTRY-CODE Alpha 2 HR30.1
Country Code Contains the country code for the
address.
HCP-EMAIL-ADDRESS Alpha 60 (Lower Case) HR30.1
Email Address Contains the requestor's email address.
HCP-TYPE Alpha 2 HR30.1
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
Date Requested Contains the date the request was
received.
HCP-DATA-REQUESTED Alpha 10 HR30.1
Data Requested Indicates the type of information
requested.
HCP-COST Signed 11.2 HR30.1
Cost Contains the cots charged for the
information.
HCP-CURRENCY-CODE Alpha 5 HR30.1
Currency Code Contains the currency in which the cost
is recorded.
HCP-CURR-ND Numeric 1 HR30.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
HCP-BASE-CURRENCY Alpha 5 HR30.1
Base Currency Contains the company's base currency.
HCP-BASE-ND Numeric 1 HR30.1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
HCP-BASE-AMOUNT Signed 15.2 HR30.1
Base Amount Contains the amount in the company's
base currency.
HCP-EXTENSION-SENT Numeric 8 (yyyymmdd) HR30.1
Extension Sent Contains the date a notification of
extension on fulfilling the request was
sent.
HCP-EXTENSION-DATE Numeric 8 (yyyymmdd) HR30.1
Extension Date Contains the date the request
fulfillment is pushed to.
HCP-EXTENSION-RSN Alpha 10 HR30.1
Extension Rsn Contains a user-defined reason for the
extension.
HCP-DATE-SENT Numeric 8 (yyyymmdd) HR30.1
Date Sent Contains the date the information is
sent.
HCP-COMM-METHOD Alpha 10 HR30.1
Comm Method Contains a user-defined communication
method used to send the information to
the requestor.
HCP-CHANGE-RECD Numeric 8 (yyyymmdd) HR30.1
Change Recd Contains the date a request was
received to change the information.
HCP-CHANGE-REQUEST Alpha 10 HR30.1
Change Request Indicates the type of change that was
requested.
HCP-CHANGE Alpha 1 HR30.1
Change Indicates whether the change was made.
Y = Yes
N = No
HCP-REASON Alpha 10 HR30.1
Reason Indicates the reason for the change.
HCP-CHANGED-DATE Numeric 8 (yyyymmdd) HR30.1
Changed Date Indicates the date the information was
changed and/or communicated to the
requestor.
HCP-DATE-CHG-SENT Numeric 8 (yyyymmdd) HR30.1
Date Chg Sent Contains the date notification of the
change was sent to the requestor.
HCP-COMM-METH-CHG Alpha 10 HR30.1
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 HCP- = HCP-
And HCP-EMPLOYEE = Zeroes
HCP-ID-NBR -> INS-INSTRUCT
Instruct Home EMPLOYEE Required
When HCP- = HCP-
And HCP-FIRST-NAME != Spaces
And HCP-ID-NBR = HCP-INSTRUCT
INS-COMPANY -> EMP-COMPANY
INS-EMPLOYEE -> EMP-EMPLOYEE
Instruct Pem PAEMPLOYEE Required
When HCP- = HCP-
And HCP-FIRST-NAME != Spaces
And HCP-ID-NBR = HCP-INSTRUCT
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
|
