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

Object Details

Object Name:	IGSFV_PERSON_INTEREST
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_PERSON_INTEREST
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This table holds person's extracirricular activities or interests that are not present in TCA tables HZ_INTEREST

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_INTEREST_IDENTIFIER	NUMBER	(15)	Yes	Unique identifier of the person's interest
HZ_EXTRACURR_ACT_IDENTIFIER	NUMBER	(15)	Yes	Person activity or interest identifier
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Identifier for the person. Foreign key to the HZ_PARTIES table.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this person
PERSON_NAME	VARCHAR2	(360)	Yes	Name of this person
RANK	VARCHAR2	(30)		User-defined level number or name to rate the amount of interest in the activity. For example, high, medium, or low.
_LA:LEVEL_OF_PARTICIPATION	CHAR	(76)		User-defined level number or name to indicate if the person participates and to what extent
_LA:INTEREST_TYPE_CODE	CHAR	(66)		A code to classify interests for evaluation
COMMENTS	VARCHAR2	(240)		Comments about the person's interest
_LA:SPORT_INDICATOR	CHAR	(56)		Indicates if the activity is a sport. Y for sports, N for non-sport activities
INTEREST_NAME	VARCHAR2	(240)	Yes	A text field that lets you assign a descriptive name to an interest. For example, pets, dogs, baseball, or sports car racing.
TEAM	VARCHAR2	(240)		Any team the person likes to watch or play for.
START_DATE	DATE			Approximate date the person became involved in this activity
END_DATE	DATE			End date
HOURS_PER_WEEK	NUMBER	(5)		Hours per week
WEEKS_PER_YEAR	NUMBER	(5)		Weeks per year
_LA:ACTIVITY_SOURCE_CODE	CHAR	(68)		Person Interest Source Code
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT PERSON_INTEREST_IDENTIFIER
,      HZ_EXTRACURR_ACT_IDENTIFIER
,      PERSON_IDENTIFIER
,      PERSON_NUMBER
,      PERSON_NAME
,      RANK
,      _LA:LEVEL_OF_PARTICIPATION
,      _LA:INTEREST_TYPE_CODE
,      COMMENTS
,      _LA:SPORT_INDICATOR
,      INTEREST_NAME
,      TEAM
,      START_DATE
,      END_DATE
,      HOURS_PER_WEEK
,      WEEKS_PER_YEAR
,      _LA:ACTIVITY_SOURCE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGSFV_PERSON_INTEREST;

Dependencies

[top of page]

APPS.IGSFV_PERSON_INTEREST references the following:

APPS: HZ_PARTIES; HZ_PERSON_INTEREST; IGS_AD_HZ_EXTRACURR_ACT

APPS.IGSFV_PERSON_INTEREST is not referenced by any database object