VIEW: HR.GHR_POSITION_DESCRIPTIONS#

Source

View Text - Preformatted

select POSITION_DESCRIPTION_ID POSITION_DESCRIPTION_ID, ROUTING_GROUP_ID ROUTING_GROUP_ID, DATE_FROM DATE_FROM, DATE_TO DATE_TO, OPM_CERT_NUM OPM_CERT_NUM, FLSA FLSA, FINANCIAL_STATEMENT FINANCIAL_STATEMENT, SUBJECT_TO_IA_ACTION SUBJECT_TO_IA_ACTION, POSITION_STATUS POSITION_STATUS, POSITION_IS POSITION_IS, POSITION_SENSITIVITY POSITION_SENSITIVITY, COMPETITIVE_LEVEL COMPETITIVE_LEVEL, PD_REMARKS PD_REMARKS, POSITION_CLASS_STD POSITION_CLASS_STD, CATEGORY CATEGORY, CAREER_LADDER CAREER_LADDER, SUPERVISOR_NAME SUPERVISOR_NAME, SUPERVISOR_TITLE SUPERVISOR_TITLE, SUPERVISOR_DATE SUPERVISOR_DATE, MANAGER_NAME MANAGER_NAME, MANAGER_TITLE MANAGER_TITLE, MANAGER_DATE MANAGER_DATE, CLASSIFIER_NAME CLASSIFIER_NAME, CLASSIFIER_TITLE CLASSIFIER_TITLE, CLASSIFIER_DATE CLASSIFIER_DATE, PA_REQUEST_ID PA_REQUEST_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, BUSINESS_GROUP_ID BUSINESS_GROUP_ID from "HR"."GHR_POSITION_DESCRIPTIONS"

View Text - HTML Formatted

SELECT POSITION_DESCRIPTION_ID POSITION_DESCRIPTION_ID
, ROUTING_GROUP_ID ROUTING_GROUP_ID
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, OPM_CERT_NUM OPM_CERT_NUM
, FLSA FLSA
, FINANCIAL_STATEMENT FINANCIAL_STATEMENT
, SUBJECT_TO_IA_ACTION SUBJECT_TO_IA_ACTION
, POSITION_STATUS POSITION_STATUS
, POSITION_IS POSITION_IS
, POSITION_SENSITIVITY POSITION_SENSITIVITY
, COMPETITIVE_LEVEL COMPETITIVE_LEVEL
, PD_REMARKS PD_REMARKS
, POSITION_CLASS_STD POSITION_CLASS_STD
, CATEGORY CATEGORY
, CAREER_LADDER CAREER_LADDER
, SUPERVISOR_NAME SUPERVISOR_NAME
, SUPERVISOR_TITLE SUPERVISOR_TITLE
, SUPERVISOR_DATE SUPERVISOR_DATE
, MANAGER_NAME MANAGER_NAME
, MANAGER_TITLE MANAGER_TITLE
, MANAGER_DATE MANAGER_DATE
, CLASSIFIER_NAME CLASSIFIER_NAME
, CLASSIFIER_TITLE CLASSIFIER_TITLE
, CLASSIFIER_DATE CLASSIFIER_DATE
, PA_REQUEST_ID PA_REQUEST_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM "HR"."GHR_POSITION_DESCRIPTIONS"