|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | ST_STDNT_SPCL_DSGNTR_A |
| Schema | dbo |
| Row Count | 341637 |
| Data Size | 27464 KB |
| Index Size | 5128 KB |
| Create Date | 8/15/2012 2:10 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 |
|||
|
|
END_TERM |
varchar(6) |
True |
False |
False |
|||
|
|
HOLD |
int(10, 0) |
True |
False |
False |
|||
|
|
ISN_ST_STDNT_SPCL_DSGNTR_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 |
|||
|
|
SEQUENCE_NBR |
int(10, 0) |
True |
False |
False |
|||
|
|
SPCL_DSGNTR |
varchar(2) |
True |
False |
False |
|||
|
|
START_TERM |
varchar(6) |
True |
False |
False |
|||
|
|
STUDENT_ID |
varchar(9) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_ST_STDNT_SPCL_DSGNTR_A |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.ST_STDNT_SPCL_DSGNTR_A depends on)
| Name | Type |
StoredProcedure |
Child Dependencies (objects that depend on dbo.ST_STDNT_SPCL_DSGNTR_A)
| Name | Type |
STOREDPROCEDURE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[ST_STDNT_SPCL_DSGNTR_A] Script Date: 03/09/2017 16:46:29 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_STDNT_SPCL_DSGNTR_A]( [ISN_ST_STDNT_SPCL_DSGNTR_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, [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [START_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [END_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SPCL_DSGNTR] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SEQUENCE_NBR] [int] NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| ADD_DATE | ADD_PGM | ADD_TIME | ADD_USER_ID | END_TERM | HOLD | ISN_ST_STDNT_SPCL_DSGNTR_A | MAINT_DATE | MAINT_PGM | MAINT_TIME | MAINT_USER_ID | RowUpdatedOn | SEQUENCE_NBR | SPCL_DSGNTR | START_TERM | STUDENT_ID |
| 20091110 | STA025N0 | 1321540 | E000943 | 1321540 | 125915 | 2017-02-06T10:44:17.391-05:00 | 1 | W1 | 20102 | M13044649 | |||||
| 20130510 | STA025N0 | 1109114 | E087483 | 1109114 | 252537 | 2017-02-06T10:44:24.567-05:00 | 1 | WP | 20141 | N14457048 | |||||
| 20110817 | STA025N0 | 0906232 | E001772 | 906232 | 187522 | 2017-02-06T10:44:21.057-05:00 | 1 | W1 | 20122 | H07111859 | |||||
| 20100503 | STA025N0 | 1235058 | E057665 | 1235058 | 139940 | 2017-02-06T10:44:18.233-05:00 | 1 | AB | 20103 | M13480785 | |||||
| 20110414 | STA025N0 | 0846354 | E001772 | 20123 | 846354 | 172067 | 2017-02-06T10:44:20.137-05:00 | 1 | W1 | 20113 | J13828678 | ||||
| 20060214 | STA025N0 | 1529545 | WEB4 | 1529545 | 38744 | 2017-02-06T10:44:11.978-05:00 | 1 | FA | 19962 | J06864177 | |||||
| 20080711 | STA025N0 | 1214224 | E001772 | 1214224 | 86883 | 2017-02-06T10:44:14.911-05:00 | 1 | W1 | 20091 | R12972394 | |||||
| 20101208 | STA025N0 | 1039141 | E052673 | 1039141 | 161688 | 2017-02-06T10:44:19.528-05:00 | 1 | W5 | 20112 | A13731146 | |||||
| 20100208 | STA025N0 | 0914422 | E052673 | 20102 | 914422 | 105507 | 2017-02-06T10:44:16.112-05:00 | 1 | W1 | 20111 | D13462239 | ||||
| 20130314 | STA025N0 | 1225205 | E088028 | 1225205 | 243138 | 2017-02-06T10:44:24.099-05:00 | 1 | WP | 20141 | J14384945 |
| Powered by BI Documenter |
