!!!Alias: PPLD (P2K_PR_PAY_LINE_DETAILS) Unique Keys: \\ Child Table: \\ Parent Table: \\ ERD: [ERD-PR55] \\ Pay Line Details !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[PPC_ID]|Number(10)|[ID]|Y|link to [P2K_PR_PAY_COMPONENTS] |[PPL_ID]|Number(10)|[ID]|Y|link to [P2K_PR_PAY_LINES] |[PEL_ID]|Number(10)|[ID]| |link to [P2K_PR_ELEMENTS] |[MVR_ID]|Number(10)|[ID]| |link to [P2K_AM_USER_VARIABLES] |[SPM_ID]|Number(10)|[ID]| |link to [P2K_SA_PREMIUMS] |[DSC_ID]|Number(10)|[ID]| |link to [P2K_CM_STATISTIC_COMPONENTS] |[PAY_LINE_DETAIL_STATUS]|Varchar2(2)|[X_PAY_LINE_DETAIL_STATUS]|Y| |[PC_ACTION]|Varchar2(1)|[X_PC_ACTION]|Y| |[PC_DETAIL_TYPE]|Varchar2(2)|[X_PC_DETAIL_TYPE]|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| |[PC_CALC_METHOD]|Varchar2(2)|[X_PC_CALC_METHOD]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[WAGE_RATE_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[RATE_BASIS]|Varchar2(2)|[X_RATE_BASIS]| | |[RATE_BASIS_OVERRIDE]|Varchar2(2)|[X_RATE_BASIS]| | |[AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[AMOUNT_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[AMOUNT_PROCESSED]|Number(18)|[AMT12V6|AMTnn]| | |[RETRO_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[USER_VARIABLE_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[DISTRIBUTION_CR_MASK]|Varchar2(50)|[DISTRIBUTION]| | |[PC_RATE_SOURCE]|Varchar2(2)|[X_PC_RATE_SOURCE]| | |[HIGHER_OF_RATE]|Varchar2(1)|[X_HIGHER_OF_RATE]| | |[DISTRIBUTION_DR_MASK]|Varchar2(50)|[DISTRIBUTION]| | |[AUDIT_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[REFERENCE_ID]|Number(10)|[NUMBER10|NUMBERn]| | |[JOURNALIZED_BY]|Varchar2(2)|[X_JOURNALIZED_BY]| | |[PWCC_ID]|Number(10)|[ID]| |link to [P2K_PR_WC_CLASSES] |[ENTERED_VALUE]|Number(18)|[AMT12V6|AMTnn]| | |[ENTERED_VALUE_SOURCE]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[TRANSACTION_POINTER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[REFERENCE_ID_HOD]|Number(10)|[NUMBER10|NUMBERn]| | |[REFERENCE_ID_REVERSAL]|Number(10)|[NUMBER10|NUMBERn]| | !![Derived Fields|DERIVED FIELDS] ||Column Name |[DRV_PAY_AUDIT_AMOUNT] |[DRV_PAY_AUDIT_DESCRIPTION] |[DRV_PAY_AUDIT_DESCRIPTION] User Fields: Not Allowed\\ Audit Logging: Not Allowed\\ ---- ![Notes|Edit:Internal.P2K_PR_PAY_LINE_DETAILS] [{InsertPage page='Internal.P2K_PR_PAY_LINE_DETAILS' default='Click to create a new notes page'}]