|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | ST_EXTRNL_CRS_A |
| Schema | dbo |
| Row Count | 9763140 |
| Data Size | 917232 KB |
| Index Size | 145528 KB |
| Create Date | 8/15/2012 1:36 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ACCEL_SCR |
varchar(3) |
True |
False |
False |
|||
|
|
COMPL_DT |
varchar(8) |
True |
False |
False |
|||
|
|
CRDNTL_CD |
varchar(2) |
True |
False |
False |
|||
|
|
CRS_EQUIV |
varchar(10) |
True |
False |
False |
|||
|
|
CRS_LVL |
varchar(2) |
True |
False |
False |
|||
|
|
CRS_MRG_ACAD_HIST |
varchar(1) |
True |
False |
False |
|||
|
|
CRS_MRG_DT |
varchar(8) |
True |
False |
False |
|||
|
|
CRS_TTL |
varchar(20) |
True |
False |
False |
|||
|
|
EVAL_CRED_HRS |
numeric(17, 2) |
True |
False |
False |
|||
|
|
EXTRNL_CRED_HRS |
numeric(17, 2) |
True |
False |
False |
|||
|
|
GRADE |
varchar(2) |
True |
False |
False |
|||
|
|
GRADE_LVL |
varchar(2) |
True |
False |
False |
|||
|
|
HRS_CD |
varchar(2) |
True |
False |
False |
|||
|
|
INST_ID |
varchar(8) |
True |
False |
False |
|||
|
|
ISN_ST_EXTRNL_CRS_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RECV_DT |
varchar(8) |
True |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
SEQ_NUM |
int(10, 0) |
True |
False |
False |
|||
|
|
STDNT_ID |
varchar(9) |
True |
False |
False |
|||
|
|
TRM_CRS_ID |
varchar(16) |
True |
False |
False |
|||
|
|
TRMNT_RPT_CD |
varchar(2) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_ST_EXTRNL_CRS_A |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.ST_EXTRNL_CRS_A depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.ST_EXTRNL_CRS_A)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[ST_EXTRNL_CRS_A] Script Date: 03/09/2017 16:46:06 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_EXTRNL_CRS_A]( [ISN_ST_EXTRNL_CRS_A] [int] NOT NULL, [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRDNTL_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [INST_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TRM_CRS_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SEQ_NUM] [int] NULL, [ACCEL_SCR] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [COMPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRS_EQUIV] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRS_LVL] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRS_MRG_ACAD_HIST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRS_MRG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRS_TTL] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EVAL_CRED_HRS] [numeric](17, 2) NULL, [EXTRNL_CRED_HRS] [numeric](17, 2) NULL, [GRADE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [GRADE_LVL] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HRS_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RECV_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TRMNT_RPT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| ACCEL_SCR | COMPL_DT | CRDNTL_CD | CRS_EQUIV | CRS_LVL | CRS_MRG_ACAD_HIST | CRS_MRG_DT | CRS_TTL | EVAL_CRED_HRS | EXTRNL_CRED_HRS | GRADE | GRADE_LVL | HRS_CD | INST_ID | ISN_ST_EXTRNL_CRS_A | RECV_DT | RowUpdatedOn | SEQ_NUM | STDNT_ID | TRM_CRS_ID | TRMNT_RPT_CD |
| HC | M/J CIVICS & CAR PL | B | 100915 | 8643518 | 20150731 | 2017-02-06T10:02:24.558-05:00 | 37 | J15103740 | 20103 2106016 | |||||||||||
| HC | EMERGENT COMPU TECH | 0.50 | 0.50 | A | 100913 | 2443962 | 20051202 | 2017-02-06T09:54:50.58-05:00 | 25 | K12207353 | 20001 0200360 | |||||||||
| HC | M/J MATH 1 | A | 101466 | 1399272 | 20040414 | 2017-02-06T09:53:41.643-05:00 | 14 | B08653768 | 19973 1205010 | |||||||||||
| HC | M/J ART/ART APPREC 1 | A | 101844 | 5835060 | 20110630 | 2017-02-06T09:58:56.687-05:00 | 7 | A13911904 | 20051 0100000 | |||||||||||
| HC | ENG 1 | 0.50 | 0.50 | D | 101341 | 8549284 | 20150623 | 2017-02-06T10:02:17.881-05:00 | 49 | T12925178 | 20121 1001310 | |||||||||
| HC | WORLD HIST | 0.50 | 0.50 | A | 100915 | 9450075 | 20160706 | 2017-02-06T10:03:20.672-05:00 | 25 | S15369721 | 20141 2109310 | |||||||||
| HC | ENG II | 0.50 | 0.50 | B | 100913 | 2986763 | 20061117 | 2017-02-06T09:55:29.268-05:00 | 54 | J12469003 | 20041 1001340 | |||||||||
| HC | ADV PL US GOVT/POL | 0.50 | 0.50 | C | 101493 | 4566444 | 20090727 | 2017-02-06T09:57:20.403-05:00 | 76 | R12953113 | 20082 2106420 | |||||||||
| HC | EARLY CHILD 1 NEW | 0.50 | 0.50 | A | 100825 | 9433153 | 20160629 | 2017-02-06T10:03:19.486-05:00 | 22 | O15345978 | 20142 8405110 | |||||||||
| HC | ADV PL HUMAN GEOG | 0.50 | 0.50 | B | 101822 | 9550239 | 20160809 | 2017-02-06T10:03:27.848-05:00 | 73 | A13521927 | 20132 2103400 |
| Powered by BI Documenter |
