eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.HR_H2PI_FEDERAL_TAX_RULES#

Source

View Text - Preformatted


select PERSON_ID PERSON_ID, EMP_FED_TAX_RULE_ID EMP_FED_TAX_RULE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ASSIGNMENT_ID ASSIGNMENT_ID, SUI_STATE_CODE SUI_STATE_CODE, SUI_JURISDICTION_CODE SUI_JURISDICTION_CODE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CLIENT_ID CLIENT_ID, ADDITIONAL_WA_AMOUNT ADDITIONAL_WA_AMOUNT, FILING_STATUS_CODE FILING_STATUS_CODE, FIT_OVERRIDE_AMOUNT FIT_OVERRIDE_AMOUNT, FIT_OVERRIDE_RATE FIT_OVERRIDE_RATE, WITHHOLDING_ALLOWANCES WITHHOLDING_ALLOWANCES, CUMULATIVE_TAXATION CUMULATIVE_TAXATION, EIC_FILING_STATUS_CODE EIC_FILING_STATUS_CODE, FIT_ADDITIONAL_TAX FIT_ADDITIONAL_TAX, FIT_EXEMPT FIT_EXEMPT, FUTA_TAX_EXEMPT FUTA_TAX_EXEMPT, MEDICARE_TAX_EXEMPT MEDICARE_TAX_EXEMPT, SS_TAX_EXEMPT SS_TAX_EXEMPT, STATUTORY_EMPLOYEE STATUTORY_EMPLOYEE, W2_FILED_YEAR W2_FILED_YEAR, SUPP_TAX_OVERRIDE_RATE SUPP_TAX_OVERRIDE_RATE, EXCESSIVE_WA_REJECT_DATE EXCESSIVE_WA_REJECT_DATE, LAST_UPD_DATE LAST_UPD_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STATUS STATUS from "HR"."HR_H2PI_FEDERAL_TAX_RULES"

View Text - HTML Formatted

SELECT PERSON_ID PERSON_ID
, EMP_FED_TAX_RULE_ID EMP_FED_TAX_RULE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ASSIGNMENT_ID ASSIGNMENT_ID
, SUI_STATE_CODE SUI_STATE_CODE
, SUI_JURISDICTION_CODE SUI_JURISDICTION_CODE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CLIENT_ID CLIENT_ID
, ADDITIONAL_WA_AMOUNT ADDITIONAL_WA_AMOUNT
, FILING_STATUS_CODE FILING_STATUS_CODE
, FIT_OVERRIDE_AMOUNT FIT_OVERRIDE_AMOUNT
, FIT_OVERRIDE_RATE FIT_OVERRIDE_RATE
, WITHHOLDING_ALLOWANCES WITHHOLDING_ALLOWANCES
, CUMULATIVE_TAXATION CUMULATIVE_TAXATION
, EIC_FILING_STATUS_CODE EIC_FILING_STATUS_CODE
, FIT_ADDITIONAL_TAX FIT_ADDITIONAL_TAX
, FIT_EXEMPT FIT_EXEMPT
, FUTA_TAX_EXEMPT FUTA_TAX_EXEMPT
, MEDICARE_TAX_EXEMPT MEDICARE_TAX_EXEMPT
, SS_TAX_EXEMPT SS_TAX_EXEMPT
, STATUTORY_EMPLOYEE STATUTORY_EMPLOYEE
, W2_FILED_YEAR W2_FILED_YEAR
, SUPP_TAX_OVERRIDE_RATE SUPP_TAX_OVERRIDE_RATE
, EXCESSIVE_WA_REJECT_DATE EXCESSIVE_WA_REJECT_DATE
, LAST_UPD_DATE LAST_UPD_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STATUS STATUS
FROM "HR"."HR_H2PI_FEDERAL_TAX_RULES"