DWStaging
 dbo.ST_INSTITUTION_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.ST_INSTITUTION_A
  Properties
Property Value
Name ST_INSTITUTION_A
Schema dbo
Row Count 42795
Data Size 6768 KB
Index Size 680 KB
Create Date 3/4/2015 10:09 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
 
ALT_FASTER_ID
varchar(17)
True
False
False
 
ASGND_INST_ID
varchar(1)
True
False
False
 
CITY
varchar(20)
True
False
False
 
CNTRY
varchar(3)
True
False
False
 
CONTACT_NAME
varchar(30)
True
False
False
 
CRED_ACPTD
varchar(1)
True
False
False
 
DEFAULT_CONTACT_CODE
varchar(2)
True
False
False
 
FASTER_PRTCPNT
varchar(1)
True
False
False
 
FASTER_PRTCPNT_STAT
varchar(1)
True
False
False
 
FAX_NUMBER
varchar(20)
True
False
False
 
FLA_STATE_HS_CODE
varchar(8)
True
False
False
 
GEN_ED_ACCEPTED
varchar(1)
True
False
False
 
GEN_ED_ACCEPTED_BEGIN_TERM
varchar(6)
True
False
False
 
GEN_ED_ACCEPTED_END_TERM
varchar(6)
True
False
False
 
HM_PHN
varchar(20)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HONOR_FASTER_REQ
varchar(1)
True
False
False
 
INST_CAMP
varchar(3)
True
False
False
 
INST_ID
varchar(8)
True
False
False
 
INST_NM
varchar(32)
True
False
False
 
INST_SHORT_NM
varchar(8)
True
False
False
 
INST_TY
varchar(1)
True
False
False
 
ISN_ST_INSTITUTION_A
int(10, 0)
False
False
False
 
LINK_INST_ID
varchar(8)
True
False
False
 
LINK_INST_TY
varchar(1)
True
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
 
PUBLIC_PRIVATE_IND
varchar(1)
True
False
False
 
RECEIVE_FASTER_TRS
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SDB_TRANSFER
varchar(7)
True
False
False
 
SEND_FASTER_TRS
varchar(1)
True
False
False
 
SEND_WEB_TRS
varchar(1)
True
False
False
 
STATE
varchar(2)
True
False
False
 
STREET_1
varchar(32)
True
False
False
 
STREET_2
varchar(32)
True
False
False
 
TRANSCRIPT_COURSE_TY
varchar(1)
True
False
False
 
ZIP_CD
varchar(11)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_INSTITUTION_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_INSTITUTION_A depends on)
Name Type
View
View
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_INSTITUTION_A)
Name Type
VIEW
STOREDPROCEDURE
STOREDPROCEDURE
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_INSTITUTION_A] Script Date: 03/09/2017 16:46:09 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_INSTITUTION_A](
    [ISN_ST_INSTITUTION_A] [int] NOT NULL,
    [ASGND_INST_ID] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRED_ACPTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FASTER_PRTCPNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FASTER_PRTCPNT_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HM_PHN] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_CAMP] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_NM] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_SHORT_NM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP_CD] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALT_FASTER_ID] [varchar](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVE_FASTER_TRS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HONOR_FASTER_REQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEND_FASTER_TRS] [varchar](1) 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,
    [FLA_STATE_HS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PUBLIC_PRIVATE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSCRIPT_COURSE_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FAX_NUMBER] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SDB_TRANSFER] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEND_WEB_TRS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GEN_ED_ACCEPTED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GEN_ED_ACCEPTED_BEGIN_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GEN_ED_ACCEPTED_END_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LINK_INST_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LINK_INST_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEFAULT_CONTACT_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ALT_FASTER_ID ASGND_INST_ID CITY CNTRY CONTACT_NAME CRED_ACPTD DEFAULT_CONTACT_CODE FASTER_PRTCPNT FASTER_PRTCPNT_STAT FAX_NUMBER FLA_STATE_HS_CODE GEN_ED_ACCEPTED GEN_ED_ACCEPTED_BEGIN_TERM GEN_ED_ACCEPTED_END_TERM HM_PHN HOLD HONOR_FASTER_REQ INST_CAMP INST_ID INST_NM INST_SHORT_NM INST_TY ISN_ST_INSTITUTION_A LINK_INST_ID LINK_INST_TY MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PUBLIC_PRIVATE_IND RECEIVE_FASTER_TRS RowUpdatedOn SDB_TRANSFER SEND_FASTER_TRS SEND_WEB_TRS STATE STREET_1 STREET_2 TRANSCRIPT_COURSE_TY ZIP_CD
19970515 STC310N0 2236143 ZMHJH SAN ANTONIO US Y N 2236143 446123 BLESSED HOPE ACADEMY H 19748 2017-02-06T11:07:58.03-05:00 8888888 N TX 4522 FREDERICKSBURG RD A14 POST OFFICE BOX 4880 782804880
19970515 STC310N0 2228175 ZMHJH SACRAMENTO US Y N 2228175 052700 AMERICAN LEGION HIGH SCHOOL H 29076 2017-02-06T11:07:59.044-05:00 8888888 N CA 3801 BROADWAY 958173399
19970515 STC310N0 2241072 ZMHJH GLENNS US Y N 2241072 009160 RAPPAHANNOCK COMMUNITY COLLEGE P 25356 2017-02-06T11:07:58.623-05:00 8888888 N VA GLENNS CAMPUS PO BOX 287 23149
19970515 STC310N0 2241126 ZMHJH RAPID CITY US Y N 2241126 010170 WESTERN DAKOTA VOCATIONAL TECHNI P 25483 2017-02-06T11:07:58.623-05:00 8888888 N SD 1600 SEDIVY 57701
19970515 STC310N0 2231497 ZMHJH NORTHPORT US Y N 2231497 232830 NORTHPORT HIGH SCHOOL H 7644 2017-02-06T11:07:56.719-05:00 8888888 N MI 104 WING STREET 496700188
19980609 STC310N0 0849539 JJIVIDN EAGLE PASS US Y N 849539 442103 LIGHTHOUSE CHRISTIAN H 37018 2017-02-06T11:07:59.902-05:00 N TX POST OFFICE BOX 2398 78853
20140702 STC310N0 1515515 E002056 CONCORD US Y N 704 788-4500 1515515 340890 JAY M ROBINSON HIGH SCHOOL H 42144 2017-02-06T11:08:00.51-05:00 N NC 300 PITTS CHOOL ROAD SW 28027
19980609 STC310N0 0848276 JJIVIDN GENEVA US Y N 848276 332073 TRIUMPHANT FAITH CHR H 35068 2017-02-06T11:07:59.683-05:00 N NY 405 EXCHANGE STREET 14456
19980609 STC310N0 0848112 JJIVIDN ENFIELD US Y N 848112 300170 LA SALETTE SEMINARY H 34714 2017-02-06T11:07:59.637-05:00 N NH UNKNOWN 03748
19980609 STC310N0 0849384 JJIVIDN ERWIN US Y N 849384 420390 ERWIN HIGH SCHOOL H 36659 2017-02-06T11:07:59.855-05:00 N SD UNKNOWN 57233
Powered by BI Documenter