DWStaging
 dbo.ST_VA_INT_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_VA_INT_A
  Properties
Property Value
Name ST_VA_INT_A
Schema dbo
Row Count 6686
Data Size 1816 KB
Index Size 144 KB
Create Date 8/15/2012 2:11 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
 
ADJUST_CRED_CP
numeric(17, 2)
True
False
False
 
ADJUST_CRED_CP_DT
varchar(8)
True
False
False
 
ADJUST_CRED_IS
numeric(17, 2)
True
False
False
 
ADJUST_CRED_IS_DT
varchar(8)
True
False
False
 
ADJUST_CRED_REG
numeric(17, 2)
True
False
False
 
ADJUST_CRED_REG_DT
varchar(8)
True
False
False
 
ADJUST_CRED_TC
numeric(17, 2)
True
False
False
 
ADJUST_CRED_TC_DT
varchar(8)
True
False
False
 
ADJUST_HRS_VOC
numeric(17, 2)
True
False
False
 
ADJUST_HRS_VOC_DT
varchar(8)
True
False
False
 
ADJUST_HRS_VP
numeric(17, 2)
True
False
False
 
ADJUST_HRS_VP_DT
varchar(8)
True
False
False
 
CERT_CRED_CP
numeric(17, 2)
True
False
False
 
CERT_CRED_CP_DT
varchar(8)
True
False
False
 
CERT_CRED_IS
numeric(17, 2)
True
False
False
 
CERT_CRED_IS_DT
varchar(8)
True
False
False
 
CERT_CRED_REG
numeric(17, 2)
True
False
False
 
CERT_CRED_REG_DT
varchar(8)
True
False
False
 
CERT_CRED_TC
numeric(17, 2)
True
False
False
 
CERT_CRED_TC_DT
varchar(8)
True
False
False
 
CERT_HRS_VOC
numeric(17, 2)
True
False
False
 
CERT_HRS_VOC_DT
varchar(8)
True
False
False
 
CERT_HRS_VP
numeric(17, 2)
True
False
False
 
CERT_HRS_VP_DT
varchar(8)
True
False
False
 
CNTRY
varchar(3)
True
False
False
 
CNTRY_OF_LPR
varchar(3)
True
False
False
 
CRIMINAL_CON_IND
varchar(1)
True
False
False
 
CVR_TRN_BEG_DT
varchar(8)
True
False
False
 
CVR_TRN_END_DT
varchar(8)
True
False
False
 
DROP_BELOW_FULL_CRS_RSN
varchar(2)
True
False
False
 
EDUCATION_LEVEL
varchar(2)
True
False
False
 
ELF_RCV_DT
varchar(8)
True
False
False
 
ELF_SNT_DT
varchar(8)
True
False
False
 
EMPLOYMENT_TIME
varchar(2)
True
False
False
 
EMPLOYMENT_TYPE
varchar(2)
True
False
False
 
EPR_ALT
varchar(2)
True
False
False
 
EPR_MET
varchar(1)
True
False
False
 
FOREIGN_CITY
varchar(20)
True
False
False
 
FOREIGN_CNTRY
varchar(3)
True
False
False
 
FOREIGN_STATE
varchar(20)
True
False
False
 
FOREIGN_STREET1
varchar(32)
True
False
False
 
FOREIGN_STREET2
varchar(32)
True
False
False
 
FOREIGN_ZIP_CD
varchar(9)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
I94_ENTRY_DT
varchar(8)
True
False
False
 
INS_NUMBER
varchar(20)
True
False
False
 
INSR_EXP_DT
varchar(8)
True
False
False
 
INSR_NAME
varchar(30)
True
False
False
 
INT_CAMP
varchar(5)
True
False
False
 
INT_FRST_NM
varchar(20)
True
False
False
 
INT_LST_NM
varchar(35)
True
False
False
 
INT_MDL_NM
varchar(20)
True
False
False
 
INT_STDNT_ID
varchar(9)
True
False
False
 
ISN_ST_VA_INT_A
int(10, 0)
False
False
False
 
LAST_ATTEND_DT
varchar(8)
True
False
False
 
