|
![]() |
Property | Value |
Name | ST_STDNT_TEST_DEMO_A |
Schema | dbo |
Row Count | 2847292 |
Data Size | 281424 KB |
Index Size | 42480 KB |
Create Date | 8/15/2012 2:10 PM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
ACTIVE_1_IND |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
ACTIVE_2_IND |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
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 |
|||
![]() |
![]() |
EFF_TRM |
varchar(6) |
True |
False |
False |
|||
![]() |
![]() |
HOLD |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
INIT_STATUS_IND |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
ISN_ST_STDNT_TEST_DEMO_A |
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 |
|||
![]() |
![]() |
PGM_ID |
varchar(5) |
True |
False |
False |
|||
![]() |
![]() |
PLACEMENT_AREA |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
![]() |
![]() |
STATUS_IND |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
STDNT_ID |
varchar(9) |
True |
False |
False |
|||
![]() |
![]() |
TABE_EXMPTN_IND |
varchar(1) |
True |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_ST_STDNT_TEST_DEMO_A |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
Name | Type |
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[ST_STDNT_TEST_DEMO_A] Script Date: 03/09/2017 16:46:29 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_STDNT_TEST_DEMO_A]( [ISN_ST_STDNT_TEST_DEMO_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, [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PLACEMENT_AREA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STATUS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ACTIVE_1_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ACTIVE_2_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TABE_EXMPTN_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [INIT_STATUS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
ACTIVE_1_IND | ACTIVE_2_IND | ADD_DATE | ADD_PGM | ADD_TIME | ADD_USER_ID | EFF_TRM | HOLD | INIT_STATUS_IND | ISN_ST_STDNT_TEST_DEMO_A | MAINT_DATE | MAINT_PGM | MAINT_TIME | MAINT_USER_ID | PGM_ID | PLACEMENT_AREA | RowUpdatedOn | STATUS_IND | STDNT_ID | TABE_EXMPTN_IND |
A | I | 19990306 | STS272N0 | 1807507 | OPERTNS | 258250 | U | 1076538 | 20040401 | STS272N0 | 0258250 | OPER2 | ENG | 2017-02-06T09:30:06.979-05:00 | U | R10419166 | |||
I | I | 20160414 | STS272N0 | 1721360 | SAG | 1959505 | T | 2179387 | 20160804 | STS272N0 | 1959505 | OPER1 | REA | 2017-02-06T09:31:18.505-05:00 | T | N13264817 | |||
I | F | 20090120 | STS272N0 | 1741279 | FACTS1 | 255320 | C | 2115550 | 20140507 | STS272N0 | 0255320 | OPER2 | ENG | 2017-02-06T09:31:14.2-05:00 | C | C13119623 | |||
A | I | 19990306 | STS272N0 | 1626260 | OPERTNS | 1626260 | U | 1001622 | MAT | 2017-02-06T09:30:02.33-05:00 | U | T10113652 | |||||||
I | I | 20151222 | STS272N0 | 1115455 | OPER1 | 832193 | T | 2723984 | 20160630 | STS272N0 | 0832193 | OPER1 | MAT | 2017-02-06T09:31:54.401-05:00 | T | K14977110 | |||
A | I | 20140909 | STS272N0 | 0336084 | WEB8 | 225365 | U | 2652156 | 20160107 | STS272N0 | 0225365 | WEB5 | ENG | 2017-02-06T09:31:49.893-05:00 | U | D14864011 | |||
A | I | 19990306 | STS272N0 | 0617206 | OPERTNS | 617206 | U | 511405 | REA | 2017-02-06T09:29:31.536-05:00 | U | W08166662 | |||||||
A | I | 19990306 | STS272N0 | 0202246 | OPERTNS | 257032 | T | 262893 | 20020718 | STS272N0 | 0257032 | OPER2 | ENG | 2017-02-06T09:29:16.013-05:00 | T | S07135528 | |||
A | I | 20000502 | STS272N0 | 1652424 | IVOWELL | 2315324 | U | 1386953 | 20000811 | STS272N0 | 2315324 | OPER2 | ENG | 2017-02-06T09:30:27.025-05:00 | U | L09884974 | |||
A | I | 19990306 | STS272N0 | 1204585 | OPERTNS | 1907448 | U | 805751 | 20000609 | STS272N0 | 1907448 | OPER2 | ENG | 2017-02-06T09:29:49.741-05:00 | U | K09329905 |
Powered by BI Documenter |