!!!Alias: IVSPA (INF_CV_PERSONNELACTIONS) \\ Reviews !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[ENTITY_CODE]|Varchar2(16)|[CODE]|Y| |[PA_NUMBER]|Number(10)|[NUMBER10|NUMBERn]|Y| |[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[HIRE_DATE]|Date()|[DATE]| | |[PERSON_CODE]|Varchar2(16)|[CODE]|Y| |[PA_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_CODE]|Varchar2(16)|[CODE]|Y| |[PA_EFFECTIVE_DATE]|Date()|[DATE]|Y| |[ASSIGNMENT_CODE]|Varchar2(16)|[CODE]|Y| |[ASSIGNMENT_START_DATE]|Date()|[DATE]|Y| |[REVIEW_NUMBER]|Number(10)|[NUMBER10|NUMBERn]|Y| |[PA_TYPE_CODE]|Varchar2(16)|[CODE]|Y| |[APPROVED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[UPDATE_FUTURE_RECORDS]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[CASCADE_CHANGE_REASON]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[TABLE_ALIAS]|Varchar2(16)|[CODE]| | |[TABLE_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[COLUMN_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PA_CHANGE_STATUS]|Varchar2(2)|[VARCHAR30|VARCHARnn]| | |[PA_TYPE_OF_VALUE]|Varchar2(2)|[DESCRIPTION]| | |[REFERENCE_ID]|Number(10)|[NUMBER10|NUMBERn]| | |[COLUMN_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[PA_OLD_VALUE]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[PA_NEW_VALUE]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |