INF_CV_PERSONNELACTIONS
Back to current versionRestore this version

Alias: IVSPA#

(INF_CV_PERSONNELACTIONS)
Reviews

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PA_NUMBERNumber(10)NUMBER10Y
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
PERSON_CODEVarchar2(16)CODEY
PA_STATUSVarchar2(30)VARCHAR30Y
CHANGE_CODEVarchar2(16)CODEY
PA_EFFECTIVE_DATEDate()DATEY
ASSIGNMENT_CODEVarchar2(16)CODEY
ASSIGNMENT_START_DATEDate()DATEY
REVIEW_NUMBERNumber(10)NUMBER10Y
PA_TYPE_CODEVarchar2(16)CODEY
APPROVEDVarchar2(4)VARCHAR4
DESCRIPTIONVarchar2(50)DESCRIPTION
UPDATE_FUTURE_RECORDSVarchar2(4)VARCHAR4
CASCADE_CHANGE_REASONVarchar2(4)VARCHAR4
TABLE_ALIASVarchar2(16)CODE
TABLE_NAMEVarchar2(30)VARCHAR30
COLUMN_NAMEVarchar2(30)VARCHAR30
PA_CHANGE_STATUSVarchar2(2)VARCHAR30
PA_TYPE_OF_VALUEVarchar2(2)DESCRIPTION
REFERENCE_IDNumber(10)NUMBER10
COLUMN_SEQUENCENumber(5)NUMBER5
PA_OLD_VALUEVarchar2(2000)VARCHAR2000
PA_NEW_VALUEVarchar2(2000)VARCHAR2000
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30