DWStaging
 dbo.IA_EMAIL_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.IA_EMAIL_A
  Properties
Property Value
Name IA_EMAIL_A
Schema dbo
Row Count 149462
Data Size 14352 KB
Index Size 2696 KB
Create Date 11/7/2012 2:39 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACTUAL_SEND_DATE
varchar(8)
True
False
False
 
ACTUAL_SEND_TIME
varchar(7)
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
 
EMAIL_FUNCTION
varchar(10)
True
False
False
 
EMAIL_TO_ID
varchar(9)
True
False
False
 
EMAIL_TO_TYPE
varchar(1)
True
False
False
 
FROM_USER
varchar(40)
True
False
False
 
HDR_MESSAGE_NBR
varchar(9)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
IMPORTANCE
varchar(3)
True
False
False
 
ISN_IA_EMAIL_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
 
MESSAGE_NBR
varchar(9)
True
False
False
 
MESSAGE_SEQ
int(10, 0)
True
False
False
 
REQUESTED_SEND_DATE
varchar(8)
True
False
False
 
REQUESTED_SEND_TIME
varchar(7)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SEND_IND
varchar(1)
True
False
False
 
SUBJECT
varchar(60)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_IA_EMAIL_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.IA_EMAIL_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.IA_EMAIL_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[IA_EMAIL_A] Script Date: 03/09/2017 16:45:36 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IA_EMAIL_A](
    [ISN_IA_EMAIL_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,
    [HDR_MESSAGE_NBR] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MESSAGE_NBR] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MESSAGE_SEQ] [int] NULL,
    [SEND_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTED_SEND_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTED_SEND_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTUAL_SEND_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTUAL_SEND_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FROM_USER] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUBJECT] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [IMPORTANCE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_TO_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_TO_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_FUNCTION] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTUAL_SEND_DATE ACTUAL_SEND_TIME ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID EMAIL_FUNCTION EMAIL_TO_ID EMAIL_TO_TYPE FROM_USER HDR_MESSAGE_NBR HOLD IMPORTANCE ISN_IA_EMAIL_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MESSAGE_NBR MESSAGE_SEQ REQUESTED_SEND_DATE REQUESTED_SEND_TIME RowUpdatedOn SEND_IND SUBJECT
20150203 UTL620N1 1154008 ZCTLC 1098-EMAIL G09001215 S ACCOUNTSRECEIVABLE@IRSC.EDU 002325596 1 343029 2017-02-06T10:32:16.588-05:00 Y Your 1098T is available for viewing
20150203 UTL620N1 1151139 ZCTLC 1098-EMAIL A12001046 S ACCOUNTSRECEIVABLE@IRSC.EDU 002322128 1 336093 2017-02-06T10:32:16.058-05:00 Y Your 1098T is available for viewing
20150203 UTL620N1 1159266 ZCTLC 1098-EMAIL T03000361 S ACCOUNTSRECEIVABLE@IRSC.EDU 002332286 1 356409 2017-02-06T10:32:17.712-05:00 Y Your 1098T is available for viewing
20151211 UTL620N1 0651346 ZCMSW EMP-F1095 000071138 E HELP@HETGROUP.ORG 002341016 1 374123 2017-02-06T10:32:19.022-05:00 N Your Form 1095 has been mailed
20150203 UTL620N1 1155531 ZCTLC 1098-EMAIL K10002939 S ACCOUNTSRECEIVABLE@IRSC.EDU 002327906 1 347649 2017-02-06T10:32:16.994-05:00 Y Your 1098T is available for viewing
20150203 UTL620N1 1152112 ZCTLC 1098-EMAIL C05000609 S ACCOUNTSRECEIVABLE@IRSC.EDU 002323301 1 338439 2017-02-06T10:32:16.23-05:00 Y Your 1098T is available for viewing
363444 002335809 1 2017-02-06T10:32:18.242-05:00
361408 002334777 1 2017-02-06T10:32:18.086-05:00
20150131 UTL620N1 1018271 SAG PIN-CHANGE L14003529 S help@fccsc.org 002319193 1 330221 2017-02-06T10:32:15.574-05:00 Y Hetgroup Student PIN
20160915 UTL620N1 1108126 ZCEAL 1098-EMAIL D15022312 S CASHIER@HETGROUP.ORG 004218111 1 3654 2017-02-06T10:32:08.57-05:00 N SSN information needed
Powered by BI Documenter