DWStaging
 dbo.ST_REPORT_SELECTION_A (Table)
  Properties
Property Value
Name ST_REPORT_SELECTION_A
Schema dbo
Row Count 376
Data Size 112 KB
Index Size 32 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
AA_DEG_CRD
numeric(17, 1)
True
False
False
 
AA_DEG_CRD_GRTR
varchar(1)
True
False
False
 
AA_DEG_CRD_INCL_CURNT
varchar(1)
True
False
False
 
AA_DEG_CRD_LESS
varchar(1)
True
False
False
 
ACAD_STAT_EXCLD
varchar(1)
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_TYPE_1ST_GOOD
varchar(1)
True
False
False
 
ADDR_TYPE_EMERG
varchar(1)
True
False
False
 
ADDR_TYPE_LCL
varchar(1)
True
False
False
 
ADDR_TYPE_PERM
varchar(1)
True
False
False
 
ADM_DATE
varchar(8)
True
False
False
 
ADM_DATE_AFTER
varchar(1)
True
False
False
 
ADM_DATE_BEFORE
varchar(1)
True
False
False
 
ADM_TERM_AFTER
varchar(1)
True
False
False
 
ADM_TERM_BEFORE
varchar(1)
True
False
False
 
ADM_TERM_EQUAL
varchar(1)
True
False
False
 
ADVSR_CODE_EXCLD
varchar(1)
True
False
False
 
AGE_BTWN_1
varchar(2)
True
False
False
 
AGE_BTWN_2
varchar(2)
True
False
False
 
AGE_GRTR
varchar(2)
True
False
False
 
AGE_LESS
varchar(2)
True
False
False
 
AWD_TYPE_EXCLD
varchar(1)
True
False
False
 
BASIS_ADM_EXCLD
varchar(1)
True
False
False
 
BATCH_EXEC_DATE
varchar(8)
True
False
False
 
BATCH_EXEC_TIME
varchar(8)
True
False
False
 
BATCH_REC_COUNT
int(10, 0)
True
False
False
 
CAMP_APPL_EXCLD
varchar(1)
True
False
False
 
CLS_CAMP_CNTR_EXCLD
varchar(1)
True
False
False
 
CLS_REF_NBR_EXCLD
varchar(1)
True
False
False
 
CLS_SPCL_DSGNTR_EXCLD
varchar(1)
True
False
False
 
CNTRY_CITZ_EXCLD
varchar(1)
True
False
False
 
COMM_RQST
varchar(1)
True
False
False
 
COMM_RQST_ALPHA
varchar(1)
True
False
False
 
COMM_RQST_OTH
varchar(1)
True
False
False
 
COMM_RQST_VAR_NM
varchar(4)
True
False
False
 
COMM_RQST_ZIP
varchar(1)
True
False
False
 
CR_ADM_DATE_IND
varchar(1)
True
False
False
 
CR_ADM_READM_IND
varchar(1)
True
False
False
 
CR_ADM_TERM
varchar(6)
True
False
False
 
CRED_TYPE_EXCLD
varchar(1)
True
False
False
 
CRS_ID_EXCLD
varchar(1)
True
False
False
 
CUM_CRD_ATT
numeric(17, 1)
True
False
False
 
CUM_CRD_ATT_GRTR
varchar(1)
True
False
False
 
CUM_CRD_ATT_LESS
varchar(1)
True
False
False
 
CUM_CRD_ERN
numeric(17, 1)
True
False
False
 
CUM_CRD_ERN_GRTR
varchar(1)
True
False
False
 
CUM_CRD_ERN_LESS
varchar(1)
True
False
False
 
CUM_CRD_GPA
numeric(17, 1)
True
False
False
 
CUM_CRD_GPA_GRTR
varchar(1)
True
False
False
 
CUM_CRD_GPA_LESS
varchar(1)
True
False
False
 
CUM_GPA
numeric(17, 2)
True
False
False
 
CUM_GPA_GRTR
varchar(1)
True
False
False
 
CUM_GPA_LESS
varchar(1)
True
False
False
 
CURR_CRD
numeric(17, 1)
True
False
False
 
CURR_CRD_GRTR
varchar(1)
True
False
False
 
CURR_CRD_LESS
varchar(1)
True
False
False
 
DATE
varchar(8)
True
False
False
 
DATE_9SCOMP
varchar(8)
True
False
False
 
DEG_AUD
varchar(1)
True
False
False
 
DEG_AUD_ALPHA
varchar(1)
True
False
False
 
DEG_AUD_OTH
varchar(1)
True
False
False
 
DEG_AUD_VAR_NM
varchar(4)
True
False
False
 
DEG_AUD_ZIP
varchar(1)
True
False
False
 
DISAB_ANY
varchar(1)
True
False
False
 
DISAB_CODE_EXCLD
varchar(1)
True
False
False
 
ENRL_CODE_EXCLD
varchar(1)
True
False
False
 
ENRL_TRM_CRD_ENR
varchar(1)
True
False
False
 
ENRL_TRM_CRD_NOT_ENR
varchar(1)
True
False
False
 
ENRL_TRM_NCR_ENR
varchar(1)
True
False
False
 
ENRL_TRM_NCR_NOT_ENR
varchar(1)
True
False
False
 
ENRL_TRM_NOT_ENR
varchar(1)
True
False
False
 
ENRL_TRM_VOC_ENR
varchar(1)
True
False
False
 
ENRL_TRM_VOC_NOT_ENR
varchar(1)
True
False
False
 
ETHNICITY_EXCLD
varchar(1)
True
False
False
 
EXCLD_BAD_ADDR
varchar(1)
True
False
False
 
EXPCTD_REC_COUNT
int(10, 0)
True
False
False
 
FERPA_EXCLD
varchar(1)
True
False
False
 
FERPA_ONLY
varchar(1)
True
False
False
 
GENDER_FEMALE
varchar(1)
True
False
False
 
GENDER_MALE
varchar(1)
True
False
False
 
GRAD_AWD_TYPE_EXCLD
varchar(1)
True
False
False
 
GRAD_CAMP
varchar(1)
True
False
False
 
GRAD_CAMP_EXCL
varchar(1)
True
False
False
 
GRAD_PROG_OBJ_EXCLD
varchar(1)
True
False
False
 
GRAD_STAT_EXCLD
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_OUTPUT
varchar(1)
True
False
False
 
HOLDS_ANY
varchar(1)
True
False
False
 
HOLDS_EXCLD
varchar(1)
True
False
False
 
HOLDS_NONE
varchar(1)
True
False
False
 
HOME_CAMP
varchar(1)
True
False
False
 
HOME_CAMP_EXCLD
varchar(1)
True
False
False
 
HS_ADM_DATE_IND
varchar(1)
True
False
False
 
HS_ADM_READM_IND
varchar(1)
True
False
False
 
HS_ADM_TERM
varchar(6)
True
False
False
 
HS_CODE_EXCLD
varchar(1)
True
False
False
 
HS_GRAD_AFTER
varchar(1)
True
False
False
 
HS_GRAD_BEFORE
varchar(1)
True
False
False
 
HS_GRAD_DT
varchar(6)
True
False
False
 
IMMIG_STAT_EXCLD
varchar(1)
True
False
False
 
INCLD_WTHDRWLS
varchar(1)
True
False
False
 
ISN_ST_REPORT_SELECTION_A
int(10, 0)
False
False
False
 
LABEL
varchar(1)
True
False
False
 
LABEL_ACROSS
varchar(1)
True
False
False
 
LABEL_ALPHA
varchar(1)
True
False
False
 
LABEL_INCL_STDNT_ID
varchar(1)
True
False
False
 
LABEL_OTH
varchar(1)
True
False
False
 
LABEL_VAR_NM
varchar(4)
True
False
False
 
LABEL_WDTH
varchar(1)
True
False
False
 
LABEL_ZIP
varchar(1)
True
False
False
 
LANG_EXCLD
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
 
NC_ADM_DATE_IND
varchar(1)
True
False
False
 
NC_ADM_READM_IND
varchar(1)
True
False
False
 
NC_ADM_TERM
varchar(6)
True
False
False
 
NOT_ENRL_TRM
varchar(6)
True
False
False
 
NOT_ENRL_TRM_ANYTHING
varchar(1)
True
False
False
 
NOT_ENRL_TRM_CRD
varchar(1)
True
False
False
 
NOT_ENRL_TRM_NCR
varchar(1)
True
False
False
 
NOT_ENRL_TRM_VOC
varchar(1)
True
False
False
 
PAID_ALL_CLS
varchar(1)
True
False
False
 
PAID_NO_CLS
varchar(1)
True
False
False
 
PAID_SOME_CLS
varchar(1)
True
False
False
 
PC_FILE
varchar(1)
True
False
False
 
PRINT_ALWAYS
varchar(1)
True
False
False
 
PROD_IND
varchar(1)
True
False
False
 
PROG_OBJ_EXCLD
varchar(1)
True
False
False
 
PROG_OBJ_IND
varchar(1)
True
False
False
 
RACE_EXCLD
varchar(1)
True
False
False
 
REG_DATE
varchar(8)
True
False
False
 
REG_DATE_AFTER
varchar(1)
True
False
False
 
REG_DATE_BEFORE
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
RPT
varchar(1)
True
False
False
 
RPT_ALPHA
varchar(1)
True
False
False
 
RPT_DSCRPTN
varchar(50)
True
False
False
 
RPT_OTH
varchar(1)
True
False
False
 
RPT_REF_NBR
int(10, 0)
True
False
False
 
RPT_VAR_NM
varchar(4)
True
False
False
 
RPT_ZIP
varchar(1)
True
False
False
 
RSDNCY_EXCLD
varchar(1)
True
False
False
 
STDNT_ID_DUMMY
varchar(1)
True
False
False
 
STDNT_ID_VALID
varchar(1)
True
False
False
 
STDNT_SCHD
varchar(1)
True
False
False
 
STDNT_SCHD_ALPHA
varchar(1)
True
False
False
 
STDNT_SCHD_OTH
varchar(1)
True
False
False
 
STDNT_SCHD_VAR_NM
varchar(4)
True
False
False
 
STDNT_SCHD_ZIP
varchar(1)
True
False
False
 
STDNT_SPCL_DSGNTR_EXCLD
varchar(1)
True
False
False
 
TEST_IND
varchar(1)
True
False
False
 
TEST_REC_LIMIT
int(10, 0)
True
False
False
 
TIME
varchar(8)
True
False
False
 
TIME_9SCOMP
varchar(8)
True
False
False
 
TRNSCRPT
varchar(1)
True
False
False
 
TRNSCRPT_ALPHA
varchar(1)
True
False
False
 
TRNSCRPT_OTH
varchar(1)
True
False
False
 
TRNSCRPT_VAR_NM
varchar(4)
True
False
False
 
TRNSCRPT_ZIP
varchar(1)
True
False
False
 
TYPE_STDNT_CR
varchar(1)
True
False
False
 
TYPE_STDNT_HS
varchar(1)
True
False
False
 
TYPE_STDNT_NCR
varchar(1)
True
False
False
 
TYPE_STDNT_PROSP
varchar(1)
True
False
False
 
TYPE_STDNT_VOC
varchar(1)
True
False
False
 
USER_ID
varchar(8)
True
False
False
 
VC_ADM_DATE_IND
varchar(1)
True
False
False
 
VC_ADM_READM_IND
varchar(1)
True
False
False
 
VC_ADM_TERM
varchar(6)
True
False
False
 
VETERAN
varchar(1)
True
False
False
 
VETERAN_RCV_BNFT
varchar(1)
True
False
False
 
VISA_TYPE_EXCLD
varchar(1)
True
False
False
 
