P 2 K_PR_PAY_LINE_DETAILS
Back to current versionRestore this version

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

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation