Table - dbo.ST_STDNT

Property	Value
Name	ST_STDNT_A
Schema	dbo
Row Count	922776
Data Size	593256 KB
Index Size	13816 KB
Create Date	2/2/2017 2:14 PM
Description

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
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
ALIEN_DATE	varchar(8)	True	False	False
ALIEN_NBR	varchar(10)	True	False	False
ALIEN_NUM	varchar(10)	True	False	False
ALL_GPA	numeric(4, 2)	True	False	False
ALL_GPA_HRS	numeric(5, 2)	True	False	False
ALL_GRD_PTS	numeric(7, 2)	True	False	False
ALL_HRS_ATT	numeric(5, 2)	True	False	False
ALL_HRS_ERN	numeric(5, 2)	True	False	False
APPEND	varchar(4)	True	False	False
APPL_FEE	varchar(1)	True	False	False
ATHLT_STDNT_ID	varchar(9)	True	False	False
ATHLTC_SCHLRSHP	varchar(1)	True	False	False
AWD_TY	varchar(3)	True	False	False
BA_CC	varchar(2)	True	False	False
BA_HS	varchar(2)	True	False	False
BA_NC	varchar(2)	True	False	False
BA_VC	varchar(2)	True	False	False
BANK_CODE	varchar(9)	True	False	False
BANKING_INSTITUTION_ACCOUNT_NBR	varchar(20)	True	False	False
BASIS_RESIDENCY	varchar(1)	True	False	False
CAMP_PREF	varchar(5)	True	False	False
CNTRY_BIRTH	varchar(3)	True	False	False
COLL_CRED_FLG	bit(1, 0)	True	False	False
COLL_CRED_SHRT_FLG	bit(1, 0)	True	False	False
CONFIRMATION_NBR	varchar(23)	True	False	False
CONTACT_TIME_PREF	varchar(1)	True	False	False
CR_APPL_DT	varchar(8)	True	False	False
CR_APPL_TERM	varchar(6)	True	False	False
CR_READMT_TERM	varchar(6)	True	False	False
CUM_GPA	numeric(3, 2)	True	False	False
CUM_HRS_ERND	numeric(6, 2)	True	False	False
DECEASED_DT	varchar(8)	True	False	False
DECEASED_VERIF_CD	varchar(1)	True	False	False
DISAB_CD	varchar(1)	True	False	False
DISADV_ACAD	varchar(1)	True	False	False
DISADV_ECON	varchar(1)	True	False	False
DOB	varchar(8)	True	False	False
ED_LVL_PARENT_GUARDIAN_1	varchar(1)	True	False	False
ED_LVL_PARENT_GUARDIAN_2	varchar(1)	True	False	False
EDUC_LVL	varchar(2)	True	False	False
EFT_ACCOUNT_ACTIVE_IND	varchar(1)	True	False	False
EFT_ACCOUNT_OPEN_IND	varchar(1)	True	False	False
EFT_AUTHORIZED_IND	varchar(1)	True	False	False
EFT_BANK_ACCT_TYPE	varchar(1)	True	False	False
ELIGIBLE	varchar(1)	True	False	False
ELIGIBLE_TO_RETURN	varchar(6)	True	False	False
EMAIL_ADDR	varchar(40)	True	False	False
EMAIL_INST	varchar(50)	True	False	False
EMER_CNTCT	varchar(50)	True	False	False
EMER_HM_PHN	varchar(20)	True	False	False
EMER_RLTV_CD	varchar(1)	True	False	False
EMER_WRK_PHN	varchar(20)	True	False	False
EMPLOYMENT_STATUS	varchar(1)	True	False	False
ETHNICITY	varchar(1)	True	False	False
FA_BOOKSTORE_AUTH	varchar(1)	True	False	False
FA_CURRENT_TRM_NON_TUITION_AUTH	varchar(1)	True	False	False
FA_PRIOR_FUTURE_TRM_AUTH	varchar(1)	True	False	False
FAX_NUM	varchar(20)	True	False	False
FMLY_HIST_FLG	varchar(1)	True	False	False
FRST_NM	varchar(20)	True	False	False
FT_TERM	varchar(6)	True	False	False
GED_DATE_SW	varchar(1)	True	False	False
GPA_MOD	varchar(1)	True	False	False
HM_PHN	varchar(20)	True	False	False
HOLD	int(10, 0)	True	False	False
HS_APPL_DT	varchar(8)	True	False	False
HS_APPL_TERM	varchar(6)	True	False	False
HS_COMPL_FLG	bit(1, 0)	True	False	False
HS_GRAD_DT	varchar(8)	True	False	False
HS_PGM_CD	varchar(5)	True	False	False
HS_READMT_TERM	varchar(6)	True	False	False
IMMIG_STAT	varchar(2)	True	False	False
ISN_ST_STDNT_A	int(10, 0)	False	False	False
LAST_STATUS_CODE	varchar(2)	True	False	False
LAST_STATUS_TERM	varchar(6)	True	False	False
LICENSE_DATE	varchar(8)	True	False	False
LICENSE_NBR	varchar(20)	True	False	False
LICENSE_STATE	varchar(2)	True	False	False
LST_NM	varchar(35)	True	False	False
LST_TRM_ATND	varchar(6)	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
MARKET_SOURCE	varchar(2)	True	False	False
MDL_NM	varchar(20)	True	False	False
NBR_FT_TRMS	int(10, 0)	True	False	False
NC_APPL_DT	varchar(8)	True	False	False
NC_APPL_TERM	varchar(6)	True	False	False
NC_PGM_CD	varchar(5)	True	False	False
NC_READMT_TERM	varchar(6)	True	False	False
NON_CRED_FLG	bit(1, 0)	True	False	False
NOT_ELIGIBLE_HS_PLCMNT_EXMPTN	varchar(1)	True	False	False
PGM_CD	varchar(5)	True	False	False
PHYSCL_EXM_DT	varchar(8)	True	False	False
PIN_NUM	varchar(6)	True	False	False
PREV_GPA	numeric(4, 2)	True	False	False
PREV_HRS	numeric(5, 2)	True	False	False
PREV_MOD	varchar(1)	True	False	False
PREV_TRM	varchar(6)	True	False	False
PRIM_LANG	varchar(2)	True	False	False
PRSPCT_CAMP_PREF	varchar(1)	True	False	False
PRSPCT_FLG	bit(1, 0)	True	False	False
PRSPCT_PGM_ID	varchar(5)	True	False	False
PRSPCT_TYPE	varchar(2)	True	False	False
QUAL_CODE	varchar(1)	True	False	False
RCRD_CRTN_DT	varchar(8)	True	False	False
RDSHRT	varchar(1)	True	False	False
RECEIVED_QUAL_DATE	varchar(8)	True	False	False
RES_CD	varchar(1)	True	False	False
RES_CNTRY_CD	varchar(3)	True	False	False
RES_CNTY_CD	varchar(2)	True	False	False
RES_FL_DT	varchar(8)	True	False	False
RES_FRST_NM	varchar(20)	True	False	False
RES_LST_NM	varchar(35)	True	False	False
RES_MDL_NM	varchar(20)	True	False	False
RES_PHONE	varchar(20)	True	False	False
RES_RELATIONSHIP	varchar(2)	True	False	False
RES_ST_CD	varchar(2)	True	False	False
RESIDENT_YN	varchar(1)	True	False	False
RLS_FRM_PRVD	varchar(1)	True	False	False
RLS_FRM_PRVD_DT	varchar(8)	True	False	False
RLS_FRM_RQRD	varchar(1)	True	False	False
RowUpdatedOn	datetime2(27, 7)	True	False	False
SALUT	varchar(3)	True	False	False
SCHLRSHIP	varchar(1)	True	False	False
SCHLRSHP_TRM	varchar(6)	True	False	False
SEASON	int(10, 0)	True	False	False
SECURITY_QUESTION	varchar(2)	True	False	False
SECURITY_RESPONSE	varchar(40)	True	False	False
SENT_FOR_QUAL_DATE	varchar(8)	True	False	False
SEX	varchar(1)	True	False	False
SITE_SPECIFIC_FIELD	varchar(50)	True	False	False
SPRT_CD	varchar(2)	True	False	False
SPRT_STATUS_DT	varchar(8)	True	False	False
SPRT_STDNT_ID	varchar(9)	True	False	False
SPRT_TRM	varchar(6)	True	False	False
STATUS_AI	varchar(1)	True	False	False
STDNT_STAT	varchar(2)	True	False	False
STDNT_TY	varchar(1)	True	False	False
STUDENT_BILLING_SELECTION	varchar(1)	True	False	False
STUDENT_ID	varchar(9)	True	False	False
STUDENT_INACTIVE	varchar(1)	True	False	False
STUDENT_SSN	varchar(9)	True	False	False
SUSPENSION_TERM	varchar(6)	True	False	False
TERM_ATT	numeric(5, 2)	True	False	False
TERM_ERN	numeric(5, 2)	True	False	False
TERM_GPA	numeric(4, 2)	True	False	False
TERM_HRS	numeric(5, 2)	True	False	False
TERM_PTS	numeric(7, 2)	True	False	False
VC_APPL_DT	varchar(8)	True	False	False
VC_APPL_TERM	varchar(6)	True	False	False
VC_READMT_TERM	varchar(6)	True	False	False
VEHICLE_DATE	varchar(8)	True	False	False
VEHICLE_NBR	varchar(20)	True	False	False
VEHICLE_STATE	varchar(2)	True	False	False
VET_FLG	bit(1, 0)	True	False	False
VISA_EXP_DT	varchar(8)	True	False	False
VISA_ISSUE_DATE	varchar(8)	True	False	False
VISA_TYPE	varchar(3)	True	False	False
VOC_FLG	bit(1, 0)	True	False	False
VOC_PGM_CD	varchar(5)	True	False	False
VOTER_COUNTY	varchar(2)	True	False	False
VOTER_DATE	varchar(8)	True	False	False
VOTER_NBR	varchar(20)	True	False	False
VOTER_STATE	varchar(2)	True	False	False
WRK_PHN	varchar(20)	True	False	False

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
U5KKS0B4F60NQ	False	ISN_ST_STDNT_A

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.arch_AR_Obligations	View
dbo.arch_AR_Receipt	View
dbo.arch_AR_Receivables	View
dbo.arch_Student	View
dbo.arch_StudentAddressesAll	View
dbo.usp_DimApplication_Select	StoredProcedure
dbo.usp_DimEmployee_Select	StoredProcedure
dbo.usp_DimEmployee_Select_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_Old	StoredProcedure
dbo.usp_DimProgramRetentionCohort_Select	StoredProcedure
dbo.usp_DimStudent_Select	StoredProcedure
dbo.usp_DimStudentObjective_Select	StoredProcedure
dbo.usp_DimStudentReceipt_Select	StoredProcedure
dbo.usp_DimStudentSuccessCohort_Select	StoredProcedure
dbo.usp_DimStudentTerm_Select	StoredProcedure
dbo.usp_FactApplicationStatus_Select	StoredProcedure
dbo.usp_FactInstitutionalRetentionY2YSnapshot_Select	StoredProcedure
dbo.usp_FactStudentReceiptPayments_Select	StoredProcedure

