Table - dbo.ST_SESSION

Property	Value
Name	ST_SESSION_A
Schema	dbo
Row Count	67117
Data Size	5904 KB
Index Size	1040 KB
Create Date	8/15/2012 2:10 PM
Description

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
ADD_DATE	varchar(8)	True	False	False
ADD_PGM	varchar(8)	True	False	False
ADD_TIME	varchar(7)	True	False	False
ADD_USER_ID	varchar(8)	True	False	False
CLASS_KEY	varchar(25)	True	False	False
FEE_TYPE_IND	varchar(1)	True	False	False
HOLD	int(10, 0)	True	False	False
ISN_ST_SESSION_A	int(10, 0)	False	False	False
MAINT_DATE	varchar(8)	True	False	False
MAINT_PGM	varchar(8)	True	False	False
MAINT_TIME	varchar(7)	True	False	False
MAINT_USER_ID	varchar(8)	True	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False
SESS_9S_COMP_BEG_DT	varchar(8)	True	False	False
SESS_9S_COMP_END_DT	varchar(8)	True	False	False
SESS_BEG_DT	varchar(8)	True	False	False
SESS_END_DT	varchar(8)	True	False	False
SESSION_KEY	varchar(10)	True	False	False
SESSION_TTL	varchar(30)	True	False	False
SESSION_TY	varchar(1)	True	False	False

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
U7VPQBQ9133WN	False	ISN_ST_SESSION_A

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.arch_AR_Receivables	View
dbo.arch_StudentLastTermAttended	View
dbo.usp_DimCurriculum_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_Old	StoredProcedure
dbo.usp_DimProgramRetentionCohort_Select	StoredProcedure
dbo.usp_DimStudentSuccessCohort_Select	StoredProcedure
dbo.usp_DimStudentTerm_Select	StoredProcedure
dbo.usp_FactApplicationStatus_Select	StoredProcedure

Name	Type
dbo.arch_StudentLastTermAttended	VIEW
dbo.usp_DimCurriculum_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_Old	STOREDPROCEDURE
dbo.usp_DimProgramRetentionCohort_Select	STOREDPROCEDURE
dbo.usp_DimStudentSuccessCohort_Select	STOREDPROCEDURE
dbo.usp_DimStudentTerm_Select	STOREDPROCEDURE
dbo.usp_FactApplicationStatus_Select	STOREDPROCEDURE
dbo.arch_AR_Receivables	VIEW

Object

Property

Value

Object

Property

Value

/****** Object: Table [dbo].[ST_SESSION_A] Script Date: 03/09/2017 16:46:20 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_SESSION_A](
    [ISN_ST_SESSION_A] [int] NOT NULL,
    [SESSION_KEY] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESSION_TTL] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESS_BEG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESS_END_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLASS_KEY] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESSION_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESS_9S_COMP_BEG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESS_9S_COMP_END_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_TYPE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)

ADD_DATE

ADD_PGM

ADD_TIME

ADD_USER_ID

CLASS_KEY

FEE_TYPE_IND

HOLD

ISN_ST_SESSION_A

MAINT_DATE

MAINT_PGM

MAINT_TIME

MAINT_USER_ID

RowUpdatedOn

SESS_9S_COMP_BEG_DT

SESS_9S_COMP_END_DT

SESS_BEG_DT

SESS_END_DT

SESSION_KEY

SESSION_TTL

SESSION_TY

NBCA0345 R 20122 1 001

43091

2017-02-06T10:49:36.741-05:00

20120105

20120507

12-15 WEEKS

NHEV0111 20033 5 001

13266

2017-02-06T10:49:34.494-05:00

20030714

20030721

NON-CREDIT

NBCA0361 R 20162 1 005

59535

2017-02-06T10:49:37.989-05:00

20160106

20160506

12-15 WEEKS

NPOO0200 20121 1 003

45260

2017-02-06T10:49:36.881-05:00

20110804

20120430

LAW ENFORCEMENT

NMEA0230 20061 1 003

20300

2017-02-06T10:49:35.025-05:00

20050823

20051219

12-16 WEEKS

NOST0104 20011 1 001

3450

2017-02-06T10:49:33.761-05:00

20001024

20001205

CTE TERM

NCJK0061 20121 1 002

45144

2017-02-06T10:49:36.881-05:00

20110819

20120531

LAW ENFORCEMENT

CSPC1017 20172 4 001

64602

2017-02-06T10:49:38.316-05:00

20170227

20170508

10 Week - Credit

CHSC2100 20173 3 002

63558

2017-02-06T10:49:38.254-05:00

20170612

20170808

SUMMER 8 WEEKS

20020325

STC530N0

1451559

ECASSIDY

S

1453435

10430

20020325

STC530N0

1453435

ECASSIDY

2017-02-06T10:49:34.292-05:00

79978984

79978786

20021015

20021213

20031 10EE

MINI SESSION

B