Alias: IVSPA#

(INF_CV_PERSONNELACTIONS)
Reviews

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODEVarchar2(16)Y
PA_NUMBERNumber(10)Y
EMPLOYMENT_TYPEVarchar2(30)
HIRE_DATEDate()
PERSON_CODEVarchar2(16)Y
PA_STATUSVarchar2(30)Y
CHANGE_CODEVarchar2(16)Y
PA_EFFECTIVE_DATEDate()Y
ASSIGNMENT_CODEVarchar2(16)Y
ASSIGNMENT_START_DATEDate()Y
REVIEW_NUMBERNumber(10)Y
PA_TYPE_CODEVarchar2(16)Y
APPROVEDVarchar2(4)
DESCRIPTIONVarchar2(50)
UPDATE_FUTURE_RECORDSVarchar2(4)
CASCADE_CHANGE_REASONVarchar2(4)
TABLE_ALIASVarchar2(16)
TABLE_NAMEVarchar2(30)
COLUMN_NAMEVarchar2(30)
PA_CHANGE_STATUSVarchar2(2)
PA_TYPE_OF_VALUEVarchar2(2)
REFERENCE_IDNumber(10)
COLUMN_SEQUENCENumber(5)
PA_OLD_VALUEVarchar2(2000)
PA_NEW_VALUEVarchar2(2000)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.