DWStaging
 dbo.AR_FLPREPAID_MATRICULATION_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.AR_FLPREPAID_MATRICULATION_A
  Properties
Property Value
Name AR_FLPREPAID_MATRICULATION_A
Schema dbo
Row Count 15655
Data Size 2736 KB
Index Size 280 KB
Create Date 2/13/2013 10:46 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCOUNT_NUMBER
numeric(17, 0)
True
False
False
 
ACCOUNT_STATUS
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
 
COMM_COLL_HOURS_AVAILABLE
int(10, 0)
True
False
False
 
CONTRACT_YEAR
int(10, 0)
True
False
False
 
DELINQUENT_STATUS
varchar(5)
True
False
False
 
DORM_CONTRACT_YEAR
int(10, 0)
True
False
False
 
DORM_SEMESTERS_AVAILABLE
int(10, 0)
True
False
False
 
DORM_TUITION_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AR_FLPREPAID_MATRICULATION_A
int(10, 0)
False
False
False
 
LAST_TERM_PAID
varchar(6)
True
False
False
 
LAST_YEAR_PAID
int(10, 0)
True
False
False
 
LOC_COMM_COLL_HOURS_AVAILABLE
int(10, 0)
True
False
False
 
LOC_UNIV_HOURS_AVAILABLE
int(10, 0)
True
False
False
 
LOCAL_CONTRACT_YEAR
int(10, 0)
True
False
False
 
LOCAL_IND
varchar(1)
True
False
False
 
LOCAL_UPPER_DIV_HRS_AVAIL
int(10, 0)
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
 
MATRIC_CURR_YEAR
int(10, 0)
True
False
False
 
RECORD_STATUS
varchar(2)
True
False
False
 
RECORD_STATUS_DATE
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STARS_IND
int(10, 0)
True
False
False
 
STUDENT_ADDRESS
varchar(35)
True
False
False
 
STUDENT_CITY
varchar(25)
True
False
False
 
STUDENT_FNAME
varchar(15)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
STUDENT_LNAME
varchar(25)
True
False
False
 
STUDENT_STATE
varchar(2)
True
False
False
 
STUDENT_ZIP
int(10, 0)
True
False
False
 
TDF_CONTRACT_YEAR
int(10, 0)
True
False
False
 
TDF_INDICATOR
varchar(1)
True
False
False
 
TDF_UNIV_HRS_AVAIL
int(10, 0)
True
False
False
 
TUIT_PLAN_TYPE
varchar(2)
True
False
False
 
TUITION_UPPER_DIV_HRS_AVAIL
int(10, 0)
True
False
False
 
