DWStaging
 dbo.ST_EXTRNL_CRDNTL_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.ST_EXTRNL_CRDNTL_A
  Properties
Property Value
Name ST_EXTRNL_CRDNTL_A
Schema dbo
Row Count 1140889
Data Size 262024 KB
Index Size 17040 KB
Create Date 2/26/2016 9:04 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AA_OR_HIGHER_AWARD
varchar(1)
True
False
False
 
ACDMC_STAT_CD
varchar(2)
True
False
False
 
ACT_GRAD_DT
varchar(8)
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
 
APPEND
varchar(4)
True
False
False
 
CLS_STNDG
int(10, 0)
True
False
False
 
COLL_READY_DIPL_IND
varchar(1)
True
False
False
 
COMPL_CD
varchar(1)
True
False
False
 
CRDNTL_CD
varchar(2)
True
False
False
 
DIPL_TYPE
varchar(4)
True
False
False
 
DOB
varchar(8)
True
False
False
 
EVAL_CD
varchar(1)
True
False
False
 
EVAL_DT
varchar(8)
True
False
False
 
EXPCTD_GRAD_DT
varchar(8)
True
False
False
 
FORGN_TRNSCRPT_CD
varchar(1)
True
False
False
 
FRMR_LST_NM
varchar(35)
True
False
False
 
FRST_NM
varchar(20)
True
False
False
 
GED_STATE
varchar(2)
True
False
False
 
GEN_ED_STATUS_MANUAL
varchar(1)
True
False
False
 
GEN_ED_STATUS_RECEIVED
varchar(1)
True
False
False
 
GRAD_CLS_SIZE
int(10, 0)
True
False
False
 
HGHST_GRD_LVL
varchar(2)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HS_FORGN_LANG_REQ_MET
varchar(1)
True
False
False
 
HS_GPA_UNWTD
numeric(3, 2)
True
False
False
 
HS_GPA_WTD
numeric(3, 2)
True
False
False
 
HS_STDNT_ID
varchar(12)
True
False
False
 
INST_ID
varchar(8)
True
False
False
 
ISN_ST_EXTRNL_CRDNTL_A
int(10, 0)
False
False
False
 
LST_NM
varchar(35)
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
 
MDL_NM
varchar(20)
True
False
False
 
MRG_DT
varchar(8)
True
False
False
 
MRGD_TO_AH
varchar(1)
True
False
False
 
OFCL_CD
varchar(1)
True
False
False
 
PRIM_LANG
varchar(2)
True
False
False
 
RES_CODE
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
RQST_DT
varchar(8)
True
False
False
 
RQST_IND
varchar(1)
True
False
False
 
RQST_MODE
varchar(1)
True
False
False
 
RQST_STATUS
varchar(1)
True
False
False
 
SALUT
varchar(3)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
STMNT_RES_FLG
bit(1, 0)
True
False
False
 
TECH_PREP_PARTICIPANT
varchar(1)
True
False
False
 
TRANS_DT
varchar(8)
True
False
False
 
TRANS_MODE
varchar(2)
True
False
False
 
TRNSCRPT_NOTES_INST
varchar(8)
True
False
False
 
TRNSCRPT_NOTES_TERM
varchar(6)
True
False
False
 
WTHDRWL_DT
varchar(8)
True
False
False
 
