DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GHR_MT_PEOPLE_F_V

Object Details
Object Name: GHR_MT_PEOPLE_F_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_MT_PEOPLE_F_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
GHR_INTERFACE_ID NUMBER (15) Yes GHR Interface ID
MT_PROCESS_DATE DATE
Yes Process Date
MT_SOURCE VARCHAR2 (30)
Source
MT_EFFECTIVE_DATE DATE

Effective Date
MT_NAME VARCHAR2 (255)
Name
MT_STATUS VARCHAR2 (255)
Status
MT_PERSON_ID VARCHAR2 (255)
MT Person ID
MT_TABLE_NAME VARCHAR2 (255)
Table Name
MT_INFORMATION_TYPE VARCHAR2 (255)
Information Type
MT_INTER_BG_TRANSFER VARCHAR2 (255)
Inter BG Transfer
PERSON_ID VARCHAR2 (255)
Person ID
EFFECTIVE_START_DATE VARCHAR2 (255)
Effective Start Date
EFFECTIVE_END_DATE VARCHAR2 (255)
Effective End Date
BUSINESS_GROUP_ID VARCHAR2 (255)
Business Group of the Record
PERSON_TYPE_ID VARCHAR2 (255)
Person Type ID
LAST_NAME VARCHAR2 (255)
Last Name
START_DATE VARCHAR2 (255)
Start Date
APPLICANT_NUMBER VARCHAR2 (255)
Applicant Number
BACKGROUND_CHECK_STATUS VARCHAR2 (255)
Background Check Status
BACKGROUND_DATE_CHECK VARCHAR2 (255)
Background Date Check
BLOOD_TYPE VARCHAR2 (255)
Blood Type
COMMENT_ID VARCHAR2 (255)
Comment ID
CORRESPONDENCE_LANGUAGE VARCHAR2 (255)
Correspondence Language
CURRENT_APPLICANT_FLAG VARCHAR2 (255)
Current Applicant Flag
CURRENT_EMP_OR_APL_FLAG VARCHAR2 (255)
Current Emp or Apl Flag
CURRENT_EMPLOYEE_FLAG VARCHAR2 (255)
Current Employee Flag
DATE_EMPLOYEE_DATA_VERIFIED VARCHAR2 (255)
Date Employee Data Verified
DATE_OF_BIRTH VARCHAR2 (255)
Date of Birth
EMAIL_ADDRESS VARCHAR2 (255)
Email Address
EMPLOYEE_NUMBER VARCHAR2 (255)
Employee Number
EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (255)
Expense Check Send to Address
FAST_PATH_EMPLOYEE VARCHAR2 (255)
Fast Path Employee
FIRST_NAME VARCHAR2 (255)
First Name
FTE_CAPACITY VARCHAR2 (255)
FTE Capacity
FULL_NAME VARCHAR2 (255)
Full Name
HOLD_APPLICANT_DATE_UNTIL VARCHAR2 (255)
Hold Applicant Date Until
HONORS VARCHAR2 (255)
Honors
INTERNAL_LOCATION VARCHAR2 (255)
Internal Location
KNOWN_AS VARCHAR2 (255)
Known AS
LAST_MEDICAL_TEST_BY VARCHAR2 (255)
Last Medical Test By
LAST_MEDICAL_TEST_DATE VARCHAR2 (255)
Last Medical Test Date
MAILSTOP VARCHAR2 (255)
Mail Stop
MARITAL_STATUS VARCHAR2 (255)
Marital Status
MIDDLE_NAMES VARCHAR2 (255)
Middle Names
NATIONALITY VARCHAR2 (255)
Nationality
NATIONAL_IDENTIFIER VARCHAR2 (255)
National Identifier
OFFICE_NUMBER VARCHAR2 (255)
Office Number
ON_MILITARY_SERVICE VARCHAR2 (255)
On Military Service
ORDER_NAME VARCHAR2 (255)
Order Name
PRE_NAME_ADJUNCT VARCHAR2 (255)
Pre Name Adjunct
PREVIOUS_LAST_NAME VARCHAR2 (255)
Previous Last Name
PROJECTED_START_DATE VARCHAR2 (255)
Projected Start Date
REHIRE_AUTHORIZOR VARCHAR2 (255)
Rehire Authorizor
REHIRE_RECOMMENDATION VARCHAR2 (255)
Rehire Recommendation
RESUME_EXISTS VARCHAR2 (255)
Resume Exists
RESUME_LAST_UPDATED VARCHAR2 (255)
Resume Last Updated
REGISTERED_DISABLED_FLAG VARCHAR2 (255)
Registered Disabled Flag
SECOND_PASSPORT_EXISTS VARCHAR2 (255)
Second Passport Exists
SEX VARCHAR2 (255)
Sex
STUDENT_STATUS VARCHAR2 (255)
Student Status
SUFFIX VARCHAR2 (255)
Suffix
TITLE VARCHAR2 (255)
Title
VENDOR_ID VARCHAR2 (255)
Vendor ID
WORK_SCHEDULE VARCHAR2 (255)
Work Schedule
WORK_TELEPHONE VARCHAR2 (255)
Work Telephone
REQUEST_ID VARCHAR2 (255)
Request ID
PROGRAM_APPLICATION_ID VARCHAR2 (255)
Program Application ID
PROGRAM_ID VARCHAR2 (255)
Program ID
PROGRAM_UPDATE_DATE VARCHAR2 (255)
Program Update Date
ATTRIBUTE_CATEGORY VARCHAR2 (255)
Attribute Category for the Descriptive Flexfield Columns
ATTRIBUTE1 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE16 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE17 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE18 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE19 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE20 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE21 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE22 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE23 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE24 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE25 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE26 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE27 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE28 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE29 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE30 VARCHAR2 (255)
Descriptive Flexfield
LAST_UPDATE_DATE VARCHAR2 (255)
Standard WHO Column
LAST_UPDATED_BY VARCHAR2 (255)
Standard WHO Column
LAST_UPDATE_LOGIN VARCHAR2 (255)
Standard WHO Column
CREATED_BY VARCHAR2 (255)
Standard WHO Column
CREATION_DATE VARCHAR2 (255)
Standard WHO Column
PER_INFORMATION_CATEGORY VARCHAR2 (255)
Information Category for Developer Descriptive Flexfield columns
PER_INFORMATION1 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION2 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION3 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION4 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION5 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION6 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION7 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION8 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION9 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION10 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION11 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION12 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION13 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION14 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION15 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION16 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION17 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION18 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION19 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION20 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION21 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION22 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION23 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION24 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION25 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION26 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION27 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION28 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION29 VARCHAR2 (255)
Developer Descriptive Flexfield
PER_INFORMATION30 VARCHAR2 (255)
Developer Descriptive Flexfield
OBJECT_VERSION_NUMBER VARCHAR2 (255)
Object Version Number
DATE_OF_DEATH VARCHAR2 (255)
Date of Death
REHIRE_REASON VARCHAR2 (255)
Rehire Reason
Query Text

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


