DWStaging
 dbo.ST_COMM_RQST_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_COMM_RQST_A
  Properties
Property Value
Name ST_COMM_RQST_A
Schema dbo
Row Count 3725283
Data Size 950304 KB
Index Size 55576 KB
Create Date 8/15/2012 12:45 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
 
CITY
varchar(20)
True
False
False
 
CNTRY
varchar(3)
True
False
False
 
COMM_RQST
varchar(10)
True
False
False
 
COPIES
int(10, 0)
True
False
False
 
DEPT_CD
varchar(10)
True
False
False
 
EFF_TERM
varchar(6)
True
False
False
 
EMAIL_ADDR
varchar(40)
True
False
False
 
EXP_DT
varchar(8)
True
False
False
 
FAX_NUM
varchar(20)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
IND_BATCH_ONLINE
varchar(1)
True
False
False
 
ISN_ST_COMM_RQST_A
int(10, 0)
False
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
 
PSTG_CLS
varchar(10)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
RQST_DT
varchar(8)
True
False
False
 
RQST_TM
varchar(7)
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_CONTACT_CD
varchar(2)
True
False
False
 
SND_HOLD
varchar(1)
True
False
False
 
SND_NAME
varchar(30)
True
False
False
 
STATE
varchar(2)
True
False
False
 
STREET_1
varchar(32)
True
False
False
 
STREET_2
varchar(32)
True
False
False
 
TRACKING_NO
varchar(10)
True
False
False
 
TRANS_MODE
varchar(10)
True
False
False
 
ZIP_CD
varchar(11)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_COMM_RQST_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_COMM_RQST_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_COMM_RQST_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_COMM_RQST_A] Script Date: 03/09/2017 16:46:00 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_COMM_RQST_A](
    [ISN_ST_COMM_RQST_A] [int] NOT NULL,
    [COMM_RQST] [varchar](10) 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,
    [RQST_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRACKING_NO] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANS_MODE] [varchar](10) 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,
    [EXP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEPT_CD] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PSTG_CLS] [varchar](10) 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,
    [SND_HOLD] [varchar](1) 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,
    [SND_CONTACT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_ADDR] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FAX_NUM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COPIES] [int] NULL,
    [IND_BATCH_ONLINE] [varchar](1) 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,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CITY CNTRY COMM_RQST COPIES DEPT_CD EFF_TERM EMAIL_ADDR EXP_DT FAX_NUM HOLD IND_BATCH_ONLINE ISN_ST_COMM_RQST_A LTTR_CD MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PSTG_CLS RowUpdatedOn RQST_DT RQST_TM SENT_DT SENT_TM SND_CONTACT SND_CONTACT_CD SND_HOLD SND_NAME STATE STREET_1 STREET_2 TRACKING_NO TRANS_MODE ZIP_CD
20110808 UTL651N0 1055235 WEB5 PORT ST LUCIE US SN13948104 1 STUDLTTR 20121 NPATEL.BWVERO@GMAIL.COM 20110808 (772) 341-0938 1055235 994654 AP1 AM 2017-02-06T09:29:29.508-05:00 20110808 1055235 20110808 1055235 PATEL NIMA RAMESH FL 1060 SW VERSAILLES AVE 0000999309 EM 34953
20120731 UTL651N0 0338420 OPER2 POMPANO BEACH US SN13890397 1 STUDLTTR 20131 castilhon@my.palmbeachstate.edu 20120731 338420 1480600 MCL AM 2017-02-06T09:30:17.322-05:00 20120731 0338420 20120731 0338420 CASTILHO NATASHA FL 630 NE 24 ST 0001498955 EM 33064
20100629 UTL651N0 1427504 E001772 DEERFIELD BEACH US SJ13610019 1 STUDLTTR 20111 HAFERJON@GMAIL.COM 20100629 (754) 245-3515 1427504 585551 RE4 AM 2017-02-06T09:28:50.445-05:00 20100629 1427504 20100629 1427504 HAFER JONATHAN R FL 465 NE 9 AV 0000588346 EM 33441
20140812 UTL651N0 0354058 OPER2 WEST PALM BEACH US ST13642632 1 STUDLTTR 20151 vongpaphanty@my.palmbeachstate.edu 20140812 (561) 574-0763 354058 2523866 MCL AM 2017-02-06T09:32:02.981-05:00 20140812 0354058 20140812 0354058 VONGPAPHAN TIFFANY YURI FL 13127 78TH PL N 0002581474 EM 33412
20091208 UTL651N0 0313365 OPER2 FORT LAUDERDALE US SC13314711 1 STUDLTTR 20102 vielc@my.pbcc.edu 20091208 (954) 854-7313 313365 413294 MCL AM 2017-02-06T09:28:35.141-05:00 20091208 0313365 20091208 0313365 VIEL CEDRICK FL 10220 NW 80 CT 0000417080 EM 33321
20141201 UTL651N0 1709323 E077620 No city UE082720 1 STUDLTTR 20092 MCFADDES@PALMBEACHSTATE.EDU 20141201 1709323 2644096 UAP AM 2017-02-06T09:32:14.666-05:00 20141201 1709323 20141201 1709323 SHERRY,F,MCFADDEN XX No street address 0002705435 EM 99999
20161213 UTL651N0 1026308 E031488 JUPITER US SM14619852 1 STUDLTTR 20073 haysm1@my.palmbeachstate.edu 20161213 (561) 743-6930 1026308 3687344 E9P AM 2017-02-06T09:33:56.191-05:00 20161213 1026307 20161213 1026307 HAYS MICHAEL FL 127 WEST RIVERSIDE DRIVE 0003762656 EM 33469
20130111 UTL651N0 0939550 OPER1 LOXAHATCHEE US SM13891627 1 STUDLTTR 2012 testam1@my.palmbeachstate.edu 20130111 (561) 758-9911 939550 1724383 E98 AM 2017-02-06T09:30:41.876-05:00 20130111 0939550 20130111 0939550 TESTA MICHAELANGELO FL 16898 75TH PL. N. 0001749483 EM 33470
20140812 UTL651N0 0344451 OPER2 WEST PALM BEACH US SO14487441 1 STUDLTTR 20151 borisovao@my.palmbeachstate.edu 20140812 (561) 578-7553 344451 2519823 MCL AM 2017-02-06T09:32:02.56-05:00 20140812 0344451 20140812 0344451 BORISOVA OLGA FL 1707 FLORIDA AVE. 1/2 #C 0002577431 EM 33401
20130212 UTL651N0 0643458 OPER2 LAKE WORTH US E000002082 1 STUDLTTR 20132 MANESHM@PALMBEACHSTATE.EDU 20130212 643458 1810207 S10 AM 2017-02-06T09:30:50.425-05:00 20130212 0643458 20130212 0643458 MANESH, MIKE FL 4845 GARDNER LANE 0001836978 EM 33463
Powered by BI Documenter