CONTACTS INTERFACE FILE#

The Contacts Interface File screen is used to import employee contacts and general contacts into the software data structures.

Contacts Interface File data is maintained on the INF_CV_CONTACTS table.

Each INF_CV_CONTACTS record will result in the creation of a P2K_HR_CONTACTS record and a P2K_HR_CONTACT_ROLES record. Subsequent records for the same contact, but different contact types will result in only a P2K_HR_CONTACT_ROLES record being created. Contacts are determined to be the same contact through the combination of USER_NAME or PERSON_CODE, FIRST_NAME, LAST_NAME, RELATION and EMPLOYER.

ID

First Name

This is the first name used by the contact.

Last Name

This is the surname of the contact.

User

Person Code

Relation

Relation describes the relationship of a person to the employee.

Employer

This field provides the name of the contact's employer.

Gender

This field indicates whether the contact is male or female.

Middle Name

This is the contact's middle name or initials.

Salutation

Salutation is the usual form of address for the contact.

Rank

This is the name extension e.g. Jr., Sr., III, etc.

Address 1

This is the home address (street or rural route or concession #) of the contact person.

Address 2

This field provides the second line of address, used for PO Box # or special delivery instructions.

City/Town

This field refers to the city, district or township name where the contact person resides.

State/Country

This is the standard abbreviation of the state or province and country of the contact’s address.

Mailing Address 1

This field holds the contact's mailing address (street or rural route or concession #).

Mailing Address 2

This is the second line of address, used for PO Box # or special delivery instructions.

Mailing City/Town

Locality refers to the city, district or township name of the mailing address.

Mailing State

This is the standard abbreviation for the state or province of the contact’s address.

Mailing Country

This field displays the country of the mailing address.

Mailing Zip Code

This field displays the zip code of the mailing address.

Phone #

This is the daytime phone number for the contact person.

Phone Extn

This field holds the daytime extension number for the contact.

Cellular #

This is the cellular, portable or mobile phone number for the contact person.

Fax #

This field provides the facsimile number of the contact.

E-mail

This is the email address of the contact.

Security Level