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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.GHR_PD_COVERSHEET_V

Object Details

Object Name:	GHR_PD_COVERSHEET_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_PD_COVERSHEET_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_DESCRIPTION_ID	NUMBER	(15)	Yes	Position Description ID
PA_REQUEST_ID	NUMBER	(15)	Yes	PA Request ID
OPM_CERT_NUM	VARCHAR2	(20)		OPM Cert Num
FLSA	VARCHAR2	(1)		FLSA
FINANCIAL_STATEMENT	VARCHAR2	(1)		Financial Statement
SUBJECT_TO_IA_ACTION	VARCHAR2	(1)		Subject to IA Action
POSITION_STATUS	NUMBER	(1)		Position Status
POSITION_IS	VARCHAR2	(1)		Position IS
POSITION_SENSITIVITY	VARCHAR2	(1)		Position Sensitivity
COMPETITIVE_LEVEL	VARCHAR2	(4)		Competitive Level
PD_REMARKS	VARCHAR2	(2000)		PD Remarks
POSITION_CLASS_STD	VARCHAR2	(50)		Position Class STD
CATEGORY	VARCHAR2	(10)		Category
CAREER_LADDER	VARCHAR2	(1)		Career Ladder
SUPERVISOR_NAME	VARCHAR2	(240)		Supervisor Name
SUPERVISOR_TITLE	VARCHAR2	(240)		Supervisor Title
SUPERVISOR_DATE	DATE			Supervisor Date
MANAGER_NAME	VARCHAR2	(240)		Manager Name
MANAGER_TITLE	VARCHAR2	(240)		Manager Title
MANAGER_DATE	DATE			Manager Date
CLASSIFIER_NAME	VARCHAR2	(240)		Classifier Name
CLASSIFIER_TITLE	VARCHAR2	(240)		Classifier Title
CLASSIFIER_DATE	DATE			Classifier Date
POSITION_ID	NUMBER	(15)	Yes	Position ID
PERSON_ID	NUMBER	(10)		Person ID
D_FLSA	VARCHAR2	(4000)		FLSA Description
D_FINANCIAL_STATEMENT	VARCHAR2	(4000)		Financial Statment Description
D_SUBJECT_TO_IA_ACTION	VARCHAR2	(4000)		Subjec to IA Action Description
D_POSITION_STATUS	VARCHAR2	(4000)		Position Status Description
D_POSITION_IS	VARCHAR2	(4000)		Position IS Description
D_POSITION_SENSITIVITY	VARCHAR2	(4000)		Position Sensitiviy Description
D_COMPETITIVE_LEVEL	VARCHAR2	(4000)		Competitive Level Description
D_CAREER_LADDER	VARCHAR2	(4000)		Career Ladder Description
FULL_NAME	VARCHAR2	(240)		Full Name
EMPLOYING_OFFICE_LOC	VARCHAR2	(80)		Employing Office LOC
ORG_TITLE	VARCHAR2	(80)		Org Title
ORG_STRUCTURE_ID	VARCHAR2	(80)		Org Structure ID
REASON_FOR_SUBMISSION	VARCHAR2	(4000)		Reason for Submission
SERVICE	VARCHAR2	(4000)		Service
EXPLANATION	VARCHAR2	(80)		Explanation
AGENCY_USE	VARCHAR2	(80)		Agency Use
DUTY_STATION	VARCHAR2	(9)		Duty Station
AGENCY_POSITION_NUMBER	VARCHAR2	(56)		Agency Position Number
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category for the Descriptive Flexfield Column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT POSITION_DESCRIPTION_ID
,      PA_REQUEST_ID
,      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
,      POSITION_ID
,      PERSON_ID
,      D_FLSA
,      D_FINANCIAL_STATEMENT
,      D_SUBJECT_TO_IA_ACTION
,      D_POSITION_STATUS
,      D_POSITION_IS
,      D_POSITION_SENSITIVITY
,      D_COMPETITIVE_LEVEL
,      D_CAREER_LADDER
,      FULL_NAME
,      EMPLOYING_OFFICE_LOC
,      ORG_TITLE
,      ORG_STRUCTURE_ID
,      REASON_FOR_SUBMISSION
,      SERVICE
,      EXPLANATION
,      AGENCY_USE
,      DUTY_STATION
,      AGENCY_POSITION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM APPS.GHR_PD_COVERSHEET_V;

Dependencies

[top of page]

APPS.GHR_PD_COVERSHEET_V references the following:

APPS: FND_PROFILE - show dependent code; GHR_PA_REQUESTS; GHR_PD_COVERSHEET_DATA - show dependent code; GHR_POSITION_DESCRIPTIONS; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_POSITIONS_X; HR_SECURITY - show dependent code; PER_PEOPLE_X; PER_POSITION_EXTRA_INFO

APPS.GHR_PD_COVERSHEET_V is not referenced by any database object