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.PQH_GSP_ELECTABLE_CHOICE_V

Object Details

Object Name:	PQH_GSP_ELECTABLE_CHOICE_V
Object Type:	VIEW
Owner:	APPS
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
ELIG_PER_ELCTBL_CHC_ID	NUMBER	(15)	Yes	Electable Choice Identifier
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group Identifier
GRADE_LADDER_ID	NUMBER	(15)		Grade Ladder Identifier - Organizing grades in a hierarchy
TYP_CD	VARCHAR2	(30)		Life Event Type Code (GSP)
GRADE_LADDER_NAME	VARCHAR2	(240)	Yes	Grade Ladder Name
CURRENCY_CODE	VARCHAR2	(30)		Currency used by the Grade Ladder
CURRENCY_NAME	VARCHAR2	(4000)		Currency Used by the grade ladder
PER_IN_LER_STAT_CD	VARCHAR2	(30)		Status of the person in life event
PL_ID	NUMBER	(15)		Plan Identifier - Linked to a grade Identifier
OIPL_ID	NUMBER	(15)		Option in Plan Identifier - Linked to a step Identifier
GRADE_ID	NUMBER			Grade Identifier
GRADE_NAME	VARCHAR2	(4000)		Grade Name
STEP_ID	NUMBER			Step Identifier
STEP_NAME	NUMBER			Step Name
PROGRESSION_DATE	DATE			Progression Date
PERSON_ID	NUMBER	(10)	Yes	Context Person Identifier
FIRST_NAME	VARCHAR2	(150)		First Name
FULL_NAME	VARCHAR2	(240)		Full Name
WORK_PHONE	VARCHAR2	(4000)		Work Phone
LOS	NUMBER			Length Of Service
CURRENT_GRADE_LADDER	NUMBER	(15)		Current Grade Ladder
CURRENT_GRADE_LADDER_NAME	VARCHAR2	(4000)		Current Grade Ladder Name
CURRENT_GRADE	NUMBER	(15)		Current Grade
CURRENT_GRADE_NAME	VARCHAR2	(4000)		Current Grade Name
CURRENT_STEP_ID	NUMBER			Current Step
CURRENT_STEP_NAME	NUMBER			Current Step Name
ORG	NUMBER	(15)	Yes	Organization
ORG_NAME	VARCHAR2	(4000)		Organization Name
POSITION	NUMBER	(15)		Position
POSITION_NAME	VARCHAR2	(4000)		Position Name
JOB	NUMBER	(15)		Job
JOB_NAME	VARCHAR2	(4000)		Job Name
LOCATION	NUMBER	(15)		Location
LOCATION_NAME	VARCHAR2	(4000)		Location Name
SUPERVISOR	NUMBER	(10)		Supervisor
MANAGER_NAME	VARCHAR2	(4000)		Manager Name (Supervisor)
EMP_NUMBER	VARCHAR2	(30)		Employee Number
DOB	DATE			Date Of Birth
HIRE_DATE	DATE		Yes	Hire Date
ORIG_HIRE_DATE	DATE			Original Hire Date
MARITAL_STATUS	VARCHAR2	(30)		Marital Status
EMAIL	VARCHAR2	(240)		Email Address
ASGT_STATUS_ID	NUMBER	(9)	Yes	Assignment Status Identifier
ASGT_STATUS	VARCHAR2	(4000)		Assignment Status
COLLECTIVE_AGREEMENT_ID	NUMBER	(9)		Collective Agreement Identifier
CAGR_NAME	VARCHAR2	(4000)		Collective Agreement
LIFE_EVENT_TYPE	VARCHAR2	(30)		Life Event Type
DFLT_PROGRESSION	VARCHAR2	(30)	Yes	Default Progression Flag (Yes/No)
CURRENT_SAL	NUMBER			Current Salary
PROPOSED_SAL	NUMBER			Proposed Salary
SAL_CHG_DT	DATE			Salary Change Date
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment Identifier
APPROVAL_STATUS_CD	VARCHAR2	(30)		Approval Status Code
PER_IN_LER_ID	NUMBER	(15)	Yes	Person in life event identifier
LIFE_EVENT_DT	DATE		Yes	Life Event Date
LAST_NAME	VARCHAR2	(150)	Yes	Last Name of Person
OFFICE_NUMBER	VARCHAR2	(45)		Office Number of Person
IN_PNDG_WKFLOW_FLAG	VARCHAR2	(30)		Indicates if employee is approved but on workflow pending status
REQUEST_ID	NUMBER	(15)		Concurrent Request Identifier
TOTAL_SCORE	NUMBER			Employee's total score
SYSTEM_RANK	NUMBER			System derived Rank of the employee based on the the score within the population
PROPOSED_RANK	NUMBER			Rank assigned by the manager
BEN_ACTION_ID	NUMBER			The benefits action Identifier associated with the participation process run
RATE_VAL	NUMBER			Rate Value
CURRENT_RATE_VALUE	NUMBER			Current Rate Value

