P 2 K_PR_PC_RULES

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
SUNDRY_APPROVAL_REQUIREDVARCHAR2(1) TOGGLE

User Fields: Allowed
Audit Logging: 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