Wiki: P 2 K_PR

Alias: PPA#

(P2K_PR_PAYROLLS)

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

Payrolls

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DEN_ID	Number(10)	ID	Y	link to P2K_CM_ENTITIES
PAYROLL_CODE	Varchar2(16)	CODE	Y
PBA_ID_CHECK	Number(10)	ID	Y	link to P2K_PR_PAYROLL_BANK_ACCOUNTS
PCL_ID	Number(10)	ID	Y	link to P2K_PR_PAY_CALENDARS
PPTS_ID	Number(10)	ID	Y	link to P2K_PR_PAY_POINT_SETS
PBA_ID_DEPOSIT	Number(10)	ID		link to P2K_PR_PAYROLL_BANK_ACCOUNTS
PEL_ID_EARNINGS	Number(10)	ID		link to P2K_PR_ELEMENTS
PEL_ID_DEDUCTIONS	Number(10)	ID		link to P2K_PR_ELEMENTS
PEL_ID_BENEFITS	Number(10)	ID		link to P2K_PR_ELEMENTS
PEL_ID_OTHER	Number(10)	ID		link to P2K_PR_ELEMENTS
PFR_ID	Number(10)	ID		link to P2K_PR_CHECK_FORM_RANGES
LEGISLATION	Varchar2(2)	X_LEGISLATION	Y
TAX_EXEMPT_POINT	Varchar2(2)	X_TAX_EXEMPT_POINT	Y
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
DESCRIPTION	Varchar2(50)	DESCRIPTION
MAXIMUM_GROSS	Number(18)	AMT12V6
MAXIMUM_NET	Number(18)	AMT12V6
MINIMUM_NET	Number(18)	AMT12V6
ADDITIONAL_TAX_OPTION	Varchar2(2)	X_ADDITIONAL_TAX_OPTION
MONTHLY_SUMMARIES	Varchar2(1)	TOGGLE
QUARTERLY_SUMMARIES	Varchar2(1)	TOGGLE
FISCAL_SUMMARIES	Varchar2(1)	TOGGLE
DETAILED_PAY_STUB	Varchar2(1)	X_DETAILED_PAY_STUB
ADP_TAX_COMPANY	Varchar2(50)	VARCHAR50
ADP_FILE_NUMBER	Number(10)	VARCHAR50

User Fields: Allowed
Audit Logging: Allowed

Click to create a new notes page