Table: dbo.Form_5498_Fmv_Code
Form 5498 fair market value (FMV) codes.
Columns
NameTypeConstraintsDescription
form_5498_fmv_code_KEYint (4)NOT NULLPrimary key column.
fmv_codenvarchar (2)NOT NULLForm 5498 FMV code.
descriptionnvarchar (250)NOT NULLForm 5498 FMV code description.
starting_yearint (4)NOT NULLForm 5498 FMV code starting year as CCYY.
ending_yearint (4)Form 5498 FMV code ending year as CCYY. Null indicates no ending year.
Primary key
NameColumnsDescription
PK_Form_5498_Fmv_Codeform_5498_fmv_code_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_5498_Option__Form_5498_Fmv_Code__corrected_override_first__form_5498_fmv_code_KEYcorrected_override_first__form_5498_fmv_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Fmv_Code__corrected_override_second__form_5498_fmv_code_KEYcorrected_override_second__form_5498_fmv_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Fmv_Code__first__form_5498_fmv_code_KEYfirst__form_5498_fmv_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Fmv_Code__original_override_first__form_5498_fmv_code_KEYoriginal_override_first__form_5498_fmv_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Fmv_Code__original_override_second__form_5498_fmv_code_KEYoriginal_override_second__form_5498_fmv_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Fmv_Code__override_first__form_5498_fmv_code_KEYoverride_first__form_5498_fmv_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Fmv_Code__override_second__form_5498_fmv_code_KEYoverride_second__form_5498_fmv_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Fmv_Code__second__form_5498_fmv_code_KEYsecond__form_5498_fmv_code_KEYForm_5498_Option

Schema diagram