Table - dbo.Staged_TermSessionTempTable

Properties

Property	Value
Name	Staged_TermSessionTempTable
Schema	dbo
Row Count	301
Data Size	24 KB
Index Size	8 KB
Create Date	5/29/2013 12:13 AM
Description

Columns

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
SESS_BEG_DT	varchar(8)	True	False	False
TRM_TTL	varchar(30)	True	False	False
TRM_YR	varchar(6)	True	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name

Clustered

Columns

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.Staged_TermSessionTempTable depends on)

Name

Type

Child Dependencies (objects that depend on dbo.Staged_TermSessionTempTable)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[Staged_TermSessionTempTable] Script Date: 03/09/2017 17:21:45 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_TermSessionTempTable](
    [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_TTL] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESS_BEG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

Sample Data

SESS_BEG_DT	TRM_TTL	TRM_YR
20130513	SUMMER TERM 2013	20133
20170823	FALL TERM 2017	20181
19660617	SUMMER TERM 1966	19664
19920629	SUMMER TERM 1992	19924
19970512	SPRING TERM 1997	19973
19880620	SUMMER TERM 1988	19884
20170105	SPRING TERM 2017	20172
19970825	FALL TERM 1997	19981
19910826	FALL TERM 1991	19921
19650827	FALL TERM 1965	19661