[Home] [Help] [Dependency Information]
Object Name: | HZ_ORIG_SYSTEMS_B |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_ORIG_SYSTEMS_B |
Subobject Name: | |
Status: | VALID |
The HZ_ORIG_SYSTEMS_B table stores information about source systems, which are systems that load data into the TCA Registry. This table includes basic information about source systems, such as their name, description, and type, as well as the status of the system to indicate whether the system is actively providing data to TCA or not. The source system type can be Spoke, for legacy systems, or Purchased, for third party data providers.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_ORIG_SYSTEMS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ORIG_SYSTEM_ID |
HZ_ORIG_SYSTEMS_U2 | NORMAL | UNIQUE | APPS_TS_SEED | ORIG_SYSTEM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORIG_SYSTEM_ID | NUMBER | (15) | Yes | Source system identifier |
ORIG_SYSTEM | VARCHAR2 | (30) | Yes | Source system code |
ORIG_SYSTEM_TYPE | VARCHAR2 | (30) | Yes | Source system type, Spoke or Purchased |
SST_FLAG | VARCHAR2 | (1) | Yes | Indicates if source system is enabled for Single Source of Truth and used as content source. Y for yes, N or null for no. |
STATUS | VARCHAR2 | (1) | Yes | Status of the source system. Active or inactive. |
START_DATE_ACTIVE | DATE | Yes | Source system activation date | |
END_DATE_ACTIVE | DATE | Source system deactivation date | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Yes | Module that created the source system |
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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT ORIG_SYSTEM_ID
, ORIG_SYSTEM
, ORIG_SYSTEM_TYPE
, SST_FLAG
, STATUS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
FROM AR.HZ_ORIG_SYSTEMS_B;
AR.HZ_ORIG_SYSTEMS_B does not reference any database object
AR.HZ_ORIG_SYSTEMS_B is referenced by following:
|
|
|