FND Design Data [Home] [Help]

View: GHR_POSITION_DESCRIPTIONS_V

Product: GHR - US Federal Human Resources
Description: Position Description deatils
Implementation/DBA Data: ViewAPPS.GHR_POSITION_DESCRIPTIONS_V
View Text

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

Columns

Name
ROW_ID
POSITION_DESCRIPTION_ID
BUSINESS_GROUP_ID
ROUTING_GROUP_ID
PA_REQUEST_ID
DATE_FROM
DATE_TO
OPM_CERT_NUM
FLSA
FINANCIAL_STATEMENT
SUBJECT_TO_IA_ACTION
POSITION_STATUS
POSITION_IS
POSITION_SENSITIVITY
COMPETITIVE_LEVEL
PD_REMARKS
POSITION_CLASS_STD
CATEGORY
CAREER_LADDER
SUPERVISOR_NAME
SUPERVISOR_TITLE
SUPERVISOR_DATE
MANAGER_NAME
MANAGER_TITLE
MANAGER_DATE
CLASSIFIER_NAME
CLASSIFIER_TITLE
CLASSIFIER_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER