[Home] [Help] [Dependency Information]
Object Name: | HZ_ENTITY_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_ENTITY_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
The HZ_ENTITY_ATTRIBUTES table stores information about the entities and attributes included in the Third Party Data Integration setup. The setup determines which data source populates these entities and attributes in the TCA registry. All D&B related entities and attributes are seeded.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_ENTITY_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
ENTITY_ATTR_ID
ZD_EDITION_NAME |
HZ_ENTITY_ATTRIBUTES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
ENTITY_NAME
ATTRIBUTE_NAME ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENTITY_ATTR_ID | NUMBER | (15) | Yes | Sequence generated unique identifier of an attribute. |
ENTITY_NAME | VARCHAR2 | (30) | Yes | Name of the entity for data source setup, from the ENTITY_NAME lookup type. |
ATTRIBUTE_NAME | VARCHAR2 | (30) | HZ_PERSON_PROFILES lookup types. | |
ATTRIBUTE_GROUP_NAME | VARCHAR2 | (30) | Name of the group of attributes for data source setup. | |
UPDATED_FLAG | VARCHAR2 | (1) | Flag to indicate if the attribute setup was updated since the last run of the Third Party Data Integration Update. Y indicates attribute setup was update. N indicates no update. | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Source application module that created this record. | |
APPLICATION_ID | NUMBER | Unique identifier for the application that created this record. Foreign key to FND_APPLICATION table. | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ENTITY_ATTR_ID
, ENTITY_NAME
, ATTRIBUTE_NAME
, ATTRIBUTE_GROUP_NAME
, UPDATED_FLAG
, CREATED_BY_MODULE
, APPLICATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ZD_EDITION_NAME
FROM AR.HZ_ENTITY_ATTRIBUTES;
AR.HZ_ENTITY_ATTRIBUTES does not reference any database object
AR.HZ_ENTITY_ATTRIBUTES is referenced by following:
|
|
|