Wiki: IECI

DEFINE BUSINESS CONTACTS#

Business contacts (IECI) are usually people from outside the organization such as trainers and instructors, sponsors, plan administrators, representatives, recruiters, etc.

Contact data is stored in the P2K_HR_CONTACTS and P2K_HR_CONTACT_ROLES tables.

Identity#

Employer: This field holds the name of the contact's employer; for benefit purposes this would be the issuer. Employer is an optional 50-character alphanumeric field you may manually enter.

Salutation: Salutation is the usual form of address for the contact.

Salutation is an optional fixed lexicon (X_SALUTATION) you may use to look up the value.

First Name: This is the first name used by the contact. First_Name is a mandatory 50-character alphanumeric field you must manually enter.

Middle Name: This is the contact's middle name or initials. Middle_Name is an optional 50-character alphanumeric field you may manually enter.

Last Name: This is the surname of the contact. Last_Name is a 50-character alphanumeric mandatory field you must manually enter.

Rank: Rank is the name extension. Rank is an optional fixed lexicon (X_RANK) you may use to look up the value.

Language: This field indicates the contact's language of preference for communication/correspondence. Language_Code is a mandatory fixed lexicon (X_LANGUAGE_CODE) you may use to look up to choose a value.

Phone#

Phone #: This is the daytime phone number for the contact. Phone_Number is an optional 20-character alphanumeric field you must manually enter.

Extn.: This is the daytime extension number for the contact. Phone_Extension is an optional 16-character alphanumeric field you must manually enter.

Alt Phone #: This is the alternative phone number for the contact (if applicable). Alt_Phone_Number is an optional 20-character alphanumeric field you must manually enter.

Alt. Phone Extn: This is the alternate phone extension (if applicable). Alt_Phone_Extn is an alphanumeric 16-character optional field you must manually enter.

Cellular #: This field holds the cellular, portable or mobile phone number for the contact. Cellular_Number is an alphanumeric 20-character optional field you must manually enter.

Fax #: This is the facsimile number of the contact. Fax_Number is an optional 20-character alphanumeric field you must manually enter.

Email: This field holds the email address of the contact. Email_Address is an optional 50-character alphanumeric field you must manually enter.

Primary Address#

Address 1: This is the home or business address (street or rural route or concession #) of the contact. Address_Line_1 is an optional 50-character alphanumeric field you must manually enter.

Address 2: This identifies the second line of address, used for PO Box # or special delivery instructions. Address_Line_2 is an optional 50-character alphanumeric field you must manually enter.

City: This field refers to the city, district or township name for the contact. Locality is an optional 50-character alphanumeric field you may manually enter.

State/Province: State or Province code is the standard abbreviation of the contact’s address. State_Province from P2K_CM_STATE_PROVINCES is a mandatory 16-character alphanumeric field you must manually enter or use the LOV (F9).

Zip/Postal: U.S.A.: Zip Code.
Canada: Postal Code.

Zip_Postal is an optional 16-character alphanumeric field you may manually enter.

Mailing Address#

Address 1: Address 1 is the mailing address to the home or business (street or rural route or concession #) of the contact. Mail_Address_Line_1 is an optional 50-character alphanumeric field you must manually enter.

Address 2: This is the second line of the mailing address, used for PO Box # or special delivery instructions. Mail_Address_Line_2 is an optional 50-character alphanumeric field you must manually enter.

City: This field refers to the city, district or township name for the contact’s mailing address. Mail_Locality is an optional 50-character alphanumeric field you may manually enter.

State/Province: State or Province code is the standard state or province abbreviation for the contact’s address. State_Province from P2K_CM_STATE_PROVINCES is a mandatory 16-character alphanumeric field a user must manually enter or use the LOV (F9).

Zip/Postal: U.S.A.: Zip Code
Canada: Postal Code

Mail_Zip_Postal is an optional 16-character alphanumeric field you may manually enter.

Contact Type: Contact Type refers to the nature of the relationship the contact has with an employee or the user.

A contact may have multiple contact roles, for example, the contact may be the employee's spouse, emergency contact and beneficiary, simultaneously.

Contact type indicates whether this is an employee contact (spouse, emergency contact, dependent or beneficiary), or a general contact (business or personal) of the user. Contact_Type is a mandatory fixed lexicon (X_CONTACT_TYPE) you may use to look up the value.

Private Contact: If the ‘Private Contact’ toggle is ON, this contact is a private contact of the user who created it. If the toggle is OFF, any user may access the contact information. Private_Item is an optional toggle field.