DWStaging
 dbo.ST_FACTS_APPL_A (Table)
  Properties
Property Value
Name ST_FACTS_APPL_A
Schema dbo
Row Count 17417
Data Size 6448 KB
Index Size 304 KB
Create Date 2/13/2017 3:59 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACTIVE_DUTY
bit(1, 0)
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
 
AFTER_0911
bit(1, 0)
True
False
False
 
ALIEN_DATE
varchar(8)
True
False
False
 
ALIEN_NBR
varchar(30)
True
False
False
 
ALIEN_NUM
varchar(30)
True
False
False
 
APP_LOGON
varchar(40)
True
False
False
 
APP_PASSWORD
varchar(16)
True
False
False
 
APPEND
varchar(4)
True
False
False
 
APPLICATION_TYPE
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
 
CONFIRMATION_NBR
varchar(23)
True
False
False
 
CONVERSATION_ID
varchar(16)
True
False
False
 
DISAB_CD
varchar(1)
True
False
False
 
DISCIPLINE_FLAG
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
 
EMAIL_ADDR
varchar(80)
True
False
False
 
EMER_FRST_NM
varchar(25)
True
False
False
 
EMER_HM_PHN
varchar(25)
True
False
False
 
EMER_LST_NM
varchar(25)
True
False
False
 
EMER_MDL_NM
varchar(25)
True
False
False
 
EMER_RLTV_CD
varchar(2)
True
False
False
 
EMER_WRK_PHN
varchar(25)
True
False
False
 
EMPLOYMENT_STATUS
varchar(1)
True
False
False
 
ENROLLMENT_INTENT
varchar(2)
True
False
False
 
ENROLLMENT_PLAN_DATE
varchar(6)
True
False
False
 
ENROLLMENT_TERM
varchar(6)
True
False
False
 
ETHNICITY
varchar(1)
True
False
False
 
FAX_NUM
varchar(25)
True
False
False
 
FMLY_HIST_FLG
varchar(1)
True
False
False
 
FRST_NM
varchar(25)
True
False
False
 
GED_LANGUAGE
varchar(2)
True
False
False
 
HM_PHN
varchar(25)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HS_CITY
varchar(30)
True
False
False
 
HS_COUNTRY
varchar(3)
True
False
False
 
HS_GRAD_DT
varchar(6)
True
False
False
 
HS_GRAD_TYPE
varchar(3)
True
False
False
 
HS_INST_ID
varchar(8)
True
False
False
 
HS_INST_NM
varchar(50)
True
False
False
 
HS_STATE
varchar(2)
True
False
False
 
HS_STATE_PROVINCE
varchar(35)
True
False
False
 
IMMIG_STAT
varchar(1)
True
False
False
 
ISN_ST_FACTS_APPL_A
int(10, 0)
False
False
False
 
LICENSE_DATE
varchar(8)
True
False
False
 
LICENSE_NBR
varchar(30)
True
False
False
 
LICENSE_STATE
varchar(2)
True
False
False
 
LST_NM
varchar(35)
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
 
MDL_NM
varchar(25)
True
False
False
 
PGM_CD
varchar(5)
True
False
False
 
PRIM_LANG
varchar(2)
True
False
False
 
RECORD_SOURCE_IND
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(25)
True
False
False
 
RES_LST_NM
varchar(35)
True
False
False
 
RES_MDL_NM
varchar(25)
True
False
False
 
RES_PHONE
varchar(25)
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
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SALUTATION
varchar(3)
True
False
False
 
SECURITY_ANSWER
varchar(40)
True
False
False
 
SECURITY_QUESTION
varchar(2)
True
False
False
 
SEX
varchar(1)
True
False
False
 
STDNT_TY
varchar(1)
True
False
False
 
STUDENT_SSN
varchar(9)
True
False
False
 
US_VETERAN
bit(1, 0)
True
False
False
 
VA_EDUCATIONAL_BENEFITS
bit(1, 0)
True
False
False
 
VEHICLE_DATE
varchar(8)
True
False
False
 
VEHICLE_NBR
varchar(30)
True
False
False
 
VEHICLE_STATE
varchar(2)
True
False
False
 
VIOLATION_FLAG
varchar(1)
True
False
False
 
