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	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
UFED_FILING_STATUS	Varchar2(2)	X_UFED_FILING_STATUS
UFED_NUM_EXEMPTIONS	Number(5)	NUMBER5
UFED_ANN_EXEMPTION	Number(18)	AMT12V6
UFED_ADD_EXEMPTION	Number(18)	AMT12V6
UFED_ADD_TAX_PER_PERIOD	Number(18)	AMT12V6
UFED_TAX_AMOUNT	Number(18)	AMT12V6
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
UST_NUM_EXEMPTION_2	Number(5)	NUMBER5
UST_ANN_EXEMPTION	Number(18)	AMT12V6
UST_ADD_EXEMPTION	Number(18)	AMT12V6
UST_ADD_TAX_PER_PERIOD	Number(18)	AMT12V6
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
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
ULOC_ANN_EXEMPTION	Number(18)	AMT12V6
ULOC_EXEMPTION_PERCENT	Number(5)	PERCENT
ULOC_ADD_TAX_PER_PERIOD	Number(18)	AMT12V6
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
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
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
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 #

Click to create a new notes page