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: OTA.OTA_NOTRNG_HISTORIES#

Source

View Text - Preformatted


select NOTA_HISTORY_ID NOTA_HISTORY_ID, PERSON_ID PERSON_ID, CONTACT_ID CONTACT_ID, TRNG_TITLE TRNG_TITLE, PROVIDER PROVIDER, TYPE TYPE, CENTRE CENTRE, COMPLETION_DATE COMPLETION_DATE, AWARD AWARD, RATING RATING, DURATION DURATION, DURATION_UNITS DURATION_UNITS, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID, STATUS STATUS, VERIFIED_BY_ID VERIFIED_BY_ID, 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, NTH_INFORMATION_CATEGORY NTH_INFORMATION_CATEGORY, NTH_INFORMATION1 NTH_INFORMATION1, NTH_INFORMATION2 NTH_INFORMATION2, NTH_INFORMATION3 NTH_INFORMATION3, NTH_INFORMATION4 NTH_INFORMATION4, NTH_INFORMATION5 NTH_INFORMATION5, NTH_INFORMATION6 NTH_INFORMATION6, NTH_INFORMATION7 NTH_INFORMATION7, NTH_INFORMATION8 NTH_INFORMATION8, NTH_INFORMATION9 NTH_INFORMATION9, NTH_INFORMATION10 NTH_INFORMATION10, NTH_INFORMATION11 NTH_INFORMATION11, NTH_INFORMATION12 NTH_INFORMATION12, NTH_INFORMATION13 NTH_INFORMATION13, NTH_INFORMATION14 NTH_INFORMATION14, NTH_INFORMATION15 NTH_INFORMATION15, NTH_INFORMATION16 NTH_INFORMATION16, NTH_INFORMATION17 NTH_INFORMATION17, NTH_INFORMATION18 NTH_INFORMATION18, NTH_INFORMATION19 NTH_INFORMATION19, NTH_INFORMATION20 NTH_INFORMATION20, ORG_ID ORG_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CUSTOMER_ID CUSTOMER_ID, ORGANIZATION_ID ORGANIZATION_ID from "OTA"."OTA_NOTRNG_HISTORIES"

View Text - HTML Formatted

SELECT NOTA_HISTORY_ID NOTA_HISTORY_ID
, PERSON_ID PERSON_ID
, CONTACT_ID CONTACT_ID
, TRNG_TITLE TRNG_TITLE
, PROVIDER PROVIDER
, TYPE TYPE
, CENTRE CENTRE
, COMPLETION_DATE COMPLETION_DATE
, AWARD AWARD
, RATING RATING
, DURATION DURATION
, DURATION_UNITS DURATION_UNITS
, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, STATUS STATUS
, VERIFIED_BY_ID VERIFIED_BY_ID
, 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
, NTH_INFORMATION_CATEGORY NTH_INFORMATION_CATEGORY
, NTH_INFORMATION1 NTH_INFORMATION1
, NTH_INFORMATION2 NTH_INFORMATION2
, NTH_INFORMATION3 NTH_INFORMATION3
, NTH_INFORMATION4 NTH_INFORMATION4
, NTH_INFORMATION5 NTH_INFORMATION5
, NTH_INFORMATION6 NTH_INFORMATION6
, NTH_INFORMATION7 NTH_INFORMATION7
, NTH_INFORMATION8 NTH_INFORMATION8
, NTH_INFORMATION9 NTH_INFORMATION9
, NTH_INFORMATION10 NTH_INFORMATION10
, NTH_INFORMATION11 NTH_INFORMATION11
, NTH_INFORMATION12 NTH_INFORMATION12
, NTH_INFORMATION13 NTH_INFORMATION13
, NTH_INFORMATION14 NTH_INFORMATION14
, NTH_INFORMATION15 NTH_INFORMATION15
, NTH_INFORMATION16 NTH_INFORMATION16
, NTH_INFORMATION17 NTH_INFORMATION17
, NTH_INFORMATION18 NTH_INFORMATION18
, NTH_INFORMATION19 NTH_INFORMATION19
, NTH_INFORMATION20 NTH_INFORMATION20
, ORG_ID ORG_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CUSTOMER_ID CUSTOMER_ID
, ORGANIZATION_ID ORGANIZATION_ID
FROM "OTA"."OTA_NOTRNG_HISTORIES"