P 2 K_PR_PC_DETAILS

Alias: PPCD#

(P2K_PR_PC_DETAILS)

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


Pc Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PPCR_IDNumber(10)IDYlink to P2K_PR_PC_RULES
PPC_IDNumber(10)IDYlink to P2K_PR_PAY_COMPONENTS
PEL_IDNumber(10)ID link to P2K_PR_ELEMENTS
DSC_IDNumber(10)ID link to P2K_CM_STATISTIC_COMPONENTS
MVR_IDNumber(10)ID link to P2K_AM_USER_VARIABLES
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
PC_RATE_SOURCEVarchar2(2)X_PC_RATE_SOURCE
ENTER_RATEVarchar2(1)TOGGLE
ENTER_VALUEVarchar2(1)TOGGLE
ENTER_USER_VARIABLEVarchar2(1)TOGGLE
ENTER_ELEMENTVarchar2(1)TOGGLE
ENTER_DISTRIBUTIONVarchar2(1)TOGGLE
HIGHER_OF_RATEVarchar2(1)X_HIGHER_OF_RATE
HIGHEST_RATE_OF_DAYVarchar2(2)X_HIGHEST_RATE_OF_DAY
CUSTOM_RATE_LOGICVarchar2(2)X_CUSTOM_RATE_LOGIC
SALARY_RATE_METHODVarchar2(2)X_SALARY_RATE_METHOD

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page