HRCORRESP

UPDATED BY
HR130 HR30.1 HR230

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


HRCORRESP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HCPSET1 COMPANY
REQ-TYPE
ID-NBR
DEPENDENT
SEQ-NBR
KeyChange
HR130 HR230
HR30.1
HCPSET2 REQ-TYPE
ID-NBR
COMPANY
DEPENDENT
SEQ-NBR
KeyChange


HRCORRESP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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-
AndINS-EMPLOYEE =Zeroes
HCP-ID-NBR->INS-INSTRUCT
Instruct Home EMPLOYEE Required
When INS- =HCP-
AndINS-EMPLOYEE !=Zeroes
INS-COMPANY->EMP-COMPANY
INS-EMPLOYEE->EMP-EMPLOYEE
Instruct Pem PAEMPLOYEE Required
When INS- =HCP-
AndINS-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
NAME
RELATED 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


File created: Wed Jun 08 20:49:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.