[Home] [Help] [Dependency Information]

VIEW: APPS.PER_POSITION_EXTRA_INFO1_DFV

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      TYPE
,      START_DATE
,      END_DATE
,      STELLEN_ID
,      FTE
,      DATE_FROM
,      DATE_TO
,      POSITION_DESCRIPTION_ID
,      INTERDISCIPLINARY_SERIES_CODE
,      INTERDISCIPLINARY_TITLE_CODE
,      INTERDISCIPLINARY_TITLE_PREFIX
,      INTERDISCIPLINARY_TITLE_SUFFIX
,      LANGUAGE_IDENTIFIER
,      LANGUAGE_PROFICIENCY_LEVEL
,      LANGUAGE_READING_PROFICIENCY
,      LANGUAGE_SPEAKING_PROFICIENCY
,      LANGUAGE_LISTENING_PROFICIENCY
,      LANGUAGE_WRITING_PROFICIENCY
,      LANGUAGE_PROFICIENCY_TEST_DATE
,      PERSONNEL_SYSTEM_INDICATOR
,      PERSONNEL_OFFICE_ID
,      OFFICE_SYMBOL
,      OPM_ORGANIZATIONAL_COMPONENT
,      OCCUPATION_CATEGORY_CODE
,      FLSA_CATEGORY
,      BARGAINING_UNIT_STATUS
,      COMPETITIVE_LEVEL
,      COMPETITIVE_AREA
,      WORK_SCHEDULE
,      PART_TIME_HOURS_BIWEEKLY
,      FUNCTIONAL_CLASS
,      POSITION_WORKING_TITLE
,      POSITION_SENSITIVITY
,      SECURITY_ACCESS
,      PRP_SCI
,      SUPERVISORY_STATUS
,      TYPE_EMPLOYEE_SUPERVISED
,      SUPERVISORY_DIFF_ELIGIBLITY
,      PAYROLL_OFFICE_ID
,      TIMEKEEPER
,      POSITION_S_ORGANIZATION
,      PAYROLL_OFFICE_NUMBER
,      POSITION_TYPE
,      POSITION_OCCUPIED
,      ORGANIZATION_FUNCTION_CODE
,      DATE_POSITION_CLASSIFIED
,      DATE_LAST_POSITION_AUDIT
,      CLASSIFICATION_OFFICIAL
,      LANGUAGE_REQUIRED
,      DRUG_TEST
,      FINANCIAL_STATEMENT
,      TRAINING_PROGRAM_ID
,      KEY_EMERGENCY_ESSENTIAL
,      APPROPRIATION_CODE_1
,      APPROPRIATION_CODE_2
,      INTELLIGENCE_POSITION_IND
,      LEO_POSITION_INDICATOR
,      ENVIRONMENTAL_HAZARD_DIFF
,      COMPUTER_POSITION_INDICATOR
,      EDP_HDP_LAST_REVIEW_DATE
,      NFC_AGENCY_CODE
,      WORKING_TITLE_CODE
,      OFFICIAL_TITLE_PREFIX
,      OFFICIAL_TITLE_SUFFIX
,      OFFICIAL_TITLE_CODE
,      HEADQUARTERS_FIELD_CODE
,      CLASSIFICATION_STANDARD_CODE
,      MAINTENANCE_REVIEW_CODE
,      CLASSIFICATION_ACTION_CODE
,      POJECTED_DUTIES_INDICATOR
,      VACANCY_REVIEW_CODE
,      POSITION_SCHEDULE
,      GRADE_BASIS_INDICATOR
,      PROCUREMENT_INTEGRITY_ACT
,      PRESIDENTIAL_APPOINTMENT_INDIC
,      ACCOUNTING_STATION
,      CUSTOMS_OFFICER_PAY_REFORM
,      EARLY_RETIREMENT_INDICATOR
,      DATE_CLASSFN_REQUEST_RECD
,      MASS_REALIGNMENT_FLAG
,      MASS_REALIGNMENT_REMARKS
,      MASS_REALIGNMENT_NAME
,      AGENCY_CODE__SUBELEM
,      DUTY_STATION_CODE
,      MASS_TRANSFER_OUT_FLAG
,      MASS_TRANSFER_OUT_REMARKS
,      MASS_TRANSFER_OUT_NAME
,      DUTY_STATION_LOCATION_ID
,      MASS_TABLE_CHANGE_FLAG
,      MASS_TABLE_CHANGE_REMARKS
,      MASS_TABLE_CHANGE_NAME
,      EXPIRATION_DATE
,      OBLIGATED_TYPE
,      OBLIGATED_EMPLOYEE_SSN
,      VALID_GRADE
,      TARGET_GRADE
,      PAY_TABLE_ID
,      PAY_BASIS
,      EMPLOYMENT_CATEGORY_GROUP
,      PROFESSIONAL_CATEGORY
,      CLINICAL_SPECIALTY
,      PHYS_AND_DENT_PAY_RANGE_TABLE
,      PHYSICIAN_AND_DENTIST_TIER
,      POSITION_FAMILY
,      OVERLAP_START_DATE
,      OVERLAP_END_DATE
,      BEGIN_DATE
,      RESERVATION_END_DATE
,      PERSON
,      FTE_RESERVED
,      RESERVED_STATUS
,      SEASON_START_DATE
,      SEASON_END_DATE
,      KEY_ROLE
,      TURNOVER_RATE
,      ROLE_ID
,      CONCATENATED_SEGMENTS
FROM APPS.PER_POSITION_EXTRA_INFO1_DFV;

Dependencies

[top of page]

APPS

FND_NUMBER - show dependent code

PER_POSITION_EXTRA_INFO

PUBLIC

PER_POSITION_EXTRA_INFO1_DFV