DWStaging
 dbo.ST_STDNT_OBJ_AWD_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_STDNT_OBJ_AWD_A
  Properties
Property Value
Name ST_STDNT_OBJ_AWD_A
Schema dbo
Row Count 1631584
Data Size 457096 KB
Index Size 24368 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
ACT_GRAD_DT
varchar(8)
True
False
False
 
ACT_GRAD_TRM
varchar(6)
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
 
ADDR_CD
varchar(2)
True
False
False
 
ADMT_STAT
varchar(1)
True
False
False
 
ADV_FOR_OBJ
bit(1, 0)
True
False
False
 
APPL_DCLN_DT
varchar(8)
True
False
False
 
AWD_MAIL_DT
varchar(8)
True
False
False
 
AWD_ORDR_DT
varchar(8)
True
False
False
 
AWD_RECV_DT
varchar(8)
True
False
False
 
AWD_TYPE
varchar(3)
True
False
False
 
CAMP
varchar(1)
True
False
False
 
COMNCMNT
bit(1, 0)
True
False
False
 
CUM_CRED_HRS
numeric(5, 2)
True
False
False
 
EFF_TERM
varchar(6)
True
False
False
 
EXPCTD_GRAD_TRM
varchar(6)
True
False
False
 
FRMTD_NM
varchar(60)
True
False
False
 
GPA
numeric(3, 2)
True
False
False
 
GRAD_APPL_DT
varchar(8)
True
False
False
 
GRAD_AUTH_BY
varchar(9)
True
False
False
 
GRAD_AUTH_DT
varchar(8)
True
False
False
 
GRAD_AUTH_USER_ID
varchar(8)
True
False
False
 
GRAD_COMPL_DT
varchar(8)
True
False
False
 
GRAD_FEE_FLG
bit(1, 0)
True
False
False
 
GRAD_HNRS
varchar(2)
True
False
False
 
GRAD_RVW_DT
varchar(8)
True
False
False
 
GRAD_STAT
varchar(2)
True
False
False
 
GRP_ID
varchar(6)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_STDNT_OBJ_AWD_A
int(10, 0)
False
False
False
 
LA_ACKNLDG_DT
varchar(8)
True
False
False
 
LA_APPL_DT
varchar(8)
True
False
False
 
LA_APPL_TRM
varchar(6)
True
False
False
 
LA_BAS_ADM
varchar(2)
True
False
False
 
LA_LST_TRM_ATND
varchar(6)
True
False
False
 
LA_STAT
varchar(4)
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
 
NEW_ADDR_CD
bit(1, 0)
True
False
False
 
PGM_CHNG_DT
varchar(8)
True
False
False
 
PGM_GPA
numeric(4, 2)
True
False
False
 
PGM_GPA_HRS
numeric(5, 2)
True
False
False
 
PGM_GRD_PTS
numeric(7, 2)
True
False
False
 
PGM_HRS_ATT
numeric(5, 2)
True
False
False
 
PGM_HRS_ERN
numeric(5, 2)
True
False
False
 
PGM_ID
varchar(5)
True
False
False
 
PGM_STAT
varchar(2)
True
False
False
 
PRIM_FLG
bit(1, 0)
True
False
False
 
PRNTD_APPEND
varchar(4)
True
False
False
 
PRNTD_FRST_NM
varchar(25)
True
False
False
 
PRNTD_LST_NM
varchar(40)
True
False
False
 
PRNTD_MDL_NM
varchar(20)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SEQ_NUM
int(10, 0)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
TRM_YR_RPTD
varchar(6)
True
False
False
 
TRNSFR_INST
varchar(8)
True
False
False
 
