IBY_TRANSMIT_CONFIGS_B

IBY_TRANSMIT_CONFIGS defines a transmission channel with all parameters for the communication scheme, such as network addresses, defined. A transmission configuration is associated with one of the funds capture profiles.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

IBY_TRANSMIT_CONFIGS_B_PK

TRANSMIT_CONFIGURATION_ID

Columns

Name Datatype Length Precision Not-null Comments
TRANSMIT_CONFIGURATION_ID NUMBER 18 Yes System-generated primary key.
TRANSMIT_PROTOCOL_CODE VARCHAR2 30 Yes Transmission protocol identifier
TUNNELING_TRANS_CONFIG_ID NUMBER 18 Transmission configuration for the tunneling protocol used to encapsulate this one- for example, a web service request to perform FTP transmission
INACTIVE_DATE DATE Inactive date
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
START_DATE DATE Yes Date when the transmission configuration becomes active.
END_DATE DATE Yes Date when the transmission configuration becomes inactive.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
IBY_TRANSMIT_CONFIGS_B iby_transmit_protocols_b TRANSMIT_PROTOCOL_CODE
IBY_TRANSMIT_CONFIGS_B iby_transmit_configs_b TUNNELING_TRANS_CONFIG_ID
iby_fndcpt_user_eft_pf_b iby_transmit_configs_b VERIFY_TRANS_CONFIG_ID
iby_fndcpt_user_eft_pf_b iby_transmit_configs_b FUNDS_XFER_TRANS_CONFIG_ID
iby_fndcpt_user_eft_pf_b iby_transmit_configs_b QUERY_TRANS_CONFIG_ID
iby_transmit_values iby_transmit_configs_b TRANSMIT_CONFIGURATION_ID
iby_fndcpt_user_cc_pf_b iby_transmit_configs_b ONLINE_AUTH_TRANS_CONFIG_ID
iby_fndcpt_user_cc_pf_b iby_transmit_configs_b SETTLEMENT_TRANS_CONFIG_ID
iby_fndcpt_user_cc_pf_b iby_transmit_configs_b QUERY_TRANS_CONFIG_ID
iby_pay_instructions_h iby_transmit_configs_b TRANSMIT_CONFIGURATION_ID
iby_transmit_configs_tl iby_transmit_configs_b TRANSMIT_CONFIGURATION_ID
iby_fndcpt_user_dc_pf_b iby_transmit_configs_b ONLINE_DEB_TRANS_CONFIG_ID
iby_fndcpt_user_dc_pf_b iby_transmit_configs_b SETTLEMENT_TRANS_CONFIG_ID
iby_fndcpt_user_dc_pf_b iby_transmit_configs_b QUERY_TRANS_CONFIG_ID
iby_acct_pmt_profiles_b iby_transmit_configs_b TRANSMIT_CONFIGURATION_ID
iby_transmit_configs_b iby_transmit_configs_b TUNNELING_TRANS_CONFIG_ID

Indexes

Index Uniqueness Tablespace Columns
IBY_TRANSMIT_CONFIGS_B_CID_U1 Unique Default TRANSMIT_CONFIGURATION_ID, ORA_SEED_SET1
IBY_TRANSMIT_CONFIGS_B_CID_U11 Unique Default TRANSMIT_CONFIGURATION_ID, ORA_SEED_SET2