DWStaging
 dbo.AR_CONDITIONS_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_CONDITIONS_A
  Properties
Property Value
Name AR_CONDITIONS_A
Schema dbo
Row Count 1276460
Data Size 185848 KB
Index Size 19072 KB
Create Date 11/7/2012 8:27 AM
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
 
ALLOW_UPPER_BACKLOR_LEVEL_CLS
varchar(1)
True
False
False
 
COMMENT_IND
varchar(1)
True
False
False
 
CONDITION_AFTER
varchar(1)
True
False
False
 
CONDITION_BEGIN_DATE
varchar(8)
True
False
False
 
CONDITION_END_DATE
varchar(8)
True
False
False
 
CONDITION_HOURS
int(10, 0)
True
False
False
 
CONDITION_PER
varchar(1)
True
False
False
 
CONDITION_TYPE
varchar(2)
True
False
False
 
CONTRACT_ID
int(10, 0)
True
False
False
 
CONTRACT_STUDENT_FLAG
varchar(1)
True
False
False
 
CREDIT_HOUR_LIMIT
int(10, 0)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
FEE_INCLUDE_EXCLUDE_FLAG
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INCLUDE_EXCLUDE_PARTIAL_CREDITS
varchar(1)
True
False
False
 
ISN_AR_CONDITIONS_A
int(10, 0)
False
False
False
 
LOCK_DATE
varchar(8)
True
False
False
 
LOCK_IND
varchar(1)
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
 
MAX_AMT
numeric(17, 2)
True
False
False
 
MAX_AMT_PER_CREDIT_HR
numeric(17, 2)
True
False
False
 
MAX_SPECIAL_COURSE_FEES
numeric(17, 2)
True
False
False
 
PAY_TERM_FEES
bit(1, 0)
True
False
False
 
PERCENT_COVERAGE
numeric(17, 4)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SESSION_KEY
varchar(10)
True
False
False
 
STDNT_MIN_AMT_BEFORE_COVERAGE
numeric(17, 2)
True
False
False
 
STDNT_PAYS_FIRST_HOURS
int(10, 0)
True
False
False
 
STDNT_PAYS_HOURS_PER_CRS
int(10, 0)
True
False
False
 
STUDENT_AFTER
varchar(1)
True
False
False
 
STUDENT_HOURS
int(10, 0)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
STUDENT_PER
varchar(1)
True
False
False
 
STUDENT_SEQ
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_CONDITIONS_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_CONDITIONS_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AR_CONDITIONS_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_CONDITIONS_A] Script Date: 03/09/2017 16:44:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_CONDITIONS_A](
    [ISN_AR_CONDITIONS_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,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_ID] [int] NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_SEQ] [int] NULL,
    [CONTRACT_STUDENT_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONDITION_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOCK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOCK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESSION_KEY] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONDITION_BEGIN_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONDITION_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_AMT] [numeric](17, 2) NULL,
    [PERCENT_COVERAGE] [numeric](17, 4) NULL,
    [CREDIT_HOUR_LIMIT] [int] NULL,
    [STDNT_PAYS_HOURS_PER_CRS] [int] NULL,
    [STDNT_PAYS_FIRST_HOURS] [int] NULL,
    [FEE_INCLUDE_EXCLUDE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_HOURS] [int] NULL,
    [STUDENT_PER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_AFTER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONDITION_HOURS] [int] NULL,
    [CONDITION_PER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONDITION_AFTER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_TERM_FEES] [bit] NULL,
    [MAX_AMT_PER_CREDIT_HR] [numeric](17, 2) NULL,
    [STDNT_MIN_AMT_BEFORE_COVERAGE] [numeric](17, 2) NULL,
    [MAX_SPECIAL_COURSE_FEES] [numeric](17, 2) NULL,
    [INCLUDE_EXCLUDE_PARTIAL_CREDITS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALLOW_UPPER_BACKLOR_LEVEL_CLS] [varchar](1) 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 ALLOW_UPPER_BACKLOR_LEVEL_CLS COMMENT_IND CONDITION_AFTER CONDITION_BEGIN_DATE CONDITION_END_DATE CONDITION_PER CONDITION_TYPE CONTRACT_ID CONTRACT_STUDENT_FLAG CREDIT_HOUR_LIMIT CUSTOMER_ID FEE_INCLUDE_EXCLUDE_FLAG HOLD INCLUDE_EXCLUDE_PARTIAL_CREDITS ISN_AR_CONDITIONS_A LOCK_DATE LOCK_IND MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAX_AMT PAY_TERM_FEES PERCENT_COVERAGE RowUpdatedOn SESSION_KEY STUDENT_AFTER STUDENT_ID STUDENT_PER STUDENT_SEQ
20150911 FIC402N1 0413579 OPER2 20150821 20151217 FI 1 S A14801690 413579 1132384 727.00 true 2017-02-06T10:04:22.994-05:00 20161 1 A14801690 1
20040803 FIC402N1 0446540 OPER2 20040823 20041217 FI 16 S 000000035 101004 199556 20041001 FIC402N1 0101004 OPER2 542.00 true 2017-02-06T10:02:44.729-05:00 20051 1 H11368198 1
20050114 FIC402N1 0055382 OPER2 20040823 20041217 FI 1 S L06209472 55382 218571 454.00 true 2017-02-06T10:02:46.617-05:00 20051 1 L06209472 1
20130716 FIC210N1 0737304 WEB8 N 20130822 20131218 VR 96 S 12 000001327 I 737304 890889 20131218 FIC861B1 356488 OPER2 false 2017-02-06T10:03:56.536-05:00 20141 1 B13966155 1
20130426 FIC210N1 1826411 WEB9 N 20130513 20130806 VR 90 S 8 000001327 I 1826411 855892 20130805 FIC861B1 1550383 OPER1 false 2017-02-06T10:03:52.746-05:00 20133 1 B12560215 1
20120621 FIC402N1 1130250 OPER1 20120823 20121218 FI 35 S 000000068 50208 758445 20120914 FIC402N1 0050208 OPER2 true 2017-02-06T10:03:42.044-05:00 20131 1 I13644059 1
20030730 FIC402N1 1546201 OPER2 20030820 20031216 VR 13 S 000000063 1418348 154239 20030828 FIC402N1 1418348 E016702 555.00 true 75.0000 2017-02-06T10:02:40.236-05:00 20041 1 S11700168 1
20100811 FIC402N1 1458227 OPER2 20100823 20101217 FI 9 S 000001280 38552 576004 20100909 FIC402N1 0038552 OPER2 true 2017-02-06T10:03:22.216-05:00 20111 1 A13427166 1
20060914 FIC402N1 0518012 OPER2 20060823 20061218 FI 22 S 000000035 207377 302746 20060927 FIC402N1 0207377 OPER2 true 2017-02-06T10:02:55.072-05:00 20071 1 M11702214 1
20120422 FIC210N1 1620208 WEB3 N 20120509 20120802 VR 71 S 72 000001327 I 1620208 740745 20120801 FIC861B1 1543482 E005840 false 2017-02-06T10:03:40.016-05:00 20123 1 T14141949 1
Powered by BI Documenter