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: PA.PA_COMPETENCE_PROFILES#

Source

View Text - Preformatted


select PROFILE_ID PROFILE_ID, PERSON_ID PERSON_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, COMPETENCE_ID COMPETENCE_ID, COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID, EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM, COMPETENCE_ALIAS COMPETENCE_ALIAS, COMPETENCE_NAME COMPETENCE_NAME, DESCRIPTION DESCRIPTION, RATING_LEVEL_ID RATING_LEVEL_ID, RATING_LEVEL_VALUE RATING_LEVEL_VALUE, OLD_EFFECTIVE_DATE_FROM OLD_EFFECTIVE_DATE_FROM, OLD_RATING_LEVEL_ID OLD_RATING_LEVEL_ID, OLD_RATING_LEVEL_VALUE OLD_RATING_LEVEL_VALUE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OPERATION OPERATION from "PA"."PA_COMPETENCE_PROFILES"

View Text - HTML Formatted

SELECT PROFILE_ID PROFILE_ID
, PERSON_ID PERSON_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, COMPETENCE_ID COMPETENCE_ID
, COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID
, EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, COMPETENCE_ALIAS COMPETENCE_ALIAS
, COMPETENCE_NAME COMPETENCE_NAME
, DESCRIPTION DESCRIPTION
, RATING_LEVEL_ID RATING_LEVEL_ID
, RATING_LEVEL_VALUE RATING_LEVEL_VALUE
, OLD_EFFECTIVE_DATE_FROM OLD_EFFECTIVE_DATE_FROM
, OLD_RATING_LEVEL_ID OLD_RATING_LEVEL_ID
, OLD_RATING_LEVEL_VALUE OLD_RATING_LEVEL_VALUE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OPERATION OPERATION
FROM "PA"."PA_COMPETENCE_PROFILES"