DWStaging
 dbo.SECURITY_USER_A2 (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.SECURITY_USER_A2
  Properties
Property Value
Name SECURITY_USER_A2
Schema dbo
Row Count 613
Data Size 72 KB
Index Size 48 KB
Create Date 8/15/2012 11:34 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
 
CAMP_CNTR
varchar(5)
True
False
False
 
EMAIL_ADDR
varchar(40)
True
False
False
 
EMPLOYEE_TYPE
varchar(1)
True
False
False
 
FIRST_NAME
varchar(15)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_SECURITY_USER_A2
int(10, 0)
False
False
False
 
LAST_NAME
varchar(25)
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
 
MIDDLE_I
varchar(1)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
USER_DEFAULT_PRINTER
varchar(17)
True
False
False
 
USER_DEFAULT_PRINTER_2
varchar(17)
True
False
False
 
USER_DEFAULT_PRINTER_ID
varchar(8)
True
False
False
 
USER_DEFAULT_PRINTER_ID_2
varchar(8)
True
False
False
 
USER_ID
varchar(8)
True
False
False
 
USER_PASSWORD
varchar(8)
True
False
False
 
USER_SSN
varchar(9)
True
False
False
 
USER_STATUS
varchar(1)
True
False
False
 
USER_TYPE
varchar(2)
True
False
False
 
WORK_PHONE
varchar(20)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_SECURITY_USER_A2
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.SECURITY_USER_A2 depends on)
Name Type
View
View
View
View
View
  Child Dependencies (objects that depend on dbo.SECURITY_USER_A2)
Name Type
VIEW
VIEW
VIEW
VIEW
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[SECURITY_USER_A2] Script Date: 03/09/2017 16:45:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[SECURITY_USER_A2](
    [ISN_SECURITY_USER_A2] [int] NOT NULL,
    [USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_NAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRST_NAME] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIDDLE_I] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_SSN] [varchar](9) 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,
    [USER_DEFAULT_PRINTER] [varchar](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_DEFAULT_PRINTER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_DEFAULT_PRINTER_2] [varchar](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_DEFAULT_PRINTER_ID_2] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_PASSWORD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WORK_PHONE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_ADDR] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID] [int] NULL,
    [EMPLOYEE_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP_CNTR] [varchar](5) 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 CAMP_CNTR EMAIL_ADDR EMPLOYEE_TYPE FIRST_NAME HOLD ISN_SECURITY_USER_A2 LAST_NAME MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MIDDLE_I PERSON_ID RowUpdatedOn USER_DEFAULT_PRINTER USER_DEFAULT_PRINTER_2 USER_DEFAULT_PRINTER_ID USER_DEFAULT_PRINTER_ID_2 USER_ID USER_PASSWORD USER_SSN USER_STATUS USER_TYPE WORK_PHONE
20030605 SEC001N1 1330140 ZCGEB JERRY 89 481 BISHOP 2017-02-06T11:26:27.852-05:00 FCCSCFTL
20081015 SECINIT 1422492 SAG RBROCKNE@BROWARD.EDU E REBECCA 8 29 BROCKNER-SMITH 20170130 SEC001N1 1644090 ZCBHJ 67668 2017-02-06T11:26:27.821-05:00 PDFPRT PDFPRT PDFPRT PDFPRT ZBRAB A ME 954-201-7425
20140710 SEC001N1 0542033 ZCMSW mbilling@hetgroup.org E MARY 3 767 BILLINGTON 20140710 SEC001N1 0555150 ZCMSW 28086 2017-02-06T11:26:27.868-05:00 MSW28086 A ME No work phone number
20150511 SECINIT 1136300 SAG HAREC@PALMBEACHSTATE.EDU O CHERYL 38 HARE 3153 2017-02-06T11:26:27.821-05:00 ZPCHH A ME 561-868-3153
20100318 SECINIT 1350390 SAG JMOORE@BROWARD.EDU O JESSICA 551 MOORE 73920 2017-02-06T11:26:27.852-05:00 ZBJMM D ME 954-201-6512
20081015 SECINIT 1424084 SAG WISEJ@palmbeachstate.edu O JEFF 177 WISE 2990 2017-02-06T11:26:27.836-05:00 ZPJLW A ME 561-868-3256
20150204 SECINIT 0722302 SAG CARRIESS@PALMBEACHSTATE.EDU E SANTREL 5 799 CARRIES 20170130 SEC001N1 1653024 ZCBHJ 77613 2017-02-06T11:26:27.868-05:00 ZPSCC A ME 561-993-1121
20081015 SECINIT 1422528 SAG ERUSSAKI@IRSC.EDU E BECKY 5 114 RUSSAKIS 20170131 SEC001N1 0955530 ZCBHJ 6423 2017-02-06T11:26:27.836-05:00 ZIEDR A ME 772-462-7783
19981015 SEC001N1 1016149 ZCDOG O 18 97 GENERIC TABLE MANAGEMENT 19981027 SEC001N1 2155036 ZCDOG 2017-02-06T11:26:27.836-05:00 ZUTBL A GR
20150213 SECINIT 1416246 SAG EGARRARD@POLK.EDU E EMILY 1 806 GARRARD 20150216 SEC001N1 1047175 ZCBHJ 70511 2017-02-06T11:26:27.868-05:00 ZKEGG A ME 863-669-2918
Powered by BI Documenter