!!!Alias: PPRU (P2K_PR_US_PAY_RULES) Unique Keys: \\ Child Table: \\ Parent Table: \\ ERD: [ERD-PR35] \\ Us Pay Rules !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[PTAU_ID]|Number(10)|[ID]|Y|link to [P2K_PR_US_TAX_AREAS] |[EFFECTIVE]|Date()|[EFFECTIVE]|Y| |[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS] |[EXPIRY]|Date()|[EXPIRY]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[UFED_FILING_STATUS]|Varchar2(2)|[X_UFED_FILING_STATUS]| | |[UFED_NUM_EXEMPTIONS]|Number(5)|[NUMBER5|NUMBERn]| | |[UFED_ANN_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| | |[UFED_ADD_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| | |[UFED_ADD_TAX_PER_PERIOD]|Number(18)|[AMT12V6|AMTnn]| | |[UFED_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[UFED_TAX_PERCENT]|Number(5)|[PERCENT]| | |[US Tax Withholding Options (UFED_TAX_METHOD)]|Varchar2(2)|[X_UFED_TAX_METHOD]| | |[UFED_SUPPL_TAX_METHOD]|Varchar2(2)|[X_UFED_SUPPL_METHOD]| | |[UFED_FICA_METHOD]|Varchar2(2)|[X_UFED_FICA_METHOD]| | |[UFED_MEDICARE_METHOD]|Varchar2(2)|[X_UFED_MEDICARE_METHOD]| | |[UFED_FUTA_METHOD]|Varchar2(2)|[X_UFED_FUTA_METHOD]| | |[UFED_EIC_METHOD]|Varchar2(2)|[X_UFED_EIC_METHOD]| | |[UST_RECIPROCATION]|Varchar2(2)|[X_UST_RECIPROCATION]| | |[UST_FILING_STATUS]|Varchar2(4)|[X_UST_FILING_STATUS]| | |[UST_NUM_EXEMPTION_1]|Number(5)|[NUMBER5|NUMBERn]| | |[UST_NUM_EXEMPTION_2]|Number(5)|[NUMBER5|NUMBERn]| | |[UST_ANN_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| | |[UST_ADD_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| | |[UST_ADD_TAX_PER_PERIOD]|Number(18)|[AMT12V6|AMTnn]| | |[UST_ADD_TAX_RES]|Varchar2(2)|[X_UST_ADD_TAX_RES]| | |[UST_ADD_TAX_WORK]|Varchar2(2)|[X_UST_ADD_TAX_WORK]| | |[UST_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[UST_TAX_PERCENT]|Number(5)|[PERCENT]| | |[UST_TAX_METHOD]|Varchar2(2)|[X_UST_TAX_METHOD]| | |[UST_SUPPL_TAX_METHOD]|Varchar2(2)|[X_UST_SUPPL_METHOD]| | |[UST_ALT_TAX_METHOD]|Varchar2(4)|[X_UST_ALT_TAX_METHOD]| | |[UST_SUI_EE_METHOD]|Varchar2(2)|[X_UST_SUI_METHOD]| | |[UST_SUI_ER_METHOD]|Varchar2(2)|[X_UST_SUI_METHOD]| | |[UST_SDI_EE_METHOD]|Varchar2(2)|[X_UST_SDI_METHOD]| | |[UST_SDI_ER_METHOD]|Varchar2(2)|[X_UST_SDI_METHOD]| | |[UST_WCB_METHOD]|Varchar2(2)|[X_UST_WCB_METHOD]| | |[ULOC_RECIPROCATION]|Varchar2(2)|[X_ULOC_RECIPROCATION]| | |[ULOC_FILING_STATUS]|Varchar2(4)|[X_ULOC_FILING_STATUS]| | |[ULOC_NUM_EXEMPTIONS]|Number(5)|[NUMBER5|NUMBERn]| | |[ULOC_ANN_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| | |[ULOC_EXEMPTION_PERCENT]|Number(5)|[PERCENT]| | |[ULOC_ADD_TAX_PER_PERIOD]|Number(18)|[AMT12V6|AMTnn]| | |[ULOC_ADD_TAX_WORK]|Varchar2(2)|[X_ULOC_ADD_TAX_WORK]| | |[ULOC_ADD_TAX_RES]|Varchar2(2)|[X_ULOC_ADD_TAX_RES]| | |[ULOC_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[ULOC_TAX_PERCENT_1]|Number(5)|[PERCENT]| | |[ULOC_TAX_PERCENT_2]|Number(5)|[PERCENT]| | |[ULOC_COUNTY_TAX_METHOD]|Varchar2(2)|[X_ULOC_COUNTY_TAX_METHOD]| | |[ULOC_CITY_TAX_METHOD]|Varchar2(2)|[X_ULOC_CITY_TAX_METHOD]| | |[ULOC_SCHOOL_TAX_METHOD]|Varchar2(2)|[X_ULOC_SCHOOL_TAX_METHOD]| | |[ULOC_SCHOOL_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[ULOC_SCHOOL_TAX_PERCENT]|Number(5)|[PERCENT]| | |[ULOC_HEAD_TAX_METHOD]|Varchar2(2)|[X_ULOC_HEAD_TAX_METHOD]| | |[ULOC_HEAD_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[UST_EIC_METHOD]|Varchar2(2)|[X_UST_EIC_METHOD]| | |[URR_TIER1_SOC_METHOD]|Varchar2(2)|[X_URR_TIER1_SOC_METHOD]| | |[URR_TIER1_MED_METHOD]|Varchar2(2)|[X_URR_TIER1_MED_METHOD]| | |[URR_TIER2_RET_METHOD]|Varchar2(2)|[X_URR_TIER2_RET_METHOD]| | |[URR_RUIA_METHOD]|Varchar2(2)|[X_URR_RUIA_METHOD]| | |[URR_RURT_METHOD]|Varchar2(2)|[X_URR_RURT_METHOD]| | |[URR_SUPPL_METHOD]|Varchar2(2)|[X_URR_SUPPL_METHOD]| | User Fields: Allowed\\ Audit Logging: Allowed\\ ---- ![Notes|Edit:Internal.P2K_PR_US_PAY_RULES] [{InsertPage page='Internal.P2K_PR_US_PAY_RULES' default='Click to create a new notes page'}]