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(30)
PA_TYPE_OF_VALUEVarchar2(50)
REFERENCE_IDNumber(10)
COLUMN_SEQUENCENumber(5)
PA_OLD_VALUEVarchar2(2000)
PA_NEW_VALUEVarchar2(2000)