P 2 K_SA_PREMIUM_USAGES

Alias: SPMU#

(P2K_SA_PREMIUM_USAGES)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-SA03


Premium Usages

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
SPM_IDNumber(10)IDYlink to P2K_SA_PREMIUMS
DPD_IDNumber(10)ID link to P2K_CM_POSITION_DETAILS
DJD_IDNumber(10)ID link to P2K_CM_JOB_DETAILS
EASD_IDNumber(10)ID link to P2K_HR_ASSIGNMENT_DETAILS
PSL_IDNumber(10)ID link to P2K_PR_SUNDRY_LINES
PPL_IDNumber(10)ID link to P2K_PR_PAY_LINES
PTR_IDNumber(10)ID link to P2K_PR_PAY_TRANSACTIONS
TTE_IDNumber(10)ID link to P2K_TS_TIME_ENTRIES
TWSD_IDNumber(10)ID link to P2K_TS_WORK_STATION_DETAILS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
RATE_BASISVarchar2(2)X_RATE_BASIS
PREMIUM_RATENumber(18)AMT12V6
PTSE_IDNumber(10)ID link to P2K_PR_TIME_SHEET_ENTRIES
TTX_IDNumber(10)ID link to P2K_TS_TIME_EXCEPTIONS

Derived Fields#

Column Name
DRV_ANNUAL_PREM
DRV_BI_WEEKLY_PREM
DRV_DAILY_PREM
DRV_DERIVED_PROMPT
DRV_HOURLY_PREM
DRV_MONTHLY_PREM
DRV_SEMI_MONTHLY_PREM
DRV_SPMD_PREMIUM_RATE
DRV_SPMD_RATE_BASIS
DRV_WEEKLY_PREM

User Fields: Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page