Lookup Tables
Home
afs:TRADE
Services
Support
About AFS

Lookup tables are not documented individually, because they always have the same three-column structure:

  • code - A mnemonic of up to six alphanumeric characters that is used throughout the database for foreign key values
  • description - A longer description of the code, often shown in combo boxes for data entry assistance
  • display_index - A unique number that assigns the order in which the list of choices should be displayed (because pure alphabetical order may not always be the best choice)

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)