Entity Definition

Logical Name : StoredValueTransaction
Physical Name : TR_STRD_VL_TRN

A type of Transaction that captures the activation, loading, canceling and other actions taken for a StoredValueInstrument.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
ActivityCode Activity code defines actions that may be applied to a SVI that changes its state and the monetary balance it carries. Valid values (based on POSLOG6) include: Activation enables a stored value -instrument Associate BalanceTransfer transfer balance from one SVI to another Cancel Cancel a Card ( Cashout Convert balance to cash and deactivate Deactivate Deactivate a card Expired SVI expired - escheatment Recharge Add monetary value to the SVI Refund Refund value (add prior Replace Replace the SVI Stolen Flag SVI as stolen and deactivate it Void Flag SVI as VOID and deactivate it CD_ACTV Code varchar(20)
StoredValueInstrumentID (FK) A token ID for a StoredValueInstrument ID_STRD_VL_INSTRMNT Identity integer StoredValueInstrument(DO_STRD_VL_INSTRMNT)
CustomerAccountID (FK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerStoredValueAccount(LE_CT_STRD_VL_ACNT)


Parent Entity Verb Phrase Child Entity
StoredValueInstrument is altered by StoredValueTransaction
CustomerStoredValueAccount is altered by StoredValueTransaction
StoredValueTransaction is authorized by StoredValueInstrumentActivationAuthorization

Logical Views containing StoredValueTransaction

Logical View
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 02500 - Tender Control Transaction - Macro View
Logical 02510 - Tender Control Transaction - Movement View