TRNSFR_MJR
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_OBJ_AWD_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_OBJ_AWD_A depends on)
Name Type
View
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_STDNT_OBJ_AWD_A)
Name Type
VIEW
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_OBJ_AWD_A] Script Date: 03/09/2017 16:46:27 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_OBJ_AWD_A](
    [ISN_ST_STDNT_OBJ_AWD_A] [int] NOT NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEQ_NUM] [int] NULL,
    [FRMTD_NM] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADMT_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWD_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIM_FLG] [bit] NULL,
    [ADV_FOR_OBJ] [bit] NULL,
    [GRP_ID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_STAT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_CHNG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_AUTH_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_RVW_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_STAT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_APPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_COMPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXPCTD_GRAD_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACT_GRAD_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACT_GRAD_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_HNRS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_AUTH_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_AUTH_BY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWD_ORDR_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWD_RECV_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWD_MAIL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRNTD_LST_NM] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRNTD_FRST_NM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NEW_ADDR_CD] [bit] NULL,
    [COMNCMNT] [bit] NULL,
    [CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_FEE_FLG] [bit] NULL,
    [GPA] [numeric](3, 2) NULL,
    [CUM_CRED_HRS] [numeric](5, 2) NULL,
    [APPL_DCLN_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [PGM_GPA] [numeric](4, 2) NULL,
    [PGM_GRD_PTS] [numeric](7, 2) NULL,
    [PGM_HRS_ERN] [numeric](5, 2) NULL,
    [PGM_HRS_ATT] [numeric](5, 2) NULL,
    [PGM_GPA_HRS] [numeric](5, 2) NULL,
    [TRNSFR_MJR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSFR_INST] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_YR_RPTD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_STAT] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_APPL_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_APPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_BAS_ADM] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_ACKNLDG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_LST_TRM_ATND] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRNTD_MDL_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRNTD_APPEND] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
  Sample Data
ACT_GRAD_DT ACT_GRAD_TRM ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADDR_CD ADMT_STAT ADV_FOR_OBJ APPL_DCLN_DT AWD_MAIL_DT AWD_ORDR_DT AWD_RECV_DT AWD_TYPE CAMP COMNCMNT EFF_TERM EXPCTD_GRAD_TRM FRMTD_NM GRAD_APPL_DT GRAD_AUTH_BY GRAD_AUTH_DT GRAD_AUTH_USER_ID GRAD_COMPL_DT GRAD_FEE_FLG GRAD_HNRS GRAD_RVW_DT GRAD_STAT GRP_ID HOLD ISN_ST_STDNT_OBJ_AWD_A LA_ACKNLDG_DT LA_APPL_DT LA_APPL_TRM LA_BAS_ADM LA_LST_TRM_ATND LA_STAT MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NEW_ADDR_CD PGM_CHNG_DT PGM_ID PGM_STAT PRIM_FLG PRNTD_APPEND PRNTD_FRST_NM PRNTD_LST_NM PRNTD_MDL_NM RowUpdatedOn SEQ_NUM STDNT_ID TRM_YR_RPTD TRNSFR_INST TRNSFR_MJR
20150909 STA710N0 1940415 WEB5 Y false VC false 20161 USHER BRETT false A 941235 1423216 20150910 20150910 STA710N0 0941235 E090506 false 20150909 5266 AC true 2017-02-06T09:35:52.287-05:00 1 B12700043
19990307 STA710N0 2257342 OPERTNS Y false NC false 19962 KANE SUSAN false A 2257342 550415 false 19990307 8381 AC true 2017-02-06T09:33:35.552-05:00 1 S06964290
20081103 STA710N0 1444185 FACTS1 Y false AA false 20092 MOORE LEAH A false A 1444185 989380 false 20081103 1000 AC true 2017-02-06T09:34:44.13-05:00 1 L13059027
19990307 STA710N0 2330054 OPERTNS Y false NC false 19941 MILLER JUAN M false A 2330054 593788 false 19990307 8381 AC true 2017-02-06T09:33:41.902-05:00 1 J07250350
19990307 STA710N0 2216580 OPERTNS Y false NC false 19864 SMITH JERRY H false A 2216580 516005 false 19990307 8381 AC true 2017-02-06T09:33:30.404-05:00 1 J08855280
20160825 STA710N0 0957571 WEB9 Y false NC false 20171 THURLLER CAROLINA false A 957571 1604793 false 20160825 8384 AC false 2017-02-06T09:36:24.299-05:00 1 C15420821
20130427 STA710N0 1144461 WEB5 Y false AA false 20133 LIPNICK TAYLOR A false A 1144461 1332012 false 20130427 1000 AC true 2017-02-06T09:35:37.171-05:00 1 T14442073
20121107 STA710N0 1606039 WEB5 Y false AS false 20132 ADAMS ETHAN F false A 1606039 1295087 false 20121107 2126 AC true 2017-02-06T09:35:31.087-05:00 1 E14301170
19990307 STA710N0 1921101 OPERTNS Y false AS false 19722 PRINCE JOHN E false A 1921101 372744 false 19990307 2198 AC true 2017-02-06T09:33:08.861-05:00 1 J10610889
19990308 STA710N0 1039324 DWORKMN Y false AS false 19861 VOLLENDORF STEVEN E false A 1039324 706514 false 19990308 2050 AC true 2017-02-06T09:33:58.438-05:00 1 S09000670
Powered by BI Documenter