VIEW: HR.PAY_US_COUNTY_TAX_INFO_F#

Source

View Text - Preformatted

select COUNTY_TAX_INFO_ID COUNTY_TAX_INFO_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, JURISDICTION_CODE JURISDICTION_CODE, COUNTY_TAX COUNTY_TAX, HEAD_TAX HEAD_TAX, SCHOOL_TAX SCHOOL_TAX, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CNTY_ATTRIBUTE1 CNTY_ATTRIBUTE1, CNTY_ATTRIBUTE2 CNTY_ATTRIBUTE2, CNTY_ATTRIBUTE3 CNTY_ATTRIBUTE3, CNTY_ATTRIBUTE4 CNTY_ATTRIBUTE4, CNTY_ATTRIBUTE5 CNTY_ATTRIBUTE5, CNTY_ATTRIBUTE6 CNTY_ATTRIBUTE6, CNTY_ATTRIBUTE7 CNTY_ATTRIBUTE7, CNTY_ATTRIBUTE8 CNTY_ATTRIBUTE8, CNTY_ATTRIBUTE9 CNTY_ATTRIBUTE9, CNTY_ATTRIBUTE10 CNTY_ATTRIBUTE10, CNTY_ATTRIBUTE11 CNTY_ATTRIBUTE11, CNTY_ATTRIBUTE12 CNTY_ATTRIBUTE12, CNTY_ATTRIBUTE13 CNTY_ATTRIBUTE13, CNTY_ATTRIBUTE14 CNTY_ATTRIBUTE14, CNTY_ATTRIBUTE15 CNTY_ATTRIBUTE15, CNTY_ATTRIBUTE16 CNTY_ATTRIBUTE16, CNTY_ATTRIBUTE17 CNTY_ATTRIBUTE17, CNTY_ATTRIBUTE18 CNTY_ATTRIBUTE18, CNTY_ATTRIBUTE19 CNTY_ATTRIBUTE19, CNTY_ATTRIBUTE20 CNTY_ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CNTY_INFORMATION_CATEGORY CNTY_INFORMATION_CATEGORY, CNTY_INFORMATION1 CNTY_INFORMATION1, CNTY_INFORMATION2 CNTY_INFORMATION2, CNTY_INFORMATION3 CNTY_INFORMATION3, CNTY_INFORMATION4 CNTY_INFORMATION4, CNTY_INFORMATION5 CNTY_INFORMATION5, CNTY_INFORMATION6 CNTY_INFORMATION6, CNTY_INFORMATION7 CNTY_INFORMATION7, CNTY_INFORMATION8 CNTY_INFORMATION8, CNTY_INFORMATION9 CNTY_INFORMATION9, CNTY_INFORMATION10 CNTY_INFORMATION10, CNTY_INFORMATION11 CNTY_INFORMATION11, CNTY_INFORMATION12 CNTY_INFORMATION12, CNTY_INFORMATION13 CNTY_INFORMATION13, CNTY_INFORMATION14 CNTY_INFORMATION14, CNTY_INFORMATION15 CNTY_INFORMATION15, CNTY_INFORMATION16 CNTY_INFORMATION16, CNTY_INFORMATION17 CNTY_INFORMATION17, CNTY_INFORMATION18 CNTY_INFORMATION18, CNTY_INFORMATION19 CNTY_INFORMATION19, CNTY_INFORMATION20 CNTY_INFORMATION20, CNTY_INFORMATION21 CNTY_INFORMATION21, CNTY_INFORMATION22 CNTY_INFORMATION22, CNTY_INFORMATION23 CNTY_INFORMATION23, CNTY_INFORMATION24 CNTY_INFORMATION24, CNTY_INFORMATION25 CNTY_INFORMATION25, CNTY_INFORMATION26 CNTY_INFORMATION26, CNTY_INFORMATION27 CNTY_INFORMATION27, CNTY_INFORMATION28 CNTY_INFORMATION28, CNTY_INFORMATION29 CNTY_INFORMATION29, CNTY_INFORMATION30 CNTY_INFORMATION30, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_US_COUNTY_TAX_INFO_F"

View Text - HTML Formatted

