P 2 K_SA_EXPERIENCE_DETAILS
Back to current versionRestore this version

P2K_SA_EXPERIENCE_DETAILS

Alias: SEPD#

Unique Keys: _
Child Table:
_
Parent Table: _

Experience Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
SEP_IDNumber(10)IDYlink to P2K_SA_EXPERIENCES
EXPERIENCE_LAST_STEP_DATEDate()DATE
SWSS_IDNumber(10)ID link to P2K_SA_WAGE_SCALE_STEPS
EXPERIENCE_STATUSVarchar2(2)X_EXPERIENCE_STATUSY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EXPERIENCE_LAST_WORKED_DATEDate()DATE
EXPERIENCE_LAST_EVAL_DATEDate()DATE
ELIGIBLE_DAYSNumber(18)AMT12V6
ELIGIBLE_HOURSNumber(18)AMT12V6
ELIGIBLE_UNITSNumber(18)AMT12V6
PRE_ELIGIBLE_DAYSNumber(18)AMT12V6
PRE_ELIGIBLE_HOURSNumber(18)AMT12V6
PRE_ELIGIBLE_UNITSNumber(18)AMT12V6
WORKED_DAYSNumber(18)AMT12V6
WORKED_HOURSNumber(18)AMT12V6
WORKED_UNITSNumber(18)AMT12V6
ABSENT_DAYSNumber(18)AMT12V6
ABSENT_HOURSNumber(18)AMT12V6
ACCUMULATED_DAYSNumber(18)AMT12V6
ACCUMULATED_HOURSNumber(18)AMT12V6
ACCUMULATED_UNITSNumber(18)AMT12V6

User Fields: Allowed
Audit Logging: Allowed