!!!Alias: PPCR Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Pc Rules !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[PPC_ID]|Number(10)|[ID]|Y|link to [P2K_PR_PAY_COMPONENTS] |[DEN_ID]|Number(10)|[ID]| |link to [P2K_CM_ENTITIES] |[DUN_ID]|Number(10)|[ID]| |link to [P2K_CM_UNITS] |[DGR_ID]|Number(10)|[ID]| |link to [P2K_CM_GROUPS] |[DTC_ID]|Number(10)|[ID]| |link to [P2K_CM_TIME_CODES] |[DGA_ID_CREDIT]|Number(10)|[ID]| |link to [P2K_CM_GL_ACCOUNTS] |[DGA_ID_DEBIT]|Number(10)|[ID]| |link to [P2K_CM_GL_ACCOUNTS] |[MUC_ID]|Number(10)|[ID]| |link to [P2K_AM_USER_CALCS] |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[GENERATE_DETAILS]|Varchar2(1)|[TOGGLE]| | |[ENTER_SUNDRY_LINES]|Varchar2(1)|[TOGGLE]| | |[ENTER_PAY_LINES]|Varchar2(1)|[TOGGLE]| | |[ENTER_DATE]|Varchar2(1)|[TOGGLE]| | |[ENTER_ACTION]|Varchar2(1)|[TOGGLE]| | |[ENTER_DESCRIPTION]|Varchar2(1)|[X_ENTER_DESCRIPTION]| | |[ENTER_PAY_POINT]|Varchar2(1)|[TOGGLE]| | |[ENTER_PAY_POINT_SEQUENCE]|Varchar2(1)|[TOGGLE]| | |[ENTER_POSITION]|Varchar2(1)|[TOGGLE]| | |[ENTER_JOB]|Varchar2(1)|[TOGGLE]| | |[ENTER_PREMIUMS]|Varchar2(1)|[TOGGLE]| | |[ENTER_TIME]|Varchar2(1)|[TOGGLE]| | |[ENTER_WAGE_RATE]|Varchar2(1)|[TOGGLE]| | |[ENTER_WAGE_RATE_BASIS]|Varchar2(1)|[TOGGLE]| | |[ENTER_USER_CALC]|Varchar2(1)|[TOGGLE]| | |[ENTER_WORK_GEO]|Varchar2(1)|[TOGGLE]| | |[DEFAULT_THE_JOB]|Varchar2(1)|[TOGGLE]| | |[DEFAULT_THE_POSITION]|Varchar2(1)|[TOGGLE]| | |[TIME_BASIS]|Varchar2(2)|[X_TIME_BASIS]| | |[PAY_POINT_TYPE]|Varchar2(2)|[X_PAY_POINT_TYPE]| | |[ASSIGNMENT_TYPE]|Varchar2(2)|[X_ASSIGN_TYPE]| | |[POSITIVE_DEDUCTION]|Varchar2(2)|[X_DEDN_POSITIVE_RULE]| | |[NEGATIVE_DEDUCTION]|Varchar2(2)|[X_DEDN_NEGATIVE_RULE]| | |[DEDUCTION_RECOVERY]|Varchar2(2)|[X_DEDN_RECOVERY_RULE]| | |[POSITIVE_ARREARS]|Varchar2(1)|[TOGGLE]| | |[NEGATIVE_ARREARS]|Varchar2(1)|[TOGGLE]| | |[SUMMARIZE_RETRO]|Varchar2(1)|[TOGGLE]| | |[RETRO_METHOD]|Varchar2(2)|[X_RETRO_METHOD]| | |[PPC_ID_RETRO]|Number(10)|[ID]| |link to [P2K_PR_PAY_COMPONENTS] |[MUC_ID_RETRO]|Number(10)|[ID]| |link to [P2K_AM_USER_CALCS] |[AP_VENDOR]|Varchar2(16)|[X_AP_VENDORS]| | |[GL_SUFFIX_TYPE_DR]|Varchar2(2)|[X_GL_SUFFIX_TYPE]| | |[GL_SUFFIX_TYPE_CR]|Varchar2(2)|[X_GL_SUFFIX_TYPE]| | |[SUNDRY_BY_ASSIGNMENT]|Varchar2(1)|[TOGGLE]| | |[PPC_ID_ARREARS]|Number(10)|[ID]| |link to [P2K_PR_PAY_COMPONENTS] User Fields: Allowed\\ Audit Logging: Allowed\\