DWStaging
 dbo.ST_STDNT_OBJ_AWD_LOG_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_LOG_A
  Properties
Property Value
Name ST_STDNT_OBJ_AWD_LOG_A
Schema dbo
Row Count 4007960
Data Size 1365496 KB
Index Size 59776 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_LOG_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
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
varchar(8)
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_LOG_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_LOG_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_STDNT_OBJ_AWD_LOG_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_OBJ_AWD_LOG_A] Script Date: 03/09/2017 16:46:28 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_OBJ_AWD_LOG_A](
    [ISN_ST_STDNT_OBJ_AWD_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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_LOG_A LA_ACKNLDG_DT LA_APPL_DT LA_APPL_TRM LA_BAS_ADM LA_LST_TRM_ATND LA_STAT LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NEW_ADDR_CD PGM_CHNG_DT PGM_GPA PGM_GPA_HRS PGM_GRD_PTS PGM_HRS_ATT PGM_HRS_ERN 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
20140822 STA710N0 0956220 WEB5 Y false TC false 20151 ALLEN LINDSEY E false A 956220 2913275 A 20140822 <notty> 956220 ROOT false 20140822 6159 AC true 2017-02-06T09:15:29.801-05:00 1 L11997202
20040831 STA710N0 1028595 E000943 Y false AA false 20051 MILIAN THAIS false A 1028595 521644 A 20040831 0100 1028594 E000943 false 20040831 1000 AC true 2017-02-06T09:09:29.673-05:00 1 T11431889
20150818 STA710N0 1154126 E062722 N false BAS false 20162 PARRIS HAYLEY J false A 1505049 3330144 20150818 20162 TC 20153 PRE M 20150911 pts/201 1505049 E062722 20150911 STA710N0 1505049 E062722 false 20150911 3.94 51.00 201.00 54.00 51.00 T702A IN false 2017-02-06T09:16:40.454-05:00 1 H14919567
20151211 STA710N0 1130024 E062722 Y false BAS false 20162 READ JONAS M false A 909484 4001136 20151211 20162 TR 20151 BASU M 20170107 <notty> 2044099 OPER1 20160104 STA710N0 0909484 E062722 false 20151211 3.21 84.00 270.00 87.00 84.00 T705A AC true 2017-02-06T09:18:26.207-05:00 1 J12276408
20090722 STA710N0 1622389 FACTS1 Y false ND false 20101 EVERINGHAM KATHLEEN S false A 1622389 1549328 A 20090722 <notty> 1622389 ROOT false 20090722 3408 AC true 2017-02-06T09:11:58.373-05:00 1 K13309224
20101103 STA710N0 0847094 E003231 Y true VC false 20112 HILL CONSUELO D false A 856208 1830961 20101116 M 20101116 pts/101 856208 E025953 20101116 STA710N0 0856208 E025953 false 20101103 5601 AC true 2017-02-06T09:12:41.569-05:00 1 C06952907
20111028 STA710N0 1130218 E062722 Y false BAS false 20122 HASKO RYAN J false A 926431 2695210 20111026 20122 HR 20083 BASU M 20140103 <notty> 1743139 WEB5 20120103 STA710N0 0926431 E062722 false 20111028 3.12 112.00 350.00 141.00 112.00 T701A AC true 2017-02-06T09:14:55.106-05:00 2 R07976020
20141126 STA710N0 1354056 E062722 N false BAS false 20152 LEVY MICHELLE A false A 1354233 3008898 20141126 20152 TR 20131 INCP M 20141126 pts/230 1354233 E062722 20141126 STA710N0 1354233 E062722 false 20141126 T704A AC true 2017-02-06T09:15:45.791-05:00 1 M12696613
20091219 STA710N0 1331149 FACTS1 Y false AA false 20102 ARMSTRONG BRANDON S false A 1331149 1627440 A 20091219 <notty> 1331144 ROOT false 20091219 1000 AC true 2017-02-06T09:12:09.792-05:00 1 B13427653
20140708 STA710N0 1451009 WEB5 Y false AA false 20151 CUMMINGS LEO false A 1349515 3804037 M 20160819 <notty> 1349515 STUDENT 20160819 STA710N0 1349515 STUDENT false 20140708 1000 AC true 2017-02-06T09:17:55.615-05:00 1 L14819650 IN0001 140901
Powered by BI Documenter