IBY_SYS_PMT_PROFILES_B
IBY_SYS_PMT_PROFILES stores seeded information that specifies the bulk of payment processing behavior. The rest of the behavior is specified in a user-defined account payment process profile stored in IBY_ACCT_PMT_PROFILES. A combination of the two tables is defined in the view IBY_PAYMENT_PROFILES. The payment process profile as a whole controls the behavior of the payment process. To create a payment process profile, the user specifies how the payment instruction should be formatted, how it should be transmitted, how its acknowledgment and clearing files should be handled by the system, and other relevant information. This table corresponds to the Payment Process Profile pages.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
IBY_SYS_PMT_PROFILES_B_PK |
SYSTEM_PROFILE_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| SYSTEM_PROFILE_CODE | VARCHAR2 | 100 | Yes | User-entered primary key. | ||
| LOGICAL_GROUPING_MODE | VARCHAR2 | 30 | Specifies the grouping mode for ISO20022 format. | |||
| BEPID | NUMBER | 18 | Payment system Identifier | |||
| SECURITY_PROTOCOL_CODE | VARCHAR2 | 100 | Security protocol Identifier | |||
| TRANSMIT_PROTOCOL_CODE | VARCHAR2 | 100 | Transmission protocol Identifier | |||
| PAYMENT_FORMAT_CODE | VARCHAR2 | 30 | Yes | Payment format code | ||
| POSITIVE_PAY_FORMAT_CODE | VARCHAR2 | 30 | Positive pay format code | |||
| PAY_FILE_LETTER_FORMAT_CODE | VARCHAR2 | 30 | Payment file accompanying letter format code | |||
| PRINT_INSTRUCTION_IMMED_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether a printed payment instruction should be printed immediately after the payment instruction is created. The default value of this flag is N. The value of this flag defaults to the Print Directly After Formatting parameter of the Create Payment Instruction program. | ||
| DEFAULT_PRINTER | VARCHAR2 | 255 | Printer to be used by default for printing payments. | |||
| DEFAULT_PAYMENT_DOCUMENT_ID | NUMBER | 18 | Payment document to be used by default for printing payments. | |||
| PERIODIC_SEQUENCE_NAME_1 | VARCHAR2 | 80 | Name of the sequence. The name is referenced in the payment format templates. | |||
| PERIODIC_SEQUENCE_NAME_2 | VARCHAR2 | 80 | Name of the sequence. The name is referenced in the payment format templates. | |||
| PERIODIC_SEQUENCE_NAME_3 | VARCHAR2 | 80 | Name of the sequence. The name is referenced in the payment format templates. | |||
| PROCESSING_TYPE | VARCHAR2 | 30 | Yes | Specifies what type of processing should be done. Values from the IBY_PROCESSING_TYPES lookup include ELECTRONIC and PRINTED. | ||
| MARK_COMPLETE_EVENT | VARCHAR2 | 30 | Yes | Event at which payments in a payment instruction are automatically marked complete. Values are from the lookup IBY_MARK_COMPLETE_EVENTS. Value for payments with a processing type of Printed is always PRINTED. | ||
| MANUAL_MARK_COMPLETE_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether an administrator can manually mark the payments in a payment instruction complete after the instruction is formatted, but before it is automatically marked complete | ||
| POSITIVE_PAY_DELIVERY_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether Positive Pay is delivered using the same transmission configuration as the payment instruction. | ||
| TRANSMIT_INSTR_IMMED_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether an electronic payment instruction should be transmitted immediately after the payment instruction is created. The default value of this flag is N. The value of this flag defaults to the Print Directly After Formatting parameter of the Create Payment Instruction program. | ||
| SEEDED_FLAG | VARCHAR2 | 1 | Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited. | |||
| AUTOMATIC_PI_REG_SUBMIT | VARCHAR2 | 1 | Yes | Y or N flag indicating whether the payment instruction register is submitted automatically at the payment completion point | ||
| AUTOMATIC_PPR_REPORT_SUBMIT | VARCHAR2 | 1 | Submit payment process request status report automatically | |||
| 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. | ||
| DECLARATION_OPTION | VARCHAR2 | 30 | Specifies the customer's chosen declaration option. The declaration options are defined in IBY_CENTRAL_BANK_REPORT_OPTION lookup. They include NO_DECLARATIONS, DECLARE_THROUGH_BANK, and DECLARE_DIRECT_TO_CENTRAL_BANK | |||
| DCL_ONLY_FOREIGN_CURR_PMT_FLAG | VARCHAR2 | 1 | Used in upgrade. | |||
| DECLARATION_REPORT_FORMAT_CODE | VARCHAR2 | 30 | Format of the Regulatory Report. Only needed if the DECLARATION_OPTION is set to DECLARE_DIRECT_TO_CENTRAL_BANK | |||
| DECLARATION_CURR_FX_RATE_TYPE | VARCHAR2 | 255 | Exchange rate type, such as corporate, spot, and daily, used for regulatory reporting. Types are defined in the General Ledger currency exchange rate type table. | |||
| DECLARATION_CURRENCY_CODE | VARCHAR2 | 10 | Declaration or reporting currency code | |||
| DECLARATION_THRESHOLD_AMOUNT | NUMBER | Threshold amount, above which the payment needs to be reported to the central bank | ||||
| BANK_INSTRUCTION1_CODE | VARCHAR2 | 30 | Code of first bank instruction | |||
| BANK_INSTRUCTION2_CODE | VARCHAR2 | 30 | Code of second bank instruction | |||
| BANK_INSTRUCTION_DETAILS | VARCHAR2 | 255 | Additional bank instruction details | |||
| PAYMENT_TEXT_MESSAGE1 | VARCHAR2 | 150 | Text message for use in payment processing | |||
| PAYMENT_TEXT_MESSAGE2 | VARCHAR2 | 150 | Text message for use in payment processing | |||
| INACTIVE_DATE | DATE | Inactive date | ||||
| ACK_TRANSMIT_PROTOCOL_CODE | VARCHAR2 | 100 | Transmission protocol identifier for acknowledgment file | |||
| ACK_SECURITY_PROTOCOL_CODE | VARCHAR2 | 100 | Security protocol identifier for acknowledgment file | |||
| SEND_TO_FILE_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether the payment format output should be sent to a file or a system printer. A Y value indicates that the formatted output is sent to a file so that payments may be printed outside of Oracle Payments. An N value indicates that the printing of the formatted output is managed within Oracle Payments. | ||
| PPR_REPORT_FORMAT | VARCHAR2 | 30 | Format to be used for payment process request status report | |||
| PI_REGISTER_FORMAT | VARCHAR2 | 30 | Payment Instruction Register format | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Process Profiles (IBY_SYS_PMT_PROFILES) | ||
| OUTBOUND_PMT_FILE_DIRECTORY | VARCHAR2 | 255 | File directory where output of outbound payment file is stored | |||
| OUTBOUND_PMT_FILE_EXTENSION | VARCHAR2 | 255 | File extension of outbound payment files | |||
| OUTBOUND_PMT_FILE_PREFIX | VARCHAR2 | 255 | File name prefix of outbound payment files | |||
| POSITIVE_PAY_FILE_DIRECTORY | VARCHAR2 | 255 | File directory where output of positive pay file is stored | |||
| POSITIVE_PAY_FILE_EXTENSION | VARCHAR2 | 255 | File extension of positive pay files | |||
| POSITIVE_PAY_FILE_PREFIX | VARCHAR2 | 255 | File name prefix of positive pay files | |||
| ELECTRONIC_PROCESSING_CHANNEL | VARCHAR2 | 50 | Investigate | |||
| START_DATE | DATE | Yes | Date from which the payment process profile is available for use. | |||
| END_DATE | DATE | Yes | Date until which the payment process profile is available for use. | |||
| BATCH_BOOKING_FLAG | VARCHAR2 | 1 | Denotes if customer requests for batch booking entry to their bank. | |||
| SERVICE_LEVEL_CODE | VARCHAR2 | 30 | The service level with which a payment transaction should be processed. | |||
| DELIVERY_CHANNEL_CODE | VARCHAR2 | 30 | Additional information to qualify a service level. | |||
| 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_SYS_PMT_PROFILES_B | iby_bepinfo | BEPID |
| IBY_SYS_PMT_PROFILES_B | iby_transmit_protocols_b | TRANSMIT_PROTOCOL_CODE |
| IBY_SYS_PMT_PROFILES_B | iby_formats_b | PAYMENT_FORMAT_CODE |
| IBY_SYS_PMT_PROFILES_B | iby_formats_b | POSITIVE_PAY_FORMAT_CODE |
| IBY_SYS_PMT_PROFILES_B | iby_formats_b | PAY_FILE_LETTER_FORMAT_CODE |
| iby_pmt_logical_grp_rules | iby_sys_pmt_profiles_b | SYSTEM_PROFILE_CODE |
| iby_pmt_creation_rules | iby_sys_pmt_profiles_b | SYSTEM_PROFILE_CODE |
| iby_applicable_pmt_profs | iby_sys_pmt_profiles_b | SYSTEM_PROFILE_CODE |
| iby_remit_advice_setup | iby_sys_pmt_profiles_b | SYSTEM_PROFILE_CODE |
| iby_ack_process_profiles | iby_sys_pmt_profiles_b | FD_SYSTEM_PROFILE_CODE |
| iby_pmt_grouping_rules | iby_sys_pmt_profiles_b | SYSTEM_PROFILE_CODE |
| iby_sys_pmt_profiles_tl | iby_sys_pmt_profiles_b | SYSTEM_PROFILE_CODE |
| iby_instr_creation_rules | iby_sys_pmt_profiles_b | SYSTEM_PROFILE_CODE |
| iby_acct_pmt_profiles_b | iby_sys_pmt_profiles_b | SYSTEM_PROFILE_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_SYS_PMT_PROFILES_B_N1 | Non Unique | Default | PAYMENT_FORMAT_CODE |
| IBY_SYS_PMT_PROFILES_B_U1 | Unique | Default | SYSTEM_PROFILE_CODE, ORA_SEED_SET1 |
| IBY_SYS_PMT_PROFILES_B_U11 | Unique | Default | SYSTEM_PROFILE_CODE, ORA_SEED_SET2 |