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_CERIDIAN_500_SPOUSE_V

Object Details

Object Name:	HR_CERIDIAN_500_SPOUSE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_CERIDIAN_500_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_CERIDIAN_500_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	Spouse person ID
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_CERIDIAN_500_SPOUSE_V;

Dependencies

[top of page]

APPS.HR_CERIDIAN_500_SPOUSE_V references the following:

APPS: HR_CERIDIAN - show dependent code; PER_ALL_PEOPLE_F; PER_CONTACT_RELATIONSHIPS

APPS.HR_CERIDIAN_500_SPOUSE_V is referenced by following:

APPS: HR_CERIDIAN_500_EMPLOYEE_V