Table TRANSACTION_DIMENSION

DescriptionTransaction identifies a business activity which represents the recording of all levels of business work that change the Financial Institution's financial position or information base.

Columns
AUTHORIZATION_CODEAUTHORIZATION_CODE
BROKER_CODEBROKER_CODE
BROKER_NAMEBROKER_NAME
CODECODE
COUNTERPARTY_CODECOUNTERPARTY_CODE
COUNTERPARTY_NAMECOUNTERPARTY_NAME
DESCRIPTIONDESCRIPTION
EMPLOYEE_NAMEEMPLOYEE_NAME
EMPLOYEE_NUMBEREMPLOYEE_NUMBER
EXCHANGE_CHANNEL_CODEEXCHANGE_CHANNEL_CODE
EXCHANGE_CHANNEL_NAMEEXCHANGE_CHANNEL_NAME
GENERATING_TRANSACTION_CODEGENERATING_TRANSACTION_CODE
INITIATING_SOURCE_SYSTEM_CODEINITIATING_SOURCE_SYSTEM_CODE
INITIATING_SOURCE_SYSTEM_NAMEINITIATING_SOURCE_SYSTEM_NAME
INITIATING_INVOLVED_PARTY_SOURCE_CODEINITIATING_INVOLVED_PARTY_SOURCE_CODE
INITIATING_INVOLVED_PARTY_SOURCE_NAMEINITIATING_INVOLVED_PARTY_SOURCE_NAME
NAMENAME
ORGANIZATION_UNIT_CODEORGANIZATION_UNIT_CODE
ORGANIZATION_UNIT_NAMEORGANIZATION_UNIT_NAME
OUR_PARTY_CODEOUR_PARTY_CODE
OUR_PARTY_NAMEOUR_PARTY_NAME
PLACE_OF_TRADE_CODEPLACE_OF_TRADE_CODE
PLACE_OF_TRADE_NAMEPLACE_OF_TRADE_NAME
PRIMARY_ARRANGEMENT_NAMEPRIMARY_ARRANGEMENT_NAME
PRIMARY_ARRANGEMENT_NUMBERPRIMARY_ARRANGEMENT_NUMBER
PRODUCT_CODEPRODUCT_CODE
PRODUCT_NAMEPRODUCT_NAME
REQUESTING_CHANNEL_CODEREQUESTING_CHANNEL_CODE
REQUESTING_CHANNEL_NAMEREQUESTING_CHANNEL_NAME
REQUESTING_COMMUNICATION_CODEREQUESTING_COMMUNICATION_CODE
REQUESTING_COMMUNICATION_NAMEREQUESTING_COMMUNICATION_NAME
SETTLEMENT_CHANNEL_CODESETTLEMENT_CHANNEL_CODE
SETTLEMENT_CHANNEL_NAMESETTLEMENT_CHANNEL_NAME
SUSPICIOUS_GROUP_CODESUSPICIOUS_GROUP_CODE
SUSPICIOUS_GROUP_NAMESUSPICIOUS_GROUP_NAME
TRANSACTION_CURRENCY_CODETRANSACTION_CURRENCY_CODE
ANCHOR_IDANCHOR_ID
CURRENT_ROW_INDICATORCURRENT_ROW_INDICATOR
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
POPULATION_DATEPOPULATION_DATE
POPULATION_TIMEPOPULATION_TIME
POPULATION_DESCRIPTIONPOPULATION_DESCRIPTION
SOURCE_SYSTEM_NAMESOURCE_SYSTEM_NAME
SOURCE_SYSTEM_CODESOURCE_SYSTEM_CODE
UNIQUE_ID_IN_SOURCE_SYSTEMUNIQUE_ID_IN_SOURCE_SYSTEM
TRANSACTION_DIMENSION_IDTRANSACTION_DIMENSION_ID

Primary Key
TRANSACTION_DIMENSION_PKTRANSACTION_DIMENSION_PK

Indexes
TRANSACTION_DIMENSION_PKTRANSACTION_DIMENSION_PK

Column Details

 AUTHORIZATION_CODE
