P 2 K_PR_US_PAY_RULES
Back to current versionRestore this version

Alias: PPRU#

(P2K_PR_US_PAY_RULES)

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


Us Pay Rules

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PTAU_IDNumber(10)IDYlink to P2K_PR_US_TAX_AREAS
EFFECTIVEDate()EFFECTIVEY
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
EXPIRYDate()EXPIRYY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
UFED_FILING_STATUSVarchar2(2)X_UFED_FILING_STATUS
UFED_NUM_EXEMPTIONSNumber(5)NUMBER5
UFED_ANN_EXEMPTIONNumber(18)AMT12V6
UFED_ADD_EXEMPTIONNumber(18)AMT12V6
UFED_ADD_TAX_PER_PERIODNumber(18)AMT12V6
UFED_TAX_AMOUNTNumber(18)AMT12V6
UFED_TAX_PERCENTNumber(5)PERCENT
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
UFED_EIC_METHODVarchar2(2)X_UFED_EIC_METHOD
UST_RECIPROCATIONVarchar2(2)X_UST_RECIPROCATION
UST_FILING_STATUSVarchar2(4)X_UST_FILING_STATUS
UST_NUM_EXEMPTION_1Number(5)NUMBER5
UST_NUM_EXEMPTION_2Number(5)NUMBER5
UST_ANN_EXEMPTIONNumber(18)AMT12V6
UST_ADD_EXEMPTIONNumber(18)AMT12V6
UST_ADD_TAX_PER_PERIODNumber(18)AMT12V6
UST_ADD_TAX_RESVarchar2(2)X_UST_ADD_TAX_RES
UST_ADD_TAX_WORKVarchar2(2)X_UST_ADD_TAX_WORK
UST_TAX_AMOUNTNumber(18)AMT12V6
UST_TAX_PERCENTNumber(5)PERCENT
UST_TAX_METHODVarchar2(2)X_UST_TAX_METHOD
UST_SUPPL_TAX_METHODVarchar2(2)X_UST_SUPPL_METHOD
UST_ALT_TAX_METHODVarchar2(4)X_UST_ALT_TAX_METHOD
UST_SUI_EE_METHODVarchar2(2)X_UST_SUI_METHOD
UST_SUI_ER_METHODVarchar2(2)X_UST_SUI_METHOD
UST_SDI_EE_METHODVarchar2(2)X_UST_SDI_METHOD
UST_SDI_ER_METHODVarchar2(2)X_UST_SDI_METHOD
UST_WCB_METHODVarchar2(2)X_UST_WCB_METHOD
ULOC_RECIPROCATIONVarchar2(2)X_ULOC_RECIPROCATION
ULOC_FILING_STATUSVarchar2(4)X_ULOC_FILING_STATUS
ULOC_NUM_EXEMPTIONSNumber(5)NUMBER5
ULOC_ANN_EXEMPTIONNumber(18)AMT12V6
ULOC_EXEMPTION_PERCENTNumber(5)PERCENT
ULOC_ADD_TAX_PER_PERIODNumber(18)AMT12V6
ULOC_ADD_TAX_WORKVarchar2(2)X_ULOC_ADD_TAX_WORK
ULOC_ADD_TAX_RESVarchar2(2)X_ULOC_ADD_TAX_RES
ULOC_TAX_AMOUNTNumber(18)AMT12V6
ULOC_TAX_PERCENT_1Number(5)PERCENT
ULOC_TAX_PERCENT_2Number(5)PERCENT
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_SCHOOL_TAX_AMOUNTNumber(18)AMT12V6
ULOC_SCHOOL_TAX_PERCENTNumber(5)PERCENT
ULOC_HEAD_TAX_METHODVarchar2(2)X_ULOC_HEAD_TAX_METHOD
ULOC_HEAD_TAX_AMOUNTNumber(18)AMT12V6
UST_EIC_METHODVarchar2(2)X_UST_EIC_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

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