|
![]() |
Property | Value |
Name | ST_OVRD_A |
Schema | dbo |
Row Count | 1515196 |
Data Size | 159960 KB |
Index Size | 22656 KB |
Create Date | 8/15/2012 1:36 PM |
Description |
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 |
|||
![]() |
![]() |
CLS_REF_NUM |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
CRS_DSTNC_LRN_IND |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
CRS_ID |
varchar(10) |
True |
False |
False |
|||
![]() |
![]() |
DATE_EXPIRED |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
EFF_TRM |
varchar(6) |
True |
False |
False |
|||
![]() |
![]() |
HOLD |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
HOLD_TY |
varchar(4) |
True |
False |
False |
|||
![]() |
![]() |
INIT_DT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
INIT_SSN |
varchar(9) |
True |
False |
False |
|||
![]() |
![]() |
ISN_ST_OVRD_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 |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
![]() |
![]() |
SEQ_NO |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
STUDENT_ID |
varchar(9) |
True |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_ST_OVRD_A |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[ST_OVRD_A] Script Date: 03/09/2017 16:46:12 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_OVRD_A]( [ISN_ST_OVRD_A] [int] NOT NULL, [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HOLD_TY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [INIT_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [INIT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DATE_EXPIRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CLS_REF_NUM] [int] NULL, [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CAMP_CNTR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SEQ_NO] [int] 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, [CRS_DSTNC_LRN_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
ADD_DATE | ADD_PGM | ADD_TIME | ADD_USER_ID | CAMP_CNTR | CLS_REF_NUM | CRS_DSTNC_LRN_IND | CRS_ID | DATE_EXPIRED | EFF_TRM | HOLD | HOLD_TY | INIT_DT | INIT_SSN | ISN_ST_OVRD_A | MAINT_DATE | MAINT_PGM | MAINT_TIME | MAINT_USER_ID | RowUpdatedOn | SEQ_NO | STUDENT_ID |
20010405 | STA041N1 | 1738023 | PSTEEN | 24423 | BSC1086L | 20012 | 1738023 | 1056 | 20010405 | PSTEEN | 162610 | 2017-02-06T10:24:30.083-05:00 | 2 | T06174551 | |||||||
20080826 | STA041N1 | 1617426 | E062497 | 2 | MCB2010L | 20091 | 1617426 | 1030 | 20080826 | E062497 | 872840 | 2017-02-06T10:25:23.872-05:00 | 1 | S06367320 | |||||||
20040830 | STA041N1 | 1158408 | E023997 | 1 | BCV0942 R | 20040829 | 20051 | 1158408 | 1139 | 20040830 | E023997 | 512217 | 2017-02-06T10:24:56.556-05:00 | 2 | G11291275 | ||||||
20040426 | STA041N1 | 1521424 | E019847 | 2 | 20043 | 1521424 | ZO | 20040426 | E019847 | 469758 | 2017-02-06T10:24:53.358-05:00 | 1 | R06947691 | ||||||||
20050315 | STA052N1 | 0920233 | E005859 | 2 | HSC1000L | 20053 | 1044 | 20050315 | E005859 | 558705 | 20050315 | STA052N1 | 0920487 | E005859 | 2017-02-06T10:25:00.207-05:00 | 2 | L11880721 | ||||
20110728 | STA041N1 | 1400584 | E006160 | 5 | 20110727 | 20121 | 1400584 | ZQ | 20110728 | E006160 | 1133146 | 2017-02-06T10:25:43.981-05:00 | 1 | S13584347 | |||||||
20060323 | STA052N1 | 1558566 | E015802 | 1 | BSC1085 | 20063 | 805096 | TRAN | 20060323 | E015802 | 653479 | 2017-02-06T10:25:07.539-05:00 | 1 | R11547288 | |||||||
20120807 | STA052N1 | 1251383 | E082925 | HUN1201 | 20131 | 1438316 | DUAL | 20120807 | E082925 | 1204183 | 2017-02-06T10:25:49.425-05:00 | 1 | R13616800 | ||||||||
20070625 | STA041N1 | 1113222 | E003003 | 1 | POO0326 | 20073 | 1113222 | 1082 | 20070625 | E003003 | 765441 | 2017-02-06T10:25:16.119-05:00 | 1 | D07779671 | |||||||
1 | 19993 | RH | 19990624 | BGRAY | 11351 | 2017-02-06T10:24:19.194-05:00 | 1 | M11046646 |
Powered by BI Documenter |