Table: dbo.Form_1098_T_Option
Table for 1098-T form specific data
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary and Foreign Key
half_time_studentbit (1)NOT NULLStudent was at least half time during academic peroid for form year
graduate_studentbit (1)NOT NULLStudent is enrolled exclusively in a graduate level program
method_of_reportingbit (1)NOT NULLMethod of reporting was changed from previous year
academic_periodbit (1)NOT NULLamounts included for academic period of the following year
half_time_student_overridebit (1)Student was at least half time during academic peroid for form year override
graduate_student_overridebit (1)Student is enrolled exclusively in a graduate level program override
method_of_reporting_overridebit (1)Method of reporting was changed from previous year override
academic_period_overridebit (1)amounts included for academic period of the following year override
half_time_student_original_overridebit (1)Student was at least half time during academic peroid for form year original override
graduate_student_original_overridebit (1)Student is enrolled exclusively in a graduate level program original override
method_of_reporting_original_overridebit (1)Method of reporting was changed from previous year original override
academic_period_original_overridebit (1)amounts included for academic period of the following year original override
half_time_student_corrected_overridebit (1)Student was at least half time during academic peroid for form year corrected override
graduate_student_corrected_overridebit (1)Student is enrolled exclusively in a graduate level program corrected override
method_of_reporting_corrected_overridebit (1)Method of reporting was changed from previous year corrected override
academic_period_corrected_overridebit (1)amounts included for academic period of the following year corrected override
student_tin_not_certifiedbit (1)NOT NULLStudent TIN solicitation is not certified indicator
student_tin_not_certified_overridebit (1)Student TIN solicitation is not certified indicator override
student_tin_not_certified_original_overridebit (1)Student TIN solicitation is not certified indicator original override
student_tin_not_certified_corrected_overridebit (1)Student TIN solicitation is not certified indicator corrected override
Primary key
NameColumnsDescription
PK_Form_1098_T_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1098_T_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram