DWStaging
 dbo.BATCH_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.BATCH_A
  Properties
Property Value
Name BATCH_A
Schema dbo
Row Count 33328
Data Size 4968 KB
Index Size 536 KB
Create Date 11/7/2012 2:39 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
 
AVAILABLE_IND
bit(1, 0)
True
False
False
 
BATCH_JOB_NAME
varchar(8)
True
False
False
 
CONTACT_EMAIL
varchar(40)
True
False
False
 
CONTACT_NAME
varchar(30)
True
False
False
 
CONTACT_PHONE
varchar(10)
True
False
False
 
CONTACT_PHONE_EXT
varchar(5)
True
False
False
 
COPIES
int(10, 0)
True
False
False
 
DEFAULTS_IND
varchar(1)
True
False
False
 
END_STEP
varchar(8)
True
False
False
 
GROUPING_DESCRIPTION
varchar(40)
True
False
False
 
GROUPING_NAME
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_BATCH_A
int(10, 0)
False
False
False
 
JOB_DESCRIPTION
varchar(50)
True
False
False
 
JOB_MODULE
varchar(8)
True
False
False
 
JOB_NAME
varchar(8)
True
False
False
 
JOB_NEEDS_SECURITY
bit(1, 0)
True
False
False
 
JOB_PARM_VALIDATION_SUBP
varchar(8)
True
False
False
 
JOB_PRIORITY
int(10, 0)
True
False
False
 
JOB_PROCESS
varchar(8)
True
False
False
 
JOB_STEP
int(10, 0)
True
False
False
 
LAST_RUN_NBR
int(10, 0)
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
 
PARM_DESCRIPTION
varchar(30)
True
False
False
 
PARM_LENGTH
int(10, 0)
True
False
False
 
PARM_NAME
varchar(4)
True
False
False
 
PRINTER_ID
varchar(17)
True
False
False
 
REQUESTED_DATE
varchar(8)
True
False
False
 
REQUESTED_TIME
varchar(7)
True
False
False
 
RESTART_JOB_NAME
varchar(8)
True
False
False
 
RESTART_KEY
varchar(50)
True
False
False
 
RESTART_STEP
varchar(8)
True
False
False
 
RESTARTABLE
bit(1, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
RUN_NBR
int(10, 0)
True
False
False
 
RUN_NOW_IND
bit(1, 0)
True
False
False
 
RUN_STATUS
varchar(1)
True
False
False
 
START_DATE
varchar(8)
True
False
False
 
START_STEP
varchar(8)
True
False
False
 
START_TIME
varchar(7)
True
False
False
 
SYSTEM_AREA
varchar(8)
True
False
False
 
SYSTEM_AREA_IND
varchar(1)
True
False
False
 
USER_ID
varchar(8)
True
False
False
 
USER_NAME
varchar(30)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_BATCH_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.BATCH_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.BATCH_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[BATCH_A] Script Date: 03/09/2017 16:45:05 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[BATCH_A](
    [ISN_BATCH_A] [int] NOT 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,
    [JOB_PROCESS] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOB_NAME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BATCH_JOB_NAME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOB_DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOB_PARM_VALIDATION_SUBP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOB_PRIORITY] [int] NULL,
    [JOB_STEP] [int] NULL,
    [JOB_MODULE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_RUN_NBR] [int] NULL,
    [SYSTEM_AREA] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SYSTEM_AREA_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PARM_NAME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PARM_DESCRIPTION] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PARM_LENGTH] [int] NULL,
    [RUN_NBR] [int] NULL,
    [RUN_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTED_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_STEP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_STEP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COPIES] [int] NULL,
    [AVAILABLE_IND] [bit] NULL,
    [DEFAULTS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINTER_ID] [varchar](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RUN_NOW_IND] [bit] NULL,
    [RESTARTABLE] [bit] NULL,
    [GROUPING_NAME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GROUPING_DESCRIPTION] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_PHONE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_PHONE_EXT] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_EMAIL] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESTART_JOB_NAME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESTART_STEP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESTART_KEY] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOB_NEEDS_SECURITY] [bit] NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_TIME] [varchar](7) 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 AVAILABLE_IND BATCH_JOB_NAME CONTACT_EMAIL CONTACT_NAME CONTACT_PHONE CONTACT_PHONE_EXT COPIES DEFAULTS_IND END_STEP GROUPING_DESCRIPTION GROUPING_NAME HOLD ISN_BATCH_A JOB_DESCRIPTION JOB_MODULE JOB_NAME JOB_NEEDS_SECURITY JOB_PARM_VALIDATION_SUBP JOB_PRIORITY JOB_PROCESS JOB_STEP MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PARM_DESCRIPTION PARM_NAME PRINTER_ID REQUESTED_DATE REQUESTED_TIME RESTART_JOB_NAME RESTART_KEY RESTART_STEP RESTARTABLE RowUpdatedOn RUN_NBR RUN_NOW_IND RUN_STATUS START_DATE START_STEP START_TIME SYSTEM_AREA SYSTEM_AREA_IND USER_ID USER_NAME
