INF_CV_PERSONALS
Back to current versionRestore this version

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation