[Home] [Help] [Dependency Information]
Object Name: | HZ_TRANS_ATTRIBUTES_B |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_TRANS_ATTRIBUTES_B |
Subobject Name: | |
Status: | VALID |
The HZ_TRANS_ATTRIBUTES_B table stores attribute
characteristics of the logical entities (Party, Party
Sites, Contacts, and Contact Points) that transformation functions are defined
for. The table also includes the attribute name and the entity that the
attribute belongs to. The transformed attributes are used for Data Quality
Management.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_TRANS_ATTRIBUTES_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_ID
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_ID | NUMBER | (15) | Yes | Sequence generated id to uniquely identify a transformation attribute |
ATTRIBUTE_NAME | VARCHAR2 | (255) | Yes | Pre-seeded Attribute name |
ENTITY_NAME | VARCHAR2 | (255) | Yes | Name of the logical entity from which the attribute is derived |
CUSTOM_ATTRIBUTE_PROCEDURE | VARCHAR2 | (600) | Procedure to acquire data for custom attributes | |
SOURCE_TABLE | VARCHAR2 | (255) | Source table for the attribute | |
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). |
OBJECT_VERSION_NUMBER | NUMBER | Version number of record | ||
DENORM_FLAG | VARCHAR2 | (1) | Indicates if data from this column should be denormalized to aprty level for faster searches | |
TEMP_SECTION | VARCHAR2 | (30) | Column to temporarily hold an intermedia index section name used to distinguish attributes created with 24/7 search support. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_ID
, ATTRIBUTE_NAME
, ENTITY_NAME
, CUSTOM_ATTRIBUTE_PROCEDURE
, SOURCE_TABLE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER
, DENORM_FLAG
, TEMP_SECTION
, ZD_EDITION_NAME
FROM AR.HZ_TRANS_ATTRIBUTES_B;
AR.HZ_TRANS_ATTRIBUTES_B does not reference any database object
AR.HZ_TRANS_ATTRIBUTES_B is referenced by following:
|
|
|