DWStaging
 dbo.ST_STDNT_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_LOG_A
  Properties
Property Value
Name ST_STDNT_LOG_A
Schema dbo
Row Count 1907181
Data Size 1348976 KB
Index Size 28488 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
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
 
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
 
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
 
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_LOG_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
 
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
 
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
 
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
 
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_ID
varchar(9)
True
False
False
 
STUDENT_INACTIVE
varchar(1)
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
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_LOG_A depends on)
Name Type
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_STDNT_LOG_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_LOG_A] Script Date: 03/09/2017 16:46:26 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_LOG_A](
    [ISN_ST_STDNT_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,
    [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,
    [STDNT_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_INACTIVE] [varchar](1) 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,
    [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,
    [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,
    [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]
  Sample Data
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 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 ELIGIBLE ELIGIBLE_TO_RETURN EMAIL_ADDR EMAIL_INST EMER_CNTCT EMER_HM_PHN EMER_RLTV_CD EMER_WRK_PHN EMPLOYMENT_STATUS ETHNICITY 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_LOG_A LAST_STATUS_CODE LAST_STATUS_TERM LICENSE_DATE LICENSE_NBR LICENSE_STATE LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER 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 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 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_ID STUDENT_INACTIVE 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
20140227 STA010N1 1506261 WEB5 3.43 32.00 110.00 32.00 32.00 P HN C 2 US true false 22236272201402271506260 20140227 20151 19960211 SNOOTYBUB@ATT.NET smithtn8@my.palmbeachstate.edu NICK SMITH F (561) 222-4050 N (561) 543-9274 Y THOMAS N 2001188 false 20140605 C 1181910 20120801 S530-676-61-828-0 FL M 20151217 <notty> 2052208 OPER2 SMITH 20161 20151217 STS659N1 2052208 OPER2 NICHOLAS false 1000 EN false 1 US 01 19680603 PAMELA SMITH (561) 827-9168 M FL Y 2017-02-06T09:47:08.614-05:00 M T14678262 20131227 1541YN FL false false
19940427 SR016CP 2026106 IQ< U N7 1 false false N 19510415 bockschkl@my.palmbeachstate.edu KRISTY N (561) 798-9143 203196 false C 103721 A 20150531 <notty> 1100264 E002346 BOCKSCH 19943 20110902 STA008B1 1352256 OPER2 LYNNE 19940427 19943 8381 true 8381 EN false 1 US 50 19971201 FL 2017-02-06T09:41:01.528-05:00 F K07139249 false false
20120829 STA010N1 1515327 WEB5 2.50 6.00 15.00 6.00 6.00 P HR B 1 US true false 23202099201208291515326 20120829 20131 20161 19930401 EMILIOREYES@BELLSOUTH.NET reyese12@my.palmbeachstate.edu MAYRA M (561) 996-1990 H (561) 449-6539 Y EMANUEL N 1556263 false 20110527 C 1202566 M 20151217 <notty> 2148375 OPER2 REYES 20161 20151217 STS659N1 2148375 OPER2 false 6143 EN false 3 US 20130101 EMANUEL REYES (561) 449-6539 I FL Y 2017-02-06T09:47:16.664-05:00 M E14263446 false false
SR016CP 2112123 TS 0.82 5.00 9.00 11.00 5.00 P HC 1 true false 19800101 19802 N 19610921 bahnemande@my.palmbeachstate.edu DANIEL N 626-2493 433281 false 19790601 C 345719 A 20150531 <notty> 1103101 E002346 BAHNEMAN 19811 20110902 STA008B1 1350249 OPER2 EDWARD false 1000 EN false 1 US 50 19971201 FL 2017-02-06T09:42:21.4-05:00 M D09846072 false false
20160308 STA010N1 2019473 WEB5 P HN B 1 US true false 21282206201603082019472 20160308 20171 19971007 DANIQ106@GMAIL.COM harrisd21@my.palmbeachstate.edu MARIA HARRIS (561) 716-4904 M (561) 716-4904 H (561) 376-9306 N DANIELLA N (561) 716-4904 1128421 false 20160602 C 1570054 20141121 H620546717130 FL M 20160714 pts/173 1505028 E042646 HARRIS 20160714 STA043P1 1505028 E042646 false 1000 EN false 3 US 19870710 MARIA HARRIS (561) 716-4904 M FL Y 2017-02-06T09:49:32.54-05:00 MS F D15259419 20081020 229VJN FL false false (561) 376-9306
20120402 STA010N1 1918561 WEB5 P HN A 1 US true false 21188722201204021918560 20120402 20171 19900207 COASTALCARLY7@YAHOO.COM mrazovichca@my.palmbeachstate.edu SALLY MRAZOVICH (561) 588-5694 M N (561) 234-6327 N CARLY N (561) 588-5694 1021264 false 20080609 C 1534109 20150129 M621-101-90-547-0 FL M 20160623 pts/254 1021264 E042646 MRAZOVICH 20160623 STA010N1 1021264 E042646 ANN false 6446 EN false 3 US 19900207 CARLY MRAZOVICH ANN (561) 588-5694 I FL Y 2017-02-06T09:49:19.171-05:00 MS F C14113708 20130716 510QCU FL false false
20150512 STA010N1 1025156 WEB5 P HN C 1 PR true false 21266382201505121025156 20150512 20161 19970719 JAHNIELFLORES@GMAIL.COM floresja10@my.palmbeachstate.edu VICKI FLORES (561) 543-7154 O H (561) 676-2672 Y JAHNIEL N 821225 false 20150604 C 902566 20070620 F462426713310 FL M 20150623 <notty> 821225 OPER2 FLORES 20150623 STA010N1 0821225 OPER2 A false 1000 EN false 1 US 01 20010301 JAIME FLORES F FL Y 2017-02-06T09:45:28.524-05:00 MR M J15050420 false false
20120508 STA010N1 1613338 E002056 123456 2.00 4.00 8.00 4.00 4.00 JR P TN NN A 1 JM true false 0 193239201205081612490 20120508 20161 19811029 CLINTONBARTLEY@HOTMAIL.COM bartleyca@my.palmbeachstate.edu INDIRA BARTLEY (561) 703-5084 C N (954) 629-4041 Y CLINTON N (954) 629-4041 942543 false 20000727 P 1402584 20120913 B634101813890 FL M 20160506 <notty> 2007208 OPER2 BARTLEY 20162 20160506 STS610NA 2007208 OPER2 ANTHONY 20130822 20141 8384 true 3408 EN false 3 JM 20060616 CLINTON BARTLEY ANTHONY (954) 629-4041 I FL Y 2017-02-06T09:48:28.908-05:00 MR M C14158174 20070306 I176EZ FL false false
20100727 STA010N1 2012354 FACTS1 20080220 A095549546 A095549546 3.35 67.00 225.00 71.00 67.00 P HN A 1 JM true false 11141055201007272012352 20100727 20111 19581109 NADENEP@AOL.COM plummerng@my.palmbeachstate.edu NOVETTE, GREEN O (561) 319-5642 N (954) 709-1212 NADENE Y (954) 709-1212 1809332 false 20091201 P 1716905 20081016 P456627589090 FL M 20161101 <notty> 1809331 STUDENT PLUMMER 20162 20161101 STA010N1 1809332 STUDENT GUEANA false 2301 EN false 3 JM 19900610 NADENE PLUMMER (954) 709-1212 I FL Y 2017-02-06T09:50:29.138-05:00 F N13638978 20091027 13278513 FL false false (954) 709-1212
20160330 STA010N1 2110122 WEB5 U HN B 1 US true false 21283929201603302110121 20160330 20171 19961120 BABALOPEZ64@GMAIL.COM lopezaa13@my.palmbeachstate.edu CINDY PEREZ M H (561) 506-2144 Y ALBERTO N 822380 false 20160602 C 1570231 M 20160714 pts/191 1636462 E090506 LOPEZ 20160714 STA043P1 1636462 E090506 ARNOL false 1000 EN false 3 US 19961120 ALBERTO LOPEZ ARNOL I FL Y 2017-02-06T09:49:32.587-05:00 MR M A15278542 false false
Powered by BI Documenter