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

Object Details

Object Name:	HR_ADP_SPOUSE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_ADP_SPOUSE_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view returns information about employee spouses. It is referenced by the HR_ADP_EMPLOYEE_V view.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group ID
PERSON_ID	NUMBER	(10)	Yes	Person ID
SPOUSE_PERSON_ID	NUMBER	(10)	Yes	Person ID of spouse
SPOUSE_FULL_NAME	VARCHAR2	(240)		Spouse full name
SPOUSE_EMPLOYEE_NUMBER	VARCHAR2	(30)		Spouse employee number, if spouse is an employee
SPOUSE_DATE_OF_BIRTH	DATE			Spouse date of birth

Query Text

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


SELECT BUSINESS_GROUP_ID
,      PERSON_ID
,      SPOUSE_PERSON_ID
,      SPOUSE_FULL_NAME
,      SPOUSE_EMPLOYEE_NUMBER
,      SPOUSE_DATE_OF_BIRTH
FROM APPS.HR_ADP_SPOUSE_V;

Dependencies

[top of page]

APPS.HR_ADP_SPOUSE_V references the following:

APPS: HR_ADP - show dependent code; PER_ALL_PEOPLE_F; PER_CONTACT_RELATIONSHIPS

APPS.HR_ADP_SPOUSE_V is referenced by following:

APPS: HR_ADP_EMPLOYEE_V