Alias: PPA#

(P2K_PR_PAYROLLS)

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


Payrolls

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYlink to P2K_CM_ENTITIES
PAYROLL_CODEVarchar2(16)CODEY
PBA_ID_CHECKNumber(10)IDYlink to P2K_PR_PAYROLL_BANK_ACCOUNTS
PCL_IDNumber(10)IDYlink to P2K_PR_PAY_CALENDARS
PPTS_IDNumber(10)IDYlink to P2K_PR_PAY_POINT_SETS
PBA_ID_DEPOSITNumber(10)ID link to P2K_PR_PAYROLL_BANK_ACCOUNTS
PEL_ID_EARNINGSNumber(10)ID link to P2K_PR_ELEMENTS
PEL_ID_DEDUCTIONSNumber(10)ID link to P2K_PR_ELEMENTS
PEL_ID_BENEFITSNumber(10)ID link to P2K_PR_ELEMENTS
PEL_ID_OTHERNumber(10)ID link to P2K_PR_ELEMENTS
PFR_IDNumber(10)ID link to P2K_PR_CHECK_FORM_RANGES
LEGISLATIONVarchar2(2)X_LEGISLATIONY
TAX_EXEMPT_POINTVarchar2(2)X_TAX_EXEMPT_POINTY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
MAXIMUM_GROSSNumber(18)AMT12V6
MAXIMUM_NETNumber(18)AMT12V6
MINIMUM_NETNumber(18)AMT12V6
ADDITIONAL_TAX_OPTIONVarchar2(2)X_ADDITIONAL_TAX_OPTION
MONTHLY_SUMMARIESVarchar2(1)TOGGLE
QUARTERLY_SUMMARIESVarchar2(1)TOGGLE
FISCAL_SUMMARIESVarchar2(1)TOGGLE
DETAILED_PAY_STUBVarchar2(1)X_DETAILED_PAY_STUB
ADP_TAX_COMPANYVarchar2(50)VARCHAR50
ADP_FILE_NUMBERNumber(10)NUMBER

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 jmyers.Top