Product: | GHR - US Federal Human Resources |
---|---|
Description: | Position Description deatils |
Implementation/DBA Data: | APPS.GHR_POSITION_DESCRIPTIONS_V |
SELECT PDI.ROWID ROW_ID
, PDI.POSITION_DESCRIPTION_ID
, PDI.BUSINESS_GROUP_ID
, PDI.ROUTING_GROUP_ID
, PDI.PA_REQUEST_ID
, PDI.DATE_FROM
, PDI.DATE_TO
, PDI.OPM_CERT_NUM
, PDI.FLSA
, PDI.FINANCIAL_STATEMENT
, PDI.SUBJECT_TO_IA_ACTION
, PDI.POSITION_STATUS
, PDI.POSITION_IS
, PDI.POSITION_SENSITIVITY
, PDI.COMPETITIVE_LEVEL
, PDI.PD_REMARKS
, PDI.POSITION_CLASS_STD
, PDI.CATEGORY
, PDI.CAREER_LADDER
, PDI.SUPERVISOR_NAME
, PDI.SUPERVISOR_TITLE
, PDI.SUPERVISOR_DATE
, PDI.MANAGER_NAME
, PDI.MANAGER_TITLE
, PDI.MANAGER_DATE
, PDI.CLASSIFIER_NAME
, PDI.CLASSIFIER_TITLE
, PDI.CLASSIFIER_DATE
, PDI.ATTRIBUTE_CATEGORY
, PDI.ATTRIBUTE1
, PDI.ATTRIBUTE2
, PDI.ATTRIBUTE3
, PDI.ATTRIBUTE4
, PDI.ATTRIBUTE5
, PDI.ATTRIBUTE6
, PDI.ATTRIBUTE7
, PDI.ATTRIBUTE8
, PDI.ATTRIBUTE9
, PDI.ATTRIBUTE10
, PDI.ATTRIBUTE11
, PDI.ATTRIBUTE12
, PDI.ATTRIBUTE13
, PDI.ATTRIBUTE14
, PDI.ATTRIBUTE15
, PDI.ATTRIBUTE16
, PDI.ATTRIBUTE17
, PDI.ATTRIBUTE18
, PDI.ATTRIBUTE19
, PDI.ATTRIBUTE20
, PDI.CREATED_BY
, PDI.CREATION_DATE
, PDI.LAST_UPDATED_BY
, PDI.LAST_UPDATE_DATE
, PDI.LAST_UPDATE_LOGIN
, PDI.OBJECT_VERSION_NUMBER
FROM GHR_POSITION_DESCRIPTIONS PDI