Table of Contents
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.
Tab 1#
- 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.
Tab 3#
- Cellular #
- This field holds the individual's personal cellular or mobile phone number.
- Fax #
- This is the personal fax number for the employee.
- 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 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.