LAST_TERM
varchar(1)
True
False
False
 
MAIL_CRED_CP_DT
varchar(8)
True
False
False
 
MAIL_CRED_IS_DT
varchar(8)
True
False
False
 
MAIL_CRED_REG_DT
varchar(8)
True
False
False
 
MAIL_CRED_TC_DT
varchar(8)
True
False
False
 
MAIL_HRS_VOC_DT
varchar(8)
True
False
False
 
MAIL_HRS_VP_DT
varchar(8)
True
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
MARITAL_ST
varchar(1)
True
False
False
 
OFF_CAMP_EMPLOY_RSN
varchar(2)
True
False
False
 
OK_OFFCMP_JOB
varchar(1)
True
False
False
 
OK_ONCMP_JOB
varchar(1)
True
False
False
 
OK_TO_REG
varchar(1)
True
False
False
 
OPT_TRN_BEG_DT
varchar(8)
True
False
False
 
OPT_TRN_END_DT
varchar(8)
True
False
False
 
PASS_EXP_DT
varchar(8)
True
False
False
 
PASS_NUMBER
varchar(20)
True
False
False
 
PORT_ENTRY
varchar(3)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SESSION_CD
varchar(4)
True
False
False
 
SESSION_CD_9COMP
varchar(4)
True
False
False
 
SEVIS_ID_NBR
varchar(11)
True
False
False
 
SPONSOR_CITY
varchar(20)
True
False
False
 
SPONSOR_CNTRY
varchar(3)
True
False
False
 
SPONSOR_NAME
varchar(30)
True
False
False
 
SPONSOR_RLTV_CD
varchar(1)
True
False
False
 
SPONSOR_STATE
varchar(2)
True
False
False
 
SPONSOR_STREET_1
varchar(32)
True
False
False
 
SPONSOR_STREET_2
varchar(32)
True
False
False
 
SPONSOR_ZIP_CD
varchar(9)
True
False
False
 
SRCE_AMT
numeric(9, 2)
True
False
False
 
SRCE_AMT_TYP
varchar(1)
True
False
False
 
SRCE_CITY
varchar(20)
True
False
False
 
SRCE_CNTRY
varchar(3)
True
False
False
 
SRCE_FUND
varchar(1)
True
False
False
 
SRCE_LETTER_DT
varchar(8)
True
False
False
 
SRCE_NAME
varchar(30)
True
False
False
 
SRCE_STATE
varchar(2)
True
False
False
 
SRCE_STREET_1
varchar(32)
True
False
False
 
SRCE_STREET_2
varchar(32)
True
False
False
 
SRCE_ZIP_CD
varchar(9)
True
False
False
 
STDNT_CREATION_RSN
varchar(1)
True
False
False
 
STDNT_TERMINATION_RSN
varchar(2)
True
False
False
 
STDNT_TY
varchar(1)
True
False
False
 
TERMINATION_DT
varchar(8)
True
False
False
 
TNF_RCV_DT
varchar(8)
True
False
False
 
TNF_SNT_DT
varchar(8)
True
False
False
 
TOEFL_DT
varchar(8)
True
False
False
 
TOEFL_SCR
int(10, 0)
True
False
False
 
TRANSFER_INST_ID
varchar(8)
True
False
False
 
TRANSMIT_IND
varchar(1)
True
False
False
 
TRM_YR
varchar(6)
True
False
False
 
TRM_YR_9COMP
varchar(6)
True
False
False
 
VA_ACAD_STATUS
varchar(2)
True
False
False
 
VA_ACDMC_STAT_CD
varchar(2)
True
False
False
 
VA_ADDTL_DOCS
varchar(1)
True
False
False
 
VA_ADV_PAY
varchar(1)
True
False
False
 
VA_APPL_FOR_BENEFITS
varchar(1)
True
False
False
 
VA_BEN_STAT_CD
varchar(2)
True
False
False
 
VA_CAMP
varchar(1)
True
False
False
 
VA_CHAPTER
varchar(4)
True
False
False
 
VA_CLAIM_NO
varchar(16)
True
False
False
 
