[Home] [Help] [Dependency Information]
Object Name: | GHR_MT_INTERFACE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GHR.GHR_MT_INTERFACE_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MT_NAME | VARCHAR2 | (255) | Name | |
MT_PROCESS_DATE | DATE | Yes | Process Date | |
MT_EFFECTIVE_DATE | DATE | Effective Date | ||
MT_SOURCE | VARCHAR2 | (30) | Source | |
MT_STATUS | VARCHAR2 | (255) | Status | |
MT_PERSON_ID | NUMBER | Person ID | ||
MT_INTER_BG_TRANSFER | VARCHAR2 | (255) | Internal Busines Group Transfer | |
DATE_OF_BIRTH | DATE | Date of Birth | ||
EFFECTIVE_END_DATE | DATE | Effective End date | ||
EFFECTIVE_START_DATE | DATE | Effective start date | ||
FIRST_NAME | VARCHAR2 | (150) | First Name | |
FULL_NAME | VARCHAR2 | (240) | Full Name | |
LAST_NAME | VARCHAR2 | (150) | Last Name | |
MARITAL_STATUS | VARCHAR2 | (30) | Marital Status | |
MIDDLE_NAMES | VARCHAR2 | (60) | Middle Names | |
NATIONAL_IDENTIFIER | VARCHAR2 | (30) | National Identifier | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee Number | |
NATIONALITY | VARCHAR2 | (30) | Nationality | |
REHIRE_REASON | VARCHAR2 | (60) | Rehire Reason | |
SEX | VARCHAR2 | (30) | Sex | |
START_DATE | DATE | Start Date | ||
TITLE | VARCHAR2 | (30) | Title | |
WORK_TELEPHONE | VARCHAR2 | (60) | Work Telephone | |
CITIZENSHIP | VARCHAR2 | (30) | Citizenship | |
VETERANS_PREFERENCE | VARCHAR2 | (30) | Veterans Preference | |
VETERANS_PREFERENCE_FOR_RIF | VARCHAR2 | (30) | Veterans Preference for RIF | |
VETERANS_STATUS | VARCHAR2 | (30) | Veterans Status | |
CITIZENSHIP_DESC | VARCHAR2 | (80) | Citizenship Description | |
VETERANS_PREFERENCE_DESC | VARCHAR2 | (80) | Veterans Preferance Decription | |
VETERANS_PREFERENCE_RIF_DESC | VARCHAR2 | (80) | Veterans Preference RIF Description | |
VETERANS_STATUS_DESC | VARCHAR2 | (80) | Veterans Status Description | |
APPOINTMENT_TYPE | VARCHAR2 | (2) | Appointment Type | |
FERS_COVERAGE | VARCHAR2 | (80) | FERS Coverage | |
FERS_COVERAGE_DESC | VARCHAR2 | (80) | Description for FERS Coverage Code | |
TYPE_OF_EMPLOYMENT | VARCHAR2 | (1) | Type od Employmenmt | |
RACE_OR_NATIONAL_ORIGIN | VARCHAR2 | (1) | Race or National Origin | |
AGENCY_CODE_TRANSFER_FROM | VARCHAR2 | (4) | Agency Code Transfer From | |
ORIG_APPOINTMENT_AUTH_CODE_1 | VARCHAR2 | (3) | Original Appointment authorization code1 | |
ORIG_APPOINTMENT_AUTH_CODE_2 | VARCHAR2 | (3) | Original Appointment authorization code2 | |
HANDICAP_CODE | VARCHAR2 | (3) | Handicap Code | |
APPOINTMENT_TYPE_DESC | VARCHAR2 | (80) | Appointment type Description | |
TYPE_OF_EMPLOYMENT_DESC | VARCHAR2 | (80) | Employment type Description | |
RACE_OR_NATIONAL_ORIGIN_DESC | VARCHAR2 | (80) | Description of Race or antional Origin | |
AGENCY_CODE_TRANSFER_FROM_DESC | VARCHAR2 | (80) | Agency code transfer from description | |
ORIG_APPT_AUTH_CODE_1_DESC | VARCHAR2 | (80) | Original Appointment authorization Code 1 description | |
ORIG_APPT_AUTH_CODE_2_DESC | VARCHAR2 | (80) | Original Appointment authorization Code 2 description | |
HANDICAP_CODE_DESC | VARCHAR2 | (80) | Handicap Code description | |
SERVICE_COMP_DATE | DATE | Service Comp Date | ||
PREVIOUS_RETIREMENT_COVERAGE | VARCHAR2 | (1) | Previous Retirement Coverage | |
FROZEN_SERVICE | VARCHAR2 | (4) | Frozen Service | |
PREV_RETIREMENT_COVERAGE_DESC | VARCHAR2 | (80) | Previous Retirement Coverage description | |
CREDITABLE_MILITARY_SERVICE | VARCHAR2 | (4) | Creditable Military Service | |
FLSA_CATEGORY | VARCHAR2 | (1) | FLSA Category | |
BARGAINING_UNIT_STATUS | VARCHAR2 | (6) | Bargaining Unit status | |
FUNCTIONAL_CLASS | VARCHAR2 | (3) | Functional Class | |
POSITION_WORKING_TITLE | VARCHAR2 | (60) | Position Working Title | |
SUPERVISORY_STATUS | VARCHAR2 | (1) | Supervisory Status | |
FLSA_CATEGORY_DESC | VARCHAR2 | (80) | FLSA Category Description | |
BARGAINING_UNIT_STATUS_DESC | VARCHAR2 | (80) | Bargaining Unit status Description | |
FUNCTIONAL_CLASS_DESC | VARCHAR2 | (80) | Functional Class Description | |
SUPERVISORY_STATUS_DESC | VARCHAR2 | (80) | Supervisory Status Description | |
POSITION_OCCUPIED | VARCHAR2 | (1) | Position Occupied | |
APPROPRIATION_CODE1 | VARCHAR2 | (30) | Appropriate Code1 | |
APPROPRIATION_CODE2 | VARCHAR2 | (30) | Appropriate Code2 | |
POSITION_OCCUPIED_DESC | VARCHAR2 | (80) | Position Occupied description | |
APPROPRIATION_CODE1_DESC | VARCHAR2 | (80) | Appropriate Code1 Description | |
APPROPRIATION_CODE2_DESC | VARCHAR2 | (80) | Appropriate Code2 Description | |
TOTAL_SALARY | NUMBER | Total Salary | ||
BASIC_SALARY_RATE | NUMBER | Basic Salary Rate | ||
LOCALITY_ADJUSTMENT | NUMBER | Locality Adjustment | ||
ADJUSTED_BASIC_PAY | NUMBER | Adjusted Basic Pay | ||
OTHER_PAY | NUMBER | Other Pay | ||
FEGLI | VARCHAR2 | (30) | FEGLI | |
RETIREMENT_PLAN | VARCHAR2 | (30) | Retirement Plan | |
RETENTION_ALLOWANCE | NUMBER | Retention Allowance | ||
STAFFING_DIFFERENTIAL | NUMBER | Staffing Differential | ||
SUPERVISORY_DIFFERENTIAL | NUMBER | Supervisory Differential | ||
WGI_DATE_DUE | DATE | WGI Date Due | ||
FEGLI_DESC | VARCHAR2 | (255) | FEGLI Description | |
RETIREMENT_PLAN_DESC | VARCHAR2 | (255) | Retirement Plan Description | |
AU_OVERTIME | NUMBER | AU Overtime | ||
AVAILABILITY_PAY | NUMBER | Availability Pay | ||
AUO_PREMIUM_PAY_INDICATOR | VARCHAR2 | (1) | AUO Premium Pay Indicator | |
AP_PREMIUM_PAY_INDICATOR | VARCHAR2 | (1) | AP Premium Pay Indicator | |
TO_POSITION_ID | NUMBER | To Position ID | ||
FROM_GRADE_OR_LEVEL | VARCHAR2 | (60) | From Grade or Level | |
FROM_PAY_PLAN | VARCHAR2 | (2) | From Pay Plan | |
FROM_POSITION_TITLE | VARCHAR2 | (240) | From Position Title | |
FROM_POSITION_SEQ_NUM | NUMBER | From Position Sequence Number | ||
FROM_POSITION_DESC_NUM | VARCHAR2 | (240) | From Position Description Number | |
DUTY_STATION_CODE | VARCHAR2 | (30) | Duty Station Code | |
DUTY_STATION_DESC | VARCHAR2 | (80) | Duty Station Description | |
FROM_STEP_OR_RATE | VARCHAR2 | (2) | From Step Or Rate | |
TENURE | VARCHAR2 | (30) | Tenure | |
ANNUITANT_INDICATOR | VARCHAR2 | (30) | Annuitant Indicator | |
PAY_RATE_DETERMINANT | VARCHAR2 | (30) | Pay Rate Determinant | |
WORK_SCHEDULE | VARCHAR2 | (30) | Work Schedule | |
PART_TIME_HOURS | NUMBER | Part Time Hours | ||
TENURE_DESC | VARCHAR2 | (80) | Tenure Description | |
ANNUITANT_INDICATOR_DESC | VARCHAR2 | (80) | Annuitant Indicator Description | |
PAY_RATE_DETERMINANT_DESC | VARCHAR2 | (80) | Pay Rate Determinant Description | |
WORK_SCHEDULE_DESC | VARCHAR2 | (80) | Work Schedule Description | |
DATE_ARRIVED_PERSONNEL_OFFICE | DATE | Date Arrived Personnel Office | ||
NON_DISCLOSURE_AGMT_STATUS | VARCHAR2 | (1) | Non Disclosure Agrement Status | |
PART_TIME_INDICATOR | VARCHAR2 | (1) | Part Time Indicator | |
QUALIF_STANDARDS_WAIVER | VARCHAR2 | (1) | Qualifications Standard Waiver | |
NON_DISCLOSURE_AGMT_STAT_DESC | VARCHAR2 | (80) | Non Disclosure Agrement Status Description | |
PART_TIME_INDICATOR_DESC | VARCHAR2 | (80) | Part Time Indicator Description | |
QUALIF_STANDARDS_WAIVER_DESC | VARCHAR2 | (80) | Qualifications Standard Waiver Description | |
EDUCATIONAL_LEVEL | VARCHAR2 | (2) | Education Level | |
ACADEMIC_DISCIPLINE | VARCHAR2 | (6) | Academic Discipline | |
YEAR_DEGREE_ATTAINED | VARCHAR2 | (4) | Year Degree Attained | |
EDUCATIONAL_LEVEL_DESC | VARCHAR2 | (80) | Education Level Description | |
ACADEMIC_DISCIPLINE_DESC | VARCHAR2 | (80) | Academic Discipline Description | |
TO_RETENTION_ALLOW_PERCENTAGE | VARCHAR2 | (255) | Retention Allowance Percentage | |
TO_SUPERVISORY_DIFF_PERCENTAGE | VARCHAR2 | (255) | Supervisory Differential Percentage | |
TO_STAFFING_DIFF_PERCENTAGE | VARCHAR2 | (255) | Staffing Differential Percentage | |
TO_BASIC_SALARY_RATE | NUMBER | |||
TO_ADJUSTED_BASIC_PAY | NUMBER | |||
TO_TOTAL_SALARY | NUMBER | |||
ASSIGNMENT_NTE_START_DATE | DATE | Assignment NTE Start Date | ||
ASSIGNMENT_NTE | DATE | Assingment NTE End Date |
Cut, paste (and edit) the following text to query this object:
SELECT MT_NAME
, MT_PROCESS_DATE
, MT_EFFECTIVE_DATE
, MT_SOURCE
, MT_STATUS
, MT_PERSON_ID
, MT_INTER_BG_TRANSFER
, DATE_OF_BIRTH
, EFFECTIVE_END_DATE
, EFFECTIVE_START_DATE
, FIRST_NAME
, FULL_NAME
, LAST_NAME
, MARITAL_STATUS
, MIDDLE_NAMES
, NATIONAL_IDENTIFIER
, EMPLOYEE_NUMBER
, NATIONALITY
, REHIRE_REASON
, SEX
, START_DATE
, TITLE
, WORK_TELEPHONE
, CITIZENSHIP
, VETERANS_PREFERENCE
, VETERANS_PREFERENCE_FOR_RIF
, VETERANS_STATUS
, CITIZENSHIP_DESC
, VETERANS_PREFERENCE_DESC
, VETERANS_PREFERENCE_RIF_DESC
, VETERANS_STATUS_DESC
, APPOINTMENT_TYPE
, FERS_COVERAGE
, FERS_COVERAGE_DESC
, TYPE_OF_EMPLOYMENT
, RACE_OR_NATIONAL_ORIGIN
, AGENCY_CODE_TRANSFER_FROM
, ORIG_APPOINTMENT_AUTH_CODE_1
, ORIG_APPOINTMENT_AUTH_CODE_2
, HANDICAP_CODE
, APPOINTMENT_TYPE_DESC
, TYPE_OF_EMPLOYMENT_DESC
, RACE_OR_NATIONAL_ORIGIN_DESC
, AGENCY_CODE_TRANSFER_FROM_DESC
, ORIG_APPT_AUTH_CODE_1_DESC
, ORIG_APPT_AUTH_CODE_2_DESC
, HANDICAP_CODE_DESC
, SERVICE_COMP_DATE
, PREVIOUS_RETIREMENT_COVERAGE
, FROZEN_SERVICE
, PREV_RETIREMENT_COVERAGE_DESC
, CREDITABLE_MILITARY_SERVICE
, FLSA_CATEGORY
, BARGAINING_UNIT_STATUS
, FUNCTIONAL_CLASS
, POSITION_WORKING_TITLE
, SUPERVISORY_STATUS
, FLSA_CATEGORY_DESC
, BARGAINING_UNIT_STATUS_DESC
, FUNCTIONAL_CLASS_DESC
, SUPERVISORY_STATUS_DESC
, POSITION_OCCUPIED
, APPROPRIATION_CODE1
, APPROPRIATION_CODE2
, POSITION_OCCUPIED_DESC
, APPROPRIATION_CODE1_DESC
, APPROPRIATION_CODE2_DESC
, TOTAL_SALARY
, BASIC_SALARY_RATE
, LOCALITY_ADJUSTMENT
, ADJUSTED_BASIC_PAY
, OTHER_PAY
, FEGLI
, RETIREMENT_PLAN
, RETENTION_ALLOWANCE
, STAFFING_DIFFERENTIAL
, SUPERVISORY_DIFFERENTIAL
, WGI_DATE_DUE
, FEGLI_DESC
, RETIREMENT_PLAN_DESC
, AU_OVERTIME
, AVAILABILITY_PAY
, AUO_PREMIUM_PAY_INDICATOR
, AP_PREMIUM_PAY_INDICATOR
, TO_POSITION_ID
, FROM_GRADE_OR_LEVEL
, FROM_PAY_PLAN
, FROM_POSITION_TITLE
, FROM_POSITION_SEQ_NUM
, FROM_POSITION_DESC_NUM
, DUTY_STATION_CODE
, DUTY_STATION_DESC
, FROM_STEP_OR_RATE
, TENURE
, ANNUITANT_INDICATOR
, PAY_RATE_DETERMINANT
, WORK_SCHEDULE
, PART_TIME_HOURS
, TENURE_DESC
, ANNUITANT_INDICATOR_DESC
, PAY_RATE_DETERMINANT_DESC
, WORK_SCHEDULE_DESC
, DATE_ARRIVED_PERSONNEL_OFFICE
, NON_DISCLOSURE_AGMT_STATUS
, PART_TIME_INDICATOR
, QUALIF_STANDARDS_WAIVER
, NON_DISCLOSURE_AGMT_STAT_DESC
, PART_TIME_INDICATOR_DESC
, QUALIF_STANDARDS_WAIVER_DESC
, EDUCATIONAL_LEVEL
, ACADEMIC_DISCIPLINE
, YEAR_DEGREE_ATTAINED
, EDUCATIONAL_LEVEL_DESC
, ACADEMIC_DISCIPLINE_DESC
, TO_RETENTION_ALLOW_PERCENTAGE
, TO_SUPERVISORY_DIFF_PERCENTAGE
, TO_STAFFING_DIFF_PERCENTAGE
, TO_BASIC_SALARY_RATE
, TO_ADJUSTED_BASIC_PAY
, TO_TOTAL_SALARY
, ASSIGNMENT_NTE_START_DATE
, ASSIGNMENT_NTE
FROM APPS.GHR_MT_INTERFACE_V;
|
|
|