VISA_EXPIRY_DATE
varchar(8)
True
False
False
 
VISA_ISSUE_DATE
varchar(8)
True
False
False
 
VISA_TYPE
varchar(7)
True
False
False
 
VOTER_COUNTY
varchar(2)
True
False
False
 
VOTER_DATE
varchar(8)
True
False
False
 
VOTER_NBR
varchar(30)
True
False
False
 
VOTER_STATE
varchar(2)
True
False
False
 
WRK_PHN
varchar(25)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_FACTS_APPL_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_FACTS_APPL_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_FACTS_APPL_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_FACTS_APPL_A] Script Date: 03/09/2017 16:46:07 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_FACTS_APPL_A](
    [ISN_ST_FACTS_APPL_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,
    [RECORD_SOURCE_IND] [varchar](1) 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,
    [APPLICATION_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APP_LOGON] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APP_PASSWORD] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SECURITY_QUESTION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SECURITY_ANSWER] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONFIRMATION_NBR] [varchar](23) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALUTATION] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LST_NM] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FRST_NM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MDL_NM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPEND] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY_BIRTH] [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,
    [ETHNICITY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HM_PHN] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WRK_PHN] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FAX_NUM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_ADDR] [varchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_LST_NM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_FRST_NM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_MDL_NM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_RLTV_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_HM_PHN] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMER_WRK_PHN] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIM_LANG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENROLLMENT_PLAN_DATE] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENROLLMENT_INTENT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENROLLMENT_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP_PREF] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_GRAD_DT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_INST_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_INST_NM] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_CITY] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_STATE_PROVINCE] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_COUNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_GRAD_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GED_LANGUAGE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISCIPLINE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VIOLATION_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [IMMIG_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_ST_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,
    [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](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_MDL_NM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_PHONE] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VOTER_NBR] [varchar](30) 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](30) 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](30) 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](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIEN_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONVERSATION_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_TYPE] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_ISSUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_EXPIRY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIEN_NUM] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISAB_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CNTY_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FMLY_HIST_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVE_DUTY] [bit] NULL,
    [US_VETERAN] [bit] NULL,
    [AFTER_0911] [bit] NULL,
    [VA_EDUCATIONAL_BENEFITS] [bit] NULL,
    [EMPLOYMENT_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EDUC_LVL] [varchar](2) 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
