Skip to end of metadata
Go to start of metadata

Cash-limit tracking is designed to address the requirements of U.S. schools to file the IRS form 8300, but it is designed to be reasonably expandable to allow for use in other areas with similar regulations.


Table: CASH_LIMIT_EVENT

Core table of the cash-limit tracking system, recording a cash-limit event.

Column

Description

ID

Autonumbered primary key.

ACCOUNT_ID

Account to which this event refers.

CREATOR_ID

The user id of the person who triggered this event.

EVENT_DATE

Date and time of the event (i.e. the transaction that triggered the event).

TOTAL_PAYMENT_AMOUNT

The total of all the transactions reference in this event. Note that the rules engine may have to lower this amount, due to IRS reporting rules.

TOTAL_CHARGE_AMOUNT

Total price of the transaction being paid. This is set via the rules engine.

IS_MULTIPLE

If there is more than one transaction referenced in this event, this will be set to TRUE. Otherwise, it will be FALSE.

SERIALS

Serial numbers of known monetary instruments.

NOTIF_RECIPIENT

Email address of the person to whom details of this event were sent.

NOTIF_SENT_DATE

Date and time when the notification was sent.

STATUS

Status of the transaction. (Q)ueued, (C)omplete, (I)gnored. See the process flows for when an event might be ignored.

REPORTING_DATE

Date and time when the reporting (the 8300) was completed.

XML_ID_FK

Pointer to the XML file create after an 8300 (or similar) is produced.

Table: CASH_LIMIT_SUM_ELEMENT

Simple key/value pair table for extended attributes of the cash/limit tracking system.

Column

Description

ID

Autonumbered primary key.

CASH_LIMIT_EVENT_ID_FK

Link to the cash-limit event.

NAME

Name of the value (human readable)

XML_ELEMENT

XML name of the value.

AMOUNT

Amount of the summary.

NATIVE_AMOUNT

Native amount of the summary.

Table: CASH_LIMIT_EVENT_TRANS

Simple association table.

Column

Description

ID

Autonumbered primary key.

CASH_LIMIT_EVENT_ID_FK

Link to the cash-limit event.

TRANSACTION_ID_FK

Link to the transaction.

Table: CASH_LIMIT_PARAMETER

Stores the items that are tracked by the cash-limit system.

Column

Description

ID

Autonumbered primary key.

TAG_ID_FK

Pointer to the tag that is tracked.

LOWER_LIMIT

Lower bound of transactions that are tracked.

UPPER_LIMIT

Upper bound of transactions that are tracked.

AUTHORITY_NAME

Name of the type of transaction in official parlance.

XML_ELEMENT

Tag that is used to identify this on the XML form.

  • No labels