!!!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]| | 
|[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'}]