DWStaging
 dbo.SECURITY_MODULE_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_MODULE_LOG_A
  Properties
Property Value
Name SECURITY_MODULE_LOG_A
Schema dbo
Row Count 2289
Data Size 288 KB
Index Size 72 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
 
HOLD
int(10, 0)
True
False
False
 
ISN_SECURITY_MODULE_LOG_A
int(10, 0)
False
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
 
MODULE_DESCRIPTION
varchar(32)
True
False
False
 
MODULE_FUNCTION_AREA
varchar(2)
True
False
False
 
MODULE_ID
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_SECURITY_MODULE_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.SECURITY_MODULE_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.SECURITY_MODULE_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[SECURITY_MODULE_LOG_A] Script Date: 03/09/2017 16:45:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[SECURITY_MODULE_LOG_A](
    [ISN_SECURITY_MODULE_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,
    [MODULE_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MODULE_DESCRIPTION] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MODULE_FUNCTION_AREA] [varchar](2) 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 HOLD ISN_SECURITY_MODULE_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MODULE_DESCRIPTION MODULE_FUNCTION_AREA MODULE_ID RowUpdatedOn
20020204 SEC002N1 1340403 ZCRCH 12 1184 M 20020204 M147 1341171 ZCRCH 20020204 SEC002N1 1341171 ZCRCH MAINTAIN INSTRUCTOR PAY SCHEDULE PE ITP075N1 2017-02-06T11:24:16.749-05:00
20041008 SEC002N1 0850528 ZCIAP 1 1705 A 20041008 905558 ZCIAP BROWSE STUDENTS BY FORMER ID ST STA017P2 2017-02-06T11:24:16.78-05:00
19971014 SEC002N1 1114443 ZOKWS 41 1242 M 20020403 M202 1645173 ZCIAP 20020403 SEC002N1 1645173 ZCIAP VA BENEFITS ST STT533P0 2017-02-06T11:24:16.749-05:00
20060707 SEC002N1 1054131 ZCFKV 5 1840 A 20060710 1433074 ZCFKV FINANCIAL AID ENROLLMENT COMPL FN FIW500N2 2017-02-06T11:24:16.78-05:00
19961111 SEC002N1 1923510 ZSMAR 3 382 A 19961111 1923510 ZSMAR MAINTAIN NEXT AVALABLE WD/PO NO FI FIP010P1 2017-02-06T11:24:16.686-05:00
19971013 SEC002N1 1024597 ZOKWS 14 897 A 19971013 1024597 ZOKWS DA BY STDNT ID AND MANY PGRM ID ST STD730P1 2017-02-06T11:24:16.718-05:00
20070717 SEC002N1 1332177 ZCVDW 4 2117 M 20110617 pts/4 1052106 ZCBHJ 20110617 SEC002N1 1052106 ZCBHJ PURCHASING CARD FI FIA240P4 2017-02-06T11:24:16.811-05:00
20020524 SEC002N1 1212425 ZSSMC 20 1942 M 20080201 1141512 ZCADM STUDENT STF TABLE OWNER MAINT ST STR 2017-02-06T11:24:16.796-05:00
19980307 SEC002N1 1048372 ZBEMC 4 1143 M 20010802 904514 ZSSMC 20010802 SEC002N1 0904514 ZSSMC BATCH JOBS UT UTL870P1 2017-02-06T11:24:16.749-05:00
19960326 SEC002N1 935525 ZPCAM 2 629 M 20010305 1617251 ZCRCH 20010305 SEC002N1 1617251 ZCRCH CALENDAR MAINTENANCE NAVIGATOR PE PEC000P4 2017-02-06T11:24:16.718-05:00
Powered by BI Documenter