DWStaging
 dbo.IT_TUITION_PAYMENT_PLAN_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.IT_TUITION_PAYMENT_PLAN_A
  Properties
Property Value
Name IT_TUITION_PAYMENT_PLAN_A
Schema dbo
Row Count 38949
Data Size 7424 KB
Index Size 608 KB
Create Date 11/7/2012 11:53 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCOUNT_STATUS
varchar(2)
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
 
ADJUSTED_AMT
numeric(17, 2)
True
False
False
 
AGREEMENT_NBR
varchar(6)
True
False
False
 
BILL_PAYER_CITY
varchar(20)
True
False
False
 
BILL_PAYER_COUNTRY
varchar(3)
True
False
False
 
BILL_PAYER_STATE
varchar(2)
True
False
False
 
BILL_PAYER_STREET_1
varchar(32)
True
False
False
 
BILL_PAYER_STREET_2
varchar(32)
True
False
False
 
BILL_PAYER_ZIP_CD
varchar(11)
True
False
False
 
CONTRACT_AMT
numeric(17, 2)
True
False
False
 
CONVENIENCE_FEE
numeric(17, 2)
True
False
False
 
EMAIL_ADDRESS
varchar(40)
True
False
False
 
FIRST_NAME
varchar(20)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_IT_TUITION_PAYMENT_PLAN_A
int(10, 0)
False
False
False
 
LAST_NAME
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
 
MIDDLE_NAME
varchar(20)
True
False
False
 
NON_GUARANTEE_FLAG
varchar(1)
True
False
False
 
ORIGINAL_CONTRACT_AMT
numeric(17, 2)
True
False
False
 
PLAN_CHANGE_IND
varchar(1)
True
False
False
 
PLAN_ID
varchar(6)
True
False
False
 
PLAN_TYPE
varchar(2)
True
False
False
 
REACTIVE_FLAG
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
STUDENT_SSN
varchar(9)
True
False
False
 
TUITION_TERM
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_IT_TUITION_PAYMENT_PLAN_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.IT_TUITION_PAYMENT_PLAN_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.IT_TUITION_PAYMENT_PLAN_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[IT_TUITION_PAYMENT_PLAN_A] Script Date: 03/09/2017 16:45:41 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IT_TUITION_PAYMENT_PLAN_A](
    [ISN_IT_TUITION_PAYMENT_PLAN_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,
    [TUITION_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [PLAN_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORIGINAL_CONTRACT_AMT] [numeric](17, 2) NULL,
    [CONTRACT_AMT] [numeric](17, 2) NULL,
    [ADJUSTED_AMT] [numeric](17, 2) NULL,
    [PLAN_CHANGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_NAME] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRST_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIDDLE_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_PAYER_STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_PAYER_STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_PAYER_CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_PAYER_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_PAYER_ZIP_CD] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_PAYER_COUNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_ADDRESS] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONVENIENCE_FEE] [numeric](17, 2) NULL,
    [NON_GUARANTEE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REACTIVE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PLAN_ID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AGREEMENT_NBR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCOUNT_STATUS ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AGREEMENT_NBR BILL_PAYER_CITY BILL_PAYER_COUNTRY BILL_PAYER_STATE BILL_PAYER_STREET_1 BILL_PAYER_STREET_2 BILL_PAYER_ZIP_CD CONTRACT_AMT EMAIL_ADDRESS FIRST_NAME HOLD ISN_IT_TUITION_PAYMENT_PLAN_A LAST_NAME MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MIDDLE_NAME NON_GUARANTEE_FLAG ORIGINAL_CONTRACT_AMT PLAN_CHANGE_IND PLAN_ID PLAN_TYPE REACTIVE_FLAG RowUpdatedOn STUDENT_ID STUDENT_SSN TUITION_TERM
AC 20120718 FIC840N1 2051449 WEB5 6CB662 1483.75 ARMAX000@HOTMAIL.COM ANDREW 1610000 14367 RODRIGUEZ 20130206 FIC850B2 1357344 E031488 MAXIM 1483.75 NELNET TU 2017-02-06T11:21:24.305-05:00 A13698907 900729739 20131
AC 20150324 FIC840N1 2309246 WEB5 7RDH05 403.00 SOUTHERN2BEAUTY@AOL.COM ROCHELLE 1144175 27405 WEBSTER 20150522 FIC840N1 1144175 E031488 MONIQUE N 403.00 NELNET TU 2017-02-06T11:21:25.663-05:00 R13714910 900731403 20153
AC 20161226 FIC840N1 1820280 STUDENT 8SWP12 616.00 KDEISMA@YAHOO.COM KETTY 1727361 38518 DEISMA 20170110 FIC840N1 1727361 E031488 N 616.00 NELNET TU 2017-02-06T11:21:26.708-05:00 K14585160 900826225 20172
AC 20150101 FIC840N1 1306095 WEB5 7MXV41 671.50 CFARAH@ME.COM CHRISTIE 1508558 26915 FARAH 20150112 FIC840N1 1508558 E031488 N 671.50 NELNET TU 2017-02-06T11:21:25.616-05:00 C14802169 900846868 20152
20161205 FIC840N1 2046125 WEB5 8TF479 BOYNTON BEACH US FL 5289 815 CEADER LAKE RD 33437 1484.00 FABERAS@MY.PALMBEACHSTATE.EDU ALEXIS 1720303 37563 FABER 20170110 FIC850B2 1735147 E031488 S N 742.00 G NELNET TU 2017-02-06T11:21:26.614-05:00 A15195845 900886434 20172
AC 20150820 FIC840N1 1920206 WEB5 7ZCG12 661.00 NATALEG@YAHOO.COM GINA 1303068 30706 NATALE 20150826 FIC840N1 1303068 E031488 TERESE N 661.00 NELNET TU 2017-02-06T11:21:25.959-05:00 G07334568 900758027 20161
AC 20091027 FIC843B2 1034544 OPER2 BOYNTON BEACH FL 2303 N CONGRESS AV #33 33426 LEEZS@MY.PBCC.EDU ZACHARY 1020447 5577 LEE S N 822.50 AMS TU 2017-02-06T11:21:23.541-05:00 Z12812004 900605647 20101
AC 20140806 FIC840N1 0903144 WEB5 7GY025 1046.00 JTRYANKEE8@AOL.COM CARA 1150022 23997 FARLEY 20140827 FIC840N1 1150022 E031488 CHRISTINE N 1046.00 NELNET TU 2017-02-06T11:21:25.304-05:00 C14224190 900790719 20151
AC 20150810 FIC840N1 1214041 WEB5 7XN394 1158.41 NGUYENMATTHEW97@YAHOO.COM TANDAT 1303292 29913 NGUYEN 20150826 FIC840N1 1303292 E031488 MATHEW N 1158.41 NELNET TU 2017-02-06T11:21:25.881-05:00 T14634455 900831273 20161
AC 20131206 FIC840N1 2150507 WEB5 6WK534 634.50 NAIKAA@ME.COM NAIKA 1339388 21499 ESTRIPLET 20140109 FIC840N1 1339388 E031488 C N 634.50 NELNET TU 2017-02-06T11:21:25.039-05:00 N13027222 900667406 20142
Powered by BI Documenter