DescriptionAuthorization Code indicates a code which has been received to authorize a requested action.
Data TypeCHAR(32)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BROKER_CODE
DescriptionBroker Code indicates a short alphanumeric identifier that uniquely identifies the Broker.
Data TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BROKER_NAME
DescriptionBroker Name indicates the entire and complete name of the subject Broker; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE
DescriptionCode indicates the text string identifier assigned to the Transaction.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COUNTERPARTY_CODE
DescriptionCounterparty Code indicates a short alphanumeric identifier that uniquely identifies the Counterparty.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COUNTERPARTY_NAME
DescriptionCounterparty Name indicates the entire and complete name of the subject Counterparty; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription indicates a textual explanation or free form comments about the Transaction.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EMPLOYEE_NAME
DescriptionEmployee Name indicates the entire and complete name of the subject Employee; for example, 'John A. Doe'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EMPLOYEE_NUMBER
DescriptionEmployee Number indicates an identifier by which the Employee is known to the Financial Institution.
Data TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXCHANGE_CHANNEL_CODE
DescriptionExchange Channel Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Group occurrence for purposes of identification.
Data TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXCHANGE_CHANNEL_NAME
DescriptionExchange Channel Name indicates a label by which Channel is known; for example, Group #43 is known as, and is commonly called,
'Fiscal Year 1993 Marketing Prospects'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GENERATING_TRANSACTION_CODE
DescriptionGenerating Transaction Code indicates the text string identifier assigned to the Transaction.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INITIATING_SOURCE_SYSTEM_CODE
DescriptionInitiating Source System Code indicates the code by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INITIATING_SOURCE_SYSTEM_NAME
DescriptionInitiating Source System Name indicates the textual name by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INITIATING_INVOLVED_PARTY_SOURCE_CODE
DescriptionInvolved Party Source Code indicates a short alphanumeric identifier that uniquely identifies the Involved Party.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INITIATING_INVOLVED_PARTY_SOURCE_NAME
DescriptionInvolved Party Source Name indicates the entire and complete name of the subject Involved Party; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionName indicates the primary name assigned to the Transaction.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ORGANIZATION_UNIT_CODE
DescriptionOrganization Unit Code indicates an internal code or business identifier used within the Financial Institution to identify the Organization Unit e.g. for accounting purposes.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ORGANIZATION_UNIT_NAME
DescriptionOrganization Unit Name indicates the entire and complete name of the Organization Unit.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OUR_PARTY_CODE
DescriptionOur Party Code indicates a short alphanumeric identifier that uniquely identifies the Our Party.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OUR_PARTY_NAME
DescriptionOur Party Name indicates the entire and complete name of the subject Our Party; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLACE_OF_TRADE_CODE
DescriptionPlace Of Trade Code indicates an internal code or business identifier used within the Financial Institution to identify the Place of Trade.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLACE_OF_TRADE_NAME
DescriptionPlace Of Trade Name indicates the entire and complete name of the subject Place Of Trade.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIMARY_ARRANGEMENT_NAME
DescriptionPrimary Arrangement Name indicates the label given to a specific Arrangement. The Financial Institution or their customers often require a name for an Arrangement to more easily distinguish it from other Arrangements. For example; a Mutual Fund Arrangement may be named 'Michael's College Fund" by his parents, the customers in the Arrangement.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIMARY_ARRANGEMENT_NUMBER
DescriptionPrimary Arrangement Number indicates the number of the Arrangement as defined by the Financial Institution.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRODUCT_CODE
DescriptionProduct Code indicates a mnemonic or highly abbreviated name for the Product. For example; IBMC is the mnemonic for International Business Machines Corporation Common Stock.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRODUCT_NAME
DescriptionProduct Name indicates a label by which the Product is publicly recognized and used.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REQUESTING_CHANNEL_CODE
DescriptionRequesting Channel Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Group occurrence for purposes of identification.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REQUESTING_CHANNEL_NAME
DescriptionRequesting Channel Name indicates a label by which Channel is known; for example, Group #43 is known as, and is commonly called,
'Fiscal Year 1993 Marketing Prospects'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REQUESTING_COMMUNICATION_CODE
DescriptionRequesting Communication Code indicates the text string identifier assigned to the Communication.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REQUESTING_COMMUNICATION_NAME
DescriptionRequesting Communication Name indicates the primary name assigned to the Communication.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SETTLEMENT_CHANNEL_CODE
DescriptionSettlement Channel Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Group occurrence for purposes of identification.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SETTLEMENT_CHANNEL_NAME
DescriptionSettlement Channel Name indicates a label by which Channel is known; for example, Group #43 is known as, and is commonly called,
'Fiscal Year 1993 Marketing Prospects'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUSPICIOUS_GROUP_CODE
DescriptionSuspicious Group Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Group occurrence for purposes of identification.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUSPICIOUS_GROUP_NAME
DescriptionSuspicious Group Name indicates a label by which an instance of Group is known; for example, Group #43 is known as, and is commonly called,
'Fiscal Year 1993 Marketing Prospects'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRANSACTION_CURRENCY_CODE
DescriptionTransaction Currency Code indicates the internationally recognised alphabetic code standard for currency which may consist of a combination of country and country reference alphabetic codes.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAnchor Id indicates any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENT_ROW_INDICATOR
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionEffective From Date indicates the effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionEffective To Date indicates the effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionValid From Date indicates the transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionValid To Date indicates the transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DATE
DescriptionPopulation Date indicates the date on which the instance of the entity was last updated.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIME
DescriptionPopulation Time indicates the time on which the instance of the entity was last updated.
Data TypeTIME
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DESCRIPTION
DescriptionPopulation Description indicates the textual description of the population cycle.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_NAME
DescriptionSource System Name indicates the textual name by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_CODE
DescriptionSource System Code indicates the code by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIQUE_ID_IN_SOURCE_SYSTEM
DescriptionUnique Id In Source System indicates the unique identifier of the populated instance in the Source System.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRANSACTION_DIMENSION_ID
DescriptionThe unique identifier of the Transaction Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 TRANSACTION_DIMENSION_PK
DescriptionThe unique identifier of the Transaction Dimension
MemberTRANSACTION_DIMENSION_ID [BIGINT]

Index Details

 TRANSACTION_DIMENSION_PK
DescriptionThe unique identifier of the Transaction Dimension
Is Uniquetrue
Is Clusteredfalse
MemberTRANSACTION_DIMENSION_ID [BIGINT] Ascending