SEDREF Data Dictionary. This dictionary identifies the Field name, a brief explanation of the field and the SEDREF table that the field is in.
| FIELD | EXPLANATION | TABLE |
| INST_ID | 12 digit random unique identifier for each institution | INSTITUTIONS |
| LEGAL_NAME | Legally authorized name of the institution, e.g that which appears on a charter or license | INSTITUTIONS |
| CORPORATE_NAME | Name of a parent corporation that this institution is a part of | INSTITUTIONS |
| POPULAR_NAME | Colloquial or familiar name of the institution | INSTITUTIONS |
| LABEL_NAME | 29 character length version of institution name used by the SED Printing and Inserting room systems | INSTITUTIONS |
| MEDICAID_PN | Medicaid Provider Number | INSTITUTIONS |
| SED_CODE | 12 digit specially constructed number assigned by the SED IRS program office | INSTITUTIONS |
| COMM_TYPE_CODE | Type of community the institution resides in (see descriptions) | INSTITUTIONS |
| NEEDS_RESOURCE_CODE | Needs category of the Institution (see descriptions) | INSTITUTIONS |
| COUNTY_CODE | Code number of the county that the institution's main office is physically located within | INSTITUTIONS |
| INACTIVE_IND | Indicates whether the institution is active or inactive. | INSTITUTIONS |
| ESTABLISHED_DATE | Date the institution officially was established - this date may be very different from the "active date" below. | INSTITUTIONS |
| CHARITY REGISTRATION NUMBER | This number pertains to Non-Profit Organizations only. This is not a tax exempt or Federal Id number. | INSTITUTIONS |
| EXEMPTION CODE | Entered for those Non-Profit organizations who are exempt from needing a Charity Registration #. | INSTITUTIONS |
| GIS_LOC_X | X coordinate for physical location of building | INSTITUTIONS |
| GIS_LOC_Y | Y coordinate for physical location of building | INSTITUTIONS |
| SEDFIN_ID | ID number from SEDFIN | INSTITUTIONS |
| HISTORY_IND | Indicates whether any history records exist for the institution | INSTITUTIONS |
| SDL_CODE | Six digit identifier for the school district that the institution physically resides within. | INSTITUTIONS |
| ACTIVE_DATE | Date this institution became active for SED purposes | INSTITUTIONS |
| INACTIVE_DATE | Date this record became inactive for SED purposes. | INSTITUTIONS |
| INST_PARENT_ID | 12 digit INST_ID of parent organization if this institution is a child of a parent - e.g. a school in a school district. | INSTITUTIONS |
| INST_SUB_TYPE_CODE | 5 digit code indicating the minor type or sub-type of the institution (See list on main help page) | INSTITUTIONS |
| INST_TYPE_CODE | 5 digit code indicating the major type or type of the institution (See list on main help page) | INSTITUTIONS |
| INST_SUCCESSOR_ID | 12 digit INST_ID indicating the successor of a superceded institution. | INSTITUTIONS |
| INST_PAYEE_ID | 12 digit random unique identifier assigned to each payee record - linking the institution to the payee information for the institution. | PAYEE_INFOS |
| INST_MODIFIED_BY | Name of the system user who last modified the record | PAYEE_INFOS |
| INST_CREATED_BY | Name of the system user who created the record. | PAYEE_INFOS |
| INST_DATE_CREATED | Date the record was created. | PAYEE_INFOS |
| INST_DATE_MODIFIED | Date the record was last modified | PAYEE_INFOS |
| PAYEE_ID | 12 digit random unique identifier assigned to each payee record. | PAYEE_INFOS |
| PAYEE_NAME | Name of the payee - this is the name | PAYEE_INFOS |
| ELSEGIS_CODE | ELSEGIS Code - Elementary and Secondary General Information System code (a Federal#) | PAYEE_INFOS |
| EFT_IND | Indicates whether the institution receives payments via ACH | PAYEE_INFOS |
| FEDERAL_ID | Federal ID - must be present if no Muni code is present. | PAYEE_INFOS |
| MUNI_CODE | Municipality Code assigned by OSC - must be present if no Federal ID is present. | PAYEE_INFOS |
| INTEREST_ELIGIBLE | Indicates whether this institution is eligible to receive interest payments | PAYEE_INFOS |
| PAYEE_ADDR_LINE1 | Address line 1 for where payments will be sent | PAYEE_INFOS |
| PAYEE_ADDR_LINE2 | Address line 2 for where payments will be sent | PAYEE_INFOS |
| PAYEE_CITY | City where payments will be sent | PAYEE_INFOS |
| PAYEE_ZIPCD5 | 5 digit zip code where payments will be sent | PAYEE_INFOS |
| PAYEE_ZIPADD4 | 4 digit zip plus four where payments will be sent | PAYEE_INFOS |
| PAYEE_FOREIGN_POSTAL_CODE | Foreign postal code for where payments will be sent if applicable | PAYEE_INFOS |
| PAYEE_STATE_CODE | US State code where payments will be sent | PAYEE_INFOS |
| PAYEE_COUNTRY_CODE | Country where payments will be sent | PAYEE_INFOS |
| PAYEE_CREATED_BY | Name of system user who created this payee record. | PAYEE_INFOS |
| PAYEE_MODIFIED_BY | Name of system user who last updated this payee record | PAYEE_INFOS |
| PAYEE_DATE_CREATED | Date when this payee record was created | PAYEE_INFOS |
| PAYEE_DATE_MODIFIED | Date when this payee record was last updated | PAYEE_INFOS |
| PAYEE_APPROVED_FOR_PAYMENT | Indicates whether this payee is approved to receive payments | PAYEE_INFOS |
| PAYEE_DATE_APPROVED | Date when this payee was approved to receive payments | PAYEE_INFOS |
| ADMIN_POS_ID | Unique, random 12 digit identifier for an administrative position associated with an institution. Any single institution may have one or more administrative positions. | ADMIN_POSITIONS |
| TITLE | Title of the administrative officer | ADMIN_POSITIONS |
| MAIL_STOP | Mail stop of address for administrative officer | ADMIN_POSITIONS |
| ACTIVE_DATE | Date this administrative position became active | ADMIN_POSITIONS |
| INACTIVE_DATE | Date this administrative position became inactive | ADMIN_POSITIONS |
| SAL_CODE | Code indicating which salutation is associated with the individual filling this administrative position (see descriptions-1st 15, last 6) | ADMIN_POSITIONS |
| FNAME | First name of the individual filling this administrative position. | ADMIN_POSITIONS |
| MI | Middle initial of the individual filling this administrative position. | ADMIN_POSITIONS |
| LNAME | Last name of the individual filling this administrative position | ADMIN_POSITIONS |
| GENERATION | Generation (Junior, Senior, etc) of the individual filling this administrative position. | ADMIN_POSITIONS |
| ADMIN_POS_CREATED_BY | Name of the user who created this administrative position record | ADMIN_POSITIONS |
| ADMIN_POS_DATE_CREATED | Date this administrative position record was created | ADMIN_POSITIONS |
| ADMIN_POS_DATE_MODIFIED | Date this administrative position record was last updated | ADMIN_POSITIONS |
| ADMIN_POS_MODIFIED_BY | Name of the user who last updated this administrative position record. | ADMIN_POSITIONS |
| ADMIN_POS_INST_ID | 12 digit INST_ID of the institution that this administrative position is associated with. | ADMIN_POSITIONS |
| ADMIN_POS_ ADDR_ID | 12 digit ADDR_ID of the address where this administrative position receives its mail or can be contacted. | ADMIN_POSITIONS |
| ADMIN_POS_TYPE_CODE | 5 digit code representing the type of administrative position (see descriptions) | ADMIN_POSITIONS |
| ADDR_ID | 12 digit unique, random identifier assigned to each address. An institution may have one or more addresses. Each administrative position has one and only one address. Addresses may be of one and only one type. | ADDRESSES |
| ADDR_ADDR_LINE1 | Line one of address | ADDRESSES |
| ADDR_ADDR_LINE2 | Line two of address | ADDRESSES |
| ADDR_CITY | City of address | ADDRESSES |
| ADDR_STATE_CODE | Code of the state of the address | ADDRESSES |
| ADDR_ZIPCD5 | 5 digit zip code of the address | ADDRESSES |
| ADDR_ZIPCD4 | 4 digit zip plus four of the address | ADDRESSES |
| ADDR_COUNTRY_CODE | Country of the address (see descriptions) | ADDRESSES |
| ADDR_FOREIGN_POSTAL_CODE | Foreign postal code of the address | ADDRESSES |
| ADDR_TYPE_CODE | Type of address (see descriptions) | ADDRESSES |
| ADDR_INST_ID | 12 digit INST_ID of the institution that this address is associated with. | ADDRESSES |
| ADDR_CREATED_BY | Name of the user who created this address record. | ADDRESSES |
| ADDR_DATE_CREATED | Date this address record was created. | ADDRESSES |
| ADDR_MODIFIED_BY | Name of the user who last modified this address record. | ADDRESSES |
| ADDR_DATE_MODIFIED | Date this address record was last modified. | ADDRESSES |
| CONTACT_ID | Unique, random 12 digit identifier assigned to each contact. An instittuion may have multiple contacts and an administrative position may have multiple contacts. Contacts are phone and fax or e-mail or web URL. | CONTACT_INFO |
| CONTACT_TYPE | Code representing the type of contact (see descriptions) | CONTACT_INFO |
| CONTACT_VALUE | Value associated with the contact (e.g. phone number or e-mail address) | CONTACT_INFO |
| CONTACT_ADMIN_POSITION_ID | 12 digit ADMIN_POS_ID of the administrative position this contact is associated with. | CONTACT_INFO |
| CONTACT_INST_ID | 12 digit INST_ID of the institution this contact is associated with. | CONTACT_INFO |
| CONTACT_CREATED_BY | Name of the user who created this contact record | CONTACT_INFO |
| CONTACT_DATE_CREATED | Date this contact record was created | CONTACT_INFO |
| CONTACT_MODIFIED_BY | Name of the user who last modified this contact record. | CONTACT_INFO |
| CONTACT_DATE_MODIFIED | Date this contact record was last modified. | CONTACT_INFO |
Last Updated on 04/10/2006
By Theresa Kramm
Email:
tkramm@mail.nysed.gov