Table - dbo.DimStudentTerm

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
AcademicStatus	varchar(30)	False	False	False			Descriptive name of the academic status for the student for the term.
AcademicStatusCode	varchar(3)	False	False	False			Code indicating the academic status for the student for the term as it relates to the Primary program objective.
Advised	varchar(3)	False	False	False			Indication if the student has been advised for the term. The valid values are 'Yes' or 'No'.
AdvisementAdvisor	varchar(50)	False	False	False			The name of the advisor for the student for the term.
AdvisementAdvisorId	varchar(8)	False	False	False			Unique identifier for the advisor of record for the student for the term.
AdvisementAwardType	varchar(30)	False	False	False			Descriptive name for the type of award the student is pursuing for the term.
AdvisementAwardTypeCode	varchar(3)	False	False	False			Code indicating the type of award the student is pursuing for the term.
AdvisementMandatory	varchar(3)	False	False	False			Indication if advisement is mandatory for the student for the term. The valid values are 'Yes' or 'No'.
AdvisementProgram	varchar(30)	False	False	False			Descriptive title of the advisement program objective for the student for the term.
AdvisementProgramCode	varchar(5)	False	False	False			Code indicating the Program used as the basis for the advisement for the student for the term.
AdvisementStatus	varchar(30)	False	False	False			Descriptive name for the current advisement status for the student for the term.
AdvisementStatusCode	varchar(3)	False	False	False			Code indicating the current advisement status for the student for the term.
AgeAtTerm	smallint(5, 0)	False	False	False			Numeric representation of the age of the student, in years on the start date of the term.
AgeRangeAtTerm	varchar(10)	False	False	False			Descriptive label for the age Range of the student on the start date of the term. The ranges are: < 16, 16 - 17, 18 - 19, 20 - 21, 22 - 24, 25 - 29, 30 - 34 and > 34.
AwardType	varchar(30)	False	False	False			Descriptive name for the type of award the student is pursuing for the term.
AwardTypeCode	varchar(3)	False	False	False			Code indicating the type of award the student is pursuing for the term, based on the primary objective.
BasisOfAdmission	varchar(30)	False	False	False			Descriptive name of the basis of admission of the student.
BasisOfAdmissionCode	varchar(3)	False	False	False			Code indicating why the student has applied and attends the college, referred to as the basis of admission.
DateLastAdvised	date(10, 0)	False	False	False			Date the students advisement was last created/updated.
EnrollmentStatus	varchar(30)	False	False	False			Descriptive name for the enrollment type for the student for the term. This indicates if the student is new, continuing or readmit.
EnrollmentStatusCode	varchar(3)	False	False	False			Code indicating the enrollment type for the student for the term. This indicates if the student is new, continuing or readmit.
Program	varchar(30)	False	False	False			Descriptive title of the primary program objective for the student for the term.
ProgramAdmitStatus	varchar(3)	False	False	False			Indication if the student was admitted into the Program for the term. The valid values are 'Y' or 'N'.
ProgramCode	varchar(5)	False	False	False			Code indicating the primary program objective for the student for the term.
Residency	varchar(30)	False	False	False			Descriptive name for the residency status of a student, used for the term from the source system.
ResidencyCode	varchar(3)	False	False	False			Code indicating the residency status of a student as used by the source system for the term.
RowEndDate	datetime(23, 3)	True	False	False			The effective end date-time for the current Student-Term row.
RowIsCurrent	char(1)	False	False	False			Indicator if the row is the most current representation of the student-term. The valid values are 'N' or 'Y'.
RowStartDate	datetime(23, 3)	False	False	False			The effective start date-time for the current Student-Term row.
SdbAwardTypeCode	varchar(3)	False	False	False			Code used by the State of Florida to report the award type for the student for the term, based on the primary objective for the student for the term.
StudentId	varchar(9)	False	False	False			Student identifier assigned by the source application.
StudentTermAK	varchar(15)	False	False	False			The unique identifier assigned to the Student Term, used by the data warehouse as the business key.
StudentTermSK	int(10, 0)	False	False	False	(1 / 1)		Unique identifier for the student-term in the data warehouse, in numeric format.
Term	varchar(6)	False	False	False			The business unique identifier for the term. The format is YYYYTT and sample values are 20111, 20113 and 20122.
TermTitle	varchar(30)	False	False	False			The title of the term. The title consists of a literal description of the term, followed by the word 'Term' and then the academic year in the format of YYYY (Fall Term 2012).
TransferInstitutionAdvisement	varchar(50)	False	False	False			Descriptive name of the institution to which the student will transfer once completed at the current institution.
TransferInstitutionAdvisementId	varchar(8)	False	False	False			Code which identifies the institution to which the student will transfer once completed with their coursework at the current institution.
TransferMajorAdvisement	varchar(30)	False	False	False			Title of the award/degree/major the student will pursue once completed at the current institution.
TransferMajorAdvisementCode	varchar(6)	False	False	False			Code identifier of the award/degree/major the student will pursue once completed with their coursework at the current institution.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_DimStudentTerm	True	StudentTermSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name	Type
dbo.FactActiveEnrollmentSnapshot	Table
dbo.FactApplicationStatus	Table
dbo.FactEnrollmentActivity	Table
dbo.FactEnrollmentSnapshot	Table
dbo.FactEOTEnrollmentSnapshot	Table
dbo.FactPriorEnrollmentSnapshot	Table
dbo.FactStudentFeesPaid	Table
dbo.FactStudentGrades	Table
dbo.FactStudentGraduation	Table
dbo.FactStudentTotalFees	Table
dbo.FactStudentTotalFeesForClass	Table

