PERSONAL INTERFACE FILE#

The Personal Interface File screen is used to import personal records into the software data structures.

Personal Interface File data is maintained on the INF_CV_PERSONALS table.

---

Identity Tab#

ID

This field uniquely identifies the personal record within the data base.

Person Code

This field identifies the person associated with the personal record.

User

This field identifies the user associated with the personal record.

Gov't Code

This field identifies the person's government identification number (SSN/SIN).

First Name/Last Name

This field provides person's name.

Date of Birth

The person's date of birth is provided in this field.

Gender

The person's gender is displayed in this field.

Language

The person's primary language is identified in this field.

Ethnic

This field identifies the individual's ethnic background.
For U.S. Installations: The ethnic code (or race of an employee) is used for Equal Employment Opportunity and Affirmative Action reporting.
For Canadian Installations: Ethnic origin of an employee is used for Employment Equity reporting.

Middle Name

This field identifies the individual's middle name, if applicable.

Salutation

This field identifies the title of the individual.

Rank

This field provides the individual's name extension. (i.e. JR., SR., II)

Birthplace

The person's place of birth is displayed in this field.

Challenged

This field indicates if the individual is physically challenged.

Veteran Status

This field indicates if the candidate is a veteran.

Govt Code Verified

This field indicates if the government code has been verified as a legitimate code for that individual.

Photo Location

This field holds the name for the file containing the employee's picture, if applicable

Drivers License

This field displays the license number of the individual,if applicable.

---

Address tab#

Govt Code Origin

This field displays the employee/candidate’s country of origin.

Effective as of/Expires On

These fields define the dates during which the address is effective.

Change Reason

This field displays the ‘Change Reason’ code, which provides the rationale as to why information has been created or changed as of an effective date.

Tax Jurisdiction

This field displays the GEO code of residence tax jurisdiction and is used in the payroll process for taxation purposes.

Address 1

This field holds the employee’s home address (street, rural route or concession number).

Address 2

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

City/Town

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

State/Province

This is the standard abbreviation code of the state or province where the employee resides.

Country Name

This field displays the country where the employee resides.

Zip Code

This field will display the mailing code.

Mail Address 1

This field holds the employee’s mailing address (street or rural route or concession number).

Mail Address 2

This field shows the second line of employee’s mailing address, used for PO Box number or special delivery instructions.

Mailing City/Town

This field displays the city, district or township name used with the employee’s mailing address.

Mailing State

This field shows the standard abbreviation of the state or province used with the employee’s mailing address.

Mailing Country

This field displays the country for the employee’s mailing address.

Mailing Zip Code

This field will display the mailing code.

Phone Unlisted

This field indicates that the employee‘s home phone number is unlisted.

Phone #

This is the employee's home phone number.

Alt. Phone #

This is the employee's alternate phone number.

---

Personal Tab#

Cellular #

This field holds the individual's personal cellular or mobile phone number.

Fax #

This is the personal fax number for the employee.

Email

This is the personal email address for the employee.

Marital Status

This field shows the marital status of the employee. i.e. single, married etc.

Date of Marriage

This is the date employee was most recently married.

Number of Dependents

This field indicates the number of dependants this employee has.

Years of Education

This field displays the number of years of education this employee has.

Transportation

This is the method of transportation the employee uses to get to work.

Bonded Status

This field indicates if the employee is bonded.

Citizen Status

This field indicates the citizenship status of an employee.

Foreign ID

This field shows any foreign registration codes for an employee. For example - A Canadian Social Insurance Number for an American employee.

Country of Citizenship

This field indicates the employee's country of citizenship.

School

For U.S. installations only: This field indicates the school district in the residence where employee pays school taxes.

User Fields Tab#

User Field Value 1 - 10

This field is used for conversion. This value is applied against the user-defined field for each table which must have been previously defined in the P2K_AM_USER_FIELDS table.

---

Notes #

Click to create a new notes page