SELECT GHR_INTERFACE_ID
,      MT_PROCESS_DATE
,      MT_SOURCE
,      MT_EFFECTIVE_DATE
,      MT_NAME
,      MT_STATUS
,      MT_PERSON_ID
,      MT_TABLE_NAME
,      MT_INFORMATION_TYPE
,      MT_INTER_BG_TRANSFER
,      PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_TYPE_ID
,      LAST_NAME
,      START_DATE
,      APPLICANT_NUMBER
,      BACKGROUND_CHECK_STATUS
,      BACKGROUND_DATE_CHECK
,      BLOOD_TYPE
,      COMMENT_ID
,      CORRESPONDENCE_LANGUAGE
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMP_OR_APL_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_BIRTH
,      EMAIL_ADDRESS
,      EMPLOYEE_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      FAST_PATH_EMPLOYEE
,      FIRST_NAME
,      FTE_CAPACITY
,      FULL_NAME
,      HOLD_APPLICANT_DATE_UNTIL
,      HONORS
,      INTERNAL_LOCATION
,      KNOWN_AS
,      LAST_MEDICAL_TEST_BY
,      LAST_MEDICAL_TEST_DATE
,      MAILSTOP
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      OFFICE_NUMBER
,      ON_MILITARY_SERVICE
,      ORDER_NAME
,      PRE_NAME_ADJUNCT
,      PREVIOUS_LAST_NAME
,      PROJECTED_START_DATE
,      REHIRE_AUTHORIZOR
,      REHIRE_RECOMMENDATION
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      REGISTERED_DISABLED_FLAG
,      SECOND_PASSPORT_EXISTS
,      SEX
,      STUDENT_STATUS
,      SUFFIX
,      TITLE
,      VENDOR_ID
,      WORK_SCHEDULE
,      WORK_TELEPHONE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PER_INFORMATION_CATEGORY
,      PER_INFORMATION1
,      PER_INFORMATION2
,      PER_INFORMATION3
,      PER_INFORMATION4
,      PER_INFORMATION5
,      PER_INFORMATION6
,      PER_INFORMATION7
,      PER_INFORMATION8
,      PER_INFORMATION9
,      PER_INFORMATION10
,      PER_INFORMATION11
,      PER_INFORMATION12
,      PER_INFORMATION13
,      PER_INFORMATION14
,      PER_INFORMATION15
,      PER_INFORMATION16
,      PER_INFORMATION17
,      PER_INFORMATION18
,      PER_INFORMATION19
,      PER_INFORMATION20
,      PER_INFORMATION21
,      PER_INFORMATION22
,      PER_INFORMATION23
,      PER_INFORMATION24
,      PER_INFORMATION25
,      PER_INFORMATION26
,      PER_INFORMATION27
,      PER_INFORMATION28
,      PER_INFORMATION29
,      PER_INFORMATION30
,      OBJECT_VERSION_NUMBER
,      DATE_OF_DEATH
,      REHIRE_REASON
FROM APPS.GHR_MT_PEOPLE_F_V;

Dependencies

[top of page]

APPS.GHR_MT_PEOPLE_F_V references the following:

SchemaAPPS
SynonymGHR_INTERFACE
APPS.GHR_MT_PEOPLE_F_V is referenced by following:

SchemaAPPS
Package BodyGHR_MTI_INT - show dependent code
Package BodyGHR_MTI_INT_INSERT - show dependent code
Package BodyGHR_MTO_INT - show dependent code
ViewGHR_MT_INTERFACE_V
SchemaPUBLIC
SynonymGHR_MT_PEOPLE_F_V