DWStaging
 dbo.ST_STDNT_TERM_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_TERM_A
  Properties
Property Value
Name ST_STDNT_TERM_A
Schema dbo
Row Count 4993016
Data Size 1358816 KB
Index Size 74520 KB
Create Date 2/2/2017 2:14 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACDMC_STAT_CD
varchar(2)
True
False
False
 
ACDMC_STAT_CD_HS
varchar(2)
True
False
False
 
ACDMC_STAT_CD_VC
varchar(2)
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
 
ADDRESS_VERIF_IND
varchar(1)
True
False
False
 
CAMP
varchar(1)
True
False
False
 
CRED_RGSTRTN_APPT_DT
varchar(8)
True
False
False
 
CRED_RGSTRTN_APPT_TM
varchar(7)
True
False
False
 
CVRG_FLG
varchar(1)
True
False
False
 
DISPLACED_HOMEMAKER
varchar(1)
True
False
False
 
EARNED_HRS
numeric(6, 2)
True
False
False
 
EFF_TRM_9S_COMP
varchar(6)
True
False
False
 
EMPLOYMENT_BARRIER
varchar(1)
True
False
False
 
EMPLOYMENT_STATUS
varchar(1)
True
False
False
 
ENRLMNT_CD
varchar(2)
True
False
False
 
EX_OFFENDER
varchar(1)
True
False
False
 
FA_GPA
numeric(3, 2)
True
False
False
 
FA_SOAP_STATUS
varchar(2)
True
False
False
 
FA_STANDARD
varchar(2)
True
False
False
 
FLORIDA_PREPAID_AVAIL
varchar(1)
True
False
False
 
FLORIDA_PREPAID_REVIEWED
varchar(1)
True
False
False
 
GPA
numeric(4, 2)
True
False
False
 
GPA_HRS
numeric(5, 2)
True
False
False
 
GRAD_STATUS_UPDATE_IND
varchar(1)
True
False
False
 
GRD_PTS
numeric(5, 2)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOMELESS_RUNAWAY
varchar(1)
True
False
False
 
HRS_ATT
numeric(5, 2)
True
False
False
 
HRS_ERN
numeric(5, 2)
True
False
False
 
IMMIG_STAT
varchar(2)
True
False
False
 
ISN_ST_STDNT_TERM_A
int(10, 0)
False
False
False
 
LATE_FEE_EXMPTN
varchar(1)
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
 
MIGRANT_WORKER
varchar(1)
True
False
False
 
MILITARY_STATUS
varchar(1)
True
False
False
 
MILITARY_STATUS_REVIEWED
varchar(1)
True
False
False
 
NTFY_DISAB_FLG
bit(1, 0)
True
False
False
 
OTHER_RGSTRTN_APPT_DT
varchar(8)
True
False
False
 
OTHER_RGSTRTN_APPT_TM
varchar(7)
True
False
False
 
PCT_ATT_COMPL
numeric(5, 2)
True
False
False
 
PGM_CHNG_DT
varchar(8)
True
False
False
 
PGM_ID
varchar(5)
True
False
False
 
PGM_OF_STUDY_VERIF
varchar(1)
True
False
False
 
POLICY_PAGE_IND
varchar(1)
True
False
False
 
PRG_HRS
numeric(6, 2)
True
False
False
 
PYMT_DUE_DT_CRED
varchar(8)
True
False
False
 
PYMT_DUE_DT_CRED_EXT
varchar(8)
True
False
False
 
PYMT_DUE_DT_NCRED
varchar(8)
True
False
False
 
PYMT_DUE_DT_NONCRED_EXT
varchar(8)
True
False
False
 
RECALC_FLG
varchar(1)
True
False
False
 
REGULAR_HRS_ATT
numeric(6, 2)
True
False
False
 
REMEDIAL_HRS_ATT
numeric(6, 2)
True
False
False
 
RES_CD
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
RULE_150
numeric(5, 2)
True
False
False
 
