DWStaging
 dbo.SECURITY_MODULE_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_MODULE_A2
  Properties
Property Value
Name SECURITY_MODULE_A2
Schema dbo
Row Count 1694
Data Size 184 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_A2
int(10, 0)
False
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
 
SYSTEM_AVAILABILITY_FLAG
varchar(1)
True
False
False
 
SYSTEM_IDENTIFIER
varchar(2)
True
False
False
 
SYSTEM_NAME
varchar(15)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_SECURITY_MODULE_A2
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.SECURITY_MODULE_A2 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.SECURITY_MODULE_A2)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[SECURITY_MODULE_A2] Script Date: 03/09/2017 16:45:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[SECURITY_MODULE_A2](
    [ISN_SECURITY_MODULE_A2] [int] NOT 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,
    [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_FUNCTION_AREA] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SYSTEM_IDENTIFIER] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SYSTEM_NAME] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SYSTEM_AVAILABILITY_FLAG] [varchar](1) 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_A2 MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MODULE_DESCRIPTION MODULE_FUNCTION_AREA MODULE_ID RowUpdatedOn SYSTEM_AVAILABILITY_FLAG SYSTEM_IDENTIFIER SYSTEM_NAME
20040422 SEC002N1 0916481 ZSSMC 4 1373 BROWSE NON-EMPLOYEE BY LASTNAME PE PED600N3 2017-02-06T11:24:51.896-05:00
20010402 SEC002N1 1451291 ZCIAP 13 72 CREATE FACILITIES DATABASE FC FCI280P1 2017-02-06T11:24:51.818-05:00
19970716 SEC002N1 1144362 ZSMAR 1 673 BROWSE BATCH JOB/CREATE JCL COPY UT UTL880P1 2017-02-06T11:24:51.849-05:00
20111012 SEC002N1 0905082 ZCSMC 5 1611 20120229 SEC002N1 1006524 ZCBHJ BUDGET ROLL-UP REPORT FI FIG585J4 2017-02-06T11:24:51.911-05:00
19980611 SEC002N1 1502071 ZFCAI 5 946 20010410 SEC002N1 1040596 ZCDAM PROCESS RETAINAGE BY PAYEE FI FIA150P1 2017-02-06T11:24:51.849-05:00
20020211 SEC002N1 1024081 ZCRCH 2 1157 20020415 SEC002N1 1258415 ZCRCH DISPLAY EMPLOYEE LOG PE PED201N1 2017-02-06T11:24:51.88-05:00
19960325 SEC002N1 1826515 ZMEAL 33 267 S&U PO BY VENDOR NAME FI FIP820P3 2017-02-06T11:24:51.818-05:00
19971014 SEC002N1 1101419 ZOKWS 22 813 MAINTAIN EXEMPTION CODE TABLE ST STT420P1 2017-02-06T11:24:51.849-05:00
19960905 SEC002N1 2154118 ZSSAN 6 464 19980406 SEC002N1 1037262 ZSIAP STUDENT CLAST ALTERNATIVES ST STS210P1 2017-02-06T11:24:51.818-05:00
19960310 SEC002N1 1842356 ZTRAB 1 192 MAINTAIN SECURITY SYSTEMS SE SEC005P1 2017-02-06T11:24:51.818-05:00
Powered by BI Documenter