Alias: IVEPS#

The INF_CV_PERSONALS table is used to import employee identity and personal information into the software data structures. Basic employee information is created through Identity and Personal tables.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
PERSON_CODEVarchar2(16)CODEY
USER_NAMEVarchar2(30)VARCHAR30
GOVERNMENT_CODEVarchar2(16)CODE
FIRST_NAMEVarchar2(50)VARCHAR50Y
LAST_NAMEVarchar2(50)VARCHAR50Y
BIRTH_DATEDate()DATE
GENDERVarchar2(30)VARCHAR30
LANGUAGE_CODEVarchar2(30)VARCHAR30
ETHNICVarchar2(30)VARCHAR30
MIDDLE_NAMEVarchar2(50)VARCHAR50
SALUTATIONVarchar2(30)VARCHAR30
RANKVarchar2(30)VARCHAR30
BIRTHPLACEVarchar2(50)VARCHAR50
CHALLENGEDVarchar2(30)VARCHAR30
VETERAN_STATUSVarchar2(30)VARCHAR30
GOVT_CODE_VERIFIEDVarchar2(4)VARCHAR4
PHOTO_LOCATIONVarchar2(50)VARCHAR50
DRIVERS_LICENSEVarchar2(30)LICENSE
ALT_LANGUAGE_CODEVarchar2(30)VARCHAR30
GOVT_CODE_ORIGINVarchar2(30)VARCHAR30
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
GEO_CODEVarchar2(16)CODE
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
STATE_PROVINCE_CODEVarchar2(16)CODE
COUNTRY_CODEVarchar2(16)CODE
ZIP_POSTALVarchar2(16)POSTAL CODE
MAIL_ADDRESS_LINE_1Varchar2(50)ADDRESS
MAIL_ADDRESS_LINE_2Varchar2(50)ADDRESS
MAIL_LOCALITYVarchar2(50)ADDRESS
MAIL_STATE_PROVINCE_CODEVarchar2(16)CODE
MAIL_COUNTRY_CODEVarchar2(16)CODE
MAIL_ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_UNLISTEDVarchar2(4)VARCHAR4
PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
CELLULAR_NUMBERVarchar2(20)TELEPHONE
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
MARITAL_STATUSVarchar2(30)VARCHAR30
MARRIED_DATEDate()DATE
NUMBER_DEPENDENTSNumber(5)NUMBER5
YEARS_EDUCATIONNumber(5)NUMBER5
TRANSPORTATIONVarchar2(30)VARCHAR30
BONDED_STATUSVarchar2(30)VARCHAR30
CITIZEN_STATUSVarchar2(30)VARCHAR30
FOREIGN_CODEVarchar2(16)CODE
CITIZENSHIPVarchar2(16)CODE
SCHOOL_DISTRICT_CODEVarchar2(16)CODE
USER_FIELD_VALUE_01Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_02Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_03Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_04Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_05Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_06Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_07Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_08Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_09Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_10Varchar2(2000)VARCHAR2000
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top