[Home] [Help] [Dependency Information]
Object Name: | PQH_GSP_ELECTABLE_CHOICE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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 | |
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 |
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;
|
|
|