VA_D_STDNT_ID
varchar(9)
True
False
False
 
VA_DD214
varchar(1)
True
False
False
 
VA_H_FRST_NM
varchar(20)
True
False
False
 
VA_H_LST_NM
varchar(35)
True
False
False
 
VA_H_MDL_NM
varchar(20)
True
False
False
 
VA_H_STDNT_ID
varchar(9)
True
False
False
 
VA_PGM_CD
varchar(5)
True
False
False
 
VA_PGM_CD_EFF_TERM
varchar(6)
True
False
False
 
VA_RCVD_DFRM
varchar(1)
True
False
False
 
VA_RCVD_DFRM_TERM
varchar(6)
True
False
False
 
VA_VSD_STATUS
varchar(1)
True
False
False
 
VISA_EXP_DT
varchar(8)
True
False
False
 
VISA_ISSUE_DATE
varchar(8)
True
False
False
 
VISA_ISSUE_POST
varchar(3)
True
False
False
 
VISA_TYPE
varchar(3)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_VA_INT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_VA_INT_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_VA_INT_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_VA_INT_A] Script Date: 03/09/2017 16:46:32 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_VA_INT_A](
    [ISN_ST_VA_INT_A] [int] NOT NULL,
    [INT_STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_H_STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_D_STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INT_LST_NM] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INT_FRST_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INT_MDL_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_H_LST_NM] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_H_FRST_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_H_MDL_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_CHAPTER] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_CLAIM_NO] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_ACDMC_STAT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_VSD_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_BEN_STAT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_RCVD_DFRM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_RCVD_DFRM_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_DD214] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_APPL_FOR_BENEFITS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_ADDTL_DOCS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_PGM_CD_EFF_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_ADV_PAY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_YR_9COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_ACAD_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESSION_CD] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESSION_CD_9COMP] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CERT_CRED_REG] [numeric](17, 2) NULL,
    [CERT_CRED_CP] [numeric](17, 2) NULL,
    [CERT_CRED_IS] [numeric](17, 2) NULL,
    [CERT_CRED_TC] [numeric](17, 2) NULL,
    [CERT_HRS_VOC] [numeric](17, 2) NULL,
    [CERT_HRS_VP] [numeric](17, 2) NULL,
    [CERT_CRED_REG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CERT_CRED_CP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CERT_CRED_IS_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CERT_CRED_TC_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CERT_HRS_VOC_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CERT_HRS_VP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_TERM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUST_CRED_REG] [numeric](17, 2) NULL,
    [ADJUST_CRED_CP] [numeric](17, 2) NULL,
    [ADJUST_CRED_IS] [numeric](17, 2) NULL,
    [ADJUST_CRED_TC] [numeric](17, 2) NULL,
    [ADJUST_HRS_VOC] [numeric](17, 2) NULL,
    [ADJUST_HRS_VP] [numeric](17, 2) NULL,
    [LAST_ATTEND_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUST_CRED_REG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUST_CRED_CP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUST_CRED_IS_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUST_CRED_TC_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUST_HRS_VOC_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUST_HRS_VP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAIL_CRED_REG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAIL_CRED_CP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAIL_CRED_IS_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAIL_CRED_TC_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAIL_HRS_VOC_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAIL_HRS_VP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INT_CAMP] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_EXP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INS_NUMBER] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OK_TO_REG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PASS_NUMBER] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PASS_EXP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSR_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSR_EXP_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_FUND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_LETTER_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_AMT] [numeric](9, 2) NULL,
    [SRCE_AMT_TYP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_ZIP_CD] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCE_CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPONSOR_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPONSOR_STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPONSOR_STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPONSOR_CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPONSOR_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPONSOR_ZIP_CD] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPONSOR_CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPONSOR_RLTV_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OPT_TRN_BEG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OPT_TRN_END_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CVR_TRN_BEG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CVR_TRN_END_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OK_ONCMP_JOB] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OK_OFFCMP_JOB] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TNF_SNT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TNF_RCV_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ELF_SNT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ELF_RCV_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EPR_MET] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EPR_ALT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOEFL_SCR] [int] NULL,
    [TOEFL_DT] [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,
    [MARITAL_ST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY_OF_LPR] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOREIGN_STREET1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOREIGN_STREET2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOREIGN_CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOREIGN_STATE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOREIGN_ZIP_CD] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOREIGN_CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [I94_ENTRY_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PORT_ENTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_ISSUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERMINATION_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSMIT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSFER_INST_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEVIS_ID_NBR] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRIMINAL_CON_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_ISSUE_POST] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_CREATION_RSN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_TERMINATION_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EDUCATION_LEVEL] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DROP_BELOW_FULL_CRS_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMPLOYMENT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMPLOYMENT_TIME] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OFF_CAMP_EMPLOY_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADJUST_CRED_CP_DT ADJUST_CRED_IS_DT ADJUST_CRED_REG_DT ADJUST_CRED_TC_DT ADJUST_HRS_VOC_DT ADJUST_HRS_VP_DT CERT_CRED_CP_DT CERT_CRED_IS_DT CERT_CRED_REG_DT CERT_CRED_TC_DT CERT_HRS_VOC_DT CERT_HRS_VP_DT CNTRY CNTRY_OF_LPR CRIMINAL_CON_IND CVR_TRN_BEG_DT CVR_TRN_END_DT DROP_BELOW_FULL_CRS_RSN EDUCATION_LEVEL ELF_RCV_DT ELF_SNT_DT EMPLOYMENT_TIME EMPLOYMENT_TYPE EPR_ALT EPR_MET FOREIGN_CITY FOREIGN_CNTRY FOREIGN_STATE FOREIGN_STREET1 FOREIGN_STREET2 FOREIGN_ZIP_CD HOLD I94_ENTRY_DT INS_NUMBER INSR_EXP_DT INSR_NAME INT_CAMP INT_FRST_NM INT_LST_NM INT_MDL_NM INT_STDNT_ID ISN_ST_VA_INT_A LAST_ATTEND_DT LAST_TERM MAIL_CRED_CP_DT MAIL_CRED_IS_DT MAIL_CRED_REG_DT MAIL_CRED_TC_DT MAIL_HRS_VOC_DT MAIL_HRS_VP_DT MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MARITAL_ST OFF_CAMP_EMPLOY_RSN OK_OFFCMP_JOB OK_ONCMP_JOB OK_TO_REG OPT_TRN_BEG_DT OPT_TRN_END_DT PASS_EXP_DT PASS_NUMBER PORT_ENTRY RowUpdatedOn SESSION_CD SESSION_CD_9COMP SEVIS_ID_NBR SPONSOR_CITY SPONSOR_CNTRY SPONSOR_NAME SPONSOR_RLTV_CD SPONSOR_STATE SPONSOR_STREET_1 SPONSOR_STREET_2 SPONSOR_ZIP_CD SRCE_AMT SRCE_AMT_TYP SRCE_CITY SRCE_CNTRY SRCE_FUND SRCE_LETTER_DT SRCE_NAME SRCE_STATE SRCE_STREET_1 SRCE_STREET_2 SRCE_ZIP_CD STDNT_CREATION_RSN STDNT_TERMINATION_RSN STDNT_TY TERMINATION_DT TNF_RCV_DT TNF_SNT_DT TOEFL_DT TRANSFER_INST_ID TRANSMIT_IND TRM_YR TRM_YR_9COMP VA_ACAD_STATUS VA_ACDMC_STAT_CD VA_ADDTL_DOCS VA_ADV_PAY VA_APPL_FOR_BENEFITS VA_BEN_STAT_CD VA_CAMP VA_CHAPTER VA_CLAIM_NO VA_D_STDNT_ID VA_DD214 VA_H_FRST_NM VA_H_LST_NM VA_H_MDL_NM VA_H_STDNT_ID VA_PGM_CD VA_PGM_CD_EFF_TERM VA_RCVD_DFRM VA_RCVD_DFRM_TERM VA_VSD_STATUS VISA_EXP_DT VISA_ISSUE_DATE VISA_ISSUE_POST VISA_TYPE
