IBY_VAL_ASSIGNMENTS
IBY_VAL_ASSIGNMENTS links validation sets to the appropriate validation entity. Through this table, individual validation sets are assigned to the payment method, payment format, or other entity that requires the validation encoded in that validation set. Payment method validation sets are those that should be evaluated as soon as possible once a transaction is assigned a payment method. Since each transaction is required to have a payment method assigned, these validations are evaluated immediately upon submission to Oracle Payments. All other types of validations are done offline, once the appropriate format or other entity has been assigned to the transaction. The determination of what type of entity a validation set should be associated with is based on the deploying company's business rules, the rules of the countries that have jurisdiction over the transaction, and ease-of-use. Typically, validations should be performed as early as possible, so users have immediate feedback and opportunity to modify invalid transactions.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
IBY_VAL_ASSIGNMENTS_PK |
VALIDATION_ASSIGNMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| VALIDATION_ASSIGNMENT_ID | NUMBER | 18 | Yes | System-generated primary key. | |
| FIELD_NAME_CODE | VARCHAR2 | 30 | Field name lookup code of user-defined validation. This column can be null for predefined validation. | ||
| VALIDATION_SET_CODE | VARCHAR2 | 30 | Yes | Validation set code | |
| VAL_ASSIGNMENT_ENTITY_TYPE | VARCHAR2 | 30 | Yes | Type of entity to which this validation is assigned. Values, from the lookup IBY_VALIDATION_ASSIGN_ENTITIES, include METHOD, FORMAT, BANK, TRANSPROTOCOL, and INTBANKACCOUNT | |
| ASSIGNMENT_ENTITY_ID | VARCHAR2 | 30 | Yes | Identifier of the appropriate entity, for example, payment method, payment format. | |
| 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. | |
| TERRITORY_CODE | VARCHAR2 | 2 | Country to which the validation is applicable | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Payment method to which the validation is applicable | ||
| START_DATE | DATE | Yes | Date when the assignment of a validation set to the payment method or format becomes active. | ||
| END_DATE | DATE | Yes | Date when the assignment of a validation set to the payment method or format 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_VAL_ASSIGNMENTS | iby_validation_sets_b | VALIDATION_SET_CODE |
| IBY_VAL_ASSIGNMENTS | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_validation_values | iby_val_assignments | VALIDATION_ASSIGNMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_VAL_ASSIGNMENTS_AEID_N1 | Non Unique | Default | ASSIGNMENT_ENTITY_ID |
| IBY_VAL_ASSIGNMENTS_N1 | Non Unique | Default | VAL_ASSIGNMENT_ENTITY_TYPE, ASSIGNMENT_ENTITY_ID |
| IBY_VAL_ASSIGNMENTS_N2 | Non Unique | Default | PAYMENT_METHOD_CODE |
| IBY_VAL_ASSIGNMENTS_N3 | Non Unique | Default | TERRITORY_CODE |
| IBY_VAL_ASSIGNMENTS_VAID_U1 | Unique | Default | VALIDATION_ASSIGNMENT_ID, ORA_SEED_SET1 |
| IBY_VAL_ASSIGNMENTS_VAID_U11 | Unique | Default | VALIDATION_ASSIGNMENT_ID, ORA_SEED_SET2 |