P 2 K_SA_SALARY_RANGE_DETAILS

Alias: SSRD#

(P2K_SA_SALARY_RANGE_DETAILS)

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


Salary Range Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
SSR_IDNumber(10)IDYlink to P2K_SA_SALARY_RANGES
EFFECTIVEDate()EFFECTIVEY
SMX_IDNumber(10)ID link to P2K_SA_SALARY_MATRICES
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
EXPIRYDate()EXPIRYY
RATE_BASISVarchar2(2)X_RATE_BASISY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
RANGE_MINIMUMNumber(18)AMT12V6
RANGE_MIDPOINTNumber(18)AMT12V6
RANGE_MAXIMUMNumber(18)AMT12V6
BASE_AMOUNTNumber(18)AMT12V6
DOLLAR_PER_POINTNumber(18)AMT12V6
MAXIMUM_PERCENTNumber(5)PERCENT
MINIMUM_PERCENTNumber(5)PERCENT
ACHV_MAXIMUM_PERCENTNUMBER(5,2) PERCENT
ACHV_TARGET_PERCENTNUMBER(5,2) PERCENT
ACHV_THRESHOLD_PERCENTNUMBER(5,2) PERCENT

Derived Fields#

Column Name
DRV_FIXED_VALUE
DRV_PERCENT
DRV_RANGE_MODIFY_ACTION
DRV_RANGE_MODIFY_TYPE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page