Alias: PPCR#

(P2K_PR_PC_RULES)

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

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	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	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
SUNDRY_APPROVAL_REQUIRED	VARCHAR2(1)	TOGGLE

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page