Name	Type
dbo.arch_Student	VIEW
dbo.arch_StudentAddressesAll	VIEW
dbo.usp_DimApplication_Select	STOREDPROCEDURE
dbo.usp_DimEmployee_Select	STOREDPROCEDURE
dbo.usp_DimEmployee_Select_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_Old	STOREDPROCEDURE
dbo.usp_DimProgramRetentionCohort_Select	STOREDPROCEDURE
dbo.usp_DimStudent_Select	STOREDPROCEDURE
dbo.usp_DimStudentObjective_Select	STOREDPROCEDURE
dbo.usp_DimStudentReceipt_Select	STOREDPROCEDURE
dbo.usp_DimStudentSuccessCohort_Select	STOREDPROCEDURE
dbo.usp_DimStudentTerm_Select	STOREDPROCEDURE
dbo.usp_FactApplicationStatus_Select	STOREDPROCEDURE
dbo.usp_FactInstitutionalRetentionY2YSnapshot_Select	STOREDPROCEDURE
dbo.usp_FactStudentReceiptPayments_Select	STOREDPROCEDURE
dbo.arch_AR_Obligations	VIEW
dbo.arch_AR_Receipt	VIEW
dbo.arch_AR_Receivables	VIEW

Object

Property

Value

Object

Property

Value

