Partner Mfqueue

The sequence in which the records was placed in the PARTNER_MFQUEUE. Used to order the publication of messages to the RIB.

Functional key that uniquely identify the change to the partner table that caused the record to be written to the PARTNER_MFQUEUE. Partner_type and partner_id uniquely identify a partner.

Functional key that uniquely identify the change to the partner table that caused the record to be written to the PARTNER_MFQUEUE. Partner_type and partner_id uniquely identify a partner.

Functional key that uniquely identifies the change to the address table that caused the record to be written to the PARTNER_MFQUEUE. Addr_key uniquely identifies an address.

Describes the action in RMS that is causing the message to be published to the RIB.

The functional area that this transaction belongs to, in this case, partner.

Not used by RMS. Oracle Retail target column CUSTOM_MESSAGE_TYPE on PARTNER_MFQUEUE.

Set to Unpublished upon insertion into the table. Will be set to Hospital when a non-fatal error is encountered during the publication process.

Business transaction key. Oracle Retail target column TRANSACTION_NUMBER on PARTNER_MFQUEUE.

Time of record creation. Oracle Retail target column TRANSACTION_TIME_STAMP on PARTNER_MFQUEUE.

Holds the custom flex attribute group id that the extended attribute is associated with. It is the group_id on PARTNER_CFA_EXT or ADDR_CFA_EXT table being published. It is used to indicate that the row on MFQUEUE is a result of CFA_EXT change and will be used to delete the redundant MFQUEUE rows related to CFA_EXT changes for the same entity down in the queue once a create or update message is processed.