[Home] [Help] [Dependency Information]
Object Name: | GHR_PA_REMARKS_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
TYPE | VARCHAR2 | (30) | ||
HOURS_PER_YEAR | VARCHAR2 | (2000) | ||
DAYS_PER_YEAR | VARCHAR2 | (2000) | ||
STATEMENT_DATE | DATE | |||
A22 | VARCHAR2 | (2000) | ||
SCD_DATE | DATE | |||
NO__OF_HOURS | VARCHAR2 | (150) | ||
CALENDAR_YEAR2 | VARCHAR2 | (150) | ||
REASON | VARCHAR2 | (2000) | ||
AGENCY_NAME_1 | VARCHAR2 | (2000) | ||
AGENCY_NAME_2 | VARCHAR2 | (2000) | ||
AGE_IN_YEARS | VARCHAR2 | (2000) | ||
ELECTED_ON | DATE | |||
AMOUNT | VARCHAR2 | (150) | ||
YEAR | NUMBER | |||
MONTHS | NUMBER | |||
PERIOD_S_ | VARCHAR2 | (150) | ||
FROM_DATE | DATE | |||
MD_DDS_SPECIAL_PAY_NTE_DATE | DATE | |||
RETIREMENT_TYPE | VARCHAR2 | (2000) | ||
BASED_ON | VARCHAR2 | (150) | ||
CORRECTS | VARCHAR2 | (2000) | ||
EFFECTIVE_DATE | DATE | |||
DATA_ITEM_NUMBER | VARCHAR2 | (2000) | ||
TO_ADD | VARCHAR2 | (150) | ||
SEPARATION_DATE | DATE | |||
AGENCY_NAME | VARCHAR2 | (2000) | ||
CORRECTED_FROM | VARCHAR2 | (150) | ||
DATE_FROM | DATE | |||
DATE_TO | DATE | |||
C14 | VARCHAR2 | (2000) | ||
EMPLOYING_OFFICE | VARCHAR2 | (2000) | ||
CORRECTED_ITEM | VARCHAR2 | (2000) | ||
TO_READ | VARCHAR2 | (150) | ||
DATE_FROM_1 | DATE | |||
DATE_FROM_2 | DATE | |||
C21 | VARCHAR2 | (150) | ||
ACTIVE_DUTY_FROM | VARCHAR2 | (2000) | ||
COMPLETION_DATE | DATE | |||
PROBATION_BEGINS | DATE | |||
TRIAL_PERIOD_BEGINS | DATE | |||
SES_PROBATION_BEGINS | DATE | |||
PROBATION_TYPE | VARCHAR2 | (2000) | ||
TO_DATE | DATE | |||
TOTAL_HOURS | VARCHAR2 | (2000) | ||
INTERMITTENT_HOURS | VARCHAR2 | (2000) | ||
CALENDAR_YEAR | VARCHAR2 | (2000) | ||
HOURS | VARCHAR2 | (150) | ||
SELECTED_FROM | VARCHAR2 | (2000) | ||
DATED | DATE | |||
FROM_PROMOTION_NTE | DATE | |||
PAY_PLAN | VARCHAR2 | (2000) | ||
GRADE__LEVEL__OR_BAND | VARCHAR2 | (150) | ||
PROMOTED_FROM | VARCHAR2 | (2000) | ||
INSTITUTION | VARCHAR2 | (2000) | ||
POSITION_CHANGE_NTE | DATE | |||
REASON_FOR_APPOINTMENT | VARCHAR2 | (2000) | ||
UNIFORMED_SERVICE | VARCHAR2 | (2000) | ||
RETIREMENT_DATE | VARCHAR2 | (150) | ||
EXCEPTION | VARCHAR2 | (150) | ||
DATE_OF_TRANSFER | VARCHAR2 | (150) | ||
OPF_MAINTAINED_BY | VARCHAR2 | (2000) | ||
CONTINUES_PROMOTION_NTE | DATE | |||
TOUR_OF_DUTY | VARCHAR2 | (2000) | ||
NONPAY_AGENCY | VARCHAR2 | (2000) | ||
POSITION_OR_AGENCY | VARCHAR2 | (2000) | ||
DATE_ | DATE | |||
ENTER_YRS__AND_MOS_ | VARCHAR2 | (2000) | ||
PREVIOUSLY_COVERED | VARCHAR2 | (2000) | ||
OPM_OFFICE_ | VARCHAR2 | (2000) | ||
DATE_OF_ELECTION | DATE | |||
TYPE_OF_APPOINTMENT | VARCHAR2 | (2000) | ||
CASE_OBTAINED_FROM | VARCHAR2 | (2000) | ||
PERIOD_LENGTH | VARCHAR2 | (150) | ||
INTERNATIONAL_ORGANIZATION | VARCHAR2 | (150) | ||
AUTHORITY | VARCHAR2 | (150) | ||
FORWARDING_ADDRESS | VARCHAR2 | (2000) | ||
REASON_FOR_NONPAY_STATUS | VARCHAR2 | (2000) | ||
REASON_FOR_FURLOUGH | VARCHAR2 | (2000) | ||
FURLOUGH_DATE | DATE | |||
NUMBER_OF_HOURS | VARCHAR2 | (2000) | ||
NOTIFICATION_BLOCK_NUM__S | VARCHAR2 | (2000) | ||
POSITION_INFORMATION | VARCHAR2 | (2000) | ||
SERIES | VARCHAR2 | (150) | ||
LOCATION | VARCHAR2 | (150) | ||
DATE_APPROVED | DATE | |||
NTE_DATE | DATE | |||
RIF_SEPARATION_DATE | DATE | |||
BENEFITS_COVERAGE | VARCHAR2 | (150) | ||
RIF_SEPARATION_FROM_DATE | DATE | |||
RIF_SEPARATION_TO_DATE | DATE | |||
RIF_EFFECTIVE_FROM_DATE | DATE | |||
RIF_EFFECTIVE_TO_DATE | DATE | |||
REASON_RETAINED | VARCHAR2 | (150) | ||
RIF_SEPARATION_REASON | DATE | |||
DATE1 | DATE | |||
AGENCY_RESPONSIBLE | VARCHAR2 | (2000) | ||
SEVERANCE_PAY_AMOUNT | VARCHAR2 | (2000) | ||
WEEKLY_AMOUNT | VARCHAR2 | (150) | ||
NUMBER_OF_WEEKS | VARCHAR2 | (2000) | ||
BEGINNING_DATE | DATE | |||
TERMINATING_AGENCY | VARCHAR2 | (2000) | ||
ENDING_DATE_AND_HOUR | DATE | |||
FISCAL_YEAR | VARCHAR2 | (2000) | ||
SUGGESTION_NUMBER | VARCHAR2 | (2000) | ||
INVENTION_NUMBER | VARCHAR2 | (2000) | ||
PATENT_NUMBER | VARCHAR2 | (2000) | ||
OPF_RETAINED_BY | VARCHAR2 | (2000) | ||
PAY_PLAN__GRADE__RATE | VARCHAR2 | (2000) | ||
RATE | VARCHAR2 | (150) | ||
SPECIAL_RATE_TABLE | VARCHAR2 | (2000) | ||
ADJUSTED_DATE | DATE | |||
ANNUITY_AMOUNT | VARCHAR2 | (2000) | ||
ELIGIBILITY_DATE | DATE | |||
ADJUSTED_HOURS | VARCHAR2 | (2000) | ||
TO_STEP | VARCHAR2 | (2000) | ||
GS_NUMBER | VARCHAR2 | (150) | ||
STEP_NUMBER | VARCHAR2 | (2000) | ||
GRADE_AND_STEP | VARCHAR2 | (2000) | ||
DUE_DATE | DATE | |||
ENTITLED_TO_DATE | DATE | |||
STEP | VARCHAR2 | (150) | ||
RETAINED_RATE_EXPIRES | DATE | |||
RETAINED_RATE_AMOUNT | VARCHAR2 | (150) | ||
ACTIONS_EFFECTIVE | VARCHAR2 | (2000) | ||
PAYABLE_AMOUNT | VARCHAR2 | (2000) | ||
APPROVAL_DATE | DATE | |||
RETENTION_ALLOWANCE | VARCHAR2 | (2000) | ||
STAFFING_DIFFERENTIAL | VARCHAR2 | (2000) | ||
SUPERVISORY_DIFFERENTIAL | VARCHAR2 | (2000) | ||
RETENTION_ALLOWANCE_AMOUNT | VARCHAR2 | (2000) | ||
SUPERVISORY_DIFFERENTIAL_AMT | VARCHAR2 | (2000) | ||
AUO_AMOUNT | VARCHAR2 | (2000) | ||
SPECIAL_PAY_AMOUNT | VARCHAR2 | (2000) | ||
PERCENTAGE | VARCHAR2 | (2000) | ||
AVAILABILITY_PAY_AMOUNT | VARCHAR2 | (2000) | ||
REASON_FOR_RESIGNATION | VARCHAR2 | (2000) | ||
REASON_FOR_RETIREMENT | VARCHAR2 | (2000) | ||
REASON_FOR_DECLINATION | VARCHAR2 | (2000) | ||
REASON_FOR_REFUSAL | VARCHAR2 | (2000) | ||
REASON_FOR_ABANDONMENT | VARCHAR2 | (2000) | ||
AGENCY_FINDING | VARCHAR2 | (2000) | ||
NOTICE_DATE | DATE | |||
AGENCY_REASONS | VARCHAR2 | (150) | ||
RULE_OR_REGULATION | VARCHAR2 | (150) | ||
REASON_FOR_REMOVAL | VARCHAR2 | (2000) | ||
REASON_FOR_TERMINATION | VARCHAR2 | (2000) | ||
REASON_FOR_SUSPENSION | VARCHAR2 | (2000) | ||
RIF_NOTICE_DATED | DATE | |||
OFFERED_JOBS_OF | VARCHAR2 | (2000) | ||
REASON_FOR_SEPARATION | VARCHAR2 | (150) | ||
DAYS_DATES_OF_SUSPENSION | VARCHAR2 | (2000) | ||
REASON_FOR_PLACEMENT_OUT | VARCHAR2 | (150) | ||
ESTIMATED_CONVERSION_DATE | DATE | |||
NEW_CONVERSION_DATE | DATE | |||
SERVICE_FROM_DATE | DATE | |||
SERVICE_TO_DATE | DATE | |||
CHANGE_IN_TENURE_REASON | VARCHAR2 | (2000) | ||
PAY_PLAN__GRAD__RATE_1 | VARCHAR2 | (2000) | ||
PAY_PLAN__GRAD__RATE_2 | VARCHAR2 | (150) | ||
PAY_PLAN_AND_GRADE | VARCHAR2 | (2000) | ||
RETAIN_THROUGH_DATE | DATE | |||
RETAINED_THROUGH_DATE | DATE | |||
POSITION_TITLE | VARCHAR2 | (2000) | ||
GRADE__LEVEL_OR_BAND | VARCHAR2 | (150) | ||
REMARKS | VARCHAR2 | (2000) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (2484) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TYPE
, HOURS_PER_YEAR
, DAYS_PER_YEAR
, STATEMENT_DATE
, A22
, SCD_DATE
, NO__OF_HOURS
, CALENDAR_YEAR2
, REASON
, AGENCY_NAME_1
, AGENCY_NAME_2
, AGE_IN_YEARS
, ELECTED_ON
, AMOUNT
, YEAR
, MONTHS
, PERIOD_S_
, FROM_DATE
, MD_DDS_SPECIAL_PAY_NTE_DATE
, RETIREMENT_TYPE
, BASED_ON
, CORRECTS
, EFFECTIVE_DATE
, DATA_ITEM_NUMBER
, TO_ADD
, SEPARATION_DATE
, AGENCY_NAME
, CORRECTED_FROM
, DATE_FROM
, DATE_TO
, C14
, EMPLOYING_OFFICE
, CORRECTED_ITEM
, TO_READ
, DATE_FROM_1
, DATE_FROM_2
, C21
, ACTIVE_DUTY_FROM
, COMPLETION_DATE
, PROBATION_BEGINS
, TRIAL_PERIOD_BEGINS
, SES_PROBATION_BEGINS
, PROBATION_TYPE
, TO_DATE
, TOTAL_HOURS
, INTERMITTENT_HOURS
, CALENDAR_YEAR
, HOURS
, SELECTED_FROM
, DATED
, FROM_PROMOTION_NTE
, PAY_PLAN
, GRADE__LEVEL__OR_BAND
, PROMOTED_FROM
, INSTITUTION
, POSITION_CHANGE_NTE
, REASON_FOR_APPOINTMENT
, UNIFORMED_SERVICE
, RETIREMENT_DATE
, EXCEPTION
, DATE_OF_TRANSFER
, OPF_MAINTAINED_BY
, CONTINUES_PROMOTION_NTE
, TOUR_OF_DUTY
, NONPAY_AGENCY
, POSITION_OR_AGENCY
, DATE_
, ENTER_YRS__AND_MOS_
, PREVIOUSLY_COVERED
, OPM_OFFICE_
, DATE_OF_ELECTION
, TYPE_OF_APPOINTMENT
, CASE_OBTAINED_FROM
, PERIOD_LENGTH
, INTERNATIONAL_ORGANIZATION
, AUTHORITY
, FORWARDING_ADDRESS
, REASON_FOR_NONPAY_STATUS
, REASON_FOR_FURLOUGH
, FURLOUGH_DATE
, NUMBER_OF_HOURS
, NOTIFICATION_BLOCK_NUM__S
, POSITION_INFORMATION
, SERIES
, LOCATION
, DATE_APPROVED
, NTE_DATE
, RIF_SEPARATION_DATE
, BENEFITS_COVERAGE
, RIF_SEPARATION_FROM_DATE
, RIF_SEPARATION_TO_DATE
, RIF_EFFECTIVE_FROM_DATE
, RIF_EFFECTIVE_TO_DATE
, REASON_RETAINED
, RIF_SEPARATION_REASON
, DATE1
, AGENCY_RESPONSIBLE
, SEVERANCE_PAY_AMOUNT
, WEEKLY_AMOUNT
, NUMBER_OF_WEEKS
, BEGINNING_DATE
, TERMINATING_AGENCY
, ENDING_DATE_AND_HOUR
, FISCAL_YEAR
, SUGGESTION_NUMBER
, INVENTION_NUMBER
, PATENT_NUMBER
, OPF_RETAINED_BY
, PAY_PLAN__GRADE__RATE
, RATE
, SPECIAL_RATE_TABLE
, ADJUSTED_DATE
, ANNUITY_AMOUNT
, ELIGIBILITY_DATE
, ADJUSTED_HOURS
, TO_STEP
, GS_NUMBER
, STEP_NUMBER
, GRADE_AND_STEP
, DUE_DATE
, ENTITLED_TO_DATE
, STEP
, RETAINED_RATE_EXPIRES
, RETAINED_RATE_AMOUNT
, ACTIONS_EFFECTIVE
, PAYABLE_AMOUNT
, APPROVAL_DATE
, RETENTION_ALLOWANCE
, STAFFING_DIFFERENTIAL
, SUPERVISORY_DIFFERENTIAL
, RETENTION_ALLOWANCE_AMOUNT
, SUPERVISORY_DIFFERENTIAL_AMT
, AUO_AMOUNT
, SPECIAL_PAY_AMOUNT
, PERCENTAGE
, AVAILABILITY_PAY_AMOUNT
, REASON_FOR_RESIGNATION
, REASON_FOR_RETIREMENT
, REASON_FOR_DECLINATION
, REASON_FOR_REFUSAL
, REASON_FOR_ABANDONMENT
, AGENCY_FINDING
, NOTICE_DATE
, AGENCY_REASONS
, RULE_OR_REGULATION
, REASON_FOR_REMOVAL
, REASON_FOR_TERMINATION
, REASON_FOR_SUSPENSION
, RIF_NOTICE_DATED
, OFFERED_JOBS_OF
, REASON_FOR_SEPARATION
, DAYS_DATES_OF_SUSPENSION
, REASON_FOR_PLACEMENT_OUT
, ESTIMATED_CONVERSION_DATE
, NEW_CONVERSION_DATE
, SERVICE_FROM_DATE
, SERVICE_TO_DATE
, CHANGE_IN_TENURE_REASON
, PAY_PLAN__GRAD__RATE_1
, PAY_PLAN__GRAD__RATE_2
, PAY_PLAN_AND_GRADE
, RETAIN_THROUGH_DATE
, RETAINED_THROUGH_DATE
, POSITION_TITLE
, GRADE__LEVEL_OR_BAND
, REMARKS
, CONCATENATED_SEGMENTS
FROM APPS.GHR_PA_REMARKS_DFV;
|
|
|