DWStaging
 dbo.ST_TRANSCRIPT_LOG_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_TRANSCRIPT_LOG_A
  Properties
Property Value
Name ST_TRANSCRIPT_LOG_A
Schema dbo
Row Count 1527751
Data Size 493248 KB
Index Size 22816 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
 
CITY
varchar(20)
True
False
False
 
CNTRY
varchar(3)
True
False
False
 
CONTACT_CODE
varchar(2)
True
False
False
 
COPIES
int(10, 0)
True
False
False
 
ELC_PPR_CD
varchar(1)
True
False
False
 
FASTER_BLOCK
varchar(253)
True
False
False
 
FASTER_CODE_IN
varchar(3)
True
False
False
 
FASTER_CODE_OUT
varchar(3)
True
False
False
 
FASTER_DT
varchar(8)
True
False
False
 
FASTER_TM
varchar(7)
True
False
False
 
FAX_NUM
varchar(20)
True
False
False
 
FORMER_NAME_1
varchar(17)
True
False
False
 
FORMER_NAME_2
varchar(17)
True
False
False
 
HELD_CD
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLDS_OVERRIDDEN
bit(1, 0)
True
False
False
 
IMM_BCH_CD
varchar(1)
True
False
False
 
INST_ID
varchar(8)
True
False
False
 
INST_STUDENT_ID
varchar(12)
True
False
False
 
INST_TY
varchar(1)
True
False
False
 
ISN_ST_TRANSCRIPT_LOG_A
int(10, 0)
False
False
False
 
LINK_AGENCY_ID
varchar(8)
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
 
MASS_IND
varchar(1)
True
False
False
 
NON_CREDIT_DESCRIPTIONS
varchar(1)
True
False
False
 
OFFLINE_CD
varchar(1)
True
False
False
 
PAGE
int(10, 0)
True
False
False
 
PICKUP_CD
varchar(1)
True
False
False
 
PRINT_ADDRESS
varchar(1)
True
False
False
 
PRINT_CD
varchar(1)
True
False
False
 
PRINTER_ADDRESS
varchar(17)
True
False
False
 
RCVD_DATE
varchar(8)
True
False
False
 
RCVD_TIME
varchar(9)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
RQST_DT
varchar(8)
True
False
False
 
RQST_DT_9S_COMP
varchar(8)
True
False
False
 
RQST_ST
varchar(1)
True
False
False
 
RQST_TM
varchar(7)
True
False
False
 
RQST_TM_9S_COMP
varchar(7)
True
False
False
 
RQST_TRN_CD
varchar(1)
True
False
False
 
SELF_CD
varchar(1)
True
False
False
 
SEND_TYPE
varchar(1)
True
False
False
 
SENT_DT
varchar(8)
True
False
False
 
SENT_TM
varchar(7)
True
False
False
 
SND_CONTACT
varchar(30)
True
False
False
 
SND_NAME
varchar(30)
True
False
False
 
STATE
varchar(2)
True
False
False
 
STD_DIPLOMA
varchar(1)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
STREET_1
varchar(32)
True
False
False
 
STREET_2
varchar(32)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
TERM_REQUESTED
varchar(6)
True
False
False
 
TIME_CD
varchar(1)
True
False
False
 
TRANSCRIPT_TYPE
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_TRANSCRIPT_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_TRANSCRIPT_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_TRANSCRIPT_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_TRANSCRIPT_LOG_A] Script Date: 03/09/2017 16:46:31 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_TRANSCRIPT_LOG_A](
    [ISN_ST_TRANSCRIPT_LOG_A] [int] NOT NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_ST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_DT_9S_COMP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_TM_9S_COMP] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [IMM_BCH_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ELC_PPR_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OFFLINE_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_TRN_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SND_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SND_CONTACT] [varchar](30) 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,
    [CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP_CD] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SENT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SENT_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FAX_NUM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINT_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PICKUP_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STD_DIPLOMA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FASTER_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FASTER_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FASTER_CODE_IN] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FASTER_CODE_OUT] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COPIES] [int] NULL,
    [HELD_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSCRIPT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINT_ADDRESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINTER_ADDRESS] [varchar](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM_REQUESTED] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEND_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FORMER_NAME_1] [varchar](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FORMER_NAME_2] [varchar](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_STUDENT_ID] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NON_CREDIT_DESCRIPTIONS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RCVD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RCVD_TIME] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAGE] [int] NULL,
    [MASS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SELF_CD] [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,
    [FASTER_BLOCK] [varchar](253) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLDS_OVERRIDDEN] [bit] NULL,
    [LINK_AGENCY_ID] [varchar](8) 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 CITY CNTRY CONTACT_CODE COPIES ELC_PPR_CD FASTER_BLOCK FASTER_CODE_IN FASTER_CODE_OUT FASTER_DT FASTER_TM FAX_NUM FORMER_NAME_1 FORMER_NAME_2 HELD_CD HOLD HOLDS_OVERRIDDEN IMM_BCH_CD INST_ID INST_STUDENT_ID INST_TY ISN_ST_TRANSCRIPT_LOG_A LINK_AGENCY_ID MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MASS_IND NON_CREDIT_DESCRIPTIONS OFFLINE_CD PICKUP_CD PRINT_ADDRESS PRINT_CD PRINTER_ADDRESS RCVD_DATE RCVD_TIME RowUpdatedOn RQST_DT RQST_DT_9S_COMP RQST_ST RQST_TM RQST_TM_9S_COMP RQST_TRN_CD SELF_CD SEND_TYPE SENT_DT SENT_TM SND_CONTACT SND_NAME STATE STD_DIPLOMA STDNT_ID STREET_1 STREET_2 STUDENT_ID TERM_REQUESTED TIME_CD TRANSCRIPT_TYPE ZIP_CD
