[Home] [Help] [Dependency Information]
Object Name: | IGSBV_FAMILY_RELATIONSHIPS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_FAMILY_RELATIONSHIPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This entity contains information about the family relationships of a person.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUBJECT_ID_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number of the subject person |
OBJECT_ID_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number of the object person |
_LA:RELATIONSHIP_CODE | CHAR | (65) | Relationship code | |
RELATIONSHIP_START_DATE | DATE | Yes | Start date for the relationship | |
RELATIONSHIP_END_DATE | DATE | End date for the relationship | ||
PRIMARY | VARCHAR2 | (1) | Indicator whether the relationship is primary | |
SECONDARY | VARCHAR2 | (1) | Indicator whether the relationship is secondary | |
JOINT_SALUTATION | VARCHAR2 | (1000) | Salutation to be used during letter generation | |
NEXT_TO_KIN | VARCHAR2 | (1) | Next of Kin | |
REPORTED_FACULTY | VARCHAR2 | (1) | Faculty Information of the relation reported by related person | |
REPORTED_STAFF | VARCHAR2 | (1) | Staff Information of the relation reported by related person | |
REPORTED_STUDENT | VARCHAR2 | (1) | Student information of the relation reported by related person | |
REPORTED_ALUMNI | VARCHAR2 | (1) | Alumni information of the relation reported by related person | |
RELATIONSHIP_ID | NUMBER | (15) | Yes | Unique identifier for the relationship |
DIRECTIONAL_FLAG | VARCHAR2 | (1) | Yes | Indicates if this is a directional relationship, such as parent-to-child or headquarters-to-branch. F for a forward relationship and B for a backward relationship. |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT SUBJECT_ID_NUMBER
, OBJECT_ID_NUMBER
, _LA:RELATIONSHIP_CODE
, RELATIONSHIP_START_DATE
, RELATIONSHIP_END_DATE
, PRIMARY
, SECONDARY
, JOINT_SALUTATION
, NEXT_TO_KIN
, REPORTED_FACULTY
, REPORTED_STAFF
, REPORTED_STUDENT
, REPORTED_ALUMNI
, RELATIONSHIP_ID
, DIRECTIONAL_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_FAMILY_RELATIONSHIPS;
APPS.IGSBV_FAMILY_RELATIONSHIPS is not referenced by any database object
|
|
|