[Home] [Help] [Dependency Information]
Object Name: | GHR_MASS_AWARDS_PREVIEW_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GHR.GHR_MASS_AWARDS_PREVIEW_V |
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 |
---|---|---|---|---|
MASS_AWARD_ID | NUMBER | (15) | Mass Award ID | |
PA_REQUEST_ID | NUMBER | (15) | Yes | Personnel Action request ID |
PERSON_ID | NUMBER | (10) | Person ID | |
EFFECTIVE_DATE | DATE | Effective Date | ||
SELECT_FLAG | VARCHAR2 | (1) | Select Flag | |
EMPLOYEE_LAST_NAME | VARCHAR2 | (150) | Employee Last Name | |
EMPLOYEE_FIRST_NAME | VARCHAR2 | (150) | Employee First Name | |
EMPLOYEE_MIDDLE_NAMES | VARCHAR2 | (60) | Employee Middle Names | |
EMPLOYEE_NATIONAL_IDENTIFIER | VARCHAR2 | (30) | Employee National Identifier | |
AWARD_AMOUNT | NUMBER | (15) | Award Amount | |
AWARD_UOM | VARCHAR2 | (30) | Award Unit of Measure | |
AWARD_PERCENTAGE | NUMBER | (5) | Award Percentage | |
AWARD_AGENCY_CODE | VARCHAR2 | (150) | Award Agency Code | |
AWARD_TYPE | VARCHAR2 | (150) | Award type | |
GROUP_AWARD_ID | VARCHAR2 | (150) | Group Award ID | |
TANGIBLE_BENEFIT_DOLLARS | VARCHAR2 | (150) | Tangible Benefit Dollars | |
DATE_AWARD_EARNED | VARCHAR2 | (150) | Date Award Earned | |
BASIC_PAY | NUMBER | (15) | Basic Pay | |
ORGANIZATION_ID | NUMBER | (15) | Organization ID | |
DUTY_STATION_CODE | VARCHAR2 | (9) | Duty Station Code | |
DUTY_STATION_DESC | VARCHAR2 | (150) | Duty Station Description | |
AGENCY_CODE | VARCHAR2 | (30) | Agency Code | |
AGENCY_CODE_DESC | VARCHAR2 | (80) | Agency Code Description | |
POI | VARCHAR2 | (4) | Personnel Office ID | |
POSITION_OCCUPIED | VARCHAR2 | (30) | Position Occupied | |
POSITION_TITLE | VARCHAR2 | (240) | Position Title | |
PAY_PLAN | VARCHAR2 | (2) | Pay Plan | |
GRADE_OR_LEVEL | VARCHAR2 | (30) | Grade or Level | |
OCC_CODE | VARCHAR2 | (150) | Occ. Code | |
OFFICE_SYMBOL | VARCHAR2 | (30) | Office Symbol | |
COMMENTS | VARCHAR2 | (255) | Comments | |
AWARD_SALARY | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_AWARD_ID
, PA_REQUEST_ID
, PERSON_ID
, EFFECTIVE_DATE
, SELECT_FLAG
, EMPLOYEE_LAST_NAME
, EMPLOYEE_FIRST_NAME
, EMPLOYEE_MIDDLE_NAMES
, EMPLOYEE_NATIONAL_IDENTIFIER
, AWARD_AMOUNT
, AWARD_UOM
, AWARD_PERCENTAGE
, AWARD_AGENCY_CODE
, AWARD_TYPE
, GROUP_AWARD_ID
, TANGIBLE_BENEFIT_DOLLARS
, DATE_AWARD_EARNED
, BASIC_PAY
, ORGANIZATION_ID
, DUTY_STATION_CODE
, DUTY_STATION_DESC
, AGENCY_CODE
, AGENCY_CODE_DESC
, POI
, POSITION_OCCUPIED
, POSITION_TITLE
, PAY_PLAN
, GRADE_OR_LEVEL
, OCC_CODE
, OFFICE_SYMBOL
, COMMENTS
, AWARD_SALARY
FROM APPS.GHR_MASS_AWARDS_PREVIEW_V;
APPS.GHR_MASS_AWARDS_PREVIEW_V is not referenced by any database object
|
|
|