DWStaging
 dbo.ST_FASTER_HOLD_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_FASTER_HOLD_A
  Properties
Property Value
Name ST_FASTER_HOLD_A
Schema dbo
Row Count 95688
Data Size 35416 KB
Index Size 1464 KB
Create Date 8/15/2012 1:36 PM
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
 
ERROR_MESSAGE
varchar(100)
True
False
False
 
FILLER_00
varchar(13)
True
False
False
 
FILLER_01
varchar(207)
True
False
False
 
FILLER_02
varchar(200)
True
False
False
 
FILLER_03
varchar(200)
True
False
False
 
FILLER_04
varchar(200)
True
False
False
 
FILLER_05
varchar(200)
True
False
False
 
FIRST_NAME
varchar(12)
True
False
False
 
HEADER_INDICATOR
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_SEQ_NUM
int(10, 0)
True
False
False
 
ISN_ST_FASTER_HOLD_A
int(10, 0)
False
False
False
 
LAST_NAME
varchar(17)
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
 
NEW_INST_ID
varchar(11)
True
False
False
 
NEW_SSN
varchar(9)
True
False
False
 
ORIGINAL_INST_ID
varchar(11)
True
False
False
 
ORIGINAL_SSN
varchar(10)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_FASTER_HOLD_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_FASTER_HOLD_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_FASTER_HOLD_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_FASTER_HOLD_A] Script Date: 03/09/2017 16:46:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_FASTER_HOLD_A](
    [ISN_ST_FASTER_HOLD_A] [int] NOT NULL,
    [ORIGINAL_SSN] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NEW_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORIGINAL_INST_ID] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NEW_INST_ID] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HEADER_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_NAME] [varchar](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRST_NAME] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ERROR_MESSAGE] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FILLER_00] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FILLER_01] [varchar](207) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FILLER_02] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FILLER_03] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FILLER_04] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FILLER_05] [varchar](200) 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,
    [HOLD_SEQ_NUM] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ERROR_MESSAGE FILLER_00 FILLER_01 FILLER_02 FILLER_03 FILLER_04 FILLER_05 FIRST_NAME HEADER_INDICATOR HOLD_SEQ_NUM ISN_ST_FASTER_HOLD_A LAST_NAME MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NEW_INST_ID NEW_SSN ORIGINAL_INST_ID ORIGINAL_SSN RowUpdatedOn
20170131 STS965B1 1523290 ZCTBK SSN 10TH CHARACTER NOT BLANK - WRITTEN TO HOLD FILE S045026878322 500961 500961BOCA RATON HIGH 201320140911200320ALG 1 HON A1HL N050050B Z BENJAMIN 42 41501 THARRINGTON 00000500961 5026878322 2017-02-06T11:23:40.681-05:00
20170131 STS965B1 1523442 ZCTBK SSN NOT IN STUDENT SYSTEM - WRITTEN TO HOLD FILE S03649264867X 500581 20122013003174P 000000 30000021003000002100 YOSLEN 65 89278 CHAVEZ-OLIVA 00000500581 649264867 2017-02-06T11:23:45.892-05:00
20170131 STS965B1 1523325 ZCTBK SSN 10TH CHARACTER NOT BLANK - WRITTEN TO HOLD FILE S045029215654 500961 NJ9900UNKNOWN 201420151132100990SOC STUDIES TRAN EL N100100C Z CRAIG 32 52957 JORGENSEN 00000500961 5029215654 2017-02-06T11:23:42.085-05:00
20170131 STS965B1 1523405 ZCTBK SSN NOT IN STUDENT SYSTEM - WRITTEN TO HOLD FILE S04593738747X 500081 500081JUPITER HIGH 201420151131206310GEO GE N100100D Z TAJAREZ 79 76850 BEASLEY 00000500081 593738747 2017-02-06T11:23:44.581-05:00
20170131 STS965B1 1523401 ZCTBK SSN NOT IN STUDENT SYSTEM - WRITTEN TO HOLD FILE S04593714356X 502191 501671WELLINGTON ELEMENTARY 200820090535013000MUS GENERAL E 4-5 N000000P Z VINCENZO 39 75167 SANFILIPPO 00000502191 593714356 2017-02-06T11:23:44.425-05:00
20170131 STS965B1 1523193 ZCTBK SSN 10TH CHARACTER NOT BLANK - WRITTEN TO HOLD FILE S040611010163 063623 063623CYPRESS BAY HIGH 2014201511101013202D STUDIO ART 3 HON PF H N050050A Z TIFFANY 35 8221 WIMMERS 00000063623 0611010163 2017-02-06T11:23:37.078-05:00
20170131 STS965B1 1523270 ZCTBK SSN 10TH CHARACTER NOT BLANK - WRITTEN TO HOLD FILE S045025444944 502201 502201WILLIAM T. DWYER HIGH 201520161111505500VOLLEYBALL 1 PE N050050A Z ALIANNA 112 33671 JONES 00000502201 5025444944 2017-02-06T11:23:39.855-05:00
20170131 STS965B1 1523450 ZCTBK SSN NOT IN STUDENT SYSTEM - WRITTEN TO HOLD FILE S01770484786X 502181 770484786X PONTON MEDINA LAURA YYNNNNFH GENTLEWOOD FOREST D BOYNTON BEACH FL33473 1COLOMBIA PBEATRIZ FERNANDEZ OLYMPIC HEIGHTS HIGH 20101 LYONS ROAD BOCA RATON 00000800000000000100010000000100 Y 00031840000527310133000006022016W06 LAURA 2 91835 PONTON MEDINA 00000502181 770484786 2017-02-06T11:23:46.173-05:00
20170131 STS965B1 1523415 ZCTBK SSN NOT IN STUDENT SYSTEM - WRITTEN TO HOLD FILE S04594654232X 501361 500021L C SWAIN MIDDLE SCHOOL 201120120811200310ALG 1 A19X N050000C C KANDELARIO 64 80002 VILLANUEVA 00000501361 594654232 2017-02-06T11:23:44.878-05:00
20170131 STS965B1 1523257 ZCTBK SSN 10TH CHARACTER NOT BLANK - WRITTEN TO HOLD FILE S045025039850 500691 502781TRADEWINDS MIDDLE SCHOOL 201120120832002110M/J COMPRE SCI 3 ADV N000000A Z YARENY 74 28820 MORALES 00000500691 5025039850 2017-02-06T11:23:39.277-05:00
Powered by BI Documenter