19971126 UTL865N1 1911418 ZSHOL false STS340J1 1 Y 1734435 2656 false 19971202 UTL865N1 1734435 ZSHOL PDFPRT false 2017-02-06T11:11:21.829-05:00 true STUDENT
20060308 UTL830N1 1329507 ZCPAT false STS266J6 1 EOJ 1329529 7716 false 50 REPORT 50 20060308 UTL830N1 1329529 ZCPAT FCCSCFTL 20060308 1329507 false 2017-02-06T11:11:22.438-05:00 3 false C 20060308 BOJ 1329517 STUDENT
20130311 UTL830N1 1126251 ZCMSW false PEJ365J1 1 EOJ 1127022 17236 false 20 UPDATE 1 20130311 UTL830N1 1127022 ZCMSW PDFPRT 20130311 1126251 false 2017-02-06T11:11:23.499-05:00 8 false C 20130311 BOJ 1126288 PERSPAYR
true PED281J1 8537 false 50 ON-RQST 50 false 2017-02-06T11:11:22.531-05:00 false PERTRAIN Y
20130116 UTL830N1 1402078 ZCEAL false FIC401J2 1 EOJ 1402301 26376 false 50 JOB 50 20130116 UTL830N1 1402301 ZCEAL PDFPRT 20130116 1402078 false 2017-02-06T11:11:24.544-05:00 935 false C 20130116 BOJ 1402117 ISFIN
20110517 UTL830N1 0614202 ZCMSW false PEP350J1 1 EOJ 644511 21945 false 1 REPORT 1 20110517 UTL830N1 0644511 ZCMSW PDFPRT 20110517 0614202 false 2017-02-06T11:11:24.045-05:00 35 false C 20110517 BOJ 0614232 PERPT
20060824 UTL830N1 1438316 ZCBHJ false UTL878J2 1 EOJ 1438344 841 false 50 ON-RQST 50 20060824 UTL830N1 1438344 ZCBHJ LOCAL 20060824 1438316 false 2017-02-06T11:11:21.595-05:00 617 false C 20060824 BOJ 1438333 ISFIN
20120612 UTL830N1 1446516 ZCBHJ false FIP610J1 1 EOJ 1447190 24669 false 50 REPORT 50 20120612 UTL830N1 1447190 ZCBHJ PDFPRT 20120612 1446516 false 2017-02-06T11:11:24.357-05:00 53 false C 20120612 BOJ 1446548 ISFIN
20160206 UTL830N1 0949432 ZCEAL false FIC939J2 1 EOJ 949521 31575 false 50 REPORT 50 20160206 UTL830N1 0949521 ZCEAL PDFPRT 20160206 0949432 false 2017-02-06T11:11:25.199-05:00 23 false C 20160206 BOJ 0949461 ISFIN
20120615 UTL830N1 1233138 ZCBHJ false FIA350J2 1 EOJ 1233356 24804 false 50 UPDATE 50 20120615 UTL830N1 1233356 ZCBHJ PDFPRT 20120615 1233138 false 2017-02-06T11:11:24.372-05:00 20 false C 20120615 BOJ 1233172 ISFIN
Powered by BI Documenter