Table of contents
No headers Most of the data entered on forms in the COM-FSM SIS is defined elsewhere in the database. When a value is entered (a code) it is verified to be one that is defined and understood. This process is referred to as validation, and is used to maintain consistent information throughout the database.
The information used to verify that each entered code is correct is defined in validation tables, collections of information that match each possible code to a description or definition.
Name | Module | Describes |
Address Type | Common | E-Mail and postal addresses |
Admission Type | Student | Admission Type |
Basis | A/R | Methods used to assess or refund tuition and fees |
Building | Student | Buildings, by campus |
Campus | Student | Campuses in the COM-FSM system |
Chart | A/R | Chart of accounts from MIP (includes Fund, Campus, Division, GL, and Performance tables) |
CIP | Student | Classification of Instruction Program codes, for IPEDS |
City | Common | Frequently used city names |
Class | Student | Student class (e.g. freshman, sophomore) |
Class Rule | Student | Credit hours required for each class, by level |
Comparison
| Common
| Comparison operators
|
Country
| Common
| Country codes
|
Ethnicity
| Common
| Ethnicity codes
|
Fees
| A/R
| Fee codes for charges calculated by fee assessment
|
Meal Plan
| A/R | Meal plan codes
|
Rate
| A/R | Fee assessment rate codes
|
Refund Schedule
| A/R | Refund schedule codes
|
Refund Type
| A/R | Refund type codes
|
Transaction
| A/R | Account transaction codes
|