[Home] [Help] [Dependency Information]
Object Name: | PER_POSITION_EXTRA_INFO1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
TYPE | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
STELLEN_ID | NUMBER | |||
FTE | VARCHAR2 | (150) | ||
DATE_FROM | DATE | |||
DATE_TO | DATE | |||
POSITION_DESCRIPTION_ID | VARCHAR2 | (150) | ||
INTERDISCIPLINARY_SERIES_CODE | VARCHAR2 | (150) | ||
INTERDISCIPLINARY_TITLE_CODE | VARCHAR2 | (150) | ||
INTERDISCIPLINARY_TITLE_PREFIX | VARCHAR2 | (150) | ||
INTERDISCIPLINARY_TITLE_SUFFIX | VARCHAR2 | (150) | ||
LANGUAGE_IDENTIFIER | VARCHAR2 | (150) | ||
LANGUAGE_PROFICIENCY_LEVEL | VARCHAR2 | (150) | ||
LANGUAGE_READING_PROFICIENCY | VARCHAR2 | (150) | ||
LANGUAGE_SPEAKING_PROFICIENCY | VARCHAR2 | (150) | ||
LANGUAGE_LISTENING_PROFICIENCY | VARCHAR2 | (150) | ||
LANGUAGE_WRITING_PROFICIENCY | VARCHAR2 | (150) | ||
LANGUAGE_PROFICIENCY_TEST_DATE | DATE | |||
PERSONNEL_SYSTEM_INDICATOR | VARCHAR2 | (150) | ||
PERSONNEL_OFFICE_ID | VARCHAR2 | (150) | ||
OFFICE_SYMBOL | VARCHAR2 | (150) | ||
OPM_ORGANIZATIONAL_COMPONENT | VARCHAR2 | (150) | ||
OCCUPATION_CATEGORY_CODE | VARCHAR2 | (150) | ||
FLSA_CATEGORY | VARCHAR2 | (150) | ||
BARGAINING_UNIT_STATUS | VARCHAR2 | (150) | ||
COMPETITIVE_LEVEL | VARCHAR2 | (150) | ||
COMPETITIVE_AREA | VARCHAR2 | (150) | ||
WORK_SCHEDULE | VARCHAR2 | (150) | ||
PART_TIME_HOURS_BIWEEKLY | NUMBER | |||
FUNCTIONAL_CLASS | VARCHAR2 | (150) | ||
POSITION_WORKING_TITLE | VARCHAR2 | (150) | ||
POSITION_SENSITIVITY | VARCHAR2 | (150) | ||
SECURITY_ACCESS | VARCHAR2 | (150) | ||
PRP_SCI | VARCHAR2 | (150) | ||
SUPERVISORY_STATUS | VARCHAR2 | (150) | ||
TYPE_EMPLOYEE_SUPERVISED | VARCHAR2 | (150) | ||
SUPERVISORY_DIFF_ELIGIBLITY | VARCHAR2 | (150) | ||
PAYROLL_OFFICE_ID | VARCHAR2 | (150) | ||
TIMEKEEPER | VARCHAR2 | (150) | ||
POSITION_S_ORGANIZATION | VARCHAR2 | (150) | ||
PAYROLL_OFFICE_NUMBER | VARCHAR2 | (150) | ||
POSITION_TYPE | VARCHAR2 | (150) | ||
POSITION_OCCUPIED | VARCHAR2 | (150) | ||
ORGANIZATION_FUNCTION_CODE | VARCHAR2 | (150) | ||
DATE_POSITION_CLASSIFIED | DATE | |||
DATE_LAST_POSITION_AUDIT | DATE | |||
CLASSIFICATION_OFFICIAL | VARCHAR2 | (150) | ||
LANGUAGE_REQUIRED | VARCHAR2 | (150) | ||
DRUG_TEST | VARCHAR2 | (150) | ||
FINANCIAL_STATEMENT | VARCHAR2 | (150) | ||
TRAINING_PROGRAM_ID | VARCHAR2 | (150) | ||
KEY_EMERGENCY_ESSENTIAL | VARCHAR2 | (150) | ||
APPROPRIATION_CODE_1 | VARCHAR2 | (150) | ||
APPROPRIATION_CODE_2 | VARCHAR2 | (150) | ||
INTELLIGENCE_POSITION_IND | VARCHAR2 | (150) | ||
LEO_POSITION_INDICATOR | VARCHAR2 | (150) | ||
ENVIRONMENTAL_HAZARD_DIFF | VARCHAR2 | (150) | ||
COMPUTER_POSITION_INDICATOR | VARCHAR2 | (150) | ||
EDP_HDP_LAST_REVIEW_DATE | DATE | |||
NFC_AGENCY_CODE | VARCHAR2 | (150) | ||
WORKING_TITLE_CODE | VARCHAR2 | (150) | ||
OFFICIAL_TITLE_PREFIX | VARCHAR2 | (150) | ||
OFFICIAL_TITLE_SUFFIX | VARCHAR2 | (150) | ||
OFFICIAL_TITLE_CODE | VARCHAR2 | (150) | ||
HEADQUARTERS_FIELD_CODE | VARCHAR2 | (150) | ||
CLASSIFICATION_STANDARD_CODE | VARCHAR2 | (150) | ||
MAINTENANCE_REVIEW_CODE | VARCHAR2 | (150) | ||
CLASSIFICATION_ACTION_CODE | VARCHAR2 | (150) | ||
POJECTED_DUTIES_INDICATOR | VARCHAR2 | (150) | ||
VACANCY_REVIEW_CODE | VARCHAR2 | (150) | ||
POSITION_SCHEDULE | VARCHAR2 | (150) | ||
GRADE_BASIS_INDICATOR | VARCHAR2 | (150) | ||
PROCUREMENT_INTEGRITY_ACT | VARCHAR2 | (150) | ||
PRESIDENTIAL_APPOINTMENT_INDIC | VARCHAR2 | (150) | ||
ACCOUNTING_STATION | VARCHAR2 | (150) | ||
CUSTOMS_OFFICER_PAY_REFORM | VARCHAR2 | (150) | ||
EARLY_RETIREMENT_INDICATOR | VARCHAR2 | (150) | ||
DATE_CLASSFN_REQUEST_RECD | DATE | |||
MASS_REALIGNMENT_FLAG | VARCHAR2 | (150) | ||
MASS_REALIGNMENT_REMARKS | VARCHAR2 | (150) | ||
MASS_REALIGNMENT_NAME | VARCHAR2 | (150) | ||
AGENCY_CODE__SUBELEM | VARCHAR2 | (150) | ||
DUTY_STATION_CODE | VARCHAR2 | (150) | ||
MASS_TRANSFER_OUT_FLAG | VARCHAR2 | (150) | ||
MASS_TRANSFER_OUT_REMARKS | VARCHAR2 | (150) | ||
MASS_TRANSFER_OUT_NAME | VARCHAR2 | (150) | ||
DUTY_STATION_LOCATION_ID | VARCHAR2 | (150) | ||
MASS_TABLE_CHANGE_FLAG | VARCHAR2 | (150) | ||
MASS_TABLE_CHANGE_REMARKS | VARCHAR2 | (150) | ||
MASS_TABLE_CHANGE_NAME | VARCHAR2 | (150) | ||
EXPIRATION_DATE | DATE | |||
OBLIGATED_TYPE | VARCHAR2 | (150) | ||
OBLIGATED_EMPLOYEE_SSN | VARCHAR2 | (150) | ||
VALID_GRADE | VARCHAR2 | (150) | ||
TARGET_GRADE | VARCHAR2 | (150) | ||
PAY_TABLE_ID | VARCHAR2 | (150) | ||
PAY_BASIS | VARCHAR2 | (150) | ||
EMPLOYMENT_CATEGORY_GROUP | VARCHAR2 | (150) | ||
PROFESSIONAL_CATEGORY | VARCHAR2 | (150) | ||
CLINICAL_SPECIALTY | VARCHAR2 | (150) | ||
PHYS_AND_DENT_PAY_RANGE_TABLE | VARCHAR2 | (150) | ||
PHYSICIAN_AND_DENTIST_TIER | VARCHAR2 | (150) | ||
POSITION_FAMILY | VARCHAR2 | (150) | ||
OVERLAP_START_DATE | DATE | |||
OVERLAP_END_DATE | DATE | |||
BEGIN_DATE | DATE | |||
RESERVATION_END_DATE | DATE | |||
PERSON | VARCHAR2 | (150) | ||
FTE_RESERVED | NUMBER | |||
RESERVED_STATUS | VARCHAR2 | (150) | ||
SEASON_START_DATE | DATE | |||
SEASON_END_DATE | DATE | |||
KEY_ROLE | VARCHAR2 | (150) | ||
TURNOVER_RATE | VARCHAR2 | (150) | ||
ROLE_ID | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (3352) |
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;
|
|
|