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.BEN_PEOPLE_RSLT_V

Object Details

Object Name:	BEN_PEOPLE_RSLT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BEN_PEOPLE_RSLT_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
PERSON_ID	NUMBER	(10)	Yes	Foreign Key to PER_PEOPLE_F.
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
BUSINESS_GROUP_ID	NUMBER			Foreign Key to HR_ORGANIZATION_UNITS
PERSON_TYPE_ID	NUMBER	(15)	Yes
LAST_NAME	VARCHAR2	(150)	Yes
START_DATE	DATE		Yes
APPLICANT_NUMBER	VARCHAR2	(30)
COMMENT_ID	NUMBER	(15)
CURRENT_APPLICANT_FLAG	VARCHAR2	(30)
CURRENT_EMP_OR_APL_FLAG	VARCHAR2	(30)
CURRENT_EMPLOYEE_FLAG	VARCHAR2	(30)
DATE_EMPLOYEE_DATA_VERIFIED	DATE
DATE_OF_BIRTH	DATE
DATE_OF_DEATH	DATE
EMAIL_ADDRESS	VARCHAR2	(240)
EMPLOYEE_NUMBER	VARCHAR2	(30)
EXPENSE_CHECK_SEND_TO_ADDRESS	VARCHAR2	(30)
FIRST_NAME	VARCHAR2	(150)
FULL_NAME	VARCHAR2	(240)
ORDER_NAME	VARCHAR2	(240)
KNOWN_AS	VARCHAR2	(80)
MARITAL_STATUS	VARCHAR2	(30)
MIDDLE_NAMES	VARCHAR2	(60)
NATIONALITY	VARCHAR2	(30)
NATIONAL_IDENTIFIER	VARCHAR2	(30)
PREVIOUS_LAST_NAME	VARCHAR2	(150)
REGISTERED_DISABLED_FLAG	VARCHAR2	(30)
SEX	VARCHAR2	(30)
TITLE	VARCHAR2	(30)
SUFFIX	VARCHAR2	(30)
VENDOR_ID	NUMBER	(15)
WORK_TELEPHONE	VARCHAR2	(4000)
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(150)
ATTRIBUTE17	VARCHAR2	(150)
ATTRIBUTE18	VARCHAR2	(150)
ATTRIBUTE19	VARCHAR2	(150)
ATTRIBUTE20	VARCHAR2	(150)
ATTRIBUTE21	VARCHAR2	(150)
ATTRIBUTE22	VARCHAR2	(150)
ATTRIBUTE23	VARCHAR2	(150)
ATTRIBUTE24	VARCHAR2	(150)
ATTRIBUTE25	VARCHAR2	(150)
ATTRIBUTE26	VARCHAR2	(150)
ATTRIBUTE27	VARCHAR2	(150)
ATTRIBUTE28	VARCHAR2	(150)
ATTRIBUTE29	VARCHAR2	(150)
ATTRIBUTE30	VARCHAR2	(150)
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
PER_INFORMATION_CATEGORY	VARCHAR2	(30)
PER_INFORMATION1	VARCHAR2	(150)
PER_INFORMATION2	VARCHAR2	(150)
PER_INFORMATION3	VARCHAR2	(150)
PER_INFORMATION4	VARCHAR2	(150)
PER_INFORMATION5	VARCHAR2	(150)
PER_INFORMATION6	VARCHAR2	(150)
PER_INFORMATION7	VARCHAR2	(150)
PER_INFORMATION8	VARCHAR2	(150)
PER_INFORMATION9	VARCHAR2	(150)
PER_INFORMATION10	VARCHAR2	(150)
PER_INFORMATION11	VARCHAR2	(150)
PER_INFORMATION12	VARCHAR2	(150)
PER_INFORMATION13	VARCHAR2	(150)
PER_INFORMATION14	VARCHAR2	(150)
PER_INFORMATION15	VARCHAR2	(150)
PER_INFORMATION16	VARCHAR2	(150)
PER_INFORMATION17	VARCHAR2	(150)
PER_INFORMATION18	VARCHAR2	(150)
PER_INFORMATION19	VARCHAR2	(150)
PER_INFORMATION20	VARCHAR2	(150)
WORK_SCHEDULE	VARCHAR2	(30)
CORRESPONDENCE_LANGUAGE	VARCHAR2	(30)
STUDENT_STATUS	VARCHAR2	(30)
FTE_CAPACITY	NUMBER	(5)
ON_MILITARY_SERVICE	VARCHAR2	(30)
SECOND_PASSPORT_EXISTS	VARCHAR2	(30)
BACKGROUND_CHECK_STATUS	VARCHAR2	(30)
BACKGROUND_DATE_CHECK	DATE
BLOOD_TYPE	VARCHAR2	(30)
LAST_MEDICAL_TEST_DATE	DATE
LAST_MEDICAL_TEST_BY	VARCHAR2	(60)
REHIRE_RECOMMENDATION	VARCHAR2	(30)
REHIRE_AUTHORIZER	VARCHAR2	(30)
REHIRE_REASON	VARCHAR2	(60)
RESUME_EXISTS	VARCHAR2	(30)
RESUME_LAST_UPDATED	DATE
OFFICE_NUMBER	VARCHAR2	(45)
INTERNAL_LOCATION	VARCHAR2	(45)
MAILSTOP	VARCHAR2	(45)
PROJECTED_START_DATE	DATE
HONORS	VARCHAR2	(45)
PRE_NAME_ADJUNCT	VARCHAR2	(30)
HOLD_APPLICANT_DATE_UNTIL	DATE
D_PERSON_TYPE_ID	VARCHAR2	(80)	Yes
S_SYSTEM_PERSON_TYPE	VARCHAR2	(30)	Yes
D_TITLE	VARCHAR2	(80)
D_SEX	VARCHAR2	(80)
D_HOME_OFFICE	VARCHAR2	(80)
D_MARITAL_STATUS	VARCHAR2	(80)
D_NATIONALITY	VARCHAR2	(80)
D_STUDENT_STATUS	VARCHAR2	(80)
D_WORK_SCHEDULE	VARCHAR2	(80)
D_CORR_LANGUAGE	VARCHAR2	(255)
D_BLOOD_TYPE	VARCHAR2	(80)
D_REGISTERED_DISABLED_FLAG	VARCHAR2	(80)
D_ON_MILITARY_SERVICE	VARCHAR2	(80)
HIRE_DATE	DATE
PERIOD_OF_SERVICE_ID	NUMBER	(9)
COORD_BEN_MED_PLN_NO	VARCHAR2	(30)
COORD_BEN_NO_CVG_FLAG	VARCHAR2	(30)
DPDNT_ADOPTION_DATE	DATE
DPDNT_VLNTRY_SVCE_FLAG	VARCHAR2	(30)
RECEIPT_OF_DEATH_CERT_DATE	DATE
USES_TOBACCO_FLAG	VARCHAR2	(30)
D_USES_TOBACCO_FLAG	VARCHAR2	(80)
BENEFIT_GROUP_ID	NUMBER	(15)
D_BENEFIT_GROUP_NAME	VARCHAR2	(240)
ADJUSTED_SVC_DATE	DATE
ORIGINAL_DATE_OF_HIRE	DATE