Query Text

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


SELECT ELIG_PER_ELCTBL_CHC_ID
,      BUSINESS_GROUP_ID
,      GRADE_LADDER_ID
,      TYP_CD
,      GRADE_LADDER_NAME
,      CURRENCY_CODE
,      CURRENCY_NAME
,      PER_IN_LER_STAT_CD
,      PL_ID
,      OIPL_ID
,      GRADE_ID
,      GRADE_NAME
,      STEP_ID
,      STEP_NAME
,      PROGRESSION_DATE
,      PERSON_ID
,      FIRST_NAME
,      FULL_NAME
,      WORK_PHONE
,      LOS
,      CURRENT_GRADE_LADDER
,      CURRENT_GRADE_LADDER_NAME
,      CURRENT_GRADE
,      CURRENT_GRADE_NAME
,      CURRENT_STEP_ID
,      CURRENT_STEP_NAME
,      ORG
,      ORG_NAME
,      POSITION
,      POSITION_NAME
,      JOB
,      JOB_NAME
,      LOCATION
,      LOCATION_NAME
,      SUPERVISOR
,      MANAGER_NAME
,      EMP_NUMBER
,      DOB
,      HIRE_DATE
,      ORIG_HIRE_DATE
,      MARITAL_STATUS
,      EMAIL
,      ASGT_STATUS_ID
,      ASGT_STATUS
,      COLLECTIVE_AGREEMENT_ID
,      CAGR_NAME
,      LIFE_EVENT_TYPE
,      DFLT_PROGRESSION
,      CURRENT_SAL
,      PROPOSED_SAL
,      SAL_CHG_DT
,      ASSIGNMENT_ID
,      APPROVAL_STATUS_CD
,      PER_IN_LER_ID
,      LIFE_EVENT_DT
,      LAST_NAME
,      OFFICE_NUMBER
,      IN_PNDG_WKFLOW_FLAG
,      REQUEST_ID
,      TOTAL_SCORE
,      SYSTEM_RANK
,      PROPOSED_RANK
,      BEN_ACTION_ID
,      RATE_VAL
,      CURRENT_RATE_VALUE
FROM APPS.PQH_GSP_ELECTABLE_CHOICE_V;

Dependencies

[top of page]

APPS.PQH_GSP_ELECTABLE_CHOICE_V references the following:

APPS: BEN_BATCH_UTILS - show dependent code; BEN_ELIG_PER_ELCTBL_CHC; BEN_ENRT_RT; BEN_LER_F; BEN_PER_IN_LER; BEN_PGM_F; BEN_PL_F; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PER_ALL_ASSIGNMENTS_F; PER_PEOPLE_F; PQH_EMPLOYEE_SALARY - show dependent code; PQH_GSP_UTILITY - show dependent code; PQH_RANK_UTILITY - show dependent code

APPS.PQH_GSP_ELECTABLE_CHOICE_V is referenced by following:

APPS: PER_CAGR_UTILITY_PKG - show dependent code; PQH_GSP_PROCESS_LOG - show dependent code