/****** Object: Table [dbo].[ST_STDNT_A] Script Date: 03/09/2017 16:46:22 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_A](
    [ISN_ST_STDNT_A] [int] NOT 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,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_INACTIVE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PIN_NUM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_STAT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLL_CRED_FLG] [bit] NULL,
    [VOC_FLG] [bit] NULL,
    [HS_COMPL_FLG] [bit] NULL,
    [NON_CRED_FLG] [bit] NULL,
    [PRSPCT_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,
    [DOB] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEX] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_GRAD_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_ST_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CNTY_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CNTRY_CD] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_FL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [IMMIG_STAT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIEN_NUM] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HM_PHN] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WRK_PHN] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FAX_NUM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FMLY_HIST_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWD_TY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP_PREF] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISAB_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VET_FLG] [bit] NULL,
    [CUM_GPA] [numeric](3, 2) NULL,
    [CUM_HRS_ERND] [numeric](6, 2) NULL,
    [CR_APPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NC_APPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VC_APPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_APPL_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CR_APPL_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CR_READMT_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NC_APPL_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NC_READMT_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_APPL_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_READMT_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VC_APPL_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VC_READMT_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LST_TRM_ATND] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIM_LANG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ETHNICITY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_ADDR] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BA_CC] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BA_HS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BA_VC] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BA_NC] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_CNTCT] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_RLTV_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_HM_PHN] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_WRK_PHN] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DECEASED_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RCRD_CRTN_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISADV_ACAD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISADV_ECON] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY_BIRTH] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLL_CRED_SHRT_FLG] [bit] NULL,
    [HS_PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VOC_PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NC_PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EDUC_LVL] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATHLT_STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATHLTC_SCHLRSHP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHLRSHP_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPRT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPRT_STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PHYSCL_EXM_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEASON] [int] NULL,
    [RDSHRT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_AI] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RLS_FRM_RQRD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RLS_FRM_PRVD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RLS_FRM_PRVD_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPRT_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPRT_STATUS_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALL_GPA] [numeric](4, 2) NULL,
    [ALL_GRD_PTS] [numeric](7, 2) NULL,
    [ALL_HRS_ERN] [numeric](5, 2) NULL,
    [ALL_HRS_ATT] [numeric](5, 2) NULL,
    [ALL_GPA_HRS] [numeric](5, 2) NULL,
    [APPL_FEE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUSPENSION_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ELIGIBLE_TO_RETURN] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DECEASED_VERIF_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRSPCT_CAMP_PREF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MARKET_SOURCE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [QUAL_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_TIME_PREF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRSPCT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_STATUS_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_STATUS_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SENT_FOR_QUAL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVED_QUAL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRSPCT_PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GED_DATE_SW] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANK_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANKING_INSTITUTION_ACCOUNT_NBR] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_ACCOUNT_ACTIVE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_AUTHORIZED_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_ACCOUNT_OPEN_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_BANK_ACCT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_CURRENT_TRM_NON_TUITION_AUTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_PRIOR_FUTURE_TRM_AUTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_ISSUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_EXP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESIDENT_YN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BASIS_RESIDENCY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_RELATIONSHIP] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_LST_NM] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_FRST_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_MDL_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_PHONE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VOTER_NBR] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VOTER_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VOTER_COUNTY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VOTER_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LICENSE_NBR] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LICENSE_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LICENSE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VEHICLE_NBR] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VEHICLE_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VEHICLE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIEN_NBR] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIEN_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONFIRMATION_NBR] [varchar](23) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SECURITY_QUESTION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SECURITY_RESPONSE] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHLRSHIP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ELIGIBLE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GPA_MOD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM_GPA] [numeric](4, 2) NULL,
    [TERM_PTS] [numeric](7, 2) NULL,
    [TERM_ERN] [numeric](5, 2) NULL,
    [TERM_ATT] [numeric](5, 2) NULL,
    [TERM_HRS] [numeric](5, 2) NULL,
    [PREV_HRS] [numeric](5, 2) NULL,
    [PREV_GPA] [numeric](4, 2) NULL,
    [PREV_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREV_MOD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NBR_FT_TRMS] [int] NULL,
    [FT_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_INST] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SITE_SPECIFIC_FIELD] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_BOOKSTORE_AUTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_BILLING_SELECTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOT_ELIGIBLE_HS_PLCMNT_EXMPTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMPLOYMENT_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ED_LVL_PARENT_GUARDIAN_1] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ED_LVL_PARENT_GUARDIAN_2] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]

ADD_DATE

ADD_PGM

ADD_TIME

ADD_USER_ID

ALIEN_DATE

ALIEN_NBR

ALIEN_NUM

ALL_GPA

ALL_GPA_HRS

ALL_GRD_PTS

ALL_HRS_ATT

ALL_HRS_ERN

APPEND

APPL_FEE

ATHLT_STDNT_ID

ATHLTC_SCHLRSHP

AWD_TY

BA_CC

BA_HS

BA_NC

BA_VC

BANK_CODE

BANKING_INSTITUTION_ACCOUNT_NBR

BASIS_RESIDENCY

CAMP_PREF

CNTRY_BIRTH

COLL_CRED_FLG

COLL_CRED_SHRT_FLG

CONFIRMATION_NBR

CONTACT_TIME_PREF

CR_APPL_DT

CR_APPL_TERM

CR_READMT_TERM

DECEASED_DT

DECEASED_VERIF_CD

DISAB_CD

DISADV_ACAD

DISADV_ECON

DOB

ED_LVL_PARENT_GUARDIAN_1

ED_LVL_PARENT_GUARDIAN_2

EDUC_LVL

EFT_ACCOUNT_ACTIVE_IND

EFT_ACCOUNT_OPEN_IND

EFT_AUTHORIZED_IND

EFT_BANK_ACCT_TYPE

ELIGIBLE

ELIGIBLE_TO_RETURN

EMAIL_ADDR

EMAIL_INST

EMER_CNTCT

EMER_HM_PHN

EMER_RLTV_CD

EMER_WRK_PHN

EMPLOYMENT_STATUS

ETHNICITY

FA_BOOKSTORE_AUTH

FA_CURRENT_TRM_NON_TUITION_AUTH

FA_PRIOR_FUTURE_TRM_AUTH

FAX_NUM

FMLY_HIST_FLG

FRST_NM

FT_TERM

GED_DATE_SW

GPA_MOD

HM_PHN

HOLD

HS_APPL_DT

HS_APPL_TERM

HS_COMPL_FLG

HS_GRAD_DT

HS_PGM_CD

HS_READMT_TERM

IMMIG_STAT

ISN_ST_STDNT_A

LAST_STATUS_CODE

LAST_STATUS_TERM

LICENSE_DATE

LICENSE_NBR

LICENSE_STATE

LST_NM

LST_TRM_ATND

MAINT_DATE

MAINT_PGM

MAINT_TIME

MAINT_USER_ID

MARKET_SOURCE

MDL_NM

NC_APPL_DT

NC_APPL_TERM

NC_PGM_CD

NC_READMT_TERM

NON_CRED_FLG

NOT_ELIGIBLE_HS_PLCMNT_EXMPTN

PGM_CD

PHYSCL_EXM_DT

PIN_NUM

PREV_MOD

PREV_TRM

PRIM_LANG

PRSPCT_CAMP_PREF

PRSPCT_FLG

PRSPCT_PGM_ID

PRSPCT_TYPE

QUAL_CODE

RCRD_CRTN_DT

RDSHRT

RECEIVED_QUAL_DATE

RES_CD

RES_CNTRY_CD

RES_CNTY_CD

RES_FL_DT

RES_FRST_NM

RES_LST_NM

RES_MDL_NM

RES_PHONE

RES_RELATIONSHIP

RES_ST_CD

RESIDENT_YN

RLS_FRM_PRVD

RLS_FRM_PRVD_DT

RLS_FRM_RQRD

RowUpdatedOn

SALUT

SCHLRSHIP

SCHLRSHP_TRM

SECURITY_QUESTION

SECURITY_RESPONSE

SENT_FOR_QUAL_DATE

SEX

SITE_SPECIFIC_FIELD

SPRT_CD

SPRT_STATUS_DT

SPRT_STDNT_ID

SPRT_TRM

STATUS_AI

STDNT_STAT

STDNT_TY

STUDENT_BILLING_SELECTION

STUDENT_ID

STUDENT_INACTIVE

STUDENT_SSN

SUSPENSION_TERM

VC_APPL_DT

VC_APPL_TERM

VC_READMT_TERM

VEHICLE_DATE

VEHICLE_NBR

VEHICLE_STATE

VET_FLG

VISA_EXP_DT

VISA_ISSUE_DATE

VISA_TYPE

VOC_FLG

VOC_PGM_CD

VOTER_COUNTY

VOTER_DATE

VOTER_NBR

VOTER_STATE

WRK_PHN

SR016CP

2104161

BF

2.75

4.00

11.00

4.00

P

HC

1

true

false

19830801

19841

N

19520204

MARION

N

(561) 555-5756

1651550

false

19830801

C

559433

POMA

19931

20160802

STA008B1

0821516

OPER2

A

false

3408

6767

EN

false

1

US

50

19971201

FL

2017-02-06T09:56:09.469-05:00

F

E

M09295569

900557868

false

(561) 555-8788

20110319

STA010N1

2115517

FACTS1

2.83

152.00

431.00

152.00

P

TN

063100277

898000000000

B

1

PH

true

false

11159154201103192115517

20110319

20113

19900518

Y

S

RYAN_DENIEGA@HETGROUP.ORG

DENIEGA, JORGE FERRERAS

(561) 452-6562

F

N

Y

(561) 555-9240

PAUL RYAN

N

(561) 555-9240

5073

false

20060401

C

741936

20051014

D520426583310

FL

LAMBOJO

20162

20160828

STA010N1

0005073

WEB6

CAPACIO

false

2126

2011

TL

false

3

US

20070131

JORGE

DENIEGA

FERRERAS

(561) 452-6562

F

FL

Y

2017-02-06T09:57:19.202-05:00

01

Lambojo

M

E

P13799044

900739836

20090415

460XIZ

FL

false

20010207

STA010N1

1017208

LDECKER

N

TN

2

false

19331207

H

MARGARITA

N

(561) 555-4974

1311584

false

C

475932

NIEVES

20012

20160802

STA008B1

0822126

OPER2

false

4252

SP

false

1

US

50

FL

2017-02-06T09:55:38.098-05:00

F

E

M11306727

900474830

20010207

20012

false

true

5000

SR016CP

2041138

ML<

2.43

21.00

51.00

21.00

P

TC

1

ZZ

true

false

19900801

19911

N

19700708

JASON

N

393-89555

1227284

false

19880601

C

175077

BUELOW

19912

20160802

STA008B1

0818041

OPER2

false

3004

2083

EN

false

3

US

WI

2017-02-06T09:53:48.21-05:00

M

E

J07934672

900174419

false

20150804

STA010N1

1529172

WEB5

1.56

21.20

33.10

21.20

17.20

P

TN

2

US

true

false

22272241201508041529171

20150804

20161

19960715

MARITZA.ORTIZ80@HETGROUP.ORG

ANNI PULEO

(774) 406-6105

R

(774) 406-6105

H

(253) 555-7732

N

MARITZA

N

(253) 555-7732

1523134

false

20140615

C

882595

ORTIZ- URVINA

20162

20160802

STA008B1

0822517

OPER2

ELIZABETH

false

1000

3031

EN

false

3

US

FL

N

2017-02-06T09:58:14.972-05:00

04

BEAU BEAU

F

E

M15128200

900879282

false

(253) 555-7732

20130129

STA010N1

0740289

WEB5

U

HN

071025797

499100000000

C

2

US

true

false

21209357201301290740288

20130129

20151

19911021

Y

C

MONDS50@HETGROUP.ORG

KARLA MONDS

(561) 945-2694

M

N

(561) 555-8071

N

BRITTANNICA

N

(561) 555-2694

813521

false

20100603

C

806638

TAYLOR

20160802

STA008B1

0813181

OPER2

false

2358

0060

EN

false

1

US

01

19901021

KARLA

MONDS

(561) 945-2694

M

FL

Y

2017-02-06T09:57:45.16-05:00

04

BLUE

F

E

B14354542

900804023

false

20120219

STA010N1

1622065

WEB5

3.62

32.00

116.00

32.00

N

DN

2

US

true

false

22185093201202191622065

20120219

20123

Y

19960830

GATORKATIE@HETGROUP.ORG

SONYA PESAE

(561) 401-9092

M

(561) 568-3105

N

(561) 555-1943

KATIE

N

(561) 555-9092

1446465

false

20140619

C

778953

PEASE

20142

20160802

STA008B1

0820163

OPER2

SIERRA

false

3800

4576

EN

false

3

US

FL

2017-02-06T09:57:34.053-05:00

MS

04

MISHKA

F

E

K14073696

900776589

false

20050923

STA030N1

1412565

E019000

U

HN

1

KE

true

false

20050923

20062

19860108

NKYEGO@HETGROUP.ORG

VERONICA

N

1512136

false

20031101

F

573582

IN

KOSGEI

20160802

STA008B1

0827025

OPER2

false

1000

3526

EN

true

4

KE

2017-02-06T09:56:15.054-05:00

F

D

E

V12176509

900571928

false

F1

false

20160127

STA010N1

1248230

WEB5

0635988340

P

HN

A

1

CU

true

false

21279671201601271248229

20160127

20162

19920612

MAILENREYE@HETGROUP.ORG

YOAN GONZALEZ GOMEZ

(561) 846-0734

O

H

Y

MAILEN

N

(561) 555-9074

830111

false

20100531

W

893484

20150817

R234540927120

FL

REYES HIDALGO

20160802

STA008B1

0822526

OPER2

false

1000

9292

SP

false

3

CU

20150515

MAILEN

REYES HIDALGO

(561) 229-9074

I

FL

Y

2017-02-06T09:58:19.309-05:00

05

LEONOR

F

E

M15227861

900890019

false

19980112

SR016CP

2011567

MA<

U

N7

5

false

N

19610418

NEDIM

N

(561) 555-4676

2234147

false

P

24622

AGANOVIC

19982

20160802

STA008B1

0822548

OPER2

19980112

19982

8381

true

8381

4786

EN

false

1

ZZ

50

19971201

FL

2017-02-06T09:52:51.098-05:00

M

E

N06263362

900024420

false