Table - dbo.DimStudent

Property	Value
Name	DimStudent
Schema	dbo
Row Count	918991
Data Size	368720 KB
Index Size	19952 KB
Create Date	8/28/2013 9:52 AM
Description	The Student demographic contains information about a student including the current name, ethnicity and gender. There is one row per student who is assigned a Student ID by the institution

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
CellPhoneNumber	varchar(25)	False	False	False			Cell phone number for a student. The format is (999)888-7777.
CountryOfBirth	varchar(30)	False	False	False			Descriptive name for the country where a student was born.
CountryOfBirthCode	varchar(3)	False	False	False			Code which indicates the country where the student was born.
CountryOfCitizenship	varchar(30)	False	False	False			Descriptive name for the country where a student has citizenship.
CountryOfCitizenshipCode	varchar(3)	False	False	False			Code which indicates the country where the student has citizenship.
DateOfBirth	date(10, 0)	False	False	False			The date of birth for a student, in the SQL Server 'date' format.
Ethnicity	varchar(30)	False	False	False			Descriptive name for the ethnicity of a student.
EthnicityCode	varchar(3)	False	False	False			Code indicating the ethnicity of a student.
FERPARequested	varchar(3)	False	False	False			Indication if the student is currently requesting FERPA non-disclosure for any personal identifying information. The valid values are 'Yes' or 'No'.
FirstName	varchar(30)	False	False	False			Current first name of the student.
FirstTimeInCollege	varchar(3)	False	False	False			Student is the first one in the family to attend college. The valid values are 'Yes' or 'No'.
FullName	varchar(50)	False	False	False			Current full name for the student in Last Name, comma, First Name and Middle Name format.
Gender	varchar(10)	False	False	False			Descriptive name for the gender of a student.
GenderCode	varchar(3)	False	False	False			Code for the gender of a student.
HighSchool	varchar(50)	False	False	False			Name of the High School institution.
HighSchoolInstitutionId	varchar(8)	False	False	False			The Institution ID for the students High School, either current or graduated. If the student records have more than one, then the high school with the most current graduation date will be used.
HomeCampus	varchar(50)	False	False	False			Descriptive name for the home campus of the student.
HomeCampusCode	varchar(3)	False	False	False			Code which indicates the home campus of the student.
HomePhoneNumber	varchar(25)	False	False	False			Home phone number for a student. The format is (999)888-7777.
ImmigrationStatus	varchar(30)	False	False	False			Descriptive name for the current immigration status of a student.
ImmigrationStatusCode	varchar(3)	False	False	False			Code which indicates the current immigration status of a student.
InitialPrepStatus	varchar(20)	False	False	False			Descriptive name for how prepared the student is to take college level course work when they first attend the institution.
InstitutionalEmailAddress	varchar(75)	False	False	False			Institutionally provided email account for a student.
InternationalStudent	varchar(3)	False	False	False			Indication of the current International status of a student.
LastName	varchar(50)	False	False	False			Current last name of the student.
MiddleName	varchar(20)	False	False	False			Current middle name for the student.
PersonalEmailAddress	varchar(75)	False	False	False			Personal email account provided by the student.
PrimaryLanguage	varchar(30)	False	False	False			Descriptive name for the primary language for a student.
PrimaryLanguageCode	varchar(3)	False	False	False			Code indicating the primary language for a student.
RaceAfricanAmerican	varchar(3)	False	False	False			Indication the student is of African American descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
RaceAmericanIndian	varchar(3)	False	False	False			Indication the student is of American Indian/Eskimo descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
RaceAsian	varchar(3)	False	False	False			Indication the student is of Asian descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
RacePacificIslander	varchar(3)	False	False	False			Indication the student is of Pacific Islander descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
RaceUnreported	varchar(3)	False	False	False			Indication the student has Not Reported their racial descent on the student's application. The valid values are 'Yes' or 'No'.
RaceWhite	varchar(3)	False	False	False			Indication the student is of White descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
Residency	varchar(30)	False	False	False			Descriptive name for the residency status of a student, per the students current demographic information in the source system.
ResidencyCode	varchar(3)	False	False	False			Code indicating the residency status of a student, per the students current demographic information in the source system.
ResidencyCounty	varchar(30)	False	False	False			Descriptive name for the county of residency for a student.
ResidencyCountyCode	varchar(3)	False	False	False			Code indicating the county where the student is residing, if the student is In State student.
ResidencyState	varchar(30)	False	False	False			Descriptive name for the state of residency for a student.
ResidencyStateCode	varchar(3)	False	False	False			Code indicating the state where the student is residing.
RowEndDate	datetime(23, 3)	True	False	False			The effective end date-time for the current Student row.
RowIsCurrent	char(1)	False	False	False			Indicator if the row is the most current representation of the student. The valid values are 'N' or 'Y'.
RowStartDate	datetime(23, 3)	False	False	False			The effective start date-time for the current Student row.
StudentAthlete	varchar(3)	False	False	False			Indication of the current Athlete status of a student.
StudentId	varchar(9)	False	False	False			Student identifier assigned by the source application.
StudentIdAK	varchar(9)	False	False	False			Student identifier assigned by the source application and used by the Data Warehouse as the Business Key.
StudentSK	int(10, 0)	False	False	False	(1 / 1)		Unique identifier for the student in the data warehouse, in numeric format.
VeteranStudent	varchar(3)	False	False	False			Indication of the current Veteran status of a student.
ZipCode	varchar(11)	False	False	False			The mailing address zip code for the student.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
IDX_StudentIdAK	False	StudentIdAK
PK_DimStudent	True	StudentSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.FactActiveEnrollmentSnapshot	Table
dbo.FactApplicationStatus	Table
dbo.FactEnrollmentActivity	Table
dbo.FactEnrollmentSnapshot	Table
dbo.FactEOTEnrollmentSnapshot	Table
dbo.FactInstitutionalRetentionSnapshot	Table
dbo.FactPriorEnrollmentSnapshot	Table
dbo.FactProgramRetentionSnapshot	Table
dbo.FactStudentFeesPaid	Table
dbo.FactStudentGrades	Table
dbo.FactStudentGraduation	Table
dbo.FactStudentReceiptPayments	Table
dbo.FactStudentReceiptTotals	Table
dbo.FactStudentSuccess_FirstYearSnapshot	Table
dbo.FactStudentSuccess_TermSnapshot	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.FactInstitutionalRetentionSnapshot	TABLE
dbo.FactPriorEnrollmentSnapshot	TABLE
dbo.FactProgramRetentionSnapshot	TABLE
dbo.FactStudentFeesPaid	TABLE
dbo.FactStudentGrades	TABLE
dbo.FactStudentGraduation	TABLE
dbo.FactStudentReceiptPayments	TABLE
dbo.FactStudentReceiptTotals	TABLE
dbo.FactStudentSuccess_FirstYearSnapshot	TABLE
dbo.FactStudentSuccess_TermSnapshot	TABLE
dbo.FactStudentTotalFees	TABLE
dbo.FactStudentTotalFeesForClass	TABLE