Query Text

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


SELECT PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_TYPE_ID
,      LAST_NAME
,      START_DATE
,      APPLICANT_NUMBER
,      COMMENT_ID
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMP_OR_APL_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_BIRTH
,      DATE_OF_DEATH
,      EMAIL_ADDRESS
,      EMPLOYEE_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      FIRST_NAME
,      FULL_NAME
,      ORDER_NAME
,      KNOWN_AS
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED_FLAG
,      SEX
,      TITLE
,      SUFFIX
,      VENDOR_ID
,      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
,      WORK_SCHEDULE
,      CORRESPONDENCE_LANGUAGE
,      STUDENT_STATUS
,      FTE_CAPACITY
,      ON_MILITARY_SERVICE
,      SECOND_PASSPORT_EXISTS
,      BACKGROUND_CHECK_STATUS
,      BACKGROUND_DATE_CHECK
,      BLOOD_TYPE
,      LAST_MEDICAL_TEST_DATE
,      LAST_MEDICAL_TEST_BY
,      REHIRE_RECOMMENDATION
,      REHIRE_AUTHORIZER
,      REHIRE_REASON
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      OFFICE_NUMBER
,      INTERNAL_LOCATION
,      MAILSTOP
,      PROJECTED_START_DATE
,      HONORS
,      PRE_NAME_ADJUNCT
,      HOLD_APPLICANT_DATE_UNTIL
,      D_PERSON_TYPE_ID
,      S_SYSTEM_PERSON_TYPE
,      D_TITLE
,      D_SEX
,      D_HOME_OFFICE
,      D_MARITAL_STATUS
,      D_NATIONALITY
,      D_STUDENT_STATUS
,      D_WORK_SCHEDULE
,      D_CORR_LANGUAGE
,      D_BLOOD_TYPE
,      D_REGISTERED_DISABLED_FLAG
,      D_ON_MILITARY_SERVICE
,      HIRE_DATE
,      PERIOD_OF_SERVICE_ID
,      COORD_BEN_MED_PLN_NO
,      COORD_BEN_NO_CVG_FLAG
,      DPDNT_ADOPTION_DATE
,      DPDNT_VLNTRY_SVCE_FLAG
,      RECEIPT_OF_DEATH_CERT_DATE
,      USES_TOBACCO_FLAG
,      D_USES_TOBACCO_FLAG
,      BENEFIT_GROUP_ID
,      D_BENEFIT_GROUP_NAME
,      ADJUSTED_SVC_DATE
,      ORIGINAL_DATE_OF_HIRE
FROM APPS.BEN_PEOPLE_RSLT_V;

Dependencies

[top of page]

APPS.BEN_PEOPLE_RSLT_V references the following:

APPS: BEN_BENFTS_GRP; BEN_PRTT_ENRT_RSLT_F; BEN_PRTT_PREM_F; FND_GLOBAL - show dependent code; FND_LANGUAGES_VL; FND_SESSIONS; HR_API - show dependent code; HR_GENERAL - show dependent code; HR_LOOKUPS; HR_PERSON_NAME - show dependent code; HR_PERSON_TYPE_USAGE_INFO - show dependent code; HR_SECURITY - show dependent code; PER_PEOPLE; PER_PERIODS_OF_SERVICE; PER_PERSON_TYPES; PER_PERSON_TYPES_TL

APPS.BEN_PEOPLE_RSLT_V is referenced by following:

PUBLIC: BEN_PEOPLE_RSLT_V