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

Source

View Text - Preformatted


select CITY_TAX_INFO_ID CITY_TAX_INFO_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, JURISDICTION_CODE JURISDICTION_CODE, CITY_TAX CITY_TAX, HEAD_TAX HEAD_TAX, SCHOOL_TAX SCHOOL_TAX, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CITY_ATTRIBUTE1 CITY_ATTRIBUTE1, CITY_ATTRIBUTE2 CITY_ATTRIBUTE2, CITY_ATTRIBUTE3 CITY_ATTRIBUTE3, CITY_ATTRIBUTE4 CITY_ATTRIBUTE4, CITY_ATTRIBUTE5 CITY_ATTRIBUTE5, CITY_ATTRIBUTE6 CITY_ATTRIBUTE6, CITY_ATTRIBUTE7 CITY_ATTRIBUTE7, CITY_ATTRIBUTE8 CITY_ATTRIBUTE8, CITY_ATTRIBUTE9 CITY_ATTRIBUTE9, CITY_ATTRIBUTE10 CITY_ATTRIBUTE10, CITY_ATTRIBUTE11 CITY_ATTRIBUTE11, CITY_ATTRIBUTE12 CITY_ATTRIBUTE12, CITY_ATTRIBUTE13 CITY_ATTRIBUTE13, CITY_ATTRIBUTE14 CITY_ATTRIBUTE14, CITY_ATTRIBUTE15 CITY_ATTRIBUTE15, CITY_ATTRIBUTE16 CITY_ATTRIBUTE16, CITY_ATTRIBUTE17 CITY_ATTRIBUTE17, CITY_ATTRIBUTE18 CITY_ATTRIBUTE18, CITY_ATTRIBUTE19 CITY_ATTRIBUTE19, CITY_ATTRIBUTE20 CITY_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, CITY_INFORMATION_CATEGORY CITY_INFORMATION_CATEGORY, CITY_INFORMATION1 CITY_INFORMATION1, CITY_INFORMATION2 CITY_INFORMATION2, CITY_INFORMATION3 CITY_INFORMATION3, CITY_INFORMATION4 CITY_INFORMATION4, CITY_INFORMATION5 CITY_INFORMATION5, CITY_INFORMATION6 CITY_INFORMATION6, CITY_INFORMATION7 CITY_INFORMATION7, CITY_INFORMATION8 CITY_INFORMATION8, CITY_INFORMATION9 CITY_INFORMATION9, CITY_INFORMATION10 CITY_INFORMATION10, CITY_INFORMATION11 CITY_INFORMATION11, CITY_INFORMATION12 CITY_INFORMATION12, CITY_INFORMATION13 CITY_INFORMATION13, CITY_INFORMATION14 CITY_INFORMATION14, CITY_INFORMATION15 CITY_INFORMATION15, CITY_INFORMATION16 CITY_INFORMATION16, CITY_INFORMATION17 CITY_INFORMATION17, CITY_INFORMATION18 CITY_INFORMATION18, CITY_INFORMATION19 CITY_INFORMATION19, CITY_INFORMATION20 CITY_INFORMATION20, CITY_INFORMATION21 CITY_INFORMATION21, CITY_INFORMATION22 CITY_INFORMATION22, CITY_INFORMATION23 CITY_INFORMATION23, CITY_INFORMATION24 CITY_INFORMATION24, CITY_INFORMATION25 CITY_INFORMATION25, CITY_INFORMATION26 CITY_INFORMATION26, CITY_INFORMATION27 CITY_INFORMATION27, CITY_INFORMATION28 CITY_INFORMATION28, CITY_INFORMATION29 CITY_INFORMATION29, CITY_INFORMATION30 CITY_INFORMATION30 from "HR"."HR_S_US_CITY_TAX_INFO_F"

View Text - HTML Formatted

SELECT CITY_TAX_INFO_ID CITY_TAX_INFO_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, JURISDICTION_CODE JURISDICTION_CODE
, CITY_TAX CITY_TAX
, HEAD_TAX HEAD_TAX
, SCHOOL_TAX SCHOOL_TAX
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CITY_ATTRIBUTE1 CITY_ATTRIBUTE1
, CITY_ATTRIBUTE2 CITY_ATTRIBUTE2
, CITY_ATTRIBUTE3 CITY_ATTRIBUTE3
, CITY_ATTRIBUTE4 CITY_ATTRIBUTE4
, CITY_ATTRIBUTE5 CITY_ATTRIBUTE5
, CITY_ATTRIBUTE6 CITY_ATTRIBUTE6
, CITY_ATTRIBUTE7 CITY_ATTRIBUTE7
, CITY_ATTRIBUTE8 CITY_ATTRIBUTE8
, CITY_ATTRIBUTE9 CITY_ATTRIBUTE9
, CITY_ATTRIBUTE10 CITY_ATTRIBUTE10
, CITY_ATTRIBUTE11 CITY_ATTRIBUTE11
, CITY_ATTRIBUTE12 CITY_ATTRIBUTE12
, CITY_ATTRIBUTE13 CITY_ATTRIBUTE13
, CITY_ATTRIBUTE14 CITY_ATTRIBUTE14
, CITY_ATTRIBUTE15 CITY_ATTRIBUTE15
, CITY_ATTRIBUTE16 CITY_ATTRIBUTE16
, CITY_ATTRIBUTE17 CITY_ATTRIBUTE17
, CITY_ATTRIBUTE18 CITY_ATTRIBUTE18
, CITY_ATTRIBUTE19 CITY_ATTRIBUTE19
, CITY_ATTRIBUTE20 CITY_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
, CITY_INFORMATION_CATEGORY CITY_INFORMATION_CATEGORY
, CITY_INFORMATION1 CITY_INFORMATION1
, CITY_INFORMATION2 CITY_INFORMATION2
, CITY_INFORMATION3 CITY_INFORMATION3
, CITY_INFORMATION4 CITY_INFORMATION4
, CITY_INFORMATION5 CITY_INFORMATION5
, CITY_INFORMATION6 CITY_INFORMATION6
, CITY_INFORMATION7 CITY_INFORMATION7
, CITY_INFORMATION8 CITY_INFORMATION8
, CITY_INFORMATION9 CITY_INFORMATION9
, CITY_INFORMATION10 CITY_INFORMATION10
, CITY_INFORMATION11 CITY_INFORMATION11
, CITY_INFORMATION12 CITY_INFORMATION12
, CITY_INFORMATION13 CITY_INFORMATION13
, CITY_INFORMATION14 CITY_INFORMATION14
, CITY_INFORMATION15 CITY_INFORMATION15
, CITY_INFORMATION16 CITY_INFORMATION16
, CITY_INFORMATION17 CITY_INFORMATION17
, CITY_INFORMATION18 CITY_INFORMATION18
, CITY_INFORMATION19 CITY_INFORMATION19
, CITY_INFORMATION20 CITY_INFORMATION20
, CITY_INFORMATION21 CITY_INFORMATION21
, CITY_INFORMATION22 CITY_INFORMATION22
, CITY_INFORMATION23 CITY_INFORMATION23
, CITY_INFORMATION24 CITY_INFORMATION24
, CITY_INFORMATION25 CITY_INFORMATION25
, CITY_INFORMATION26 CITY_INFORMATION26
, CITY_INFORMATION27 CITY_INFORMATION27
, CITY_INFORMATION28 CITY_INFORMATION28
, CITY_INFORMATION29 CITY_INFORMATION29
, CITY_INFORMATION30 CITY_INFORMATION30
FROM "HR"."HR_S_US_CITY_TAX_INFO_F"