YEAR_ENTERED_9TH_GRADE
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_EXTRNL_CRDNTL_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_EXTRNL_CRDNTL_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_EXTRNL_CRDNTL_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_EXTRNL_CRDNTL_A] Script Date: 03/09/2017 16:46:05 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_EXTRNL_CRDNTL_A](
    [ISN_ST_EXTRNL_CRDNTL_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,
    [ACDMC_STAT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACT_GRAD_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_STNDG] [int] NULL,
    [COMPL_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DIPL_TYPE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DOB] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVAL_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EVAL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXPCTD_GRAD_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FORGN_TRNSCRPT_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GED_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_CLS_SIZE] [int] NULL,
    [HGHST_GRD_LVL] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_STDNT_ID] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_GPA_UNWTD] [numeric](3, 2) NULL,
    [HS_GPA_WTD] [numeric](3, 2) NULL,
    [MRG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MRGD_TO_AH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OFCL_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIM_LANG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_MODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RQST_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STMNT_RES_FLG] [bit] NULL,
    [LST_NM] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FRST_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MDL_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPEND] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALUT] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FRMR_LST_NM] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANS_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANS_MODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WTHDRWL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [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,
    [COLL_READY_DIPL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCRPT_NOTES_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCRPT_NOTES_INST] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AA_OR_HIGHER_AWARD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TECH_PREP_PARTICIPANT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_FORGN_LANG_REQ_MET] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GEN_ED_STATUS_RECEIVED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GEN_ED_STATUS_MANUAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [YEAR_ENTERED_9TH_GRADE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
  Sample Data
AA_OR_HIGHER_AWARD ACDMC_STAT_CD ACT_GRAD_DT ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID APPEND CLS_STNDG COLL_READY_DIPL_IND COMPL_CD CRDNTL_CD DIPL_TYPE DOB EVAL_CD EVAL_DT EXPCTD_GRAD_DT FORGN_TRNSCRPT_CD FRMR_LST_NM FRST_NM GED_STATE GEN_ED_STATUS_MANUAL GEN_ED_STATUS_RECEIVED GRAD_CLS_SIZE HGHST_GRD_LVL HOLD HS_FORGN_LANG_REQ_MET HS_GPA_UNWTD HS_GPA_WTD HS_STDNT_ID INST_ID ISN_ST_EXTRNL_CRDNTL_A LST_NM MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MDL_NM MRG_DT MRGD_TO_AH OFCL_CD PRIM_LANG RES_CODE RowUpdatedOn RQST_DT RQST_IND RQST_MODE RQST_STATUS SALUT STDNT_ID STMNT_RES_FLG TECH_PREP_PARTICIPANT TRANS_DT TRANS_MODE TRNSCRPT_NOTES_INST TRNSCRPT_NOTES_TERM WTHDRWL_DT YEAR_ENTERED_9TH_GRADE
20080806 STA040N0 2244018 FACTS1 Y PC 10071988 Y 20080811 AMBER 813494 001500 739150 SCOTT 20080811 STA040N0 0813494 E009586 MICHELLE 20080811 M Y Y 2017-02-06T10:08:18.244-05:00 20080808 A E A13001672 false 20080808 E
19940901 20150602 STA040N0 1120152 OPER2 Y HC W10 19760710 Y 20150602 KERRY FL 1120152 XX0033 1070648 DORSEY MATTHEW N Y EN 2017-02-06T10:08:59.49-05:00 19320101 I N K06933865 false 19950516 P
20151014 STA040N0 1651060 E005859 Y PC Y 20160622 1514525 GB1050 1088639 20160622 STA040N0 1514525 E015802 20160622 M Y 2017-02-06T10:09:01.752-05:00 20151014 I N N14888242 false 20151110 P
20080606 20090413 STA040N0 0827426 E000943 52 Y HC W06 19900605 Y 20090714 DAVID 361 12 1826337 3.40 3.70 101818 767779 DOPICO 20090714 STA040N0 1826337 OPER2 IBRAHIM N Y 2017-02-06T10:08:21.676-05:00 20090714 A N D13181417 false 20090714 E 20080606
19610531 20010626 STA040N0 0951212 PSOUZA Y HC W06 Y 20010702 1317198 FL1040 436227 20010702 STA040N0 1317197 SLAMIE N Y 2017-02-06T10:07:40.757-05:00 20010626 A N P10222826 false 20010702 P
19990307 STA040N0 0046050 OPERTNS N HC 19480813 N RICHARD 46050 ZZ9996 184801 FORD LEWIS N N 2017-02-06T10:07:08.964-05:00 19320101 A P R09982315 false
19990307 STA040N0 0202144 OPERTNS N HC 19411001 N JOHN 202145 ZZ9996 250561 WHITTEMORE HOWAR N N 2017-02-06T10:07:17.294-05:00 19320101 A P J10955755 false
19920601 19990306 STA040N0 2217435 OPERTNS Y HC W06 19730219 N ALBERT 2217435 101818 70558 GONZALEZ I N Y 2017-02-06T10:06:54.861-05:00 19320101 A P A07536675 false 19930824 P
20090709 STA040N0 1618253 E042646 Y PC Y 20090715 1050220 ZZ9996 776178 20090715 STA040N0 1050220 E027927 N Y 2017-02-06T10:08:22.627-05:00 20090709 I N L13291620 false 20090715 E
19990307 STA040N0 0205148 OPERTNS N HC 19540730 N ANDREW 205148 101818 253182 BENOIST EUGENE N N 2017-02-06T10:07:17.622-05:00 19320101 A P A10991610 false
Powered by BI Documenter