UNIV_HOURS_AVAILABLE
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_FLPREPAID_MATRICULATION_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_FLPREPAID_MATRICULATION_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AR_FLPREPAID_MATRICULATION_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_FLPREPAID_MATRICULATION_A] Script Date: 03/09/2017 16:45:00 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_FLPREPAID_MATRICULATION_A](
    [ISN_AR_FLPREPAID_MATRICULATION_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,
    [DORM_TUITION_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DELINQUENT_STATUS] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MATRIC_CURR_YEAR] [int] NULL,
    [COMM_COLL_HOURS_AVAILABLE] [int] NULL,
    [UNIV_HOURS_AVAILABLE] [int] NULL,
    [LOCAL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOC_COMM_COLL_HOURS_AVAILABLE] [int] NULL,
    [LOC_UNIV_HOURS_AVAILABLE] [int] NULL,
    [STUDENT_FNAME] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_LNAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ADDRESS] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_CITY] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ZIP] [int] NULL,
    [TUIT_PLAN_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_NUMBER] [numeric](17, 0) NULL,
    [DORM_SEMESTERS_AVAILABLE] [int] NULL,
    [LAST_YEAR_PAID] [int] NULL,
    [LAST_TERM_PAID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_YEAR] [int] NULL,
    [TDF_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TDF_UNIV_HRS_AVAIL] [int] NULL,
    [STARS_IND] [int] NULL,
    [DORM_CONTRACT_YEAR] [int] NULL,
    [LOCAL_CONTRACT_YEAR] [int] NULL,
    [TDF_CONTRACT_YEAR] [int] NULL,
    [TUITION_UPPER_DIV_HRS_AVAIL] [int] NULL,
    [LOCAL_UPPER_DIV_HRS_AVAIL] [int] NULL,
    [RECORD_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECORD_STATUS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCOUNT_NUMBER ACCOUNT_STATUS ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID COMM_COLL_HOURS_AVAILABLE CONTRACT_YEAR DELINQUENT_STATUS DORM_CONTRACT_YEAR DORM_TUITION_IND HOLD ISN_AR_FLPREPAID_MATRICULATION_A LAST_TERM_PAID LAST_YEAR_PAID LOC_COMM_COLL_HOURS_AVAILABLE LOC_UNIV_HOURS_AVAILABLE LOCAL_CONTRACT_YEAR LOCAL_IND LOCAL_UPPER_DIV_HRS_AVAIL MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MATRIC_CURR_YEAR RECORD_STATUS RECORD_STATUS_DATE RowUpdatedOn STARS_IND STUDENT_ADDRESS STUDENT_CITY STUDENT_FNAME STUDENT_ID STUDENT_LNAME STUDENT_STATE STUDENT_ZIP TDF_CONTRACT_YEAR TDF_INDICATOR TDF_UNIV_HRS_AVAIL TUIT_PLAN_TYPE TUITION_UPPER_DIV_HRS_AVAIL UNIV_HOURS_AVAILABLE
1024898607 F 20170111 FIC860N0 0151073 OPER2 25 2002 CLEAR 2002 T 151073 1905 FALL 2013 2008 AC 20170111 2017-02-06T11:21:00.843-05:00 16526 NW 16TH ST PEMBROKE PINES BOBBY B11720711 MARIUS FL 33028 01 21 20
1035643424 F 20170111 FIC860N0 0215119 OPER2 132 2003 CLEAR T 215119 8138 FALL 2016 2016 AC 20170111 2017-02-06T11:21:01.732-05:00 6088 EAGLES NEST DR JUPITER JOSHUA J15267727 CONNELL FL 33458 01 114 107
1014672572 F 20170111 FIC860N0 0216560 OPER2 83 2001 CLEAR T 216560 8637 FALL 2014 2009 AC 20170111 2017-02-06T11:21:01.826-05:00 4330 122ND DR N WEST PALM BEACH KELLY K13539556 GEBHART FL 33411 03 72 67
1942009256 F 20170111 FIC860N0 0221507 OPER2 54 1994 CLEAR T 221507 9975 SUM-A 2015 184 55 2008 L 159 2012 AC 20170111 2017-02-06T11:21:01.997-05:00 7347 COPPERFIELD CIR LAKE WORTH MATHEW M07953136 PURVIS FL 33467 03 47 44
1983228418 F 20170111 FIC860N0 0202329 OPER2 137 1998 CLEAR T 202329 4813 SPRING 2016 2015 AC 20170111 2017-02-06T11:21:01.248-05:00 17 HARBOR DR KEY LARGO DIRK D15144454 SMITS JR FL 33037 01 119 111
3035687082 F 20170111 FIC860N0 0155469 OPER2 46 2003 CLEAR 2014 T 155469 3025 FALL 2016 2009 AC 20170111 2017-02-06T11:21:00.983-05:00 1 434 HASTINGS ST BOCA RATON CHERLYN C13258603 ROSEMEY FL 33487 03 40 37
3097166028 F 20170111 FIC860N0 0229411 OPER2 88 2009 CLEAR T 229411 11926 FALL 2016 2015 AC 20170111 2017-02-06T11:21:02.294-05:00 1 5385 ADAMS ROAD DELRAY BEACH NOAH N14945711 KUSHNER FL 33484 03 76 71
1014799243 F 20170111 FIC860N0 0224397 OPER2 39 2001 CLEAR T 224397 10503 FALL 2016 2012 AC 20170111 2017-02-06T11:21:02.122-05:00 131 6TH ST JUPITER MADISON M13924634 OETKEN FL 33458 01 34 32
1115300348 F 20170111 FIC860N0 0229296 OPER2 142 2013 CLEAR T 229296 11861 FALL 2016 142 76 2013 L 124 2015 AC 20170111 2017-02-06T11:21:02.294-05:00 3177 SANTA MARGARITA RD WEST PALM BEACH NATHAN N14704456 CALLAHAN FL 33411 2013 F 76 01 124 76
1942152668 F 20170111 FIC860N0 0209501 OPER2 4 1994 CLEAR T 209501 6729 FALL 2014 2009 AC 20170111 2017-02-06T11:21:01.529-05:00 14256 GREENTREE TRL WELLINGTON JAMES J13224597 DOWNEY FL 33414 01 3 3
Powered by BI Documenter