Name	Type
dbo.FactActiveEnrollmentSnapshot	TABLE
dbo.FactApplicationStatus	TABLE
dbo.FactEnrollmentActivity	TABLE
dbo.FactEnrollmentSnapshot	TABLE
dbo.FactEOTEnrollmentSnapshot	TABLE
dbo.FactPriorEnrollmentSnapshot	TABLE
dbo.FactStudentFeesPaid	TABLE
dbo.FactStudentGrades	TABLE
dbo.FactStudentGraduation	TABLE
dbo.FactStudentTotalFees	TABLE
dbo.FactStudentTotalFeesForClass	TABLE

Object	Property	Value
DimStudentTerm	MS_Description	The Student Term Dimension contains academic and enrollment information about the student for a term. There will be one row per student and term combination where the student could potentially enroll at the the institution.
AcademicStatus	MS_Description	Descriptive name of the academic status for the student for the term.
AcademicStatusCode	MS_Description	Code indicating the academic status for the student for the term as it relates to the Primary program objective.
Advised	MS_Description	Indication if the student has been advised for the term. The valid values are 'Yes' or 'No'.
AdvisementAdvisor	MS_Description	The name of the advisor for the student for the term.
AdvisementAdvisorId	MS_Description	Unique identifier for the advisor of record for the student for the term.
AdvisementAwardType	MS_Description	Descriptive name for the type of award the student is pursuing for the term.
AdvisementAwardTypeCode	MS_Description	Code indicating the type of award the student is pursuing for the term.
AdvisementMandatory	MS_Description	Indication if advisement is mandatory for the student for the term. The valid values are 'Yes' or 'No'.
AdvisementProgram	MS_Description	Descriptive title of the advisement program objective for the student for the term.
AdvisementProgramCode	MS_Description	Code indicating the Program used as the basis for the advisement for the student for the term.
AdvisementStatus	MS_Description	Descriptive name for the current advisement status for the student for the term.
AdvisementStatusCode	MS_Description	Code indicating the current advisement status for the student for the term.
AgeAtTerm	MS_Description	Numeric representation of the age of the student, in years on the start date of the term.
AgeRangeAtTerm	MS_Description	Descriptive label for the age Range of the student on the start date of the term. The ranges are: < 16, 16 - 17, 18 - 19, 20 - 21, 22 - 24, 25 - 29, 30 - 34 and > 34.
AwardType	MS_Description	Descriptive name for the type of award the student is pursuing for the term.
AwardTypeCode	MS_Description	Code indicating the type of award the student is pursuing for the term, based on the primary objective.
BasisOfAdmission	MS_Description	Descriptive name of the basis of admission of the student.
BasisOfAdmissionCode	MS_Description	Code indicating why the student has applied and attends the college, referred to as the basis of admission.
DateLastAdvised	MS_Description	Date the students advisement was last created/updated.
EnrollmentStatus	MS_Description	Descriptive name for the enrollment type for the student for the term. This indicates if the student is new, continuing or readmit.
EnrollmentStatusCode	MS_Description	Code indicating the enrollment type for the student for the term. This indicates if the student is new, continuing or readmit.
Program	MS_Description	Descriptive title of the primary program objective for the student for the term.
ProgramAdmitStatus	MS_Description	Indication if the student was admitted into the Program for the term. The valid values are 'Y' or 'N'.
ProgramCode	MS_Description	Code indicating the primary program objective for the student for the term.
Residency	MS_Description	Descriptive name for the residency status of a student, used for the term from the source system.
ResidencyCode	MS_Description	Code indicating the residency status of a student as used by the source system for the term.
RowEndDate	MS_Description	The effective end date-time for the current Student-Term row.
RowIsCurrent	MS_Description	Indicator if the row is the most current representation of the student-term. The valid values are 'N' or 'Y'.
RowStartDate	MS_Description	The effective start date-time for the current Student-Term row.
SdbAwardTypeCode	MS_Description	Code used by the State of Florida to report the award type for the student for the term, based on the primary objective for the student for the term.
StudentId	MS_Description	Student identifier assigned by the source application.
StudentTermAK	MS_Description	The unique identifier assigned to the Student Term, used by the data warehouse as the business key.
StudentTermSK	MS_Description	Unique identifier for the student-term in the data warehouse, in numeric format.
Term	MS_Description	The business unique identifier for the term. The format is YYYYTT and sample values are 20111, 20113 and 20122.
TermTitle	MS_Description	The title of the term. The title consists of a literal description of the term, followed by the word 'Term' and then the academic year in the format of YYYY (Fall Term 2012).
TransferInstitutionAdvisement	MS_Description	Descriptive name of the institution to which the student will transfer once completed at the current institution.
TransferInstitutionAdvisementId	MS_Description	Code which identifies the institution to which the student will transfer once completed with their coursework at the current institution.
TransferMajorAdvisement	MS_Description	Title of the award/degree/major the student will pursue once completed at the current institution.
TransferMajorAdvisementCode	MS_Description	Code identifier of the award/degree/major the student will pursue once completed with their coursework at the current institution.

