DWOperations
 dbo.Verify_dbo_DimProgramRetentionCohort (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_DimProgramRetentionCohort
  Properties
Property Value
Name Verify_dbo_DimProgramRetentionCohort
Schema dbo
Row Count 77452
Data Size 17616 KB
Index Size 80 KB
Create Date 1/28/2014 9:48 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AgeAtProgramRetentionCohort
smallint(5, 0)
False
False
False
 
AgeRangeAtProgramRetentionCohort
varchar(10)
False
False
False
 
AwardType
varchar(30)
False
False
False
 
AwardTypeCode
varchar(3)
False
False
False
 
CIP
varchar(30)
False
False
False
 
CIPCode
varchar(10)
False
False
False
 
CohortTerm
varchar(6)
False
False
False
 
CohortTermTitle
varchar(30)
False
False
False
 
Program
varchar(30)
False
False
False
 
ProgramAdmitStatus
varchar(3)
False
False
False
 
ProgramCode
varchar(5)
False
False
False
 
ProgramRetentionCohortAK
varchar(20)
False
False
False
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
StudentId
varchar(9)
False
False
False
 
SwitchedAwardType
varchar(30)
False
False
False
 
SwitchedAwardTypeCode
varchar(3)
False
False
False
 
SwitchedCIP
varchar(30)
False
False
False
 
SwitchedCIPCode
varchar(10)
False
False
False
 
SwitchedProgram
varchar(30)
False
False
False
 
SwitchedProgramCode
varchar(5)
False
False
False
 
SwitchedTerm
varchar(6)
False
False
False
 
SwitchedTermTitle
varchar(30)
False
False
False
 
In Primary Key
VerifyProgramRetentionCohortSK
int(10, 0)
False
False
False
(1 / 1)
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyProgramRetentionCohortSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimProgramRetentionCohort depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimProgramRetentionCohort)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimProgramRetentionCohort] Script Date: 03/09/2017 17:21:48 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimProgramRetentionCohort](
    [VerifyProgramRetentionCohortSK] [int] IDENTITY(1,1) NOT NULL,
    [ProgramRetentionCohortAK] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CohortTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CohortTermTitle] [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,
    [AwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AwardType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CIPCode] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CIP] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AgeAtProgramRetentionCohort] [smallint] NOT NULL,
    [AgeRangeAtProgramRetentionCohort] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedProgramCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedProgram] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedTermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedAwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedAwardType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedCIPCode] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedCIP] [varchar](30) 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_DimProgramRetentionCohort] PRIMARY KEY CLUSTERED 
(
    [VerifyProgramRetentionCohortSK] 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
AgeAtProgramRetentionCohort AgeRangeAtProgramRetentionCohort AwardType AwardTypeCode CIP CIPCode CohortTerm CohortTermTitle Program ProgramAdmitStatus ProgramCode ProgramRetentionCohortAK RowIsDuplicate RowIsSelected StudentId SwitchedAwardType SwitchedAwardTypeCode SwitchedCIP SwitchedCIPCode SwitchedProgram SwitchedProgramCode SwitchedTerm SwitchedTermTitle VerifyProgramRetentionCohortSK
43 40 - 64 ASSOCIATE IN SCIENCE DEGREE AS NURSING AS 1351380100 20162 SPRING TERM 2016 NURSING No 2301 T061151412301 20162 N Y T06115141 N/A N/A N/A N/A N/A N/A N/A N/A 70265
18 < 19 ASSOCIATE IN ARTS DEGREE AA ASSOCIATE IN ARTS 1192401010 20153 SUMMER TERM 2015 ASSOCIATE IN ARTS Yes 1000 A147172501000 20153 N Y A14717250 N/A N/A N/A N/A N/A N/A N/A N/A 16117
19 19 - 21 ASSOCIATE IN SCIENCE DEGREE AS EMERGENCY MED SRVS ASSOC AS 1351090402 20142 SPRING TERM 2014 EMERGENCY MEDICAL SERVICES Yes 2449 M142143402449 20142 N Y M14214340 TECHNICAL CERTIFICATE TC PARAMEDIC CCC 0351090405 PARAMEDIC 6450 20151 FALL TERM 2014 29497
19 19 - 21 ASSOCIATE IN ARTS DEGREE AA ASSOCIATE IN ARTS 1192401010 20141 FALL TERM 2013 ASSOCIATE IN ARTS Yes 1000 T141220221000 20141 N Y T14122022 ASSOCIATE IN SCIENCE DEGREE AS HUMAN SERVICES (AS) 1451159901 HUMAN SERVICES 2345 20171 FALL TERM 2016 71837
15 < 19 NON-DEGREE SEEKING ND NON-CREDIT 9999999999 20141 FALL TERM 2013 HS DUAL ENROLLMENT Yes 3801 B144821523801 20141 N Y B14482152 N/A N/A N/A N/A N/A N/A N/A N/A 25080
55 40 - 64 ASSOCIATE IN ARTS DEGREE AA ASSOCIATE IN ARTS 1192401010 20171 FALL TERM 2016 ASSOCIATE IN ARTS Yes 1000 E150493311000 20171 N Y E15049331 N/A N/A N/A N/A N/A N/A N/A N/A 53092
18 < 19 ASSOCIATE IN ARTS DEGREE AA ASSOCIATE IN ARTS 1192401010 20171 FALL TERM 2016 ASSOCIATE IN ARTS Yes 1000 J150446051000 20171 N Y J15044605 N/A N/A N/A N/A N/A N/A N/A N/A 21400
21 19 - 21 ASSOCIATE IN ARTS DEGREE AA ASSOCIATE IN ARTS 1192401010 20142 SPRING TERM 2014 ASSOCIATE IN ARTS Yes 1000 K141299281000 20142 N Y K14129928 N/A N/A N/A N/A N/A N/A N/A N/A 25281
28 22 - 29 BACHELOR OF SCIENCE DEGREE BS BACHELOR OF NURSING 1105138012 20163 SUMMER TERM 2016 NURSING No S901 M11763059S901 20163 N Y M11763059 NON-DEGREE SEEKING ND NON-CREDIT 9999999999 SPECIAL PERMISSION 3410 20171 FALL TERM 2016 1024
49 40 - 64 ASSOCIATE IN SCIENCE DEGREE AS RESPIRATORY CARE TECH AS 1351090800 20142 SPRING TERM 2014 RESPIRATORY CARE No 2148 T079343832148 20142 N Y T07934383 ASSOCIATE IN ARTS DEGREE AA ASSOCIATE IN ARTS 1192401010 ASSOCIATE IN ARTS 1000 20163 SUMMER TERM 2016 50235
Powered by BI Documenter