DW_EB_X_EBS_DOMAINS_W_DOMAIN_MEMBER_G_TL

Stores language-specific descriptive attributes for domain member groups.

Details

Module: Domains (EBS_DOMAINS)

Business Name: Domain Member Group Translation

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Not Null	Comments
ROW_WID	NUMBER		38	True	Warehouse-generated surrogate key that uniquely identifies the record.
SOURCE_RECORD_ID	VARCHAR2	38 CHAR			Identifier of the record in the source system.
CHANGED_BY_ID	VARCHAR2	80 CHAR			Identifier of the user or process that last changed the record.
CHANGED_ON_DT	TIMESTAMP		6		Date and time when the record was last changed.
CREATED_BY_ID	VARCHAR2	80 CHAR			Identifier of the user or process that created the record.
CREATED_ON_DT	TIMESTAMP		6		Date and time when the record was created.
DATASOURCE_NUM_ID	NUMBER		10		Identifier of the source system from which the record was extracted.
DOMAIN_CODE	VARCHAR2	255 CHAR
DOMAIN_MEMBER_CODE	VARCHAR2	255 CHAR
DOMAIN_MEMBER_DEFN_TYPE_CODE	VARCHAR2	30 CHAR
DOMAIN_MEMBER_DESCR	VARCHAR2	2000 CHAR
DOMAIN_MEMBER_NAME	VARCHAR2	255 CHAR
DOMAIN_MEMBER_REF_CODE	VARCHAR2	255 CHAR
DOMAIN_TYPE_CODE	VARCHAR2	30 CHAR
ETL_PROC_WID	NUMBER		38		Warehouse identifier of the ETL process that loaded the record.
INTEGRATION_ID	VARCHAR2	255 CHAR			Unique identifier of the record in the source system; it may contain concatenated values for composite keys.
LANGUAGE_CODE	VARCHAR2	4 CHAR			Code identifying the language in which translated attributes are stored.
SRC_LANGUAGE_CODE	VARCHAR2	4 CHAR			Code identifying the original language of the source record.
TENANT_ID	VARCHAR2	80 CHAR			Identifier of the tenant associated with the record.
W$_INSERT_DT	TIMESTAMP		6		Date and time when the record was inserted into the warehouse.
W$_UPDATE_DT	TIMESTAMP		6		Date and time when the record was last updated in the warehouse.