[Home] [Help]
[Dependency Information]
[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;
APPS
FND_NUMBER
- show dependent code
GHR_PA_REMARKS
PUBLIC
GHR_PA_REMARKS_DFV
|
|
|
|