Object	Property	Value
DimStudent	MS_Description	The Student demographic contains information about a student including the current name, ethnicity and gender. There is one row per student who is assigned a Student ID by the institution
CellPhoneNumber	MS_Description	Cell phone number for a student. The format is (999)888-7777.
CountryOfBirth	MS_Description	Descriptive name for the country where a student was born.
CountryOfBirthCode	MS_Description	Code which indicates the country where the student was born.
CountryOfCitizenship	MS_Description	Descriptive name for the country where a student has citizenship.
CountryOfCitizenshipCode	MS_Description	Code which indicates the country where the student has citizenship.
DateOfBirth	MS_Description	The date of birth for a student, in the SQL Server 'date' format.
Ethnicity	MS_Description	Descriptive name for the ethnicity of a student.
EthnicityCode	MS_Description	Code indicating the ethnicity of a student.
FERPARequested	MS_Description	Indication if the student is currently requesting FERPA non-disclosure for any personal identifying information. The valid values are 'Yes' or 'No'.
FirstName	MS_Description	Current first name of the student.
FirstTimeInCollege	MS_Description	Student is the first one in the family to attend college. The valid values are 'Yes' or 'No'.
FullName	MS_Description	Current full name for the student in Last Name, comma, First Name and Middle Name format.
Gender	MS_Description	Descriptive name for the gender of a student.
GenderCode	MS_Description	Code for the gender of a student.
HighSchool	MS_Description	Name of the High School institution.
HighSchoolInstitutionId	MS_Description	The Institution ID for the students High School, either current or graduated. If the student records have more than one, then the high school with the most current graduation date will be used.
HomeCampus	MS_Description	Descriptive name for the home campus of the student.
HomeCampusCode	MS_Description	Code which indicates the home campus of the student.
HomePhoneNumber	MS_Description	Home phone number for a student. The format is (999)888-7777.
ImmigrationStatus	MS_Description	Descriptive name for the current immigration status of a student.
ImmigrationStatusCode	MS_Description	Code which indicates the current immigration status of a student.
InitialPrepStatus	MS_Description	Descriptive name for how prepared the student is to take college level course work when they first attend the institution.
InstitutionalEmailAddress	MS_Description	Institutionally provided email account for a student.
InternationalStudent	MS_Description	Indication of the current International status of a student.
LastName	MS_Description	Current last name of the student.
MiddleName	MS_Description	Current middle name for the student.
PersonalEmailAddress	MS_Description	Personal email account provided by the student.
PrimaryLanguage	MS_Description	Descriptive name for the primary language for a student.
PrimaryLanguageCode	MS_Description	Code indicating the primary language for a student.
RaceAfricanAmerican	MS_Description	Indication the student is of African American descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
RaceAmericanIndian	MS_Description	Indication the student is of American Indian/Eskimo descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
RaceAsian	MS_Description	Indication the student is of Asian descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
RacePacificIslander	MS_Description	Indication the student is of Pacific Islander descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
RaceUnreported	MS_Description	Indication the student has Not Reported their racial descent on the student's application. The valid values are 'Yes' or 'No'.
RaceWhite	MS_Description	Indication the student is of White descent as self-reported on the student?s application. The valid values are 'Yes' or 'No'.
Residency	MS_Description	Descriptive name for the residency status of a student, per the students current demographic information in the source system.
ResidencyCode	MS_Description	Code indicating the residency status of a student, per the students current demographic information in the source system.
ResidencyCounty	MS_Description	Descriptive name for the county of residency for a student.
ResidencyCountyCode	MS_Description	Code indicating the county where the student is residing, if the student is In State student.
ResidencyState	MS_Description	Descriptive name for the state of residency for a student.
ResidencyStateCode	MS_Description	Code indicating the state where the student is residing.
RowEndDate	MS_Description	The effective end date-time for the current Student row.
RowIsCurrent	MS_Description	Indicator if the row is the most current representation of the student. The valid values are 'N' or 'Y'.
RowStartDate	MS_Description	The effective start date-time for the current Student row.
StudentAthlete	MS_Description	Indication of the current Athlete status of a student.
StudentId	MS_Description	Student identifier assigned by the source application.
StudentIdAK	MS_Description	Student identifier assigned by the source application and used by the Data Warehouse as the Business Key.
StudentSK	MS_Description	Unique identifier for the student in the data warehouse, in numeric format.
VeteranStudent	MS_Description	Indication of the current Veteran status of a student.
ZipCode	MS_Description	The mailing address zip code for the student.