20080916 STS420N0 1212135 WEB1 PORT ORANGE US AO 1 P 1740017 false B 661994 20080916 STS420N0 1740017 OPER1 N C LOCAL 2017-02-06T10:16:15.965-05:00 20080916 79919083 S 1212132 8787867 P S 20080916 1740017 BIZIER, MARTINE MONIQUE FL M07257926 3103 WATERWAY PLACE N O 32128
20140821 STS420N0 2023513 OPER1 E 221722206 0001512000000100020000R30P Hunt Robert Vincent R30 S30 20140821 2023513 2024145 false B 001481 P 1288857 20140828 STS420N0 2024145 OPER1 20140821 2023513 2017-02-06T10:17:55.151-05:00 20140821 79859178 S 2023513 7976486 S I 20140828 2024145 FLORIDA ATLANTIC UNIVERSITY R14446405 20151 N O
20150319 STS420N0 0906468 OPER2 E 589251113 0001512000000100020000R20P Crawford Desi Dixon R20 S22 20150319 0906468 907510 false B 001481 P 1340222 20150319 STS420N0 0907510 OPER2 20150319 0906468 2017-02-06T10:18:03.45-05:00 20150319 79849680 S 0906468 9093531 S I 20150319 907510 FLORIDA ATLANTIC UNIVERSITY D14921399 20152 N O
20120709 STS420N0 1029192 E082714 POMPANO BEACH US AO 1 P Q01 1029192 false I 1002585 N N D110 2017-02-06T10:17:09.302-05:00 20120709 79879290 X 1029192 8970807 S S TRIGOBOFF, ROBIN FL R12096038 5272 NW 117 AV N O 33076
20140310 STS420N0 0839385 OPER1 MIAMI US 1 E S30 R30 20151202 0830254 830254 false B 001506 P 1182946 20151202 STS420N0 0830254 OPER1 20151202 0830254 2017-02-06T10:17:38.474-05:00 20140324 79859675 S 0839384 9160615 R I 20140324 838015 MIAMI-DADE COLLEGE FL R14203798 300 NE 2ND AVE 20142 N O 33132
20050511 STS420N0 1021448 OPER2 E 592247181 0001512000000100020000R01P Worman Stephanie Michelle R01 S01 20050511 1021448 1036103 false B 001481 P 392348 20050511 STS420N0 1036103 OPER2 20050511 1021448 2017-02-06T10:15:35.14-05:00 20050511 79949488 S 1021448 8978551 S I 20050511 1036103 Worman, Stephanie Michelle S11492782 N O
20030807 STS420N0 1709163 WEB4 ORLANDO US AO 1 P Q01 2112460 false B 006750 P 271857 20030807 STS420N0 2112460 OPER2 LOCAL 2017-02-06T10:15:17.122-05:00 20030807 79969192 S 1709162 8290837 S I 20030807 2112460 VALENCIA COMMUNITY COLLEGE FL R11183910 P O BOX 3028 N O 32802
20040729 STS420N0 1316063 WEB3 BOCA RATON US AO 1 E Q01 2024573 false B 001481 P 340782 20040729 STS420N0 2024573 OPER2 LOCAL 2017-02-06T10:15:27.262-05:00 20040729 79959270 S 1316061 8683938 S I 20040729 2024573 FLORIDA ATLANTIC UNIVERSITY FL L11336914 777 GLADES ROAD P.O. BOX 3091 N O 33431
20150811 STS420N0 1206229 E089018 WEST PALM BEACH US AO 1 P Q01 1206229 false I 1391095 N N D38 2017-02-06T10:18:11.5-05:00 20150811 79849188 X 1206227 8793772 S S FORRESTER, KEISANO TEE FL K12205811 236 WEST 27TH STREET N O 33417
20130408 STS420N0 2005500 OPER1 FORT PIERCE US 1 E S01 R01 20130410 2001529 2001529 false B 001493 P 1070661 20130410 STS420N0 2001529 OPER1 20130410 2001529 2017-02-06T10:17:20.441-05:00 20130408 79869591 S 2005500 7994499 R I 20130408 2006317 INDIAN RIVER STATE COLLEGE FL W14410385 3209 VIRGINIA AVENUE N O 34981
Powered by BI Documenter