Data Dictionary

How to interpret enumerated values throughout API responses

Frequency Codes

Codes for various fields that describe periodic events

CodeDescription
DDaily
WWeekly
MMonthly
QQuarterly
YYearly

Transaction Codes

Codes for various transaction scenarios

CodeDescription
OPEOpening balance (Buy)
CLOClosing balance (Sell)
RCVDeposit or contribution
DLVWithdrawal
INTACCAccrued interest
DIVDividend received
INTInterest received
FEEFee or commission applied

Entity ID Prefixes

A short name with A- or H- prefixed, depending on whether the entity is an account or a household. Unique across both households and accounts, and indicates which one this entity is.

PrefixExample
A-A-CS4778
H-H-HGNCRS

Account and Household Status Codes

Refers to things like active/funded, waiting for deposit, closed, etc.

CodeDescription
0Unknown
14Unfunded account
22Active account
33Active account on trade hold
94, 95New account, unidentified
110Active household
115Active test account or household
199Closed household

Billing Calculation Types

Different metrics for billing rates

TypeDescription
RFlat rate
AFlat account fee
GFlat group fee
DDrop through
TTiered
FFavor

Billing Collection Types

The different methods of billing collection

TypeDescription
RArrears
DAdvance only
PAdvance with proration

Billing Quarter Cycle Codes

Billing cycles and the respective months covered

CodeName
1One
2Two
3Standard

Shared File Types

The different possible file formats of shared files

TypeDescription
1Text file
2Word document
3PDF document
4Powerpoint presentation
5Excel spreadsheet
6Archive
7Image