ACTIVE_DUTY ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AFTER_0911 ALIEN_DATE ALIEN_NBR ALIEN_NUM APP_LOGON APP_PASSWORD APPEND APPLICATION_TYPE BASIS_RESIDENCY CAMP_PREF CNTRY_BIRTH CONFIRMATION_NBR CONVERSATION_ID DISAB_CD DISCIPLINE_FLAG DOB ED_LVL_PARENT_GUARDIAN_1 ED_LVL_PARENT_GUARDIAN_2 EDUC_LVL EMAIL_ADDR EMER_FRST_NM EMER_HM_PHN EMER_LST_NM EMER_MDL_NM EMER_RLTV_CD EMER_WRK_PHN EMPLOYMENT_STATUS ENROLLMENT_INTENT ENROLLMENT_PLAN_DATE ENROLLMENT_TERM ETHNICITY FAX_NUM FMLY_HIST_FLG FRST_NM GED_LANGUAGE HM_PHN HOLD HS_CITY HS_COUNTRY HS_GRAD_DT HS_GRAD_TYPE HS_INST_ID HS_INST_NM HS_STATE HS_STATE_PROVINCE IMMIG_STAT ISN_ST_FACTS_APPL_A LICENSE_DATE LICENSE_NBR LICENSE_STATE LST_NM MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MDL_NM PGM_CD PRIM_LANG RECORD_SOURCE_IND 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 RowUpdatedOn SALUTATION SECURITY_ANSWER SECURITY_QUESTION SEX STDNT_TY STUDENT_SSN US_VETERAN VA_EDUCATIONAL_BENEFITS VEHICLE_DATE VEHICLE_NBR VEHICLE_STATE VIOLATION_FLAG VISA_EXPIRY_DATE VISA_ISSUE_DATE VISA_TYPE VOTER_COUNTY VOTER_DATE VOTER_NBR VOTER_STATE WRK_PHN
false 20120316 STA061N0 1950003 WEB5 false AMARINO267@UFL.EDU Beach7 C 1 US 19930727 amarino267@ufl.edu Carmine Marino 561 753 3176 F 561 313 7134 ND 20123 N 561 758 6993 Angelica 561 753 3176 1950003 West Palm Beach US H 101844 Palm Beach Central High School FL C 3240 Marino Nicole 3409 EN W US Carmine Marino Louis (561) 313 7134 F FL Y 2017-02-13T16:00:10.603-05:00 Pistachio 11 F 900778986 false false
false 20110915 STA061N0 1410218 WEB5 false CCULMAM@YAHOO.COM JESUS1 1 CO 19680702 cculmam@yahoo.com I CC 20122 H 5613744481 MARY 1410218 US C 824 CULMA SP W US 2017-02-13T16:00:10.072-05:00 MRS TAMAL 09 F 900766549 false false
false 20111216 STA061N0 0025587 WEB5 false ANGIEANGEL1443@YAHOO.COM GELLA1 5 JM ANGIEANGEL1443@YAHOO.COM I CC 20122 X GWENNETH 954-899-6553 2327543 US 2146 WHITE 20120107 STA061N0 2327543 WEB5 EN W US 2017-02-13T16:00:10.369-05:00 MS HAYNES 01 F false false
false 20150803 STA061N0 0857368 WEB5 false 076987045 GELADELAI@GMAIL.COM nico15 5 BR 19660416 geladelai@gmail.com AA 20162 H 5613037822 N Angela 5613725611 857368 US P 12327 Delai PO W BR 2017-02-13T16:00:12.865-05:00 guarana 10 F 900473266 false false
false 20121025 STA061N0 1616066 WEB5 false none BRITTANYDWYER0@GMAIL.COM 123456 1 US 19940331 brittanydwyer0@gmail.com I AA 20131 N 17736801672 Y Brittany 7733631942 1616066 US X 5178 dwyer Michelle W US 2017-02-13T16:00:11.071-05:00 MRS 123456 04 F 900800640 false false 20151003 20121004 7736552128
false 20141012 STA061N0 1658019 WEB5 false POETRYLADY23@GMAIL.COM Loveu2 1 poetrylady23@gmail.com CC 20151 X 1659359 US 11110 20141012 STA061N0 1659359 WEB5 W 2017-02-13T16:00:12.6-05:00 muffy 04 U false false
false 20140523 STA061N0 1638397 WEB5 false 088474125 ALESSANDRA.LEAO@AOL.COM leaolo 5 BR 19750622 alessandra.leao@aol.com I NC 20143 H 5618390638 N alessandra 1643188 US P 9063 leaoshebes 20140523 STA061N0 1643188 WEB5 PO W US 2017-02-13T16:00:12.116-05:00 MS dog 04 F 714190360 false false
false 20161223 STA061N0 2212472 WEB5 false LLUCIANO.CO77@GMAIL.COM asdfgh 2 lluciano.co77@gmail.com BA 20181 X 2212472 US 17272 W 2017-02-13T16:00:14.191-05:00 coco 04 U false false
false 20130426 STA061N0 1147556 WEB5 false ABOVEAVERAGE95@YAHOO.COM marie9 2 US 19950518 aboveaverage95@yahoo.com Adina Jackson 8564575813 I 8569829930 AA 20141 X 8569829930 Y Adina 8564575813 1147556 vineland US 201306 H ZZ9996 vineland highschool NJ C 7054 Jackson EN W US 2017-02-13T16:00:11.617-05:00 MS cinnamon 04 F 278982418 false false
false 20111205 STA061N0 1633526 WEB5 false ECUOCO44@YAHOO.COM ericke 5 US 19910617 ecuoco44@yahoo.com Ellen Cuoco 727-288-6611 I ND 20122 N 727-288-7802 Y Erick 1633526 Saint Petersburg US 200906 H ZZ9996 Lakewood FL C 1946 Cuoco E. 3409 W US Y 2017-02-13T16:00:10.306-05:00 MR roxy 04 M 900803708 false false
Powered by BI Documenter