eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GHR_PEOPLE_H_V

Object Details

Object Name:	GHR_PEOPLE_H_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_PEOPLE_H_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
PA_HISTORY_ID	NUMBER	(15)	Yes	PA History ID
PROCESS_DATE	DATE		Yes	Process Date
EFFECTIVE_DATE	DATE		Yes	Effective Date
DML_OPERATION	VARCHAR2	(1)		DML Operation
PRE_VALUES_FLAG	VARCHAR2	(1)		Pre Values Flag
ALTERED_PA_REQUEST_ID	NUMBER	(15)		Altered PA Request ID
PA_REQUEST_ID	NUMBER	(15)		PA Request ID
NATURE_OF_ACTION_ID	NUMBER	(15)		Nature of Action ID
PERSON_ID	NUMBER			Person ID
EFFECTIVE_START_DATE	DATE			Effective Start Date
EFFECTIVE_END_DATE	DATE			Effective End Date
DATE_OF_DEATH	DATE			Date of Death
PERSON_TYPE_ID	NUMBER			Person Type ID
LAST_NAME	VARCHAR2	(150)		Last Name
START_DATE	DATE			Start Date
APPLICANT_NUMBER	VARCHAR2	(30)		Applicant Number
BACKGROUND_CHECK_STATUS	VARCHAR2	(30)		Background Check Status
BACKGROUND_DATE_CHECK	DATE			Background Date Check
BLOOD_TYPE	VARCHAR2	(30)		Blood Type
COMMENT_ID	NUMBER			Comment ID
CORRESPONDENCE_LANGUAGE	VARCHAR2	(30)		Coresspondence Language
CURRENT_APPLICANT_FLAG	VARCHAR2	(30)		Current Applicant Flag
CURRENT_EMP_OR_APL_FLAG	VARCHAR2	(30)		Current Emp or Apl Flag
CURRENT_EMPLOYEE_FLAG	VARCHAR2	(30)		Current Employee Flag
DATE_EMPLOYEE_DATA_VERIFIED	DATE			Date Employee Data Verified
DATE_OF_BIRTH	DATE			Date of Birth
EMAIL_ADDRESS	VARCHAR2	(240)		Email Address
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number
EXPENSE_CHECK_SEND_TO_ADDRESS	VARCHAR2	(30)		Expense check send to Address
FAST_PATH_EMPLOYEE	VARCHAR2	(30)		Fast Path Employee
FIRST_NAME	VARCHAR2	(150)		First Name
FTE_CAPACITY	NUMBER			FTE Capacity
FULL_NAME	VARCHAR2	(240)		Full Name
HOLD_APPLICANT_DATE_UNTIL	DATE			Hold Applicant Date Until
HONORS	VARCHAR2	(45)		Honors
INTERNAL_LOCATION	VARCHAR2	(45)		Internal Location
KNOWN_AS	VARCHAR2	(80)		Known As
LAST_MEDICAL_TEST_BY	VARCHAR2	(60)		Last Medical Test By
LAST_MEDICAL_TEST_DATE	DATE			Last Medical Test Date
MAILSTOP	VARCHAR2	(45)		Mail Stop
MARITAL_STATUS	VARCHAR2	(30)		Marital Status
MIDDLE_NAMES	VARCHAR2	(60)		Middle Names
NATIONALITY	VARCHAR2	(30)		Nationality
NATIONAL_IDENTIFIER	VARCHAR2	(30)		National Identifier
OFFICE_NUMBER	VARCHAR2	(45)		Office Number
ON_MILITARY_SERVICE	VARCHAR2	(30)		On Military Service
ORDER_NAME	VARCHAR2	(240)		Order Name
PRE_NAME_ADJUNCT	VARCHAR2	(30)		Pre Name Adjunct
PREVIOUS_LAST_NAME	VARCHAR2	(150)		Previous Last Name
PROJECTED_START_DATE	DATE			Projected Start Date
REHIRE_AUTHORIZOR	VARCHAR2	(30)		Rehire Authorizor
REHIRE_RECOMMENDATION	VARCHAR2	(30)		Rehire Recommendation
RESUME_EXISTS	VARCHAR2	(30)		Resume Exists
RESUME_LAST_UPDATED	DATE			Resume Last Updated
REGISTERED_DISABLED_FLAG	VARCHAR2	(30)		Registered Disabled Flag
SECOND_PASSPORT_EXISTS	VARCHAR2	(30)		Second Passport Exists
SEX	VARCHAR2	(30)		Sex
STUDENT_STATUS	VARCHAR2	(30)		Student Status
SUFFIX	VARCHAR2	(30)		Suffix
TITLE	VARCHAR2	(30)		Title
VENDOR_ID	NUMBER			Vendor ID
WORK_SCHEDULE	VARCHAR2	(30)		Work Schedule
WORK_TELEPHONE	VARCHAR2	(60)		Work Telephone
PER_INFORMATION_CATEGORY	VARCHAR2	(30)		Information Category for Developer Descriptive Flexfield Columns
PER_INFORMATION1	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION2	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION3	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION4	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION5	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION6	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION7	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION8	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION9	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION10	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION11	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION12	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION13	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION14	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION15	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION16	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION17	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION18	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION19	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION20	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION21	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION22	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION23	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION24	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION25	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION26	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION27	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION28	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION29	VARCHAR2	(150)		Developer Descriptive Flexfield
PER_INFORMATION30	VARCHAR2	(150)		Developer Descriptive Flexfield
REHIRE_REASON	VARCHAR2	(150)		Rehire Reason
REQUEST_ID	NUMBER			Request ID
PROGRAM_APPLICATION_ID	NUMBER			Program Application ID
PROGRAM_ID	NUMBER			Program ID
PROGRAM_UPDATE_DATE	DATE			Program Update Date
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category for Descriptive Flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield
BUSINESS_GROUP_ID	NUMBER			Business Group of the Record

Query Text

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


SELECT PA_HISTORY_ID
,      PROCESS_DATE
,      EFFECTIVE_DATE
,      DML_OPERATION
,      PRE_VALUES_FLAG
,      ALTERED_PA_REQUEST_ID
,      PA_REQUEST_ID
,      NATURE_OF_ACTION_ID
,      PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      DATE_OF_DEATH
,      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
,      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
,      REHIRE_REASON
,      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
,      BUSINESS_GROUP_ID
FROM APPS.GHR_PEOPLE_H_V;

Dependencies

[top of page]

APPS.GHR_PEOPLE_H_V references the following:

APPS: FND_DATE - show dependent code; GHR_GENERAL - show dependent code; GHR_PA_HISTORY

APPS.GHR_PEOPLE_H_V is referenced by following:

APPS: GHR_HISTORY_CONV_RG - show dependent code; GHR_HISTORY_CONV_RG - show dependent code