HRCONTNBR

UPDATED BY
HR11.1 HR20.1 PA115 PA390 PA93.2 HR170
HR211 HR220 HR70.1 PA311

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HCN-COMPANY
Element: Company Hr		Numeric 4
HR20.1
HCN-REQ-TYPE
Element: Req Type		Alpha 1
Contains the type of person the contact number belongs to.
1 = Employee
2 = Applicant
3 = COBRA Participant
4 = Dependent
5 = Instructor
HR20.1
HCN-ID-NBR
Element: Id Nbr		Numeric 10
Contains an identification number (for example, an employee number) for this type of record.
HR20.1
HCN-DEPENDENT
Element: Dependent		Numeric 4
Contains the dependent if Req-Type = Dependent.
HR20.1
HCN-SEQ-NBR
Element: Seq Nbr		Numeric 4
Sequential number that allows unlimited phone records per Company:Req-Type:ID-Nbr:Dependent.
HR20.1
HCN-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Beginning date related to the contact number.
HR20.1
HCN-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
The end date for this effort period.
HR20.1
HCN-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field contains the system date when this was created. Internal date used for record sorting/display.
HR20.1
HCN-CONTACT-TYPE
Element: Contact Type		Alpha 10
User-defined type of number (for example, cell phone, pager, vacation residence, and so on).
HR20.1
HCN-PHONE-COUNTRY
Element: Phone Country		Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
HR20.1
HCN-PHONE
Element: Phone		Alpha 15
Contains the phone number.
HR20.1
HCN-PHONE-EXT
Element: Phone Ext		Alpha 5
This field contains the telephone extension number.
HR20.1
HCN-COMMENT
Element: Comment		Alpha 40 (Lower Case)
This field contains the comment narrative.
HR20.1
HCN-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
HR20.1
HCN-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR20.1
HCN-USER-ID
Element: User		Alpha 10 (Lower Case)
HR20.1


HRCONTNBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HCNSET1 COMPANY
REQ-TYPE
ID-NBR
DEPENDENT
SEQ-NBR
HR11.1 HR20.1
PA115 PA390
PA93.2
HCNSET3 COMPANY
REQ-TYPE
ID-NBR
DEPENDENT
DATE*
SEQ-NBR
KeyChange, Subset
WhereREQ-TYPE !="5"
HR170 HR20.1
HR211 HR220
HR70.1 PA115
PA311


HRCONTNBR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

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

Home
Contact Us



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