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

Object Details

Object Name:	IGS_PE_FAMILY_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PE_FAMILY_DTLS_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
ROW_ID	ROWID	(10)		ROWID
FAMILY_DTL_ID	NUMBER	(15)	Yes	System generated number to uniquely identify the Family Details of a Person
PERSON_ID	NUMBER	(15)	Yes	Person Identification
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number for identification of students.
MEMBER_ID	NUMBER	(15)	Yes	Identification for Family Members.
MEMBER_NUMBER	VARCHAR2	(30)	Yes	Person Number for a family member.
SURNAME	VARCHAR2	(150)		Surname for Family Member.
GIVEN_NAMES	VARCHAR2	(150)		Name for the Family Member.
RELATIONSHIP_TYPE_ID	NUMBER	(15)	Yes	This column stores relationship type ID.
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	Relationship type between the student and family member.
RELATIONSHIP_TYPE_MEANING	VARCHAR2	(80)		Relationship type meaning.
RELATIONSHIP_CODE	VARCHAR2	(30)	Yes
RECIPROCAL	VARCHAR2	(1)	Yes	Indicator to specify the directional relationship.
PRIMARY	VARCHAR2	(1)		Indication for the Primary member of the student.
SECONDARY	VARCHAR2	(1)		Indication for the Secondary member of the student.
PRE_NAME_ADJUNCT	VARCHAR2	(30)		Prefix for the family member name.
PRE_NAME_ADJUNCT_MEANING	VARCHAR2	(80)		Prefix meaning for the family member name.
SUFFIX	VARCHAR2	(30)		Suffix for the family member name
JOINT_SALUTATION	VARCHAR2	(1000)		Prefix for the family member name.
TITLE	VARCHAR2	(60)		Salutation to be used during letter generation.
SEX	VARCHAR2	(30)		The gender of the family member.
SEX_MEANING	VARCHAR2	(80)		The gender meaning of the family member.
MEMBER_PROFILE_ID	NUMBER	(15)	Yes	Sequence generated number unique for the Family Member.
MARITAL_STATUS	VARCHAR2	(30)		Marital Status for the Family Member.
MARITAL_STATUS_M	VARCHAR2	(80)
EMAIL_ADDRESS	VARCHAR2	(2000)		Email address of the Family Member.
FACULTY	VARCHAR2	(1)		Indicator to indicate whether the Family Member is a Faculty member.
STAFF	VARCHAR2	(1)		Indicator to indicate whether the Family Member is a Staff member
ALUMNI	VARCHAR2	(1)		Indicator to indicate whether the Family Member is an Alumni
CURRENT_STUDENT	VARCHAR2	(1)		Indicator to indicate whether the Family Member is a current student
PERSON_PROFILE_ID	NUMBER	(15)	Yes	Sequence generated number unique for the student.
DSP_NEXTTOKIN	VARCHAR2	(30)		Indicator for the Net to kin existence.
DECEASED	VARCHAR2	(1)		Deceased Indicator .
START_DATE	DATE		Yes	Start date of relationship.
END_DATE	DATE			End date of relationship.
CREATION_DATE	DATE		Yes	WHO column .
CREATED_BY	NUMBER	(15)	Yes	WHO column .
LAST_UPDATE_DATE	DATE		Yes	WHO column .
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO column .
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO column .
REL_LAST_UPDATE_DATE	DATE		Yes
PERSON_MIDDLE_NAME	VARCHAR2	(60)		Middle Name

Query Text

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


SELECT ROW_ID
,      FAMILY_DTL_ID
,      PERSON_ID
,      PERSON_NUMBER
,      MEMBER_ID
,      MEMBER_NUMBER
,      SURNAME
,      GIVEN_NAMES
,      RELATIONSHIP_TYPE_ID
,      RELATIONSHIP_TYPE
,      RELATIONSHIP_TYPE_MEANING
,      RELATIONSHIP_CODE
,      RECIPROCAL
,      PRIMARY
,      SECONDARY
,      PRE_NAME_ADJUNCT
,      PRE_NAME_ADJUNCT_MEANING
,      SUFFIX
,      JOINT_SALUTATION
,      TITLE
,      SEX
,      SEX_MEANING
,      MEMBER_PROFILE_ID
,      MARITAL_STATUS
,      MARITAL_STATUS_M
,      EMAIL_ADDRESS
,      FACULTY
,      STAFF
,      ALUMNI
,      CURRENT_STUDENT
,      PERSON_PROFILE_ID
,      DSP_NEXTTOKIN
,      DECEASED
,      START_DATE
,      END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REL_LAST_UPDATE_DATE
,      PERSON_MIDDLE_NAME
FROM APPS.IGS_PE_FAMILY_DTLS_V;

Dependencies

[top of page]

APPS.IGS_PE_FAMILY_DTLS_V references the following:

APPS: FND_LOOKUP_VALUES; HZ_PARTIES; HZ_PERSON_PROFILES; HZ_RELATIONSHIPS; IGS_LOOKUPS_VIEW; IGS_PE_FAMILY_DTLS; IGS_PE_HZ_PARTIES; IGS_PE_STAT_DETAILS

APPS.IGS_PE_FAMILY_DTLS_V is not referenced by any database object