Table: dbo.Form_1098_T_Option | |||
Table for 1098-T form specific data | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_KEY | int (4) | NOT NULL | Primary and Foreign Key |
half_time_student | bit (1) | NOT NULL | Student was at least half time during academic peroid for form year |
graduate_student | bit (1) | NOT NULL | Student is enrolled exclusively in a graduate level program |
method_of_reporting | bit (1) | NOT NULL | Method of reporting was changed from previous year |
academic_period | bit (1) | NOT NULL | amounts included for academic period of the following year |
half_time_student_override | bit (1) | Student was at least half time during academic peroid for form year override | |
graduate_student_override | bit (1) | Student is enrolled exclusively in a graduate level program override | |
method_of_reporting_override | bit (1) | Method of reporting was changed from previous year override | |
academic_period_override | bit (1) | amounts included for academic period of the following year override | |
half_time_student_original_override | bit (1) | Student was at least half time during academic peroid for form year original override | |
graduate_student_original_override | bit (1) | Student is enrolled exclusively in a graduate level program original override | |
method_of_reporting_original_override | bit (1) | Method of reporting was changed from previous year original override | |
academic_period_original_override | bit (1) | amounts included for academic period of the following year original override | |
half_time_student_corrected_override | bit (1) | Student was at least half time during academic peroid for form year corrected override | |
graduate_student_corrected_override | bit (1) | Student is enrolled exclusively in a graduate level program corrected override | |
method_of_reporting_corrected_override | bit (1) | Method of reporting was changed from previous year corrected override | |
academic_period_corrected_override | bit (1) | amounts included for academic period of the following year corrected override | |
student_tin_not_certified | bit (1) | NOT NULL | Student TIN solicitation is not certified indicator |
student_tin_not_certified_override | bit (1) | Student TIN solicitation is not certified indicator override | |
student_tin_not_certified_original_override | bit (1) | Student TIN solicitation is not certified indicator original override | |
student_tin_not_certified_corrected_override | bit (1) | Student TIN solicitation is not certified indicator corrected override |
Primary key | |||
Name | Columns | Description | |
PK_Form_1098_T_Option$form_1099_KEY | form_1099_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Form_1098_T_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |