P 2 K_PR_PAYROLLS
Back to current versionRestore this version

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

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