Alias: PCTU#

(P2K_PR_US_PAY_CATEGORIES)

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


Us Pay Categories

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PCT_IDNumber(10)IDYlink to P2K_PR_PAY_CATEGORIES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
UFED_EIC_METHODVarchar2(2)X_UFED_EIC_METHOD
US Tax Withholding Options (UFED_TAX_METHOD)Varchar2(2)X_UFED_TAX_METHOD
UFED_SUPPL_TAX_METHODVarchar2(2)X_UFED_SUPPL_METHOD
UFED_FICA_METHODVarchar2(2)X_UFED_FICA_METHOD
UFED_MEDICARE_METHODVarchar2(2)X_UFED_MEDICARE_METHOD
UFED_FUTA_METHODVarchar2(2)X_UFED_FUTA_METHOD
UST_TAX_METHODVarchar2(2)X_UST_TAX_METHOD
UST_SUPPL_TAX_METHODVarchar2(2)X_UST_SUPPL_METHOD
UST_ALT_TAX_METHODVarchar2(2)X_UST_ALT_TAX_METHOD
UST_SUI_ER_METHODVarchar2(2)X_UST_SUI_METHOD
UST_SUI_EE_METHODVarchar2(2)X_UST_SUI_METHOD
UST_SDI_ER_METHODVarchar2(2)X_UST_SDI_METHOD
UST_SDI_EE_METHODVarchar2(2)X_UST_SDI_METHOD
UST_WCB_METHODVarchar2(2)X_UST_WCB_METHOD
ULOC_COUNTY_TAX_METHODVarchar2(2)X_ULOC_COUNTY_TAX_METHOD
ULOC_CITY_TAX_METHODVarchar2(2)X_ULOC_CITY_TAX_METHOD
ULOC_SCHOOL_TAX_METHODVarchar2(2)X_ULOC_SCHOOL_TAX_METHOD
ULOC_HEAD_TAX_METHODVarchar2(2)X_ULOC_HEAD_TAX_METHOD
URR_TIER1_SOC_METHODVarchar2(2)X_URR_TIER1_SOC_METHOD
URR_TIER1_MED_METHODVarchar2(2)X_URR_TIER1_MED_METHOD
URR_TIER2_RET_METHODVarchar2(2)X_URR_TIER2_RET_METHOD
URR_RUIA_METHODVarchar2(2)X_URR_RUIA_METHOD
URR_RURT_METHODVarchar2(2)X_URR_RURT_METHOD
URR_SUPPL_METHODVarchar2(2)X_URR_SUPPL_METHOD

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page