Alias: SWSD#

(P2K_SA_WAGE_STEP_DETAILS)

Unique Keys:
Child Table:
Parent Table: P2K_SA_WAGE_SCALE_STEPS
ERD: ERD-SA02


Wage Step Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
RATE_BASISVarchar2(2)X_RATE_BASISY
SCALE_RATENumber(18)AMT12V6Y
SWSS_IDNumber(10)IDYlink to P2K_SA_WAGE_SCALE_STEPS
CELL_NUMBERNumber(5)NUMBER5
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

Derived Fields#

Column Name
DRV_AMOUNT
DRV_DATE
DRV_NEW_DATE
DRV_PERCENT
DRV_ROUND_METHOD
DRV_ROUND_RULE
DRV_SCALE_BASE_DATE
DRV_STEP_CODE
DRV_STEP_INCREMENT
DRV_STEP_SEQ
DRV_TYPE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page