P 2 K_SA_PREMIUM_USAGES
Back to current versionRestore this version

Alias: SPMU#

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

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

User Fields: Allowed
Audit Logging: Allowed