[Home] [Help] [Dependency Information]
Object Name: | GHR_PA_REQUEST_SHADOW# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PA_REQUEST_ID | NUMBER | (15) | Yes | |
ACADEMIC_DISCIPLINE | VARCHAR2 | (30) | ||
ANNUITANT_INDICATOR | VARCHAR2 | (30) | ||
APPROPRIATION_CODE1 | VARCHAR2 | (30) | ||
APPROPRIATION_CODE2 | VARCHAR2 | (30) | ||
BARGAINING_UNIT_STATUS | VARCHAR2 | (30) | ||
CITIZENSHIP | VARCHAR2 | (30) | ||
DUTY_STATION_ID | NUMBER | (15) | ||
DUTY_STATION_LOCATION_ID | NUMBER | (15) | ||
EDUCATION_LEVEL | VARCHAR2 | (30) | ||
EMPLOYEE_DATE_OF_BIRTH | DATE | |||
EMPLOYEE_FIRST_NAME | VARCHAR2 | (150) | ||
EMPLOYEE_LAST_NAME | VARCHAR2 | (150) | ||
EMPLOYEE_MIDDLE_NAMES | VARCHAR2 | (60) | ||
EMPLOYEE_NATIONAL_IDENTIFIER | VARCHAR2 | (30) | ||
FEGLI | VARCHAR2 | (30) | ||
FLSA_CATEGORY | VARCHAR2 | (30) | ||
FORWARDING_ADDRESS_LINE1 | VARCHAR2 | (240) | ||
FORWARDING_ADDRESS_LINE2 | VARCHAR2 | (240) | ||
FORWARDING_ADDRESS_LINE3 | VARCHAR2 | (240) | ||
FORWARDING_COUNTRY_SHORT_NAME | VARCHAR2 | (80) | ||
FORWARDING_POSTAL_CODE | VARCHAR2 | (30) | ||
FORWARDING_REGION_2 | VARCHAR2 | (120) | ||
FORWARDING_TOWN_OR_CITY | VARCHAR2 | (30) | ||
FUNCTIONAL_CLASS | VARCHAR2 | (30) | ||
PART_TIME_HOURS | NUMBER | (5) | ||
PAY_RATE_DETERMINANT | VARCHAR2 | (30) | ||
POSITION_OCCUPIED | VARCHAR2 | (30) | ||
RETIREMENT_PLAN | VARCHAR2 | (30) | ||
SERVICE_COMP_DATE | DATE | |||
SUPERVISORY_STATUS | VARCHAR2 | (30) | ||
TENURE | VARCHAR2 | (30) | ||
TO_AP_PREMIUM_PAY_INDICATOR | VARCHAR2 | (30) | ||
TO_AUO_PREMIUM_PAY_INDICATOR | VARCHAR2 | (30) | ||
TO_OCC_CODE | VARCHAR2 | (30) | ||
TO_POSITION_ID | NUMBER | (15) | ||
TO_RETENTION_ALLOWANCE | NUMBER | (15) | ||
TO_RETENTION_ALLOW_PERCENTAGE | NUMBER | (5) | ||
TO_STAFFING_DIFFERENTIAL | NUMBER | (15) | ||
TO_STAFFING_DIFF_PERCENTAGE | NUMBER | (5) | ||
TO_STEP_OR_RATE | VARCHAR2 | (30) | ||
TO_SUPERVISORY_DIFFERENTIAL | NUMBER | (15) | ||
TO_SUPERVISORY_DIFF_PERCENTAGE | NUMBER | (5) | ||
VETERANS_PREFERENCE | VARCHAR2 | (30) | ||
VETERANS_PREF_FOR_RIF | VARCHAR2 | (30) | ||
VETERANS_STATUS | VARCHAR2 | (30) | ||
WORK_SCHEDULE | VARCHAR2 | (30) | ||
YEAR_DEGREE_ATTAINED | NUMBER | (4) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
AWARD_AMOUNT | NUMBER | (15) | ||
AWARD_UOM | VARCHAR2 | (30) | ||
AWARD_PERCENTAGE | NUMBER | (5) | ||
TO_GRADE_OR_LEVEL | VARCHAR2 | (30) | ||
TO_GRADE_ID | NUMBER | (15) | ||
FIRST_ACTION_LA_CODE1 | VARCHAR2 | (30) | ||
FIRST_ACTION_LA_CODE2 | VARCHAR2 | (30) | ||
SECOND_ACTION_LA_CODE1 | VARCHAR2 | (30) | ||
SECOND_ACTION_LA_CODE2 | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PA_REQUEST_ID
, ACADEMIC_DISCIPLINE
, ANNUITANT_INDICATOR
, APPROPRIATION_CODE1
, APPROPRIATION_CODE2
, BARGAINING_UNIT_STATUS
, CITIZENSHIP
, DUTY_STATION_ID
, DUTY_STATION_LOCATION_ID
, EDUCATION_LEVEL
, EMPLOYEE_DATE_OF_BIRTH
, EMPLOYEE_FIRST_NAME
, EMPLOYEE_LAST_NAME
, EMPLOYEE_MIDDLE_NAMES
, EMPLOYEE_NATIONAL_IDENTIFIER
, FEGLI
, FLSA_CATEGORY
, FORWARDING_ADDRESS_LINE1
, FORWARDING_ADDRESS_LINE2
, FORWARDING_ADDRESS_LINE3
, FORWARDING_COUNTRY_SHORT_NAME
, FORWARDING_POSTAL_CODE
, FORWARDING_REGION_2
, FORWARDING_TOWN_OR_CITY
, FUNCTIONAL_CLASS
, PART_TIME_HOURS
, PAY_RATE_DETERMINANT
, POSITION_OCCUPIED
, RETIREMENT_PLAN
, SERVICE_COMP_DATE
, SUPERVISORY_STATUS
, TENURE
, TO_AP_PREMIUM_PAY_INDICATOR
, TO_AUO_PREMIUM_PAY_INDICATOR
, TO_OCC_CODE
, TO_POSITION_ID
, TO_RETENTION_ALLOWANCE
, TO_RETENTION_ALLOW_PERCENTAGE
, TO_STAFFING_DIFFERENTIAL
, TO_STAFFING_DIFF_PERCENTAGE
, TO_STEP_OR_RATE
, TO_SUPERVISORY_DIFFERENTIAL
, TO_SUPERVISORY_DIFF_PERCENTAGE
, VETERANS_PREFERENCE
, VETERANS_PREF_FOR_RIF
, VETERANS_STATUS
, WORK_SCHEDULE
, YEAR_DEGREE_ATTAINED
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, AWARD_AMOUNT
, AWARD_UOM
, AWARD_PERCENTAGE
, TO_GRADE_OR_LEVEL
, TO_GRADE_ID
, FIRST_ACTION_LA_CODE1
, FIRST_ACTION_LA_CODE2
, SECOND_ACTION_LA_CODE1
, SECOND_ACTION_LA_CODE2
FROM HR.GHR_PA_REQUEST_SHADOW#;
|
|
|