DWStaging
 dbo.IT_FREEZE_POINT_A (Table)
Home  Diagrams  Documents  Images  DWStaging  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:  DWStaging   Tables   dbo.IT_FREEZE_POINT_A
  Properties
Property Value
Name IT_FREEZE_POINT_A
Schema dbo
Row Count 1127189
Data Size 163416 KB
Index Size 16848 KB
Create Date 11/7/2012 11:53 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACADEMIC_YEAR
varchar(4)
True
False
False
 
ACT_FREEZE_DATE_STATE
varchar(8)
True
False
False
 
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
 
HOLD
int(10, 0)
True
False
False
 
HOME_CAMPUS
varchar(1)
True
False
False
 
ISN_IT_FREEZE_POINT_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
 
RESIDENCY_CODE
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
TERM_ID
varchar(6)
True
False
False
 
TOT_REMEDIAL_HRS
numeric(17, 2)
True
False
False
 
TRM_CLASS
varchar(3)
True
False
False
 
TRM_CRD_HRS_STATE
decimal(7, 2)
True
False
False
 
TRM_DEGREE
varchar(3)
True
False
False
 
TRM_ENR_STATUS_OTHER
varchar(1)
True
False
False
 
TRM_ENR_STATUS_PELL
varchar(1)
True
False
False
 
TRM_ENR_STATUS_STATE
varchar(1)
True
False
False
 
TRM_FAO
varchar(2)
True
False
False
 
TRM_GPA
numeric(17, 3)
True
False
False
 
TRM_HOUSING
varchar(1)
True
False
False
 
TRM_MAJOR
varchar(5)
True
False
False
 
TRM_NC_HRS_STATE
decimal(7, 2)
True
False
False
 
TRM_PGM
varchar(4)
True
False
False
 
TRM_PGM_INELIGIBLE_FLAG
varchar(1)
True
False
False
 
TRM_RMD_HRS_STATE
decimal(7, 2)
True
False
False
 
TRM_TOT_DUAL_ENROLLMENT_HRS
decimal(7, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_IT_FREEZE_POINT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.IT_FREEZE_POINT_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.IT_FREEZE_POINT_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[IT_FREEZE_POINT_A] Script Date: 03/09/2017 16:45:39 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IT_FREEZE_POINT_A](
    [ISN_IT_FREEZE_POINT_A] [int] NOT 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,
    [HOLD] [int] NULL,
    [ACADEMIC_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM_ID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESIDENCY_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOT_REMEDIAL_HRS] [numeric](17, 2) NULL,
    [TRM_PGM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_PGM_INELIGIBLE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_DEGREE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_CLASS] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_GPA] [numeric](17, 3) NULL,
    [TRM_TOT_DUAL_ENROLLMENT_HRS] [decimal](7, 2) NULL,
    [TRM_HOUSING] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_MAJOR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOME_CAMPUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_ENR_STATUS_OTHER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_ENR_STATUS_PELL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_ENR_STATUS_STATE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_CRD_HRS_STATE] [decimal](7, 2) NULL,
    [TRM_NC_HRS_STATE] [decimal](7, 2) NULL,
    [TRM_RMD_HRS_STATE] [decimal](7, 2) NULL,
    [ACT_FREEZE_DATE_STATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACADEMIC_YEAR ACT_FREEZE_DATE_STATE ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID HOLD HOME_CAMPUS ISN_IT_FREEZE_POINT_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RESIDENCY_CODE RowUpdatedOn STUDENT_ID TERM_ID TOT_REMEDIAL_HRS TRM_CLASS TRM_CRD_HRS_STATE TRM_DEGREE TRM_ENR_STATUS_OTHER TRM_ENR_STATUS_PELL TRM_ENR_STATUS_STATE TRM_FAO TRM_GPA TRM_HOUSING TRM_MAJOR TRM_PGM TRM_PGM_INELIGIBLE_FLAG
2010 20100519 20100518 ITW222N1 2327300 OPER2 2314287 2 387368 20100804 ITW222N1 2314287 OPER2 I 2017-02-06T10:05:57.812-05:00 C13141049 20103 9.00 FR 9.00 AA T T T PB 3.400 P 1040 1040
2010 20090901 20090831 ITW222N1 0008264 OPER2 21192 1 317034 20100104 ITW222N1 0021192 OPER2 I 2017-02-06T10:05:50.479-05:00 A13111091 20101 FR 12.00 AA F F F PB P 1040 1040
2011 20110606 20110517 ITW222N1 2326501 OPER2 17183 5 490624 20110808 ITW222N1 0017183 OPER2 I 2017-02-06T10:06:09.09-05:00 D12980025 20113 17.00 FR 3.00 AA N N L PB 2.000 P 1010 1010
2005 20050607 ITW222N1 1244310 E023242 1244310 5 126835 I 2017-02-06T10:05:30.121-05:00 T11728870 20052 FR N N PB 2.000 O Y
2014 20130909 20130906 ITW222N1 2035515 OPER1 2233363 1 763587 20131213 ITW222N1 2233363 OPER1 I 2017-02-06T10:06:38.153-05:00 S13965538 20141 3.00 SO 13.00 AA F F F PB 2.630 P 1000 1000
2017 20170209 ITW222N1 1056373 ZCBDF 1056373 5 1124099 I 2017-02-09T10:56:37.111-05:00 S15421092 20172 2.00 FR AA N N PB 0.330 O 1000 1000
2011 20100830 20100830 ITW222N1 0033002 OPER2 34218 2 398352 20101220 ITW222N1 0034218 OPER2 I 2017-02-06T10:05:58.95-05:00 J13091517 20111 SO AA N N N PB 3.190 O 1000 1000
2013 20130506 20130122 ITW222N1 0102291 OPER2 1100079 1 667013 20130506 ITW222N1 1100079 E062735 I 2017-02-06T10:06:27.748-05:00 P13119680 20132 FR AS L L N PB 2.750 O 2039C 2039
2011 20110114 20110113 ITW222N1 0023406 OPER2 2325172 1 462481 20110508 ITW222N1 2325172 OPER2 I 2017-02-06T10:06:06.048-05:00 C13449590 20112 6.00 FR 9.00 AS H H T PB 2.660 P 2301 2301
2010 20100510 20100509 ITW222N1 2314342 OPER2 935441 1 366064 20100510 ITW222N1 0935441 E026130 O 2017-02-06T10:05:55.674-05:00 A12628053 20102 FR N N N PB C
Powered by BI Documenter