P 2 K_PR_PAY_LINE_DETAILS

Alias: PPLD#

(P2K_PR_PAY_LINE_DETAILS)

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


Pay Line Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PPC_IDNumber(10)IDYlink to P2K_PR_PAY_COMPONENTS
PPL_IDNumber(10)IDYlink to P2K_PR_PAY_LINES
PEL_IDNumber(10)ID link to P2K_PR_ELEMENTS
MVR_IDNumber(10)ID link to P2K_AM_USER_VARIABLES
SPM_IDNumber(10)ID link to P2K_SA_PREMIUMS
DSC_IDNumber(10)ID link to P2K_CM_STATISTIC_COMPONENTS
PAY_LINE_DETAIL_STATUSVarchar2(2)X_PAY_LINE_DETAIL_STATUSY
PC_ACTIONVarchar2(1)X_PC_ACTIONY
PC_DETAIL_TYPEVarchar2(2)X_PC_DETAIL_TYPEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PC_CALC_METHODVarchar2(2)X_PC_CALC_METHOD
DESCRIPTIONVarchar2(50)DESCRIPTION
WAGE_RATENumber(18)AMT12V6
WAGE_RATE_OVERRIDENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
RATE_BASIS_OVERRIDEVarchar2(2)X_RATE_BASIS
AMOUNTNumber(18)AMT12V6
AMOUNT_OVERRIDENumber(18)AMT12V6
AMOUNT_PROCESSEDNumber(18)AMT12V6
RETRO_AMOUNTNumber(18)AMT12V6
USER_VARIABLE_OVERRIDENumber(18)AMT12V6
DISTRIBUTION_CR_MASKVarchar2(50)DISTRIBUTION
PC_RATE_SOURCEVarchar2(2)X_PC_RATE_SOURCE
HIGHER_OF_RATEVarchar2(1)X_HIGHER_OF_RATE
DISTRIBUTION_DR_MASKVarchar2(50)DISTRIBUTION
AUDIT_TEXTVarchar2(4000)VARCHAR4000
REFERENCE_IDNumber(10)NUMBER10
JOURNALIZED_BYVarchar2(2)X_JOURNALIZED_BY
PWCC_IDNumber(10)ID link to P2K_PR_WC_CLASSES
ENTERED_VALUENumber(18)AMT12V6
ENTERED_VALUE_SOURCEVarchar2(50)VARCHAR50
TRANSACTION_POINTERVarchar2(30)VARCHAR30
REFERENCE_ID_HODNumber(10)NUMBER10
REFERENCE_ID_REVERSALNumber(10)NUMBER10
VARIABLE_RATENUMBER(18,6) AMT12V6
PREMIUM_AUDIT_TEXTVARCHAR2(4000) VARCHAR4000
VARIABLE_RATE_AUDIT_TEXTVARCHAR2(4000) VARCHAR4000
SALARY_RATE_METHODVARCHAR2(2) X_SALARY_RATE_METHOD

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 #

Click to create a new notes page