View - dbo.arch_StudentCombined

Property	Value
Name	arch_StudentCombined
Schema	dbo
Quoted Identifier Status	True
Ansi Nulls Status	True
Returns View Metadata	False
Create Date	10/1/2014 11:53 AM
Description

Column Name	Data Type	Allow Nulls	Fulltext Indexed	Identity	Description / Computed Formula
AddDate	date(10, 0)	True	False	False
AmIndianAKNative	varchar(3)	True	False	False
ApplicationFeeStatus	varchar(25)	True	False	False
Asian	varchar(3)	True	False	False
BlackAfricanAmerican	varchar(3)	True	False	False
CellPhone	varchar(20)	True	False	False
City	varchar(20)	True	False	False
Country	varchar(3)	True	False	False
CreditApplicationDate	date(10, 0)	True	False	False
CreditApplicationTerm	varchar(6)	True	False	False
CreditReAdmitTerm	varchar(6)	True	False	False
DateOfBirth	date(10, 0)	True	False	False
EffectiveTerm	varchar(6)	True	False	False
Ethnicity	varchar(30)	False	False	False
FirstName	varchar(20)	True	False	False
Gender	varchar(7)	False	False	False
HawaiianPacIslander	varchar(3)	True	False	False
HighSchoolApplicationTerm	varchar(6)	True	False	False
HighSchoolGraduationDate	date(10, 0)	True	False	False
HighSchoolReAdmitTerm	varchar(6)	True	False	False
HomeCampus	varchar(50)	False	False	False
HomePhone	varchar(20)	True	False	False
ImmigrationStatus	varchar(30)	False	False	False
InstitutionalEmailAddress	varchar(50)	True	False	False
LastName	varchar(35)	True	False	False
LastTermAttended	varchar(6)	True	False	False
MiddleInitial	varchar(1)	True	False	False
MiddleName	varchar(20)	True	False	False
NonCreditApplicationTerm	varchar(6)	True	False	False
NonCreditReAdmitTerm	varchar(6)	True	False	False
OverallCumGPA	numeric(4, 2)	False	False	False
OverallGpaHours	numeric(5, 2)	False	False	False
OverallGradePoints	numeric(7, 2)	False	False	False
OverallHoursAttempted	numeric(5, 2)	False	False	False
OverallHoursEarned	numeric(5, 2)	False	False	False
PersonalEmailAddress	varchar(40)	True	False	False
PrimaryObjective	varchar(5)	True	False	False
PrimaryObjectiveAwardType	varchar(30)	True	False	False
PrimaryObjectiveTitle	varchar(60)	True	False	False
PrimaryObjectiveTrackTitle1	varchar(30)	True	False	False
ProspectApplication	varchar(3)	True	False	False
ResidencyCountry	varchar(30)	False	False	False
ResidencyCounty	varchar(30)	False	False	False
ResidencyState	varchar(30)	False	False	False
State	varchar(2)	True	False	False
Street1	varchar(32)	True	False	False
Street2	varchar(32)	True	False	False
StudentId	varchar(9)	True	False	False
StudentSSN	varchar(11)	True	False	False
TransferInstitution	varchar(8)	True	False	False
TransferInstitutionName	varchar(32)	True	False	False
TransferMajor	varchar(6)	True	False	False
TransferMajorDescription	varchar(30)	True	False	False
VocationalApplicationTerm	varchar(6)	True	False	False
VocationalReAdmitTerm	varchar(6)	True	False	False
White	varchar(3)	True	False	False
WorkPhone	varchar(20)	True	False	False
ZipCode	varchar(11)	True	False	False

Name

Insert

Update

Delete

Instead

Name

Clustered

Columns

Name	Type
arch_Student	View
arch_StudentAddressesAll	View
arch_StudentPrimaryAward	View

Name	Type
arch_Student	VIEW
arch_StudentAddressesAll	VIEW
arch_StudentPrimaryAward	VIEW

Object

Property

Value

Object

Property

Value

/****** Object: View [dbo].[arch_StudentCombined] Script Date: 03/09/2017 16:47:09 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW [dbo].[arch_StudentCombined]
AS
    SELECT  Student.StudentId
           ,Student.FirstName
           ,Student.LastName
           ,SUBSTRING(Student.MiddleName, 1, 1) AS MiddleInitial
           ,Student.MiddleName
           ,Student.CellPhone
           ,Student.HomePhone
           ,Student.WorkPhone
           ,Student.PersonalEmailAddress
           ,StAddr.Street1
           ,StAddr.Street2
           ,StAddr.City
           ,StAddr.State
           ,StAddr.ZipCode
           ,StAddr.Country
           ,Student.HomeCampus
           ,Student.ProspectApplication
           ,Student.InstitutionalEmailAddress
           ,CONVERT(Date,Student.DateOfBirth) AS DateOfBirth
           ,Student.CreditApplicationTerm
           ,Student.CreditReAdmitTerm
           ,Student.NonCreditApplicationTerm
           ,Student.NonCreditReAdmitTerm
           ,Student.VocationalApplicationTerm
           ,Student.VocationalReAdmitTerm
           ,Student.HighSchoolApplicationTerm
           ,Student.HighSchoolReAdmitTerm
           ,Student.LastTermAttended
           ,StPrimAwd.PrimaryObjective
           ,StPrimAwd.PrimaryObjectiveAwardType
           ,StPrimAwd.EffectiveTerm
           ,StPrimAwd.PrimaryObjectiveTitle
           ,StPrimAwd.PrimaryObjectiveTrackTitle1
           ,StPrimAwd.TransferInstitution
           ,StPrimAwd.TransferInstitutionName
           ,StPrimAwd.TransferMajor
           ,StPrimAwd.TransferMajorDescription
           ,Student.ResidencyState
           ,Student.ResidencyCounty
           ,Student.ResidencyCountry
           ,Student.ImmigrationStatus
           ,Student.Ethnicity
           ,Student.Gender
           ,Student.Asian
           ,Student.BlackAfricanAmerican
           ,Student.AmIndianAKNative
           ,Student.HawaiianPacIslander
           ,Student.White
           ,Student.CreditApplicationDate
           ,Student.OverallCumGPA
           ,Student.OverallGradePoints
           ,Student.OverallHoursEarned
           ,Student.OverallHoursAttempted
           ,Student.OverallGpaHours
           ,Student.AddDate
           ,Student.HighSchoolGraduationDate
           ,Student.ApplicationFeeStatus
           ,Student.StudentSSN
FROM dbo.arch_Student Student
INNER JOIN dbo.arch_StudentAddressesAll StAddr
ON
(
   Student.StudentId = StAddr.StudentId
)
LEFT OUTER JOIN dbo.arch_StudentPrimaryAward StPrimAwd
ON
(
  Student.StudentId = StPrimAwd.StudentId
)