!!!Alias: SPMD Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Premium Details !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[SPM_ID]|Number(10)|[ID]|Y|link to [P2K_SA_PREMIUMS] |[EFFECTIVE]|Date()|[EFFECTIVE]|Y| |[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS] |[PFQ_ID]|Number(10)|[ID]| |link to [P2K_PR_FREQUENCIES] |[PPC_ID_DOLLARS]|Number(10)|[ID]| |link to [P2K_PR_PAY_COMPONENTS] |[PPC_ID_TIME]|Number(10)|[ID]| |link to [P2K_PR_PAY_COMPONENTS] |[EXPIRY]|Date()|[EXPIRY]|Y| |[PREMIUM_CALC_RULE]|Varchar2(2)|[X_PREMIUM_CALC_RULE]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[RATE_BASIS]|Varchar2(2)|[X_RATE_BASIS]| | |[PREMIUM_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[PREMIUM_PRORATED]|Varchar2(1)|[TOGGLE]| | |[PAY_POINT_TYPE]|Varchar2(2)|[X_PAY_POINT_TYPE]| | |[PAY_POINT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[REPLACEMENT_OPTION]|Varchar2(1)|[TOGGLE]| | |[HIGHEST_RATE_OF_DAY]|Varchar2(1)|[TOGGLE]| | |[PREMIUM_WAGE_SOURCE]|Varchar2(2)|[X_PREMIUM_WAGE_SOURCE]| | |[MVR_ID]|Number(10)|[ID]| |link to [P2K_AM_USER_VARIABLES] |[CUSTOM_PREMIUM_LOGIC]|Varchar2(2)|[X_CUSTOM_PREMIUM_LOGIC]| | User Fields: Allowed\\ Audit Logging: Allowed\\