HRCONTNBR FILE
REFERENCED BY
HR170 HR211 HR220 HR70.1 PA311
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HCN-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
HCN-REQ-TYPE Alpha 1
Req Type Contains the type of person the contact
number belongs to.
1 = Employee
2 = Applicant
3 = COBRA Participant
4 = Dependent
5 = Instructor
HCN-ID-NBR Numeric 10
Id Nbr Contains an identification number (for
example, an employee number) for this
type of record.
HCN-DEPENDENT Numeric 4
Dependent Number Contains the dependent if Req-Type =
Dependent.
HCN-SEQ-NBR Numeric 4
Sequence Number Sequential number that allows unlimited
phone records per
Company:Req-Type:ID-Nbr:Dependent.
HCN-EFFECT-DATE Numeric 8 (yyyymmdd)
Effective Date Beginning date related to the contact
number.
HCN-END-DATE Numeric 8 (yyyymmdd)
Ending Date The ending date in a range of dates.
HCN-DATE Numeric 8 (yyyymmdd)
Date This field contains the system date when
this was created. Internal date used for
record sorting/display.
HCN-CONTACT-TYPE Alpha 10
Contact Type User-defined type of number (for
example, cell phone, pager, vacation
residence, and so on).
HCN-PHONE-COUNTRY Alpha 6
Telephone Country This field contains the prefix of the
Code telephone number. For example, the
country or city code.
HCN-PHONE Alpha 15
Telephone Number Contains the phone number.
HCN-PHONE-EXT Alpha 5
Telephone Extension This field contains the telephone
extension number.
HCN-COMMENT Alpha 40 (Lower Case)
Comment Line This field contains the comment
narrative.
HCN-DATE-STAMP Numeric 8 (yyyymmdd)
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
HCN-TIME-STAMP Numeric 6 (hhmmss)
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
HCN-USER-ID Alpha 10 (Lower Case)
User ID Name Contains the user ID of the person who
last changed this record.
HRCONTNBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HCNSET1 COMPANY
REQ-TYPE
ID-NBR
DEPENDENT
SEQ-NBR
HCNSET2 REQ-TYPE KeyChange, Subset
ID-NBR Where REQ-TYPE = "5"
DATE*
COMPANY
DEPENDENT
SEQ-NBR
HCNSET3 COMPANY KeyChange, Subset HR170 HR211
REQ-TYPE Where REQ-TYPE != "5" HR220 HR70.1
ID-NBR PA311
DEPENDENT
DATE*
SEQ-NBR
HRCONTNBR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When HCN-REQ-TYPE = "2"
HCN-COMPANY -> APL-COMPANY
HCN-ID-NBR -> APL-APPLICANT
Company PRSYSTEM Required
HCN-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Contact Type PCODES Required
When HCN-CONTACT-TYPE != Spaces
"NT" -> PCO-TYPE
HCN-CONTACT-TYPE -> PCO-CODE
Dependent EMDEPEND Required
When HCN-REQ-TYPE = "4"
HCN-COMPANY -> EMD-COMPANY
HCN-ID-NBR -> EMD-EMPLOYEE
HCN-DEPENDENT -> EMD-SEQ-NBR
Employee EMPLOYEE Required
When HCN-REQ-TYPE = "1"
HCN-COMPANY -> EMP-COMPANY
HCN-ID-NBR -> EMP-EMPLOYEE
Instructor PAINSTRUCT Required
When HCN-REQ-TYPE = "5"
HCN-ID-NBR -> INS-INSTRUCT
Paemployee PAEMPLOYEE Required
When HCN-REQ-TYPE = "1"
HCN-COMPANY -> PEM-COMPANY
HCN-ID-NBR -> PEM-EMPLOYEE
Participnt PARTICIPNT Required
When HCN-REQ-TYPE = "3"
HCN-COMPANY -> PAR-COMPANY
HCN-ID-NBR -> PAR-PARTICIPNT
|
