Alias: PPCR#

(P2K_PR_PC_RULES)

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


Pc Rules

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PPC_IDNumber(10)IDYlink to P2K_PR_PAY_COMPONENTS
DEN_IDNumber(10)ID link to P2K_CM_ENTITIES
DUN_IDNumber(10)ID link to P2K_CM_UNITS
DGR_IDNumber(10)ID link to P2K_CM_GROUPS
DTC_IDNumber(10)ID link to P2K_CM_TIME_CODES
DGA_ID_CREDITNumber(10)ID link to P2K_CM_GL_ACCOUNTS
DGA_ID_DEBITNumber(10)ID link to P2K_CM_GL_ACCOUNTS
MUC_IDNumber(10)ID link to P2K_AM_USER_CALCS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
GENERATE_DETAILSVarchar2(1)TOGGLE
ENTER_SUNDRY_LINESVarchar2(1)TOGGLE
ENTER_PAY_LINESVarchar2(1)TOGGLE
ENTER_DATEVarchar2(1)TOGGLE
ENTER_ACTIONVarchar2(1)TOGGLE
ENTER_DESCRIPTIONVarchar2(1)X_ENTER_DESCRIPTION
ENTER_PAY_POINTVarchar2(1)TOGGLE
ENTER_PAY_POINT_SEQUENCEVarchar2(1)TOGGLE
ENTER_POSITIONVarchar2(1)TOGGLE
ENTER_JOBVarchar2(1)TOGGLE
ENTER_PREMIUMSVarchar2(1)TOGGLE
ENTER_TIMEVarchar2(1)TOGGLE
ENTER_WAGE_RATEVarchar2(1)TOGGLE
ENTER_WAGE_RATE_BASISVarchar2(1)TOGGLE
ENTER_USER_CALCVarchar2(1)TOGGLE
ENTER_WORK_GEOVarchar2(1)TOGGLE
DEFAULT_THE_JOBVarchar2(1)TOGGLE
DEFAULT_THE_POSITIONVarchar2(1)TOGGLE
TIME_BASISVarchar2(2)X_TIME_BASIS
PAY_POINT_TYPEVarchar2(2)X_PAY_POINT_TYPE
ASSIGNMENT_TYPEVarchar2(2)X_ASSIGN_TYPE
POSITIVE_DEDUCTIONVarchar2(2)X_DEDN_POSITIVE_RULE
NEGATIVE_DEDUCTIONVarchar2(2)X_DEDN_NEGATIVE_RULE
DEDUCTION_RECOVERYVarchar2(2)X_DEDN_RECOVERY_RULE
POSITIVE_ARREARSVarchar2(1)TOGGLE
NEGATIVE_ARREARSVarchar2(1)TOGGLE
SUMMARIZE_RETROVarchar2(1)TOGGLE
RETRO_METHODVarchar2(2)X_RETRO_METHOD
PPC_ID_RETRONumber(10)ID link to P2K_PR_PAY_COMPONENTS
MUC_ID_RETRONumber(10)ID link to P2K_AM_USER_CALCS
AP_VENDORVarchar2(16)X_AP_VENDORS
GL_SUFFIX_TYPE_DRVarchar2(2)X_GL_SUFFIX_TYPE
GL_SUFFIX_TYPE_CRVarchar2(2)X_GL_SUFFIX_TYPE
SUNDRY_BY_ASSIGNMENTVarchar2(1)TOGGLE
PPC_ID_ARREARSNumber(10)ID link to P2K_PR_PAY_COMPONENTS

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top