DWStaging
 dbo.SECURITY_USER_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.SECURITY_USER_LOG_A
  Properties
Property Value
Name SECURITY_USER_LOG_A
Schema dbo
Row Count 3651
Data Size 608 KB
Index Size 88 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_LOG_A
int(10, 0)
False
False
False
 
LAST_NAME
varchar(25)
True
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
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
 
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_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.SECURITY_USER_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.SECURITY_USER_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[SECURITY_USER_LOG_A] Script Date: 03/09/2017 16:45:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[SECURITY_USER_LOG_A](
    [ISN_SECURITY_USER_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [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,
    [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,
    [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_LOG_A LAST_NAME LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER 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
20081108 SECINIT 0936242 SAG BLOETHM@palmbeachstate.edu O MICHAEL 3 3015 BLOETH M 20101116 pts/18 952081 ZCIAP 20101116 SEC001N1 0952081 ZCIAP 2017-02-06T11:22:43.928-05:00 ZPMRB A ME 561-868-3731
20010404 SEC001N1 2234307 ZCBHJ BJARAMIL@FCCSC E BRISSET 124 1401 JARA M 20040318 3985 1753519 ZCEAL 20040318 SEC001N1 1753518 ZCEAL 2017-02-06T11:22:43.788-05:00 FCCSCFTL FCCSCFTL ZCBHJ A ME 9547611170
20021030 SEC001N1 0855476 ZSSMC No email address O TIM 1 663 SMITH A 20021030 M107 855476 ZSSMC E 2017-02-06T11:22:43.741-05:00 LOCAL LOCAL FCCSCFTL FCCSCFTL ZSTES A ME No work phone number
20080122 SEC001N1 1510312 ZSSMC mcfarlar@pbcc.edu O ROZ 26 2338 MABRY M 20080729 3990 958285 ZCIAP 20080729 SEC001N1 0958285 ZCIAP 31745 2017-02-06T11:22:43.866-05:00 ZPRAM A ME 561-868-3028
20080128 SEC001N1 1544209 ZSSMC nmathews@broward.edu E NEREIDA 26 2344 MATTHEWS M 20080822 3873 933383 ZCIAP 20080822 SEC001N1 0933383 ZCIAP 68992 2017-02-06T11:22:43.866-05:00 BCC1 BCC1 ZBNRM A ME No work phone number
20110204 SECINIT 1052283 SAG DDELANEY@BROWARD.EDU E DAPHNE 2 3225 DELANEY M 20130114 pts/24 1430081 ZCBHJ 20130114 SEC001N1 1430080 ZCBHJ 63115 2017-02-06T11:22:43.944-05:00 ZBDDD A ME 954-201-7083
20020206 SEC001N1 0940578 ZSSMC simmonsn@pbcc.cc.fl.us 45 582 NANCY SIMMONS M 20020805 M099 923160 ZSSMC 20020805 SEC001N1 0923160 ZSSMC 2017-02-06T11:22:43.741-05:00 BATCH1 BATCH2 BCC1 BCC2 ZPNSS A ME (561) 439-8261
20060301 SEC001N1 1143528 ZCIAP No email address E PENNY 4 1800 NEWTEST A 20060301 3967 1143528 ZCIAP 4159 2017-02-06T11:22:43.835-05:00 MCISAACP A ME No work phone number
20010416 SEC001N1 1447179 ZSSMC No email address O SHAUN 59 744 ACHMAD M 20030317 M168 1034039 ZCBDF 20030317 SEC001N1 1034039 ZCBDF 2017-02-06T11:22:43.741-05:00 FCCSCFTL FCCSCFTL FCCSCFTL FCCSCFTL ZCSAA A ME No work phone number
20081015 SECINIT 1422518 SAG MCNEILLR@NWFSTATECOLLEGE.EDU O ROBIN 2 2526 MCNEILL M 20090210 pts/52 1522324 ZCIAP 20090210 SEC001N1 1522324 ZCIAP 4980 2017-02-06T11:22:43.897-05:00 ZORRM A ME 850-729-5325
Powered by BI Documenter