20040205 STA010N1 1440446 E009586 N 1440446 1 RASHAWN JOHNSON D R07262470 2402 S N N N 2017-02-06T11:23:20.791-05:00 P D N F1
CO N 1435007 1 ALBERT STERLING A11184694 775 20020913 STS541N0 1435007 FLABORDE S N Y N 2017-02-06T11:23:20.276-05:00 US MARIA STERLIND M 4363 S.W. 10TH PLACE #205 DEERFIELD BEACH, FL 33442 16000.00 US P 20000522 MARIA C. STERLING 4363 S.W. 10TH PLACE #205 DEERFIELD BEACH, FL 33442 N F1
20140325 STS531N0 1555370 E088197 1549196 4964 20151207 STS531N0 1549196 E019000 2017-02-06T11:23:21.509-05:00 N N Y RC 1 33 592764635 Y CURTISS HODGES R C12561122 B217 20162 V
20080221 STA010N1 1304152 E000622 DE N HANNOVER DE NIEDERSACHSEN ROSENROTWEG 14 30179 1538128 20080723 253415169 11 20100819 IFS 1 MARC FRITZ OLIVER M12818811 3130 20090624 STS541N0 1538128 E014159 S N N Y 20110824 150031077 2017-02-06T11:23:21.01-05:00 N0005214666 30179 HANNOVER DE WILFRIED FRITZ (ONLY FAX#) U ROSENROTWEG 14 17000.00 FT. LAUDERDALE US A 20080220 WACHOVIA BANK FL 3300 N. FEDERAL HIGHWAY 33306 D 20100510 N 20130609 20080610 F1
20080723 STA010N1 0909279 E000622 IT N GENOVA IT VIA BOBBIO 4/9 16137 935253 1 LAURA MUNOZ-HERNANDEZ JULIETTE L12985313 3297 20090306 STS541N0 0935253 E014159 S N N N 20150622 D835183 2017-02-06T11:23:21.041-05:00 P D N F1
20130913 STS531N0 0946379 E089251 857199 4731 20131008 STS531N0 0857199 E089251 2017-02-06T11:23:21.462-05:00 N N Y RC 2 33 348822186 Y LYDIA BUTLER MARIE L14220065 V
20050829 STS541N0 1619500 E025025 LC N MON REPOS LC MICOUD FREEDOM STREET 01758 828549 20051229 559123346 06 20060822 INSURANCE FOR STUDENTS 1 OCTAVIAN WILSON O12162376 2770 20060906 STS541N0 0828549 E002634 S N N N 20090503 103362 2017-02-06T11:23:20.9-05:00 N0003000757 CASTRIES, ST. LUCIA LC ROBERT AUGUSTIN U ENTREPOT 17000.00 LC A 20051020 BANK CARIBBEAN LIMITED D N 20090105 20051214 F1
BH N 1450296 1 CAMERON WELLS RANDOLPH C11367653 922 20020709 STS541N0 1450296 LDELANCY S N N N 2017-02-06T11:23:20.308-05:00 42728.00 BAHAMAS BS P 20010719 HAZEL IDELLA WELLS P.O. BOX SS-6927 NASSAU D N F1
20060724 STA010N1 1600591 E003003 SE N 1600591 1 JOHANNA SCHWENDINGER J12394011 2862 20061107 STS815N1 1047324 E025947 S N N N 2017-02-06T11:23:20.916-05:00 P D N F1
20090415 STS541N0 1017201 E014159 CO N CALI CO VALLE AV. 2EN #52AN 07 937012 20070616 775220380 20120501 HORIZON BLUE CROSS-BLUE SHIELD 2 MAURICIO RIVERA M12736161 2247 20110412 STS541N0 0937012 E014159 S N N Y 20180411 CC1127237694 2017-02-06T11:23:20.76-05:00 N0005454788 PALM BEACH US WALTER A. NALBANDIAN FL 11703 SAN SOVINO COURT 33418 17000.00 US P 20090413 BANK OF AMERICA D 20110509 N 20090915 20080916 F1
Powered by BI Documenter