DWOperations
 dbo.Verify_dbo_DimStudentTerm (Table)
Home  Diagrams  Documents  Images  DWOperations  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWOperations   Tables   dbo.Verify_dbo_DimStudentTerm
  Properties
Property Value
Name Verify_dbo_DimStudentTerm
Schema dbo
Row Count 4995875
Data Size 1563128 KB
Index Size 5848 KB
Create Date 8/29/2012 12:49 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AcademicStatus
varchar(30)
False
False
False
 
AcademicStatusCode
varchar(3)
False
False
False
 
Advised
varchar(3)
False
False
False
 
AdvisementAdvisor
varchar(50)
False
False
False
 
AdvisementAdvisorId
varchar(8)
False
False
False
 
AdvisementAwardType
varchar(30)
False
False
False
 
AdvisementAwardTypeCode
varchar(3)
False
False
False
 
AdvisementMandatory
varchar(3)
False
False
False
 
AdvisementProgram
varchar(30)
False
False
False
 
AdvisementProgramCode
varchar(5)
False
False
False
 
AdvisementStatus
varchar(30)
False
False
False
 
AdvisementStatusCode
varchar(3)
False
False
False
 
AgeAtTerm
smallint(5, 0)
False
False
False
 
AgeRangeAtTerm
varchar(10)
False
False
False
 
AwardType
varchar(30)
False
False
False
 
AwardTypeCode
varchar(3)
False
False
False
 
BasisOfAdmission
varchar(30)
False
False
False
 
BasisOfAdmissionCode
varchar(3)
False
False
False
 
DateLastAdvised
date(10, 0)
False
False
False
 
EnrollmentStatus
varchar(30)
False
False
False
 
EnrollmentStatusCode
varchar(3)
False
False
False
 
Program
varchar(30)
False
False
False
 
ProgramAdmitStatus
varchar(3)
False
False
False
 
ProgramCode
varchar(5)
False
False
False
 
Residency
varchar(30)
False
False
False
 
ResidencyCode
varchar(3)
False
False
False
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
SdbAwardTypeCode
varchar(3)
False
False
False
 
StudentId
varchar(9)
False
False
False
 
StudentTermAK
varchar(15)
False
False
False
 
Term
varchar(6)
False
False
False
 
TermTitle
varchar(30)
False
False
False
 
TransferInstitutionAdvisement
varchar(50)
False
False
False
 
TransferInstitutionAdvisementId
varchar(8)
False
False
False
 
TransferMajorAdvisement
varchar(30)
False
False
False
 
TransferMajorAdvisementCode
varchar(6)
False
False
False
 
In Primary Key
VerifyStudentTermSK
int(10, 0)
False
False
False
(1 / 1)
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyStudentTermSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimStudentTerm depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimStudentTerm)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimStudentTerm] Script Date: 03/09/2017 17:21:48 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimStudentTerm](
    [VerifyStudentTermSK] [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,
    [RowIsDuplicate] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsSelected] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_Verify_dbo_DimStudentTerm] PRIMARY KEY CLUSTERED 
