|
|
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
|
