| Field Name | Alias(s) | Definition | Format | Values | Tables | Fist Field Name |
|---|---|---|---|---|---|---|
| Folder: ACTIVITY | ||||||
| Activity_Type_Code | Codes for grouping of related activities | 8 ch | see below | |||
| Activity_Code | Codes for specific activities | 8 ch | see below | |||
| Activity_Desc | Names of specific activities | 40 ch | see below | |||
| Activity_Yr | Year in which activity took place (if known) | 9 ch | ||||
| Type | FIST Table | FIST Field | ||||
| SPORTS | BVSPRT | ACDEM-SPORTS | ||||
| DEV-WORK | BVWORK | ACDEM-DEV-WRK-TYP | ||||
| STUD-GOV | BVSTUD | ACDEM-STUD-GOV | ||||
| STUD-ORG | BVSERV | ACDEM-STUD-ORG | ||||
| CLUBS | BVORGS | ACDEM-ALUM-ASSOC-ORG | ||||
| MUSIC | BVMUSC | ACDEM-MUS-ORG | ||||
| AWARDS | BVURPZ | ACDEM-AWARD-TYPE | ||||
| GREEKS | BVSPHS | ACDEM-SPC-INT-HS | ||||
| HNR-SOC | BVSHNR | ACDEM-HNR-SOCTY | ||||
| HNR-SCHL | BVSCHL | ACDEM-HNR-SCHLR | ||||
| CS/REACH | BVCARV | ACDEM-CAR-TYPE | ||||
| GOV-BRD | BVGOVB | BIO-GOV-BRD | ||||
| GOV-BRD | (none) | ACDEM-PAR-CNCL | ||||
| GOV-BRD | BVORGS | ACDEM-ALUM-ASSOC-ORG | ||||
| ALUMNI | BVWORK | ACDEM-REUNION-LDR | ||||
| ALUMNI | (none) | ACDEM-ALUM-TRPS | ||||
| ALUMNI | (none) | ACDEM-VAN | ||||
| Folder: ADDRESS | Note: This file contains all addresses on FIST for a specific prospect except non-mailable preferred addresses | |||||
| Addr_Cat_Code | Address category | Identifies address type (i.e. preferred, current seasonal, or other) | 4 ch | PREF / SEAS / blank | ||
| Addr_Type_Code | address type | Address type (home, business, fax, etc.) | 1 ch | BVADDT | adr-type | |
| Addr_Type_Desc | Address type description | Long description of address type. | 10 ch | BVADDT | unknown | |
| Addr_Line1_Desc | First Line of address. | First line of address. | 30 ch | constructed from address fields | ||
| Addr_Line2_Desc | Second line of address. | Second line of address. | 30 ch | constructed from address fields | ||
| Addr_Line3_Desc | Third line of address. | City, State/country, Zip | 30 ch | constructed from address fields | ||
| City | City | City description | 18 ch | Adr-city | ||
| State_Cntry_Code | State country code | Two char. abbreviation for state, country or Canadian Province preceded by numeric indicator. (1=US, 2=Canada, 3=foreign) | 3 ch | BVSTFC | Adr-state & Adr-fc-ind | |
| Cntry_Desc | State/country description. | Long description for country | 30 ch | "United States" or name of country | BVSTFC | Adr-state |
| Sort_Zipcode | Sort-Zipcode | The zipcode field used by post office to sort mail in zipcode order grouping foreign country mail at the beginning. | 5 ch | Adr-zip | ||
| Phone_Num | Telephone number | Telephone number | 12 ch | Adr-phone | ||
| Geo_Code | Geographic code | Codes that select on multiple zipcodes from one region. | 3 ch | BVGEO | ||
| Geo_Code_Desc | Geographic code description | Long description for geographic region (geo code). | 32 ch | BVGEO | ||
| Addr_Update_Date | Date of address update | Last date of update for a given address in FIST. | date | Adr-update | ||
| Folder: AG CONTACT | ||||||
| Contact_Yr | (Current fiscal year only) | 4 ch | Curr | |||
| Constit_Code | Prospect constituency | 2 ch | BVCONS | BIO-AG-CONTACT | ||
| Solic_Meth_Code | Code defining solictation method, timing and donor giving history | 4 ch | BVSOLC | BIO-AG-CONTACT | ||
| Constit_Desc | Prospect constituency (description) | 40 ch | BVCONS | |||
| Solic_Meth_Desc | Solicitation method (description) | 40 ch | BVSOLC | |||
| Folder: DEGREE | ||||||
| Degree_Code | Codes for specific degrees | 3 ch | ISIS-DESC | ACDEM-UR-DEG | ||
| Degree_Type_Code | Degree categories (combines together types of bachelors, masters, etc.) | 3 ch | B, DOC, HNR, FLW, MD, RES, MAS, PMC, etc. | |||
| School_Code | Two digit school identifier | 2 ch | see below | ISIS-COLL | ACDEM-UR-SCH | |
| School_Desc | Name of the school | 8 ch | ISIS-COLL | ACDEM-UR-SCH | ||
| Year | Year of degree | 4 ch | 4-digit year | ISIS-YYT | ACDEM-UR-YYT | |
| Time_Status_Code | Simon MBA part-time, full-time or Executive | 1 ch | F, P, E | ACDEM-SIMON-TIME-STAT | ||
| School Code | School Name | |||||
| 01 | ARTS/SCI | |||||
| 02 | SIMON | |||||
| 03 | WARNER | |||||
| 04 | ENGINEER | |||||
| 05 | UNIV-COL | |||||
| 06 | EASTMAN | |||||
| 07 | MEDICINE | |||||
| 08 | NURSING | |||||
| 11 | DENTAL | |||||
| 80 | HIGHLAND | |||||
| Folder: DISCIPLINE | ||||||
| Discipline_Type_Code | Discipline type | 10 ch | see below | |||
| Discipline_Code | Major or specialty code | 3 ch | see below | |||
| Discipline_Desc | Major or specialty description | 32 ch | see below | |||
| TYPE | TABLE | FIST FIELD | ||||
| MAJOR | ISIS PROG | ACDEM-UR-MAJ1,MAJ2 | ||||
| INSTRUMENT | ISIS INST | ACDEM-ESM-SPC1,SPC2 | ||||
| MED SPEC. | BVMEDS | ACDEM-MED-SPC1,SPC2 | ||||
| NON-UR MED | BVMEDS | ACDEM-MED-SPC-NON-UR | ||||
| INSTRUCTOR | BVPRNC | ACDEM-PI-NAME | ||||
| Folder: GIFT | ||||||
| Gift_ID | Unique identifier of pledge/gift | 8 ch | starts with 4-digit year | GIFT-GIFT-ID | ||
| Pledge_Yrs_Num | Number of years for pledge to be paid | 2 ch | last 2 digits of GIFT-GIFT-ID | |||
| Input_Date | Date input to FIST | date | GIFT-INP-DATE | |||
| Gift_Update | Date gift record is changed | date | GIFT-DATE-UPD | |||
| Pledge_Date | Gift Date | Date pledge/gift was made | date | GIFT-D-O-GIFT | ||
| Annual_Type_Code | Code used to identify annual program that solicited gift. | 5 ch | GIFT-ANNUAL-TYPE | |||
| Camp_Pledge_Flag | Gifts credited to Campaign for the '90s | 1 ch | Y/N | GIFT-CAMP-CODE | ||
| Gift_Type_Code | Identifies unusual gifts | 1 ch | 7 types | BVGIFT | GIFT-TYPE-OF-GIFT | |
| Deferred_Type_Code | identifies deferred gifts | 1 ch | BVDEFG | GIFT-DEF-GIFT-TYP | ||
| Solic Meth_Code | Solicit Meth/Solicitation Method | Manner in which gift was solicited | 4 ch | BVSOLC | GIFT-SOLICIT-METH | |
| Meth_Type_Code | Mail vs. Phone vs. Other | 5 ch | from Gift-solicit-meth | |||
| Match_Prospect_ID | Prospect ID of matching gift corp. | 9 ch | GIFT-MATCH-ID | |||
| Match_Gift_ID | Gift ID of matching gift corp. | 8 ch | GIFT-MATCH-ID | |||
| Dual_Prospect_ID | Dual ID | Prospect ID of business/foundation | 9 ch | GIFT-DUAL-ID | ||
| Dual_Gift_ID | Gift ID of business/foundation | 8 ch | GIFT-DUAL-ID | |||
| Joint_Prospect_ID | Joint ID | Prospect ID of spouse (joint gift only) | 9 ch | GIFT-JOINT-ID | ||
| Joint_Gift_ID | Gift ID of spouse (joint gift only) | 8 ch | GIFT-JOINT-ID | |||
| Anon_Ind_Code | Anon Ind | Identifies level of anonymity | 1 ch | 1,2,3 | GIFT-ANON-IND | |
| Cr_Noncr_Flag | Credit/NonCredit Indicator | Credit indicator for accounting & tax deductibility purposes (Y = credit; N = no-credit) | 1 ch | Y/N | GIFT-CR-NONCR-IND | |
| Pledge_Amt | Pledge Amount | Amount pledged | 10.2 n | GIFT-PLEDGE-TOT-AMT | ||
| Paid_Amt | Paid Amount | Total paid on a pledge to date | 10.2 n | GIFT-PLEDGE-BAL-PD | ||
| Folder: GIFT (cont.) | ||||||
| Pledge_Status_Code | Gift Status | Status of pledge, i.e. closed/open/paid | 1 ch | BVPLSC | GIFT-PLEDGE-STATUS | |
| Fundcode | Identifies gift designations | 13 ch | Fundcode file | SUPER-FUNDCODE | ||
| Div_Dept_Code | Identifies Division/Dept receiving gift credit | 5 ch | GIFT-DIV-DEPT | |||
| Fund_Ident_Code | Sequentially assigned unique identifier | 4 ch | GIFT-FUND-IDENT | |||
| Purp1_Code | Identifies current use, endowment, capital/equipment | 1 ch | BVPUR1 | GIFT-PURP-1 | ||
| Purp2_Code | Identifies Division or School receiving gift credit | 1 ch | BVPUR2 | GIFT-PURP-2 | ||
| Purp3_Code | Identifies use of gift, i.e. scholarship, research | 2 ch | BVPUR3 | GIFT-PURP-3 | ||
| Mem_ID_Code | Unique identifier for honors and memorials | 5 ch | BVMEMS | GIFT-MEM-ID | ||
| Mem_Type_Code | Mem Code | Specifies Honor/Memorial/Behalf | 12 ch | H,M,B | BVMEMC | GIFT-MEM-CODE |
| Joint_Ratio | Ratio of split for joint gifts ("50" = 50% for husband, 50% for wife) | 2 n | GIFT-JOINT-RATIO | |||
| Entry_Date | Date input to FIST (cannot be manually overridden) | date | GIFT-DATE-ENTRY | |||
| Fiscal_Year | FY | Fiscal year of pledge | 4 ch | 4-digit year | ||
| Solic_Meth_Desc | Description of solicitation method | 32 ch | BVSOLC | GIFT-SOLICIT-METH | ||
| Mem_Desc | Mem Name | Name of person being honored, see Mem ID | 32 ch | BVMEMS | GIFT-MEM-ID | |
| Mem_Sort_Desc | For sorting memorials by honoree's name | 8 ch | BVMEMS | GIFT-MEM-ID | ||
| Fundname | Fundcode Description | Name of fund | 50 ch | fundcode file | FUND-FUNDNAME | |
| Acct_Num | Account number associated with funcode | 14 ch | FUND-DEST-ACCT | |||
| Match_Pledge_Amt | Amount corporation pledged as a match for this gift | 10.2 n | ||||
| Match_Paid_Amt | Amount corporation paid as a match for this gift | 10.2 n | ||||
| Match_Corp_Name | Name of Corporation matching this gift | 25 ch | ||||
| Gift_Sort_ID | Combination of prospect-id, gift-id, spouse -id and spouse-gift-id for sorting joint gifts together | 34 ch | ||||
| Gift_Joint_Flag | Flags if gift is joint, dual or both | 1 ch | J/D/B | GIFT-JOINT-IND | ||
| Gift_Camp_code | Campaign to which the gift should be credited | 1 ch | BVCMPC | GIFT-CAMP-CODE | ||
| Folder: GIFT AGGREGATE | ||||||
| All fields are calculated from the gift file. Divisions based on GIFT-PURP-2 code and/or Division-Department code | ||||||
| Pre_75_Giving_Amt | Archived amount of giving before gift records were computerized | 10.2 n | BIO-GH-TOT-PRE-75 | |||
| Tot_UR_Pledge_Amt | Total UR pledge | 10.2 n | all purp-2 values | |||
| Tot_RC_Pledge_Amt | Total RC pledge | 10.2 n | purp-2=A/B/C/F/G/L/X/Z/ blank | |||
| Tot_Warner_Pledge_Amt | Total Warner pledge | 10.2 n | purp-2=E | |||
| Tot_Simon_Pledge_Amt | Total SIM pledge | 10.2 n | purp-2=D | |||
| Tot_SMD_Pledge_Amt | Total SMD pledge | 10.2 n | purp-2=J (except CHaS) | |||
| Tot_SON_Pledge_Amt | Total School of Nursing pledge | 10.2 n | purp-2=K | |||
| Tot_SMH_Pledge_Amt | Total Strong Mem. Hospital pledge | 10.2 n | purp-2=S | |||
| Tot_CHAS_Pledge_Amt | Total CHAS pledge | 10.2 n | div-dept=PD--- | |||
| Tot_VPHA_Pledge_Amt | Total VPHA pledge | 10.2 n | purp-2=V (exc. Dental & HH) | |||
| Tot_ESM_Pledge_Amt | Total ESM pledge | 10.2 n | purp-2=H | |||
| Tot_Cancer_Pledge_Amt | Total Cancer Center pledge | 10.2 n | div-dept = CANCR | |||
| Tot_Dental_Pledge_Amt | Total Dental Center pledge | 10.2 n | div-dept=EDDEN or EDCTR | |||
| Total_HH_Pledge_Amt | Total Highland Hospital pledge | 10.2 n | div-dept=HIGHF | |||
| Tot_UR_Paid_Amt | Total UR paid | 10.2 n | ||||
| Tot_RC_Paid_Amt | Total RC paid | 10.2 n | ||||
| Tot_Warner_Paid_Amt | Total Warner paid | 10.2 n | ||||
| Tot_Simon Paid_Amt | Total SIM paid | 10.2 n | ||||
| Tot_SMD_Paid_Amt | Total SMD paid | 10.2 n | ||||
| Tot_SON_Paid_Amt | Total SON paid | 10.2 n | ||||
| Folder: GIFT AGGREGATE (cont.) | ||||||
| Tot_SMH_Paid_Amt | Total SMH paid | 10.2 n | ||||
| Tot_CHAS_Paid_Amt | Total CHAS paid | 10.2 n | ||||
| Tot_VPHA_Paid_Amt | Total VPHA paid | 10.2 n | ||||
| Tot_ESM_Paid_Amt | Total ESM paid | 10.2 n | ||||
| Tot_Cancer_Paid_Amt | Total Cancer Center paid | 10.2 n | ||||
| Tot_Dental_Paid_Amt | Total Dental Center paid | 10.2 n | ||||
| Total_HH_Paid_Amt | Total Highland Hospital paid | 10.2 n | ||||
| Latest_UR_Pledge_Date | Most recent UR pledge date | date | ||||
| Latest_RC_Pledge_Date | Most recent RC pledge date | date | ||||
| Latest_Warner_Pledge_Date | Most recent Warner pledge date | date | ||||
| Latest_Simon_Pledge_Date | Most recent SIM pledge date | date | ||||
| Latest_SMD_Pledge_Date | Most recent SMD pledge date | date | ||||
| Latest_SON_Pledge_Date | Most recent SON pledge date | date | ||||
| Latest_SMH_Pledge_Date | Most recent SMH pledge date | date | ||||
| Latest_CHAS_Pledge_Date | Most recent CHAS pledge date | date | ||||
| Latest_VPHA_Pledge_Date | Most recent VPHA pledge date | date | ||||
| Latest_ESM_Pledge_Date | Most recent ESM pledge date | date | ||||
| Latest_Cancer_Pledge_Date | Most recent Cancer Center pledge date | date | ||||
| Latest_Dental_Pledge_date | Most recent Dental Center pledge date | date | ||||
| Latest_HH_Pledge_date | Most recent Highland Hospital pledge date | date | ||||
| Latest_UR_Paid_Date | Most recent UR payment date | date | ||||
| Folder: GIFT AGGREGATE (cont.) | < |