ZIP_CODE_EXCLD
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_REPORT_SELECTION_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_REPORT_SELECTION_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_REPORT_SELECTION_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_REPORT_SELECTION_A] Script Date: 03/09/2017 16:46:17 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_REPORT_SELECTION_A](
    [ISN_ST_REPORT_SELECTION_A] [int] NOT NULL,
    [RPT_REF_NBR] [int] NULL,
    [USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RPT_DSCRPTN] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TYPE_STDNT_CR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TYPE_STDNT_NCR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TYPE_STDNT_HS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TYPE_STDNT_VOC] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TYPE_STDNT_PROSP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_ID_VALID] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_ID_DUMMY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP_CODE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_TYPE_LCL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_TYPE_PERM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_TYPE_EMERG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_TYPE_1ST_GOOD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXCLD_BAD_ADDR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FERPA_ONLY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FERPA_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GENDER_MALE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GENDER_FEMALE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RACE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LANG_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AGE_LESS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AGE_GRTR] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AGE_BTWN_1] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AGE_BTWN_2] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISAB_ANY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISAB_CODE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BASIS_ADM_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_GRAD_DT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_GRAD_BEFORE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_GRAD_AFTER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_CODE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CR_ADM_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_TERM_EQUAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_TERM_BEFORE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_TERM_AFTER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP_APPL_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROG_OBJ_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWD_TYPE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY_CITZ_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [IMMIG_STAT_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_TYPE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_CRD_ERN] [numeric](17, 1) NULL,
    [CUM_CRD_ERN_LESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_CRD_ERN_GRTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_CRD_GPA] [numeric](17, 1) NULL,
    [CUM_CRD_GPA_LESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_CRD_GPA_GRTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_CRD_ATT] [numeric](17, 1) NULL,
    [CUM_CRD_ATT_LESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_CRD_ATT_GRTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_GPA] [numeric](17, 2) NULL,
    [CUM_GPA_LESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_GPA_GRTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AA_DEG_CRD] [numeric](17, 1) NULL,
    [AA_DEG_CRD_LESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AA_DEG_CRD_GRTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AA_DEG_CRD_INCL_CURNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_DATE_BEFORE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_DATE_AFTER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_SPCL_DSGNTR_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRL_TRM_NOT_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRL_TRM_CRD_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRL_TRM_NCR_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRL_TRM_VOC_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRL_TRM_CRD_NOT_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRL_TRM_NCR_NOT_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRL_TRM_VOC_NOT_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOT_ENRL_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOT_ENRL_TRM_ANYTHING] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOT_ENRL_TRM_CRD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOT_ENRL_TRM_NCR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOT_ENRL_TRM_VOC] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOME_CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOME_CAMP_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RSDNCY_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CURR_CRD] [numeric](17, 1) NULL,
    [CURR_CRD_LESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CURR_CRD_GRTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAID_ALL_CLS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAID_SOME_CLS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAID_NO_CLS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENRL_CODE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACAD_STAT_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADVSR_CODE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REG_DATE_BEFORE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REG_DATE_AFTER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VETERAN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VETERAN_RCV_BNFT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_REF_NBR_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_SPCL_DSGNTR_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_ID_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRED_TYPE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_CAMP_CNTR_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INCLD_WTHDRWLS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLDS_NONE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLDS_ANY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLDS_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_CAMP_EXCL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_AWD_TYPE_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_PROG_OBJ_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRAD_STAT_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LABEL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LABEL_ZIP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LABEL_ALPHA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LABEL_OTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LABEL_VAR_NM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LABEL_ACROSS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LABEL_WDTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LABEL_INCL_STDNT_ID] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMM_RQST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMM_RQST_ZIP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMM_RQST_ALPHA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMM_RQST_OTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMM_RQST_VAR_NM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEG_AUD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEG_AUD_ZIP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEG_AUD_ALPHA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEG_AUD_OTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEG_AUD_VAR_NM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCRPT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCRPT_ZIP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCRPT_ALPHA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCRPT_OTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCRPT_VAR_NM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_SCHD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_SCHD_ZIP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_SCHD_ALPHA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_SCHD_OTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_SCHD_VAR_NM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RPT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RPT_ZIP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RPT_ALPHA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RPT_OTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RPT_VAR_NM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PC_FILE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD_OUTPUT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINT_ALWAYS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TEST_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROD_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TEST_REC_LIMIT] [int] NULL,
    [EXPCTD_REC_COUNT] [int] NULL,
    [BATCH_EXEC_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BATCH_EXEC_TIME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BATCH_REC_COUNT] [int] NULL,
    [DATE_9SCOMP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME_9SCOMP] [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,
    [CR_ADM_READM_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VC_ADM_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_ADM_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NC_ADM_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VC_ADM_READM_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_ADM_READM_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NC_ADM_READM_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CR_ADM_DATE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VC_ADM_DATE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_ADM_DATE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NC_ADM_DATE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ETHNICITY_EXCLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROG_OBJ_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
AA_DEG_CRD_GRTR AA_DEG_CRD_INCL_CURNT AA_DEG_CRD_LESS ACAD_STAT_EXCLD ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADDR_TYPE_1ST_GOOD ADDR_TYPE_EMERG ADDR_TYPE_LCL ADDR_TYPE_PERM ADM_DATE ADM_DATE_AFTER ADM_DATE_BEFORE ADM_TERM_AFTER ADM_TERM_BEFORE ADM_TERM_EQUAL ADVSR_CODE_EXCLD AGE_BTWN_1 AGE_BTWN_2 AGE_GRTR AGE_LESS AWD_TYPE_EXCLD BASIS_ADM_EXCLD BATCH_EXEC_DATE BATCH_EXEC_TIME BATCH_REC_COUNT CAMP_APPL_EXCLD CLS_CAMP_CNTR_EXCLD CLS_REF_NBR_EXCLD CLS_SPCL_DSGNTR_EXCLD CNTRY_CITZ_EXCLD COMM_RQST COMM_RQST_ALPHA COMM_RQST_OTH COMM_RQST_VAR_NM COMM_RQST_ZIP CR_ADM_DATE_IND CR_ADM_READM_IND CR_ADM_TERM CRED_TYPE_EXCLD CRS_ID_EXCLD CUM_CRD_ATT_GRTR CUM_CRD_ATT_LESS CUM_CRD_ERN_GRTR CUM_CRD_ERN_LESS CUM_CRD_GPA_GRTR CUM_CRD_GPA_LESS CUM_GPA_GRTR CUM_GPA_LESS CURR_CRD CURR_CRD_GRTR CURR_CRD_LESS DATE DATE_9SCOMP DEG_AUD DEG_AUD_ALPHA DEG_AUD_OTH DEG_AUD_VAR_NM DEG_AUD_ZIP DISAB_ANY DISAB_CODE_EXCLD ENRL_CODE_EXCLD ENRL_TRM_CRD_ENR ENRL_TRM_CRD_NOT_ENR ENRL_TRM_NCR_ENR ENRL_TRM_NCR_NOT_ENR ENRL_TRM_NOT_ENR ENRL_TRM_VOC_ENR ENRL_TRM_VOC_NOT_ENR ETHNICITY_EXCLD EXCLD_BAD_ADDR EXPCTD_REC_COUNT FERPA_EXCLD FERPA_ONLY GENDER_FEMALE GENDER_MALE GRAD_AWD_TYPE_EXCLD GRAD_CAMP GRAD_CAMP_EXCL GRAD_PROG_OBJ_EXCLD GRAD_STAT_EXCLD HOLD HOLD_OUTPUT HOLDS_ANY HOLDS_EXCLD HOLDS_NONE HOME_CAMP HOME_CAMP_EXCLD HS_ADM_DATE_IND HS_ADM_READM_IND HS_ADM_TERM HS_CODE_EXCLD HS_GRAD_AFTER HS_GRAD_BEFORE HS_GRAD_DT IMMIG_STAT_EXCLD INCLD_WTHDRWLS ISN_ST_REPORT_SELECTION_A LABEL LABEL_ACROSS LABEL_ALPHA LABEL_INCL_STDNT_ID LABEL_OTH LABEL_VAR_NM LABEL_WDTH LABEL_ZIP LANG_EXCLD MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NC_ADM_DATE_IND NC_ADM_READM_IND NC_ADM_TERM NOT_ENRL_TRM NOT_ENRL_TRM_ANYTHING NOT_ENRL_TRM_CRD NOT_ENRL_TRM_NCR NOT_ENRL_TRM_VOC PAID_ALL_CLS PAID_NO_CLS PAID_SOME_CLS PC_FILE PRINT_ALWAYS PROD_IND PROG_OBJ_EXCLD PROG_OBJ_IND RACE_EXCLD REG_DATE REG_DATE_AFTER REG_DATE_BEFORE RowUpdatedOn RPT RPT_ALPHA RPT_DSCRPTN RPT_OTH RPT_REF_NBR RPT_VAR_NM RPT_ZIP RSDNCY_EXCLD STDNT_ID_DUMMY STDNT_ID_VALID STDNT_SCHD STDNT_SCHD_ALPHA STDNT_SCHD_OTH STDNT_SCHD_VAR_NM STDNT_SCHD_ZIP STDNT_SPCL_DSGNTR_EXCLD TEST_IND TIME TIME_9SCOMP TRNSCRPT TRNSCRPT_ALPHA TRNSCRPT_OTH TRNSCRPT_VAR_NM TRNSCRPT_ZIP TYPE_STDNT_CR TYPE_STDNT_HS TYPE_STDNT_NCR TYPE_STDNT_PROSP TYPE_STDNT_VOC USER_ID VC_ADM_DATE_IND VC_ADM_READM_IND VC_ADM_TERM VETERAN VETERAN_RCV_BNFT VISA_TYPE_EXCLD ZIP_CODE_EXCLD
19991013 STS880N0 2109078 GPEDRSN X 19991014 6317 20 19991014 80008985 X N 1000 6323 20 19991014 STS880N0 0006323 GPEDRSN X X P 2017-02-06T11:29:51.683-05:00 X X STUDENTS IN SELECTED MARKETING MAJORS 24 0006323 99936769 X E002073
20100827 STS880N0 1523365 E015458 20101001 1018481 1697 1.0 X 20100908 79899091 X X N 2000 1018481 N 201 20101001 STS880N0 1018481 E015458 X X X X 2017-02-06T11:29:51.73-05:00 X X BELLE GLADE ENROLLED & PAID STUDENTS: CR & PSAV 210 1623456 83765439 E015458
20101119 STS880N0 1124156 E015458 X X 20101119 1129008 4 B 20102 1.0 X 20101119 79898880 X X X N 1400 1129008 B 20102 X 201004 209 20101119 STS880N0 1129008 E015458 X X X 2017-02-06T11:29:51.73-05:00 X X BELLE GLADE CAMPUS- H.S. GRADS, GLADES DAY 221 1124156 88758439 E015458 B 20102
20030624 STS880N0 1346090 E011832 X 20040922 1106301 270 20040922 79959077 X X N 2000 1106301 161 X 3 2 X 20040922 STS880N0 1106301 OPER2 X X X 2017-02-06T11:29:51.714-05:00 LABELS - F1 STUDENTS ~ FRANKLIN LABORDE~ 169 1048238 89517619 X X X E011832
20020405 STS880N0 0816335 LIPPEK X 20040301 1615463 7755 A 20042 20040301 79959698 N 10000 1615463 A 20042 133 X 3 2 X 20040301 STS880N0 1615463 OPER2 A 20042 X X X 2017-02-06T11:29:51.714-05:00 LABELS - FTIC SPRING APPLICANTS ~~ PENNY MCISAAC 140 1511363 84886369 X X X X X E011832 A 20042
20130221 STS880N0 1236593 E015458 X 20130221 1241213 47 20130221 79869778 X N 100 1241213 Y 283 20130221 STS880N0 1241213 E015458 X X X X 2017-02-06T11:29:51.745-05:00 X X BG CAMPUS- PSAV- CURRENTLY ENROLLED EXCL CHILDCARE 297 1237517 87624829 X E015458
20101123 STS880N0 0037497 E015458 X X 20101123 43389 97 B 20102 1.0 X 20101123 79898876 X X X N 1600 43389 B 20102 X 201004 N 219 20101123 STS880N0 0043389 E015458 X X X 2017-02-06T11:29:51.73-05:00 X X BOCA CAMPUS- H.S. GRADS, WEST BOCA 232 0037497 99625029 E015458 B 20102
20101119 STS880N0 1129012 E015458 X X 20101123 18539 17 B 20102 1.0 X 20101123 79898876 X X X N 1400 18539 B 20102 X 201004 N 212 20101123 STS880N0 0018539 E015458 X X X 2017-02-06T11:29:51.73-05:00 X X BELLE GLADE CAMPUS- H.S. GRADS, WELLINGTON 225 0017120 99828799 E015458 B 20102
20040527 STS880N0 1618040 E000920 X 20040527 1633533 116 20040527 79959472 X X X X N 1000 1633534 5 175 X 3 2 X 20040527 STS880N0 1633534 E000920 X X X 2017-02-06T11:29:51.714-05:00 LABELS - STUDS W/DISABILITIES ALL CAMPUSES BONNIE~ 183 1618270 83817299 X X X X X E000920
20000620 STS880N0 0837090 GPEDRSN X 20000620 2051081 127 20000620 79999379 X X X N 5000 2051083 57 20000620 STS880N0 2051083 OPER2 X X 2017-02-06T11:29:51.699-05:00 X X MARTIN COUNTY STUDENTS - LUISA ZUNIGA 61 2051083 79489169 X X E002073
Powered by BI Documenter