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.

VIEW: HR.PAY_US_SCHOOL_DSTS_TAX_INFO_F#

Source

View Text - Preformatted


select SCHOOL_TAX_INFO_ID SCHOOL_TAX_INFO_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, STATE_CODE STATE_CODE, SCHOOL_DSTS_CODE SCHOOL_DSTS_CODE, JURISDICTION_CODE JURISDICTION_CODE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, SCH_ATTRIBUTE1 SCH_ATTRIBUTE1, SCH_ATTRIBUTE2 SCH_ATTRIBUTE2, SCH_ATTRIBUTE3 SCH_ATTRIBUTE3, SCH_ATTRIBUTE4 SCH_ATTRIBUTE4, SCH_ATTRIBUTE5 SCH_ATTRIBUTE5, SCH_ATTRIBUTE6 SCH_ATTRIBUTE6, SCH_ATTRIBUTE7 SCH_ATTRIBUTE7, SCH_ATTRIBUTE8 SCH_ATTRIBUTE8, SCH_ATTRIBUTE9 SCH_ATTRIBUTE9, SCH_ATTRIBUTE10 SCH_ATTRIBUTE10, SCH_ATTRIBUTE11 SCH_ATTRIBUTE11, SCH_ATTRIBUTE12 SCH_ATTRIBUTE12, SCH_ATTRIBUTE13 SCH_ATTRIBUTE13, SCH_ATTRIBUTE14 SCH_ATTRIBUTE14, SCH_ATTRIBUTE16 SCH_ATTRIBUTE16, SCH_ATTRIBUTE17 SCH_ATTRIBUTE17, SCH_ATTRIBUTE18 SCH_ATTRIBUTE18, SCH_ATTRIBUTE19 SCH_ATTRIBUTE19, SCH_ATTRIBUTE20 SCH_ATTRIBUTE20, SCH_INFORMATION_CATEGORY SCH_INFORMATION_CATEGORY, SCH_INFORMATION1 SCH_INFORMATION1, SCH_INFORMATION2 SCH_INFORMATION2, SCH_INFORMATION3 SCH_INFORMATION3, SCH_INFORMATION4 SCH_INFORMATION4, SCH_INFORMATION5 SCH_INFORMATION5, SCH_INFORMATION6 SCH_INFORMATION6, SCH_INFORMATION7 SCH_INFORMATION7, SCH_INFORMATION8 SCH_INFORMATION8, SCH_INFORMATION9 SCH_INFORMATION9, SCH_INFORMATION10 SCH_INFORMATION10, 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, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_US_SCHOOL_DSTS_TAX_INFO_F"

View Text - HTML Formatted

SELECT SCHOOL_TAX_INFO_ID SCHOOL_TAX_INFO_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, STATE_CODE STATE_CODE
, SCHOOL_DSTS_CODE SCHOOL_DSTS_CODE
, JURISDICTION_CODE JURISDICTION_CODE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SCH_ATTRIBUTE1 SCH_ATTRIBUTE1
, SCH_ATTRIBUTE2 SCH_ATTRIBUTE2
, SCH_ATTRIBUTE3 SCH_ATTRIBUTE3
, SCH_ATTRIBUTE4 SCH_ATTRIBUTE4
, SCH_ATTRIBUTE5 SCH_ATTRIBUTE5
, SCH_ATTRIBUTE6 SCH_ATTRIBUTE6
, SCH_ATTRIBUTE7 SCH_ATTRIBUTE7
, SCH_ATTRIBUTE8 SCH_ATTRIBUTE8
, SCH_ATTRIBUTE9 SCH_ATTRIBUTE9
, SCH_ATTRIBUTE10 SCH_ATTRIBUTE10
, SCH_ATTRIBUTE11 SCH_ATTRIBUTE11
, SCH_ATTRIBUTE12 SCH_ATTRIBUTE12
, SCH_ATTRIBUTE13 SCH_ATTRIBUTE13
, SCH_ATTRIBUTE14 SCH_ATTRIBUTE14
, SCH_ATTRIBUTE16 SCH_ATTRIBUTE16
, SCH_ATTRIBUTE17 SCH_ATTRIBUTE17
, SCH_ATTRIBUTE18 SCH_ATTRIBUTE18
, SCH_ATTRIBUTE19 SCH_ATTRIBUTE19
, SCH_ATTRIBUTE20 SCH_ATTRIBUTE20
, SCH_INFORMATION_CATEGORY SCH_INFORMATION_CATEGORY
, SCH_INFORMATION1 SCH_INFORMATION1
, SCH_INFORMATION2 SCH_INFORMATION2
, SCH_INFORMATION3 SCH_INFORMATION3
, SCH_INFORMATION4 SCH_INFORMATION4
, SCH_INFORMATION5 SCH_INFORMATION5
, SCH_INFORMATION6 SCH_INFORMATION6
, SCH_INFORMATION7 SCH_INFORMATION7
, SCH_INFORMATION8 SCH_INFORMATION8
, SCH_INFORMATION9 SCH_INFORMATION9
, SCH_INFORMATION10 SCH_INFORMATION10
, 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
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_US_SCHOOL_DSTS_TAX_INFO_F"