(
    [VerifyStudentTermSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  Sample Data
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 RowIsDuplicate RowIsSelected SdbAwardTypeCode StudentId StudentTermAK Term TermTitle TransferInstitutionAdvisement TransferInstitutionAdvisementId TransferMajorAdvisement TransferMajorAdvisementCode VerifyStudentTermSK
CLEAR ACADEMIC STANDARD C0 No N/A N/A N/A N/A N/A N/A N/A N/A N/A 28 25 - 29 NON-DEGREE SEEKING ND NON-CREDIT N 1900-01-01T00:00:00-05:00 CONTINUING STUDENT C PERSONAL IMPROVEMENT Y 3408 IN-STATE/IN-DISTRICT 1 N Y 9 N06162069 N0616206920082 20082 SPRING TERM 2008 N/A N/A N/A N/A 4606263
ACAD SUSPENSION FOR LOW GPA S1 Yes SETHER, JEAN E057879 ASSOCIATE IN SCIENCE DEGREE AS No BUSINESS ENTREPRENEURSHIP 2040 ADVISED - STUDENT CAN REGISTER AD 20 20 - 21 ASSOCIATE IN SCIENCE DEGREE AS HS GRADUATE H 2013-11-07T00:00:00-05:00 CONTINUING STUDENT C BUSINESS ENTREPRENEURSHIP Y 2040 IN-STATE/IN-DISTRICT 1 N Y 2 J14204663 J1420466320142 20142 SPRING TERM 2014 N/A N/A N/A N/A 960119
N/A N/A No N/A N/A N/A N/A N/A N/A N/A N/A N/A 18 18 - 19 NON-DEGREE SEEKING ND HS GRADUATE H 1900-01-01T00:00:00-05:00 CONTINUING STUDENT C PERSONAL IMPROVEMENT Y 3408 IN-STATE/IN-DISTRICT 1 N Y 9 T09169541 T0916954119851 19851 FALL TERM 1984 N/A N/A N/A N/A 1920017
CLEAR ACADEMIC STANDARD C0 No N/A N/A N/A N/A N/A N/A N/A N/A N/A 73 > 34 NON-CREDIT NC HS GRADUATE H 1900-01-01T00:00:00-05:00 NEW STUDENT N JOB RELATED Y 8381 IN-STATE/IN-DISTRICT 1 N Y Z C12518544 C1251854420072 20072 SPRING TERM 2007 N/A N/A N/A N/A 3810177
CLEAR ACADEMIC STANDARD C0 No N/A N/A N/A N/A N/A N/A N/A N/A N/A 25 25 - 29 VOCATIONAL CERTIFICATE VC N/A P 1900-01-01T00:00:00-05:00 READMITTED STUDENT R PSAV GENERAL PROGRAM Y 5000 IN-STATE/IN-DISTRICT 1 N Y Z J14807713 J1480771320163 20163 SUMMER TERM 2016 N/A N/A N/A N/A 3857735
CLEAR ACADEMIC STANDARD C0 No N/A N/A N/A N/A N/A N/A N/A N/A N/A 19 18 - 19 NON-DEGREE SEEKING ND COLLEGE TRANSFER T 1900-01-01T00:00:00-05:00 CONTINUING STUDENT C TRANSIENT STUDENT Y 3409 IN-STATE/OUT-OF-DISTRICT 2 N Y 9 A12117370 A1211737020072 20072 SPRING TERM 2007 N/A N/A N/A N/A 3947713
CLEAR ACADEMIC STANDARD C0 No N/A N/A N/A N/A N/A N/A N/A N/A N/A 22 22 - 24 ASSOCIATE IN ARTS DEGREE AA COLLEGE TRANSFER T 1900-01-01T00:00:00-05:00 CONTINUING STUDENT C GENERAL/TRANSFER AA Y 1000 IN-STATE/IN-DISTRICT 1 N Y 1 J12140521 J1214052120073 20073 SUMMER TERM 2007 N/A N/A N/A N/A 1301451
ACAD PROBATION FOR LOW GPA P3 No N/A N/A N/A N/A N/A N/A N/A N/A N/A 22 22 - 24 ASSOCIATE IN ARTS DEGREE AA HS GRADUATE H 1900-01-01T00:00:00-05:00 CONTINUING STUDENT C GENERAL/TRANSFER AA Y 1000 IN-STATE/IN-DISTRICT 1 N Y 1 A06621999 A0662199920003 20003 SUMMER TERM 2000 N/A N/A N/A N/A 3577366
CLEAR ACADEMIC STANDARD C0 No N/A N/A N/A N/A N/A N/A N/A N/A N/A 19 18 - 19 VOCATIONAL CERTIFICATE VC HS ABVE 8TH GRADE BUT NOT GRAD V 1900-01-01T00:00:00-05:00 CONTINUING STUDENT C HVAC TECH APPRENTICE - 5 YEAR Y 5256 IN-STATE/IN-DISTRICT 1 N Y P A07001738 A0700173820023 20023 SUMMER TERM 2002 N/A N/A N/A N/A 1787605
N/A N/A No N/A N/A N/A N/A N/A N/A N/A N/A N/A 79 > 34 NON-CREDIT NC NON-CREDIT N 1900-01-01T00:00:00-05:00 ENROLLED IN NC PERSONAL ENRICH 7 NC-SUPPLEMENTAL Y 8381 IN-STATE/IN-DISTRICT 1 N Y Z M08719932 M0871993219872 19872 WINTER TERM 1987 N/A N/A N/A N/A 1876543
Powered by BI Documenter