DW_EB_X_EBS_COMMON_W_BANK_D

Banks table is used for tracking attributes associated with banks.

Details

Module: Common Tables (EBS_COMMON)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Not Null	Comments	Referred Table
ROW_WID	NUMBER		38	True	Surrogate key to uniquely identify a record.
ACCDET_ID	VARCHAR2	30 CHAR			Account Detail ID
ACCDET_NAME	VARCHAR2	80 CHAR			Description for Account Detail ID
ACTIVE_FLG	VARCHAR2	1 CHAR			Active Flag
AUX1_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX2_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX3_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX4_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
BANK_ACCT_ALT_NUM	VARCHAR2	400 CHAR			Bank Account Alternate Number
BANK_ACCT_NUM	VARCHAR2	120 CHAR			Bank Account Number
BANK_ALT_NAME	VARCHAR2	1500 CHAR			Name for Alternative bank acct number
BANK_ALT_NUM	VARCHAR2	30 CHAR			Alternative bank acct number
BANK_BRANCH_CODE	VARCHAR2	360 CHAR			Bank Branch Code
BANK_BRANCH_NAME	VARCHAR2	360 CHAR			Bank Branch Name
BANK_CAT_CODE	VARCHAR2	100 CHAR			Bank Category ( Customer, Supplier, Company)
BANK_CAT_NAME	VARCHAR2	80 CHAR			Bank Category Description
BANK_HIER_CODE	VARCHAR2	50 CHAR			Bank Hierarchy Code
BANK_HIER_NAME	VARCHAR2	80 CHAR			Bank Hierarchy Description
BANK_ID	VARCHAR2	30 CHAR			Bank ID
BANK_KEY_CODE	VARCHAR2	50 CHAR			Bank key code
BANK_NAME	VARCHAR2	360 CHAR			Name of the bank
BANK_NUMBER	VARCHAR2	30 CHAR			Bank number or Bank Code
BANK_TYPE_CODE	VARCHAR2	50 CHAR			Type of Bank
BANK_TYPE_NAME	VARCHAR2	80 CHAR			Description of Bank Type
BANK_USER_NAME	VARCHAR2	1000 CHAR			Bank Account Holder's Name
CHANGED_BY_WID	NUMBER		38		This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was last modified in the source system.
CITY	VARCHAR2	80 CHAR			City
CONTACT_NAME	VARCHAR2	360 CHAR			Name of contact person
COUNTRY_CODE	VARCHAR2	60 CHAR			Country Code
COUNTRY_NAME	VARCHAR2	80 CHAR			Name of the country
COUNTRY_REGION	VARCHAR2	80 CHAR			Country Region
COUNTY	VARCHAR2	80 CHAR			County
CREATED_BY_WID	NUMBER		38		This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was initially created in the source system.
CURRENT_FLG	VARCHAR2	1 CHAR			This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous.
DATASOURCE_NUM_ID	NUMBER		10		This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances.
DELETE_FLG	VARCHAR2	1 CHAR			This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active.
EFFECTIVE_FROM_DT	TIMESTAMP		6		This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
EFFECTIVE_TO_DT	TIMESTAMP		6		This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
ETL_PROC_WID	NUMBER		38		Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
INTEGRATION_ID	VARCHAR2	80 CHAR			This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts.
PHONE_NUM	VARCHAR2	40 CHAR			Phone Number
POSTAL_CODE	VARCHAR2	50 CHAR			Postal Code
SET_ID	VARCHAR2	30 CHAR			This column represents the unique identifier often used by source systems for the purpose of data sharing, reducing redundancies and minimizing system maintenance tasks, or even to drive data visibility. From a datawarehouse standpoint, the intended use of this column is to drive dimensional data security, primarily.
SRC_EFF_FROM_DT	TIMESTAMP		6		This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
SRC_EFF_TO_DT	TIMESTAMP		6		This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
STATE_CODE	VARCHAR2	50 CHAR			State Code
STATE_NAME	VARCHAR2	80 CHAR			State Name
STATE_REGION	VARCHAR2	80 CHAR			State Region
STREET_ADDRESS1	VARCHAR2	240 CHAR			Street Address 1
STREET_ADDRESS2	VARCHAR2	80 CHAR			Street Address 2
SWIFT_CODE	VARCHAR2	50 CHAR			SWIFT code for international payments
SWIFT_NAME	VARCHAR2	80 CHAR			SWIFT name for international payments
TAX_NUMBER	VARCHAR2	30 CHAR			Tax ID Number
TENANT_ID	VARCHAR2	80 CHAR			This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model.
X_CUSTOM	VARCHAR2	10 CHAR			This column is used as a generic field for customer extensions.
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6