INF_CV_PROPERTIES
Back to current versionRestore this version

Alias: IVEPP#

The INF_CV_PROPERTIES table is used to import property information into the software data structures. The property table allows users to define company equipment, cards, and any other component that are given to or issued to employees.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
PERSON_CODEVarchar2(16)CODEY
PROPERTY_TYPEVarchar2(30)VARCHAR30Y
START_DATEDate()DATEY
PROPERTY_CODEVarchar2(16)CODEY
END_DATEDate()DATEY
RENEWAL_DATEDate()DATE
DESCRIPTIONVarchar2(50)DESCRIPTION
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30