[{TableOfContents }] !!!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|ID]:This field uniquely identifies the personal record within the data base. ;[Person Code|PERSON_CODE]:This field identifies the person associated with the personal record. ;[User|USER_NAME]:This field identifies the user associated with the personal record. ;[Gov't Code|GOVERNMENT_CODE]:This field identifies the person's government identification number (SSN/SIN). ;[First Name|FIRST_NAME]/[Last Name|LAST_NAME]:This field provides person's name. ;[Date of Birth|BIRTH_DATE]:The person's date of birth is provided in this field. ;[Gender|GENDER]:The person's gender is displayed in this field. ;[Language|LANGUAGE_CODE]:The person's primary language is identified in this field. ;[Ethnic|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|MIDDLE_NAME]:This field identifies the individual's middle name, if applicable. ;[Salutation|SALUTATION]:This field identifies the title of the individual. ;[Rank|RANK]:This field provides the individual's name extension. (i.e. JR., SR., II) ;[Birthplace|BIRTHPLACE]:The person's place of birth is displayed in this field. ;[Challenged|CHALLENGED]:This field indicates if the individual is physically challenged. ;[Veteran Status|VETERAN_STATUS]:This field indicates if the candidate is a veteran. ;[Govt Code Verified|GOVT_CODE_VERIFIED]:This field indicates if the government code has been verified as a legitimate code for that individual. ;[Photo Location|PHOTO_LOCATION]:This field holds the name for the file containing the employee's picture, if applicable ;[Drivers License|DRIVERS_LICENSE]:This field displays the license number of the individual,if applicable. \\ ---- !!Address tab ;[Govt Code Origin|GOVT_CODE_ORIGIN]:This field displays the employee/candidate’s country of origin. ;[Effective as of|EFFECTIVE]/[Expires On|EXPIRY]:These fields define the dates during which the address is effective. ;[Change Reason|CHANGE_CODE]: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|GEO_CODE]:This field displays the GEO code of residence tax jurisdiction and is used in the payroll process for taxation purposes. ;[Address 1|ADDRESS_LINE_1]:This field holds the employee’s home address (street, rural route or concession number). ;[Address 2|ADDRESS_LINE_2]:This is the second line of home address, used for PO Box number or special delivery instructions. ;[City/Town|LOCALITY]:Locality refers to the city, district or township name of residence. ;[State/Province|STATE_PROVINCE_CODE]:This is the standard abbreviation code of the state or province where the employee resides. ;[Country Name|COUNTRY_CODE]:This field displays the country where the employee resides. ;[Zip Code|ZIP_POSTAL]:This field will display the mailing code. ;[Mail Address 1|MAIL_ADDRESS_LINE_1]:This field holds the employee’s mailing address (street or rural route or concession number). ;[Mail Address 2|MAIL_ADDRESS_LINE_2]:This field shows the second line of employee’s mailing address, used for PO Box number or special delivery instructions. ;[Mailing City/Town|MAIL_LOCALITY]:This field displays the city, district or township name used with the employee’s mailing address. ;[Mailing State|MAIL_STATE_PROVINCE_CODE]:This field shows the standard abbreviation of the state or province used with the employee’s mailing address. ;[Mailing Country|MAIL_COUNTRY_CODE]:This field displays the country for the employee’s mailing address. ;[Mailing Zip Code|MAIL_ZIP_POSTAL]:This field will display the mailing code. ;[Phone Unlisted|PHONE_UNLISTED]:This field indicates that the employee‘s home phone number is unlisted. ;[Phone #|PHONE_NUMBER]:This is the employee's home phone number. ;[Alt. Phone #|ALT_PHONE_NUMBER]:This is the employee's alternate phone number. \\ ---- !!Personal Tab ;[Cellular #|CELLULAR_NUMBER]:This field holds the individual's personal cellular or mobile phone number. ;[Fax #|FAX_NUMBER]:This is the personal fax number for the employee. ;[Email|EMAIL_ADDRESS(Field)]:This is the personal email address for the employee. ;[Marital Status|MARITAL_STATUS]:This field shows the marital status of the employee. i.e. single, married etc. ;[Date of Marriage|MARRIED_DATE]:This is the date employee was most recently married. ;[Number of Dependents|NUMBER_DEPENDENTS]:This field indicates the number of dependants this employee has. ;[Years of Education|YEARS_EDUCATION]:This field displays the number of years of education this employee has. ;[Transportation|TRANSPORTATION]:This is the method of transportation the employee uses to get to work. ;[Bonded Status|BONDED_STATUS]:This field indicates if the employee is bonded. ;[Citizen Status|CITIZEN_STATUS]:This field indicates the citizenship status of an employee. ;[Foreign ID|FOREIGN_CODE]:This field shows any foreign registration codes for an employee. For example - A Canadian Social Insurance Number for an American employee. ;[Country of Citizenship|CITIZENSHIP]:This field indicates the employee's country of citizenship. ;[School|SCHOOL_DISTRICT_CODE]: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|USER_FIELD_VALUE_nn]: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|Edit:Internal.IVEPS] [{InsertPage page='Internal.IVEPS' default='Click to create a new notes page'}]