[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_RELATIONS_INT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_RELATIONS_INT_ALL |
Subobject Name: | |
Status: | VALID |
Contains Relationship details for each person to be imported into IGS_PE_HZ_REL , HZ_PARTIES, HZ_PERSON_PROFILES, HZ_RELATIONSHIPS, IGS_PE_HZ_PARTIES, and IGS_PE_TYP_INSTANCES_ALL(default logic of OTHERS Person Type) table by the Admission Import process
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Person Relation
Category: BUSINESS_ENTITY HZ_PERSON
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_RELATIONS_INT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_RELATIONS_ID |
IGS_AD_RELATIONS_INT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_ID |
IGS_AD_RELATIONS_INT_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_AD_RELATIONS_INT_ALL_N4 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_RELATIONS_ID | NUMBER | (15) | Yes | Interface relation identifier |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
INTERFACE_ID | NUMBER | (15) | Yes | Interface identifier |
RELATIONSHIP_TYPE | VARCHAR2 | (30) | Yes | Relationship type |
RELATIONSHIP_CODE | VARCHAR2 | (30) | Code for Relationship that exists between the two concerned parties. The Values are pre-seeded for lookup type = 'PARTY_RELATIONS_TYPE' | |
OTH_RELATIONSHIP_TYPE | VARCHAR2 | (30) | Other relationship type | |
SURNAME | VARCHAR2 | (150) | Yes | Surname of the person |
GIVEN_NAMES | VARCHAR2 | (150) | Yes | Given names of the person |
MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
TITLE | VARCHAR2 | (60) | Title | |
PRE_NAME_ADJUNCT | VARCHAR2 | (30) | Prefix name of the person | |
PREFERRED_GIVEN_NAME | VARCHAR2 | (601) | Preferred given name | |
BIRTH_DT | DATE | Birth date | ||
RECIPROCAL_FLAG | VARCHAR2 | (1) | OBSOLETE(Reciprocal flag) | |
SEX | VARCHAR2 | (30) | Sex of the person | |
DECEASED | VARCHAR2 | (1) | Deceased indicator | |
DECEASED_DATE | DATE | Deceased date | ||
REL_PERSON_ID | NUMBER | Relation person identifier | ||
MATCH_IND | VARCHAR2 | (2) | Match indicator | |
STATUS | VARCHAR2 | (2) | Yes | Status of the record whether it is imported, pending, error or warning |
ERROR_CODE | VARCHAR2 | (30) | Error code of the record | |
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 | |
REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record | |
PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program. | ||
PERSON_NUMBER | VARCHAR2 | (30) | Person Number Id for Person Number | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Obsolete this Column- Account Number id for Customer Account Number | |
INTERFACE_RUN_ID | NUMBER | (15) | Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_RELATIONS_ID
, ORG_ID
, INTERFACE_ID
, RELATIONSHIP_TYPE
, RELATIONSHIP_CODE
, OTH_RELATIONSHIP_TYPE
, SURNAME
, GIVEN_NAMES
, MIDDLE_NAME
, TITLE
, PRE_NAME_ADJUNCT
, PREFERRED_GIVEN_NAME
, BIRTH_DT
, RECIPROCAL_FLAG
, SEX
, DECEASED
, DECEASED_DATE
, REL_PERSON_ID
, MATCH_IND
, STATUS
, ERROR_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PERSON_NUMBER
, ACCOUNT_NUMBER
, INTERFACE_RUN_ID
FROM IGS.IGS_AD_RELATIONS_INT_ALL;
IGS.IGS_AD_RELATIONS_INT_ALL does not reference any database object
IGS.IGS_AD_RELATIONS_INT_ALL is referenced by following:
|
|
|