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
UFED_TAX_METHODVarchar2(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
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top