IVEPS
Back to current versionRestore this version

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.

ID
This field uniquely identifies the personal record within the data base.
RANK:
BIRTHPLACE:
CHALLENGED:
VETERAN_STATUS:
GOVT_CODE_VERIFIED:
PHOTO_LOCATION:
DRIVERS_LICENSE:
ALT_LANGUAGE_CODE:
GOVT_CODE_ORIGIN:
EFFECTIVE:
EXPIRY:
CHANGE_CODE:
GEO_CODE:
ADDRESS_LINE_1:
ADDRESS_LINE_2:
LOCALITY:
STATE_PROVINCE_CODE:
COUNTRY_CODE:
ZIP_POSTAL:
MAIL_ADDRESS_LINE_1:
MAIL_ADDRESS_LINE_2:
MAIL_LOCALITY:
MAIL_STATE_PROVINCE_CODE:
MAIL_COUNTRY_CODE:
MAIL_ZIP_POSTAL:
PHONE_UNLISTED:
PHONE_NUMBER:
ALT_PHONE_NUMBER:
CELLULAR_NUMBER:
FAX_NUMBER:
EMAIL_ADDRESS:
MARITAL_STATUS:
MARRIED_DATE:
NUMBER_DEPENDENTS:
YEARS_EDUCATION:
TRANSPORTATION:
BONDED_STATUS:
CITIZEN_STATUS:
FOREIGN_CODE:
CITIZENSHIP:
SCHOOL_DISTRICT_CODE:
USER_FIELD_VALUE_01Varchar2(2000) Looking for EPS01 defined on IMUF
USER_FIELD_VALUE_02Varchar2(2000) Looking for EPS02 defined on IMUF
USER_FIELD_VALUE_03Varchar2(2000) Looking for EPS03 defined on IMUF
USER_FIELD_VALUE_04Varchar2(2000) Looking for EPS04 defined on IMUF
USER_FIELD_VALUE_05Varchar2(2000) Looking for EPS05 defined on IMUF
USER_FIELD_VALUE_06Varchar2(2000) Looking for EPS06 defined on IMUF
USER_FIELD_VALUE_07Varchar2(2000) Looking for EPS07 defined on IMUF
USER_FIELD_VALUE_08Varchar2(2000) Looking for EPS08 defined on IMUF
USER_FIELD_VALUE_09Varchar2(2000) Looking for EPS09 defined on IMUF
USER_FIELD_VALUE_10Varchar2(2000) Looking for EPS10 defined on IMUF