DWStaging
 dbo.COMM_REQ_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.COMM_REQ_A
  Properties
Property Value
Name COMM_REQ_A
Schema dbo
Row Count 606240
Data Size 78544 KB
Index Size 9072 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
ADB_ADMISS_ACT
varchar(1)
True
False
False
 
ADB_CIP_RPTD
varchar(10)
True
False
False
 
ADB_PGM_RPTD
varchar(5)
True
False
False
 
ADB_TRM_YR_RPTD
varchar(6)
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
 
ADM_DT
varchar(8)
True
False
False
 
ADM_SENT
varchar(1)
True
False
False
 
ADM_ST
varchar(1)
True
False
False
 
APPL_CONFIRM_DT
varchar(8)
True
False
False
 
APPL_DT
varchar(8)
True
False
False
 
APPL_SENT
varchar(1)
True
False
False
 
APPL_TM
varchar(7)
True
False
False
 
EFF_TERM
varchar(6)
True
False
False
 
FLDR_LBL_PRINT
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_COMM_REQ_A
int(10, 0)
False
False
False
 
LST_DT_SENT
varchar(8)
True
False
False
 
LST_MISS_DT
varchar(8)
True
False
False
 
LTTR_CD
varchar(3)
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
 
MISS_SENT
int(10, 0)
True
False
False
 
NBR_SENT
int(10, 0)
True
False
False
 
PAYEE_ADDR_SEQ_NBR
int(10, 0)
True
False
False
 
PAYEE_ID
varchar(9)
True
False
False
 
PAYEE_TYPE
varchar(2)
True
False
False
 
PREP_POLICY_DT
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SDB_BACC_TRM_YR_RPTD
varchar(6)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
TEST_REQ_SENT
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_COMM_REQ_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.COMM_REQ_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.COMM_REQ_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[COMM_REQ_A] Script Date: 03/09/2017 16:45:09 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[COMM_REQ_A](
    [ISN_COMM_REQ_A] [int] NOT NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPL_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_ST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPL_SENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MISS_SENT] [int] NULL,
    [ADM_SENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LST_MISS_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [TEST_REQ_SENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FLDR_LBL_PRINT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LTTR_CD] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ADDR_SEQ_NBR] [int] NULL,
    [NBR_SENT] [int] NULL,
    [LST_DT_SENT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPL_CONFIRM_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADB_TRM_YR_RPTD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADB_CIP_RPTD] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADB_PGM_RPTD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADB_ADMISS_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREP_POLICY_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SDB_BACC_TRM_YR_RPTD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADB_ADMISS_ACT ADB_CIP_RPTD ADB_PGM_RPTD ADB_TRM_YR_RPTD ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADM_DT ADM_SENT ADM_ST APPL_CONFIRM_DT APPL_DT APPL_SENT APPL_TM EFF_TERM FLDR_LBL_PRINT HOLD ISN_COMM_REQ_A LST_DT_SENT LST_MISS_DT LTTR_CD MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAYEE_ID PAYEE_TYPE PREP_POLICY_DT RowUpdatedOn SDB_BACC_TRM_YR_RPTD STDNT_ID TEST_REQ_SENT
20160524 STS858N0 1519016 WEB5 20160628 C 20160524 15:19:0 938446 590750 20160628 STS858N0 0938446 OPER1 2017-02-06T10:38:05.984-05:00 S15345853 Y
20010206 STS858N0 0142101 OPER2 I 19790101 01:42:1 1035275 64120 20020419 STS858N0 1035275 OPER2 2017-02-06T10:37:17.171-05:00 A09961483 Y
20090624 STS858N0 1306443 E028420 I 20160120 20160120 15:11:5 1511539 400306 20160120 STS858N0 1511539 WEB5 2017-02-06T10:37:48.917-05:00 R13276829 Y
20021105 STS858N0 0238001 OPER2 I 19971027 02:38:0 746075 145804 20021107 STS858N0 0746075 OPER2 2017-02-06T10:37:24.784-05:00 S06308670 Y
20151113 STS858N0 1102581 WEB5 I 20161213 20151113 11:02:5 1208304 575729 20161213 STS858N0 1208304 WEB5 2017-02-06T10:38:04.549-05:00 J15184518 Y
20091009 STS858N0 1256332 E000943 20091016 C 20091009 12:56:4 926566 409716 20091016 STS858N0 0926566 E014813 2017-02-06T10:37:49.76-05:00 L13374301 Y
20081119 STS858N0 1400374 FACTS1 I 20160412 20160412 10:15:1 1015188 380632 20160412 STS858N0 1015188 E090215 2017-02-06T10:37:47.014-05:00 I13072525 Y
20061214 STS858N0 1411207 E004094 I 20061214 14:11:2 742208 328924 20070104 STS858N0 0742208 OPER2 2017-02-06T10:37:42.038-05:00 J12490678 Y
20061106 STS858N0 1420552 E001202 I 20140210 20140210 18:26:0 1826078 325848 20140210 STS858N0 1826078 WEB5 2017-02-06T10:37:41.741-05:00 W12462610 Y
20140105 STS858N0 2059112 WEB5 I 20150112 20140105 Y 20:59:1 1539032 525508 20150112 STS858N0 1539032 WEB5 2017-02-06T10:38:00.04-05:00 T14635619 Y
Powered by BI Documenter