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_STATE_TAX_RULES#

Source

View Text - Preformatted


select PERSON_ID PERSON_ID, EMP_STATE_TAX_RULE_ID EMP_STATE_TAX_RULE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ASSIGNMENT_ID ASSIGNMENT_ID, STATE_CODE STATE_CODE, JURISDICTION_CODE JURISDICTION_CODE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CLIENT_ID CLIENT_ID, ADDITIONAL_WA_AMOUNT ADDITIONAL_WA_AMOUNT, FILING_STATUS_CODE FILING_STATUS_CODE, REMAINDER_PERCENT REMAINDER_PERCENT, SECONDARY_WA SECONDARY_WA, SIT_ADDITIONAL_TAX SIT_ADDITIONAL_TAX, SIT_OVERRIDE_AMOUNT SIT_OVERRIDE_AMOUNT, SIT_OVERRIDE_RATE SIT_OVERRIDE_RATE, WITHHOLDING_ALLOWANCES WITHHOLDING_ALLOWANCES, EXCESSIVE_WA_REJECT_DATE EXCESSIVE_WA_REJECT_DATE, SDI_EXEMPT SDI_EXEMPT, SIT_EXEMPT SIT_EXEMPT, SIT_OPTIONAL_CALC_IND SIT_OPTIONAL_CALC_IND, STATE_NON_RESIDENT_CERT STATE_NON_RESIDENT_CERT, SUI_EXEMPT SUI_EXEMPT, WC_EXEMPT WC_EXEMPT, SUI_WAGE_BASE_OVERRIDE_AMOUNT SUI_WAGE_BASE_OVERRIDE_AMOUNT, SUPP_TAX_OVERRIDE_RATE SUPP_TAX_OVERRIDE_RATE, LAST_UPD_DATE LAST_UPD_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STATUS STATUS from "HR"."HR_H2PI_STATE_TAX_RULES"

View Text - HTML Formatted

SELECT PERSON_ID PERSON_ID
, EMP_STATE_TAX_RULE_ID EMP_STATE_TAX_RULE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ASSIGNMENT_ID ASSIGNMENT_ID
, STATE_CODE STATE_CODE
, JURISDICTION_CODE JURISDICTION_CODE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CLIENT_ID CLIENT_ID
, ADDITIONAL_WA_AMOUNT ADDITIONAL_WA_AMOUNT
, FILING_STATUS_CODE FILING_STATUS_CODE
, REMAINDER_PERCENT REMAINDER_PERCENT
, SECONDARY_WA SECONDARY_WA
, SIT_ADDITIONAL_TAX SIT_ADDITIONAL_TAX
, SIT_OVERRIDE_AMOUNT SIT_OVERRIDE_AMOUNT
, SIT_OVERRIDE_RATE SIT_OVERRIDE_RATE
, WITHHOLDING_ALLOWANCES WITHHOLDING_ALLOWANCES
, EXCESSIVE_WA_REJECT_DATE EXCESSIVE_WA_REJECT_DATE
, SDI_EXEMPT SDI_EXEMPT
, SIT_EXEMPT SIT_EXEMPT
, SIT_OPTIONAL_CALC_IND SIT_OPTIONAL_CALC_IND
, STATE_NON_RESIDENT_CERT STATE_NON_RESIDENT_CERT
, SUI_EXEMPT SUI_EXEMPT
, WC_EXEMPT WC_EXEMPT
, SUI_WAGE_BASE_OVERRIDE_AMOUNT SUI_WAGE_BASE_OVERRIDE_AMOUNT
, SUPP_TAX_OVERRIDE_RATE SUPP_TAX_OVERRIDE_RATE
, LAST_UPD_DATE LAST_UPD_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STATUS STATUS
FROM "HR"."HR_H2PI_STATE_TAX_RULES"