SCHD_CHG_RSN
varchar(2)
True
False
False
 
SCHD_PRN_FLG
varchar(1)
True
False
False
 
SINGLE_PARENT
varchar(1)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
TRM_YR
varchar(6)
True
False
False
 
USER_WHO_EXT_CRED
varchar(8)
True
False
False
 
USER_WHO_EXT_NONCRED
varchar(8)
True
False
False
 
VOC_HRS_ATT
numeric(6, 2)
True
False
False
 
WITHDRAWAL_REASON
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_TERM_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_TERM_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_STDNT_TERM_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_TERM_A] Script Date: 03/09/2017 16:46:29 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_TERM_A](
    [ISN_ST_STDNT_TERM_A] [int] NOT NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACDMC_STAT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRED_RGSTRTN_APPT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRED_RGSTRTN_APPT_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CVRG_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRLMNT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [IMMIG_STAT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LATE_FEE_EXMPTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NTFY_DISAB_FLG] [bit] NULL,
    [OTHER_RGSTRTN_APPT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OTHER_RGSTRTN_APPT_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PYMT_DUE_DT_CRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PYMT_DUE_DT_CRED_EXT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PYMT_DUE_DT_NCRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PYMT_DUE_DT_NONCRED_EXT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECALC_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHD_CHG_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHD_PRN_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_WHO_EXT_CRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_WHO_EXT_NONCRED] [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,
    [GPA] [numeric](4, 2) NULL,
    [GRD_PTS] [numeric](5, 2) NULL,
    [HRS_ERN] [numeric](5, 2) NULL,
    [HRS_ATT] [numeric](5, 2) NULL,
    [GPA_HRS] [numeric](5, 2) NULL,
    [EFF_TRM_9S_COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_CHNG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACDMC_STAT_CD_VC] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACDMC_STAT_CD_HS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRG_HRS] [numeric](6, 2) NULL,
    [REGULAR_HRS_ATT] [numeric](6, 2) NULL,
    [REMEDIAL_HRS_ATT] [numeric](6, 2) NULL,
    [VOC_HRS_ATT] [numeric](6, 2) NULL,
    [EARNED_HRS] [numeric](6, 2) NULL,
    [FA_GPA] [numeric](3, 2) NULL,
    [RULE_150] [numeric](5, 2) NULL,
    [FA_STANDARD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_SOAP_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PCT_ATT_COMPL] [numeric](5, 2) NULL,
    [POLICY_PAGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDRESS_VERIF_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_OF_STUDY_VERIF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_STATUS_UPDATE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FLORIDA_PREPAID_AVAIL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FLORIDA_PREPAID_REVIEWED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMPLOYMENT_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SINGLE_PARENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISPLACED_HOMEMAKER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EX_OFFENDER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOMELESS_RUNAWAY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMPLOYMENT_BARRIER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIGRANT_WORKER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WITHDRAWAL_REASON] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MILITARY_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MILITARY_STATUS_REVIEWED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
  Sample Data
ACDMC_STAT_CD ACDMC_STAT_CD_HS ACDMC_STAT_CD_VC ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADDRESS_VERIF_IND CAMP CRED_RGSTRTN_APPT_DT CRED_RGSTRTN_APPT_TM CVRG_FLG DISPLACED_HOMEMAKER EFF_TRM_9S_COMP EMPLOYMENT_BARRIER EMPLOYMENT_STATUS ENRLMNT_CD EX_OFFENDER FA_GPA FA_SOAP_STATUS FA_STANDARD FLORIDA_PREPAID_AVAIL FLORIDA_PREPAID_REVIEWED GPA GPA_HRS GRAD_STATUS_UPDATE_IND GRD_PTS HOLD HOMELESS_RUNAWAY HRS_ATT HRS_ERN IMMIG_STAT ISN_ST_STDNT_TERM_A LATE_FEE_EXMPTN MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MIGRANT_WORKER MILITARY_STATUS MILITARY_STATUS_REVIEWED NTFY_DISAB_FLG OTHER_RGSTRTN_APPT_DT OTHER_RGSTRTN_APPT_TM PCT_ATT_COMPL PGM_CHNG_DT PGM_ID PGM_OF_STUDY_VERIF POLICY_PAGE_IND PRG_HRS PYMT_DUE_DT_CRED PYMT_DUE_DT_CRED_EXT PYMT_DUE_DT_NCRED PYMT_DUE_DT_NONCRED_EXT RECALC_FLG REGULAR_HRS_ATT RES_CD RowUpdatedOn RULE_150 SCHD_CHG_RSN SCHD_PRN_FLG SINGLE_PARENT STDNT_ID TRM_YR USER_WHO_EXT_CRED USER_WHO_EXT_NONCRED WITHDRAWAL_REASON
19990307 STR100N0 2010041 OPERTNS 2 N 800369 N7 2010041 C 389454 N false 8381 N 1 2017-02-06T10:11:24.79-05:00 N E06706691 19963
C0 C0 20121023 STR105N0 0426565 OPER1 1 20121109 0000000 N 798679 TC 2.73 FT FA 1104567 C 3781663 N 20130624 STR310B1 1756474 E062735 false 20121109 0000000 92.00 5234 Y 60.00 N 195.00 3 2017-02-06T10:20:24.959-05:00 325.00 N K11629334 20132
C0 C0 C0 20050316 STR105N0 0234518 OPER2 1 20050407 0900000 799469 HC N 1.00 3.00 3.00 823174 3.00 3.00 A 1576510 N 20050510 STR100N0 0823174 WEB1 false 20050407 0900000 1000 Y N 1 2017-02-06T10:14:29.386-05:00 Y A06168017 20053
C0 20071206 STR105N0 0922400 E000943 1 799179 TC 1.25 FB F7 1545573 C 2188244 N 20081020 STR310B1 0925324 E026130 false 30.00 A087 Y 64.00 N 44.00 1 2017-02-06T10:16:05.779-05:00 68.70 N C07224371 20082
C0 20140409 STR105N0 0317540 OPER1 1 20140422 0000000 B 798489 TC 2.37 FH FC 2.33 9.00 21.00 1118024 9.00 9.00 C 4116302 N 20141219 STR310B1 0014196 OPER2 false 20140422 0000000 60.00 T701A Y 120.00 N 142.00 1 2017-02-06T10:21:16.033-05:00 118.30 Y C13268453 20151
C0 20130523 STR105N0 0850317 WEB5 3 N 798669 TN 2.19 FC FA 2.00 3.00 6.00 1229110 3.00 3.00 C 3795624 N 20140106 STR310B1 1100017 E062735 false 79.00 3409 Y 60.00 N 34.00 1 2017-02-06T10:20:27.143-05:00 56.60 Y J14472161 20133
S5 20130807 STR105N0 0442018 OPER2 5 N 798589 HC Y 442018 C 3893030 N false 6138 N 1 2017-02-06T10:20:42.041-05:00 N D13371604 20141
C0 C0 20120320 STR105N0 0342595 OPER1 1 20120404 0900000 N 798769 TC 342595 C 3402964 N false 20120404 0900000 2212 Y N 1 2017-02-06T10:19:24.274-05:00 N D11131190 20123
C0 20120117 STR105N0 2253425 STUDENT 5 20120404 1200000 N 798769 HC 340057 C 3355225 N 20120320 STR105N0 0340057 OPER1 false 20120404 1200000 A353 Y N 1 2017-02-06T10:19:16.708-05:00 N C11698768 20123
C0 C0 C0 20051101 STR105N0 1615521 OPER2 5 20051109 1600000 799379 HC 1938061 P 1733203 N 20051219 STR105N0 1938061 OPER2 false 20051109 1600000 1000 N 1 2017-02-06T10:14:54.611-05:00 N K12166104 20062
Powered by BI Documenter