SELECT COUNTY_TAX_INFO_ID COUNTY_TAX_INFO_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, JURISDICTION_CODE JURISDICTION_CODE
, COUNTY_TAX COUNTY_TAX
, HEAD_TAX HEAD_TAX
, SCHOOL_TAX SCHOOL_TAX
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CNTY_ATTRIBUTE1 CNTY_ATTRIBUTE1
, CNTY_ATTRIBUTE2 CNTY_ATTRIBUTE2
, CNTY_ATTRIBUTE3 CNTY_ATTRIBUTE3
, CNTY_ATTRIBUTE4 CNTY_ATTRIBUTE4
, CNTY_ATTRIBUTE5 CNTY_ATTRIBUTE5
, CNTY_ATTRIBUTE6 CNTY_ATTRIBUTE6
, CNTY_ATTRIBUTE7 CNTY_ATTRIBUTE7
, CNTY_ATTRIBUTE8 CNTY_ATTRIBUTE8
, CNTY_ATTRIBUTE9 CNTY_ATTRIBUTE9
, CNTY_ATTRIBUTE10 CNTY_ATTRIBUTE10
, CNTY_ATTRIBUTE11 CNTY_ATTRIBUTE11
, CNTY_ATTRIBUTE12 CNTY_ATTRIBUTE12
, CNTY_ATTRIBUTE13 CNTY_ATTRIBUTE13
, CNTY_ATTRIBUTE14 CNTY_ATTRIBUTE14
, CNTY_ATTRIBUTE15 CNTY_ATTRIBUTE15
, CNTY_ATTRIBUTE16 CNTY_ATTRIBUTE16
, CNTY_ATTRIBUTE17 CNTY_ATTRIBUTE17
, CNTY_ATTRIBUTE18 CNTY_ATTRIBUTE18
, CNTY_ATTRIBUTE19 CNTY_ATTRIBUTE19
, CNTY_ATTRIBUTE20 CNTY_ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CNTY_INFORMATION_CATEGORY CNTY_INFORMATION_CATEGORY
, CNTY_INFORMATION1 CNTY_INFORMATION1
, CNTY_INFORMATION2 CNTY_INFORMATION2
, CNTY_INFORMATION3 CNTY_INFORMATION3
, CNTY_INFORMATION4 CNTY_INFORMATION4
, CNTY_INFORMATION5 CNTY_INFORMATION5
, CNTY_INFORMATION6 CNTY_INFORMATION6
, CNTY_INFORMATION7 CNTY_INFORMATION7
, CNTY_INFORMATION8 CNTY_INFORMATION8
, CNTY_INFORMATION9 CNTY_INFORMATION9
, CNTY_INFORMATION10 CNTY_INFORMATION10
, CNTY_INFORMATION11 CNTY_INFORMATION11
, CNTY_INFORMATION12 CNTY_INFORMATION12
, CNTY_INFORMATION13 CNTY_INFORMATION13
, CNTY_INFORMATION14 CNTY_INFORMATION14
, CNTY_INFORMATION15 CNTY_INFORMATION15
, CNTY_INFORMATION16 CNTY_INFORMATION16
, CNTY_INFORMATION17 CNTY_INFORMATION17
, CNTY_INFORMATION18 CNTY_INFORMATION18
, CNTY_INFORMATION19 CNTY_INFORMATION19
, CNTY_INFORMATION20 CNTY_INFORMATION20
, CNTY_INFORMATION21 CNTY_INFORMATION21
, CNTY_INFORMATION22 CNTY_INFORMATION22
, CNTY_INFORMATION23 CNTY_INFORMATION23
, CNTY_INFORMATION24 CNTY_INFORMATION24
, CNTY_INFORMATION25 CNTY_INFORMATION25
, CNTY_INFORMATION26 CNTY_INFORMATION26
, CNTY_INFORMATION27 CNTY_INFORMATION27
, CNTY_INFORMATION28 CNTY_INFORMATION28
, CNTY_INFORMATION29 CNTY_INFORMATION29
, CNTY_INFORMATION30 CNTY_INFORMATION30
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_US_COUNTY_TAX_INFO_F"