VIEW: HR.HR_H2PI_COUNTY_TAX_RULES#

Source

View Text - Preformatted

select PERSON_ID PERSON_ID, EMP_COUNTY_TAX_RULE_ID EMP_COUNTY_TAX_RULE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ASSIGNMENT_ID ASSIGNMENT_ID, STATE_CODE STATE_CODE, COUNTY_CODE COUNTY_CODE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CLIENT_ID CLIENT_ID, ADDITIONAL_WA_RATE ADDITIONAL_WA_RATE, FILING_STATUS_CODE FILING_STATUS_CODE, JURISDICTION_CODE JURISDICTION_CODE, LIT_ADDITIONAL_TAX LIT_ADDITIONAL_TAX, LIT_OVERRIDE_AMOUNT LIT_OVERRIDE_AMOUNT, LIT_OVERRIDE_RATE LIT_OVERRIDE_RATE, WITHHOLDING_ALLOWANCES WITHHOLDING_ALLOWANCES, LIT_EXEMPT LIT_EXEMPT, SD_EXEMPT SD_EXEMPT, HT_EXEMPT HT_EXEMPT, SCHOOL_DISTRICT_CODE SCHOOL_DISTRICT_CODE, LAST_UPD_DATE LAST_UPD_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STATUS STATUS from "HR"."HR_H2PI_COUNTY_TAX_RULES"

View Text - HTML Formatted

SELECT PERSON_ID PERSON_ID
, EMP_COUNTY_TAX_RULE_ID EMP_COUNTY_TAX_RULE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ASSIGNMENT_ID ASSIGNMENT_ID
, STATE_CODE STATE_CODE
, COUNTY_CODE COUNTY_CODE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CLIENT_ID CLIENT_ID
, ADDITIONAL_WA_RATE ADDITIONAL_WA_RATE
, FILING_STATUS_CODE FILING_STATUS_CODE
, JURISDICTION_CODE JURISDICTION_CODE
, LIT_ADDITIONAL_TAX LIT_ADDITIONAL_TAX
, LIT_OVERRIDE_AMOUNT LIT_OVERRIDE_AMOUNT
, LIT_OVERRIDE_RATE LIT_OVERRIDE_RATE
, WITHHOLDING_ALLOWANCES WITHHOLDING_ALLOWANCES
, LIT_EXEMPT LIT_EXEMPT
, SD_EXEMPT SD_EXEMPT
, HT_EXEMPT HT_EXEMPT
, SCHOOL_DISTRICT_CODE SCHOOL_DISTRICT_CODE
, LAST_UPD_DATE LAST_UPD_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STATUS STATUS
FROM "HR"."HR_H2PI_COUNTY_TAX_RULES"