This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

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.

Tables loaded: P2K_HR_PROPERTIES

Table Columns#

Column name	Data Type / Size	Mand.	Notes
ID	Number(10)		Used internally to define a unique identification for the record. This field would not be loaded.
PERSON_CODE	Varchar2(16)	Y	Validation: Must be a valid PERSON_CODE already defined on the P2K_HR_IDENTITIES table.
PROPERTY_TYPE	Varchar2(30)	Y	Validation: If provided, must be one of the fixed lexicon values from X_PROPERTY_TYPE
START_DATE	Date()	Y	Validation: Must be a valid date.
PROPERTY_CODE	Varchar2(16)	Y
END_DATE	Date()	Y	Validation: Must be a valid date, after the start date.
RENEWAL_DATE	Date()		Validation: Must be a valid date.
DESCRIPTION	Varchar2(50)
CREATE_DATE	Date()		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USER	Varchar2(30)		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATE	Date()		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USER	Varchar2(30)		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.