Lookup tables are not documented individually, because they always have the same three-column structure:
In select cases (noted below), lookup tables may be extended with additional columns. This is usually done when
there are hierarchical relationships between lookup tables, or when the tables supply additional default information
for new entities being established in the system.
| Table Name |
Type |
Description |
| acctgrp |
Custom |
Account group (optional, usually assigned for reporting purposes) |
| acctmeth |
System |
Accounting method (cost, market, FIFO, lots) |
| accttype |
Custom |
Account type (customer-defined categories) |
| apoplist |
Custom |
Approved other party list (optional) |
| avalfeat |
System |
Available features (maturity, call, par call, and/or put) |
| calccode |
System |
Calculation code (primary case selector in calculator) |
| calendar |
Custom |
Calendar (includes fields that indicate whether Saturday and/or Sunday
are business days) |
| cashtype |
System |
Cash transaction type (deposit or withdrawal) |
| clrmatch |
System |
Clearance match method (manual or automatic) |
| clrstat |
Custom |
Clearance status (DTC, NSCC, written, or verbal) |
| codealer |
Custom |
Co-dealer (optional, for new deals) |
| commtype |
Custom |
Commission type |
| country |
Custom |
Country (includes field for default_currency_code) |
| credwtch |
System |
Credit watch (status on S&P Creditwatch service) |
| custodian |
Custom |
Custodian (places where securities may be held) |
| daycntm |
System |
Daycount method (30/360, Actual, etc) |
| dayofwk |
System |
Day of week |
| dbrslng |
System |
DBRS long rating (includes fields for equivalent rating category and
value) |
| dbrssht |
System |
DBRS short rating (includes fields for equivalent rating category and
value) |
| distlist |
Custom |
Distribution range list |
| dufflng |
System |
Duff & Phelps long rating |
| duffsht |
System |
Duff & Phelps short rating |
| exchange |
Custom |
Exchange (NYSE, NASDAQ, etc. - includes fields for calendar, fee and
commission types) |
| extdata |
Custom |
External data source (KIS, Bloomberg, etc - includes field for how to
communicate with service) |
| fedrttyp |
System |
Fed rate type (financial, non-financial, A2/P2) |
| fipslvl |
System |
FIPS level (none, immediate, end-of-day) |
| fipsstat |
System |
FIPS status (none, completed, pending) |
| fitchlng |
System |
Fitch long rating (includes fields for equivalent rating category and
value) |
| fitchsht |
System |
Fitch short rating (includes fields for equivalent rating category and
value) |
| guarant |
Custom |
Guarantor |
| indclas |
Custom |
Industry class (high-level industry category) |
| industry |
Custom |
Industry type (includes field for industry class) |
| indxlist |
Custom |
Index list for reports |
| instclas |
Custom |
Instrument class (mid-level instrument category, includes field for
instrument family) |
| instfmly |
Custom |
Instrument family (high-level instrument category) |
| insttype |
Custom |
Instrument type (most detailed instrument category, includes fields for
instrument class and other defaults required to create new product
records) |
| insuran |
Custom |
Insurance company backing a particular security or issuer |
| ipa |
Custom |
Issuing & paying agent |
| keefe |
System |
Keefe Bruyette rating (includes fields for equivalent rating category
and value) |
| legalveh |
Custom |
Legal vehicle (optional, used when a customer trades for more than one
legal entity) |
| liquidity |
Custom |
Liquidity provider backing a particular security or issuer |
| loc |
Custom |
Letter of credit (LOC) backing a particular security or issuer |
| location |
Custom |
Location of cleared bonds |
| mbsagncy |
System |
MBS agency (Fannie Mae, Ginnie Mac, etc) |
| mbsppmdl |
System |
MBS pre-payment model (CPR, PSA, etc) |
| month |
System |
Months of the year |
| moodylng |
System |
Moody long rating (includes fields for equivalent rating category and
value) |
| moodysht |
System |
Moody short rating (includes fields for equivalent rating category and
value) |
| opsubtyp |
Custom |
Other party sub-type |
| optype |
Custom |
Other party type |
| paycycle |
System |
Payment cycle for interest payments |
| payfreq |
System |
Payment frequency for interest payments (annual, semiannual, monthly,
etc) |
| posnform |
System |
Possession form (coupon, registered, book entry, etc) |
| postype |
System |
Position type (long, short, crosses zero) |
| pprigrp |
Custom |
Product pricing group (domestic or foreign areas) |
| ppritype |
Custom |
Product pricing type (manual or automatic) |
| prcdtype |
Custom |
Product code type |
| priround |
System |
Price rounding (decimal places or rounding rule) |
| priserv |
Custom |
Product pricing service (companies that provide price information) |
| progtype |
System |
CP program type |
| rdmpfeat |
System |
Redemption feature (calls, mandatory puts, pre-refundings, etc) |
| resetday |
System |
Reset day of week supports all "odd" cases) |
| rollconv |
Custom |
Roll convention (backwards, forwards, modified) |
| rtgctgry |
Custom |
Generic rating category, standardized across all agencies |
| saleqlty |
Custom |
Sales quality |
| saleteam |
Custom |
Sales team |
| sandplng |
System |
S&P long rating (includes fields for equivalent rating category and
value) |
| sandpsht |
System |
S&P short rating (includes fields for equivalent rating category and
value) |
| setlcode |
System |
Settlement code (normal, when issued, how many days) |
| sinkmeth |
System |
Sinking fund method |
| sinktype |
System |
Sinking fund type |
| splevel |
System |
S&P level (for money market liquidity) |
| tckstage |
System |
Ticket stage (requires approval, completed, etc) |
| thomplng |
Custom |
Thompson long rating (includes fields for equivalent rating category and
value) |
| thompsht |
Custom |
Thompson short rating (includes fields for equivalent rating category
and value) |
| tradereg |
Custom |
Trade region |
| transtyp |
System |
Transaction type (BOT, SLD, etc) |
| trdgstyl |
System |
Trading style (associated with desks, includes field for default
settlement days) |
| trdstat |
System |
Trade clearance status |
| trsidtyp |
System |
Transactor type (trader, salesman, etc) |
| trustee |
Custom |
Trustee assigned to a particular security or issuer |
| undrwrtr |
Custom |
Underwriter assigned to a particular security or issuer |
| varindex |
Custom |
Variable rate index |
| ycvname |
Custom |
Yield curve name |
| ycvtype |
System |
Yield curve type |
| yldrule |
System |
Yield calculation rule (used internally by the calculator, not in the
database) |