Object

Property

Value

/****** Object: Table [dbo].[DimStudent] Script Date: 03/09/2017 17:14:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimStudent](
    [StudentSK] [int] IDENTITY(1,1) NOT NULL,
    [StudentIdAK] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FullName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LastName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FirstName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [MiddleName] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GenderCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Gender] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EthnicityCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Ethnicity] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FirstTimeInCollege] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryLanguageCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryLanguage] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HighSchoolInstitutionId] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HighSchool] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HomePhoneNumber] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CellPhoneNumber] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InstitutionalEmailAddress] [varchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PersonalEmailAddress] [varchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ImmigrationStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ImmigrationStatus] [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,
    [ResidencyCountyCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ResidencyCounty] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ResidencyStateCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ResidencyState] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ZipCode] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DateOfBirth] [date] NOT NULL,
    [FERPARequested] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RaceWhite] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RaceAfricanAmerican] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RacePacificIslander] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RaceAsian] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RaceAmericanIndian] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RaceUnreported] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountryOfBirthCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountryOfBirth] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountryOfCitizenshipCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountryOfCitizenship] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HomeCampusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HomeCampus] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InitialPrepStatus] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [VeteranStudent] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentAthlete] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InternationalStudent] [varchar](3) 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_DimStudent] PRIMARY KEY CLUSTERED
(
    [StudentSK] 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 demographic contains information about a student including the current name, ethnicity and gender. There is one row per student who is assigned a Student ID by the institution' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cell phone number for a student. The format is (999)888-7777.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'CellPhoneNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the country where a student was born.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'CountryOfBirth'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the country where the student was born.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'CountryOfBirthCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the country where a student has citizenship.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'CountryOfCitizenship'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the country where the student has citizenship.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'CountryOfCitizenshipCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date of birth for a student, in the SQL Server ''date'' format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'DateOfBirth'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the ethnicity of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'Ethnicity'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the ethnicity of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'EthnicityCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student is currently requesting FERPA non-disclosure for any personal identifying information. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'FERPARequested'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current first name of the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'FirstName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student is the first one in the family to attend college. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'FirstTimeInCollege'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current full name for the student in Last Name, comma, First Name and Middle Name format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'FullName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the gender of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'Gender'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the gender of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'GenderCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the High School institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'HighSchool'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Institution ID for the students High School, either current or graduated. If the student records have more than one, then the high school with the most current graduation date will be used.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'HighSchoolInstitutionId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the home campus of the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'HomeCampus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the home campus of the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'HomeCampusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Home phone number for a student. The format is (999)888-7777.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'HomePhoneNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the current immigration status of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'ImmigrationStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the current immigration status of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'ImmigrationStatusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for how prepared the student is to take college level course work when they first attend the institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'InitialPrepStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Institutionally provided email account for a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'InstitutionalEmailAddress'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the current International status of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'InternationalStudent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current last name of the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'LastName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current middle name for the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'MiddleName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Personal email account provided by the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'PersonalEmailAddress'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the primary language for a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'PrimaryLanguage'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the primary language for a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'PrimaryLanguageCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student is of African American descent as self-reported on the student?s application. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'RaceAfricanAmerican'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student is of American Indian/Eskimo descent as self-reported on the student?s application. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'RaceAmericanIndian'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student is of Asian descent as self-reported on the student?s application. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'RaceAsian'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student is of Pacific Islander descent as self-reported on the student?s application. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'RacePacificIslander'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student has Not Reported their racial descent on the student''s application. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'RaceUnreported'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student is of White descent as self-reported on the student?s application. The valid values are ''Yes'' or ''No''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'RaceWhite'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the residency status of a student, per the students current demographic information in the source system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'Residency'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the residency status of a student, per the students current demographic information in the source system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'ResidencyCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the county of residency for a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'ResidencyCounty'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the county where the student is residing, if the student is In State student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'ResidencyCountyCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the state of residency for a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'ResidencyState'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the state where the student is residing.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'ResidencyStateCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective end date-time for the current Student row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @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. The valid values are ''N'' or ''Y''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @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 row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the current Athlete status of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'StudentAthlete'

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'DimStudent', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student identifier assigned by the source application and used by the Data Warehouse as the Business Key.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'StudentIdAK'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the current Veteran status of a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'VeteranStudent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The mailing address zip code for the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudent', @level2type=N'COLUMN',@level2name=N'ZipCode'

CellPhoneNumber

CountryOfBirth

CountryOfBirthCode

CountryOfCitizenship

CountryOfCitizenshipCode

DateOfBirth

Ethnicity

EthnicityCode

FERPARequested

FirstName

FirstTimeInCollege

FullName

Gender

GenderCode

HighSchool

HighSchoolInstitutionId

HomeCampus

HomeCampusCode

HomePhoneNumber

ImmigrationStatus

ImmigrationStatusCode

InitialPrepStatus

InstitutionalEmailAddress

InternationalStudent

LastName

MiddleName

PersonalEmailAddress

PrimaryLanguage

PrimaryLanguageCode

RaceAfricanAmerican

RaceAmericanIndian

RaceAsian

RacePacificIslander

RaceUnreported

RaceWhite

Residency

ResidencyCode

ResidencyCounty

ResidencyCountyCode

ResidencyState

ResidencyStateCode

RowIsCurrent

RowStartDate

StudentAthlete

StudentId

StudentIdAK

StudentSK

VeteranStudent

ZipCode

(561) 555-7741

Unknown Or Unspecified

ZZ

United States

US

1977-12-07T00:00:00-05:00

N/A

No

Burlison

No

Gentry, Burlison Alex

Male

M

Atlantic High School

100420

Lake Worth Campus

1

(561) 555-2158

U.S. Citizen

C

Unspecified

N/A

No

Gentry

Alex

Spitfirepro@Hetgroup.Org

English

EN

No

Yes

In-State/In-District

1

Palm Beach

50

Florida

FL

Y

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

No

B11559861

22814588

No

33436

(561) 555-1637

N/A

United States

US

1968-12-08T00:00:00-05:00

N/A

N

No

Lucia

No

Prieto, Lucia Yvette

Female

F

N/A

Lake Worth Campus

1

(561) 555-8071

U.S. Citizen

C

Unspecified

N/A

No

Prieto

Yvette

Lyprieto40@Hetgroup.Org

English

EN

No

Yes

No

In-State/In-District

1

Palm Beach

50

Florida

FL

Y

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

No

L07828429

23225706

No

33486

N/A

United States

US

1957-03-17T00:00:00-05:00

N/A

No

Kenneth

No

Nejib, Kenneth Victor

Male

M

N/A

Boca Raton Campus

5

(954) 555-1181

U.S. Citizen

C

Unspecified

N/A

No

Nejib

Victor

N/A

English

EN

No

Yes

In-State/In-District

1

Broward

06

Florida

FL

Y

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

No

K07082423

23170626

No

33067

N/A

United States

US

1968-09-23T00:00:00-04:00

Hispanic

H

No

Brunilda

No

Valle Cordero, Brunilda

Female

F

N/A

Palm Beach Gardens Campus

2

(561) 555-9468

U.S. Citizen

C

Unspecified

N/A

No

Valle Cordero

N/A

English

EN

No

Yes

No

In-State/In-District

1

Palm Beach

50

Florida

FL

Y

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

No

B07292691

22791591

No

33405

(561) 555-3417

United States

US

United States

US

1996-06-30T00:00:00-04:00

Not Reported

X

No

Giovanni

No

Palermo, Giovanni Joseph

Male

M

Saint John Paul Ii Academy

100123

Boca Raton Campus

5

N/A

U.S. Citizen

C

Required Prep

N/A

No

Palermo

Joseph

Gpalermo15@Hetgroup.Org

English

EN

No

Yes

In-State/In-District

1

Alachua

01

Florida

FL

Y

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

No

G14886402

23031563

No

33445

N/A

United States

US

1991-05-14T00:00:00-04:00

N/A

N

No

Julia

No

Alame, Julia

Female

F

N/A

(561) 555-9137

U.S. Citizen

C

Unspecified

N/A

No

Alame

Julzi.Alame@Hetgroup.Org

N/A

No

Yes

No

Out-Of-State

3

N/A

Florida

FL

Y

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

No

J15212376

23161609

No

33467

N/A

Nigeria

NG

Nigeria

NG

1958-10-10T00:00:00-04:00

N/A

No

Olufunmi

No

Akinrogbe, Olufunmi Valentine O

Male

M

N/A

Lake Worth Campus

1

462-30555

Other

X

Did Not Require Prep

N/A

No

Akinrogbe

Valentine O

N/A

English

EN

Yes

No

Yes

No

Out-Of-Country

4

N/A

Y

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

No

O09375379

23378739

No

33302

(561) 555-7384

United States

US

United States

US

1989-08-28T00:00:00-04:00

N/A

N

No

Breeana

No

Willett, Breeana M

Female

F

Ged

XX0033

Palm Beach Gardens Campus

2

(561) 555-7384

U.S. Citizen

C

Required Prep

N/A

No

Willett

M

Xxlilwilletxx@Hetgroup.Org

English

EN

No

Yes

Out-Of-State

3

N/A

Florida

FL

Y

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

No

B12042099

22813603

No

33411

N/A

United States

US

1976-02-28T00:00:00-05:00

N/A

No

Krista

No

Heine, Krista Marie

Female

F

N/A

Lake Worth Campus

1

965-10555

U.S. Citizen

C

Unspecified

N/A

No

Heine

Marie

N/A

English

EN

No

Yes

In-State/In-District

1

Palm Beach

50

Florida

FL

Y

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

No

K07910599

23169485

No

33461

(561) 555-2218

United States

US

United States

US

1988-07-13T00:00:00-04:00

N/A

N

No

Latilica

No

Boldin, Latilica Shenir

Female

F

Palm Beach Gardens High School

101341

Palm Beach Gardens Campus

2

N/A

U.S. Citizen

C

Required Prep

N/A

No

Boldin

Shenir

Babyrick27@Hetgroup.Org

English

EN

No

Yes

No

In-State/In-District

1

Palm Beach

50

Florida

FL

Y

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

No

L12298840

23249231

No

33409