P2K_SA_EXPERIENCE_DETAILS !!!Alias: SEPD Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Experience Details !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[SEP_ID]|Number(10)|[ID]|Y|link to [P2K_SA_EXPERIENCES] |[EXPERIENCE_LAST_STEP_DATE]|Date()|[DATE]| | |[SWSS_ID]|Number(10)|[ID]| |link to [P2K_SA_WAGE_SCALE_STEPS] |[EXPERIENCE_STATUS]|Varchar2(2)|[X_EXPERIENCE_STATUS]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[EXPERIENCE_LAST_WORKED_DATE]|Date()|[DATE]| | |[EXPERIENCE_LAST_EVAL_DATE]|Date()|[DATE]| | |[ELIGIBLE_DAYS]|Number(18)|[AMT12V6|AMTnn]| | |[ELIGIBLE_HOURS]|Number(18)|[AMT12V6|AMTnn]| | |[ELIGIBLE_UNITS]|Number(18)|[AMT12V6|AMTnn]| | |[PRE_ELIGIBLE_DAYS]|Number(18)|[AMT12V6|AMTnn]| | |[PRE_ELIGIBLE_HOURS]|Number(18)|[AMT12V6|AMTnn]| | |[PRE_ELIGIBLE_UNITS]|Number(18)|[AMT12V6|AMTnn]| | |[WORKED_DAYS]|Number(18)|[AMT12V6|AMTnn]| | |[WORKED_HOURS]|Number(18)|[AMT12V6|AMTnn]| | |[WORKED_UNITS]|Number(18)|[AMT12V6|AMTnn]| | |[ABSENT_DAYS]|Number(18)|[AMT12V6|AMTnn]| | |[ABSENT_HOURS]|Number(18)|[AMT12V6|AMTnn]| | |[ACCUMULATED_DAYS]|Number(18)|[AMT12V6|AMTnn]| | |[ACCUMULATED_HOURS]|Number(18)|[AMT12V6|AMTnn]| | |[ACCUMULATED_UNITS]|Number(18)|[AMT12V6|AMTnn]| | User Fields: Allowed\\ Audit Logging: Allowed\\