Object

Property

Value

/****** Object: Table [dbo].[DimStudentTerm] Script Date: 03/09/2017 17:14:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimStudentTerm](
    [StudentTermSK] [int] IDENTITY(1,1) NOT NULL,
    [StudentTermAK] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Term] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ResidencyCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Residency] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ProgramCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Program] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ProgramAdmitStatus] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AcademicStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AcademicStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BasisOfAdmissionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BasisOfAdmission] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EnrollmentStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EnrollmentStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AgeAtTerm] [smallint] NOT NULL,
    [AgeRangeAtTerm] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AwardType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SdbAwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Advised] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AdvisementStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AdvisementStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AdvisementMandatory] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DateLastAdvised] [date] NOT NULL,
    [AdvisementProgramCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AdvisementProgram] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AdvisementAwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AdvisementAwardType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AdvisementAdvisorId] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AdvisementAdvisor] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TransferMajorAdvisementCode] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TransferMajorAdvisement] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TransferInstitutionAdvisementId] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TransferInstitutionAdvisement] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
CONSTRAINT [PK_DimStudentTerm] PRIMARY KEY CLUSTERED
(
    [StudentTermSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Student Term Dimension contains academic and enrollment information about the student for a term. There will be one row per student and term combination where the student could potentially enroll at the the institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the academic status for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AcademicStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the academic status for the student for the term as it relates to the Primary program objective.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AcademicStatusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student has been advised for the term. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'Advised'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the advisor for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementAdvisor'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique identifier for the advisor of record for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementAdvisorId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of award the student is pursuing for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementAwardType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the type of award the student is pursuing for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementAwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if advisement is mandatory for the student for the term. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementMandatory'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive title of the advisement program objective for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementProgram'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the Program used as the basis for the advisement for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementProgramCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the current advisement status for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the current advisement status for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AdvisementStatusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Numeric representation of the age of the student, in years on the start date of the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AgeAtTerm'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive label for the age Range of the student on the start date of the term. The ranges are: < 16, 16 - 17, 18 - 19, 20 - 21, 22 - 24, 25 - 29, 30 - 34 and > 34.
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AgeRangeAtTerm'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of award the student is pursuing for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AwardType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the type of award the student is pursuing for the term, based on the primary objective.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the basis of admission of the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'BasisOfAdmission'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating why the student has applied and attends the college, referred to as the basis of admission.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'BasisOfAdmissionCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the students advisement was last created/updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'DateLastAdvised'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the enrollment type for the student for the term. This indicates if the student is new, continuing or readmit.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'EnrollmentStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the enrollment type for the student for the term. This indicates if the student is new, continuing or readmit.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'EnrollmentStatusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive title of the primary program objective for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'Program'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student was admitted into the Program for the term. The valid values are ''Y'' or ''N''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'ProgramAdmitStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the primary program objective for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'ProgramCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the residency status of a student, used for the term from the source system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'Residency'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the residency status of a student as used by the source system for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'ResidencyCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective end date-time for the current Student-Term row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicator if the row is the most current representation of the student-term. The valid values are ''N'' or ''Y''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective start date-time for the current Student-Term row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code used by the State of Florida to report the award type for the student for the term, based on the primary objective for the student for the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'SdbAwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student identifier assigned by the source application.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The unique identifier assigned to the Student Term, used by the data warehouse as the business key.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'StudentTermAK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique identifier for the student-term in the data warehouse, in numeric format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'StudentTermSK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The business unique identifier for the term. The format is YYYYTT and sample values are 20111, 20113 and 20122.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'Term'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The title of the term. The title consists of a literal description of the term, followed by the word ''Term'' and then the academic year in the format of YYYY (Fall Term 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'TermTitle'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the institution to which the student will transfer once completed at the current institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'TransferInstitutionAdvisement'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which identifies the institution to which the student will transfer once completed with their coursework at the current institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'TransferInstitutionAdvisementId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Title of the award/degree/major the student will pursue once completed at the current institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'TransferMajorAdvisement'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code identifier of the award/degree/major the student will pursue once completed with their coursework at the current institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentTerm', @level2type=N'COLUMN',@level2name=N'TransferMajorAdvisementCode'

AcademicStatus

AcademicStatusCode

Advised

AdvisementAdvisor

AdvisementAdvisorId

AdvisementAwardType

AdvisementAwardTypeCode

AdvisementMandatory

AdvisementProgram

AdvisementProgramCode

AdvisementStatus

AdvisementStatusCode

AgeAtTerm

AgeRangeAtTerm

AwardType

AwardTypeCode

BasisOfAdmission

BasisOfAdmissionCode

DateLastAdvised

EnrollmentStatus

EnrollmentStatusCode

Program

ProgramAdmitStatus

ProgramCode

Residency

ResidencyCode

RowIsCurrent

RowStartDate

SdbAwardTypeCode

StudentId

StudentTermAK

StudentTermSK

Term

TermTitle

TransferInstitutionAdvisement

TransferInstitutionAdvisementId

TransferMajorAdvisement

TransferMajorAdvisementCode

Acad Probation For Low Gpa

N/A

20 - 21

Associate In Arts Degree

Hs Dual Now Hs Grad

1900-01-01T00:00:00-05:00

Continuing Student

General/Transfer Aa

1000

In-State/In-District

2017-03-09T11:17:00-05:00

A11628534

A1162853420072

49924004

20072

Spring Term 2007

N/A

Clear Academic Standard

N/A

20 - 21

Associate In Applied Science

AAS

College Transfer

1900-01-01T00:00:00-05:00

Continuing Student

Nursing

A309

Out-Of-State

2017-03-09T11:17:00-05:00

J11885290

J1188529020072

51952670

20072

Spring Term 2007

N/A

Clear Academic Standard

N/A

20 - 21

Associate In Arts Degree

Hs Graduate

1900-01-01T00:00:00-05:00

Continuing Student

Associate In Arts

1000

Out-Of-State

2017-03-09T11:17:00-05:00

I13447594

I1344759420123

51634732

20123

Summer Term 2012

N/A

25 - 29

Non-Degree Seeking

College Transfer

1900-01-01T00:00:00-05:00

Continuing Student

Personal Improvement

3408

In-State/In-District

2017-03-09T11:17:00-05:00

A08573453

A0857345319982

49841951

19982

Winter Term 1998

N/A

Clear Academic Standard

N/A

22 - 24

Non-Degree Seeking

College Transfer

1900-01-01T00:00:00-05:00

Continuing Student

Transient Student

3409

In-State/In-District

2017-03-09T11:17:00-05:00

N06428478

N0642847820083

53325150

20083

Summer Term 2008

N/A

Clear Academic Standard

N/A

25 - 29

Bachelor Of Applied Science

BAS

Hs Graduate

1900-01-01T00:00:00-05:00

Continuing Student

Information Management

T803

In-State/In-District

2017-03-09T11:17:00-05:00

Z11674678

Z1167467820133

54742016

20133

Summer Term 2013

N/A

18 - 19

Associate In Science Degree

Hs Graduate

1900-01-01T00:00:00-05:00

New Student

Nursing

2301

Out-Of-State

2017-03-09T11:17:00-05:00

P12927588

P1292758820083

53593138

20083

Summer Term 2008

N/A

Clear Academic Standard

N/A

> 34

Bachelor Of Applied Science

BAS

College Transfer

1900-01-01T00:00:00-05:00

Continuing Student

Supervision And Management

T702

Out-Of-State

2017-03-09T11:17:00-05:00

M07177678

M0717767820103

52870943

20103

Summer Term 2010

N/A

Clear Academic Standard

N/A

22 - 24

Associate In Arts Degree

College Transfer

1900-01-01T00:00:00-05:00

Continuing Student

Associate In Arts

1000

In-State/In-District

2017-03-09T11:17:00-05:00

A14544985

A1454498520162

50172166

20162

Spring Term 2016

N/A

Clear Academic Standard

N/A

30 - 34

Vocational Certificate

College Transfer

1900-01-01T00:00:00-05:00

Continuing Student

Child Development Associate (C

5348

In-State/In-District

2017-03-09T11:17:00-05:00

S11574621

S1157462120033

54092791

20033

Summer Term 2003

N/A

Property	Value
Name	DimStudentTerm
Schema	dbo
Row Count	4993017
Data Size	1639296 KB
Index Size	6128 KB
Create Date	8/29/2012 1:19 PM
Description	The Student Term Dimension contains academic and enrollment information about the student for a term. There will be one row per student and term combination where the student could potentially enroll at the the institution.