DWStaging
 dbo.IT_EXIT_INTERVIEW_REPOSITORY_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_EXIT_INTERVIEW_REPOSITORY_A
  Properties
Property Value
Name IT_EXIT_INTERVIEW_REPOSITORY_A
Schema dbo
Row Count 17262
Data Size 1840 KB
Index Size 288 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
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
 
FAO
varchar(2)
True
False
False
 
FOLLOWUP_FLAG
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_IT_EXIT_INTERVIEW_REPOSITORY_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
 
OPEN_STATUS_TRM
varchar(6)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STATUS
varchar(10)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_IT_EXIT_INTERVIEW_REPOSITORY_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.IT_EXIT_INTERVIEW_REPOSITORY_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.IT_EXIT_INTERVIEW_REPOSITORY_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[IT_EXIT_INTERVIEW_REPOSITORY_A] Script Date: 03/09/2017 16:45:39 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IT_EXIT_INTERVIEW_REPOSITORY_A](
    [ISN_IT_EXIT_INTERVIEW_REPOSITORY_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,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OPEN_STATUS_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOLLOWUP_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID FAO FOLLOWUP_FLAG HOLD ISN_IT_EXIT_INTERVIEW_REPOSITORY_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OPEN_STATUS_TRM RowUpdatedOn STATUS STUDENT_ID
20071115 ITW325B1 0127153 OPER2 PB 1054373 16200 20160930 ITW325B1 1054373 OPER1 20171 2017-02-06T11:21:15.585-05:00 OPEN V12302212
20140925 ITW325B1 1127310 OPER1 PB 1719053 15238 20160128 FIW327B1 1719053 E003320 20151 2017-02-06T11:21:15.522-05:00 CLOSED M14818272
20070927 ITW325B1 0159413 OPER2 PB 1539271 46 20160531 FIW327B1 1539271 OPER1 20141 2017-02-06T11:21:14.54-05:00 CLOSED E08206377
20070927 ITW325B1 0159385 OPER2 PB 144287 1038 20100217 FIW327B1 0144287 OPER2 20092 2017-02-06T11:21:14.586-05:00 CLOSED C06546022
20160226 ITW325B1 1413267 E003320 PB 1054440 16191 20160930 ITW325B1 1054440 OPER1 20171 2017-02-06T11:21:15.585-05:00 OPEN T14724785
20120127 ITW325B1 0856305 OPER2 PB 323097 10950 20130917 FIW327B1 0323097 OPER2 20122 2017-02-06T11:21:15.242-05:00 CLOSED J13284930
20160628 ITW325B1 1052517 OPER1 PB 1052517 15766 20163 2017-02-06T11:21:15.569-05:00 OPEN M14629844
20130911 ITW325B1 1009387 OPER1 PB 1054417 13887 20160930 ITW325B1 1054417 OPER1 20171 2017-02-06T11:21:15.444-05:00 OPEN S14501068
20121109 ITW325B1 0552561 OPER1 PB 1006029 11638 20131125 FIW327B1 1006029 OPER1 20131 2017-02-06T11:21:15.304-05:00 CLOSED M13812508
20081017 ITW325B1 0848390 OPER2 PB 303346 1711 20090216 FIW327B1 0303346 OPER2 20091 2017-02-06T11:21:14.633-05:00 CLOSED K12774121
Powered by BI Documenter