Table - dbo.IT_STUDENT_FEES_ARCH_A_PAYMENT

Properties

Property	Value
Name	IT_STUDENT_FEES_ARCH_A_PAYMENT_GROUP
Schema	dbo
Row Count	0
Data Size	0 KB
Index Size	0 KB
Create Date	8/15/2012 11:34 AM
Description

Columns

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
cnxarraycolumn	smallint(5, 0)	False	False	False
CONTRACT_NBR	varchar(16)	True	False	False
CRS_ID_XREF	varchar(16)	True	False	False
FEE_AMOUNT	numeric(17, 2)	True	False	False
FEE_PAYMENT_TYPE	varchar(2)	True	False	False
FEE_TY	varchar(4)	True	False	False
ISN_IT_STUDENT_FEES_ARCH_A	int(10, 0)	False	False	False
PAYMENT_GROUP_COUNT	smallint(5, 0)	False	False	False
PAYMENT_SEQ	int(10, 0)	True	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False
STUDENT_TERM	varchar(15)	True	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
U19EC7A288H20W	False	ISN_IT_STUDENT_FEES_ARCH_A, cnxarraycolumn

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.IT_STUDENT_FEES_ARCH_A_PAYMENT_GROUP depends on)

Name	Type
dbo.usp_FactStudentFeesPaidArchived_Select	StoredProcedure
dbo.usp_FactStudentTotalFeesArchive_Select	StoredProcedure
dbo.usp_FactStudentTotalFeesForClassArchived_Select	StoredProcedure

Child Dependencies (objects that depend on dbo.IT_STUDENT_FEES_ARCH_A_PAYMENT_GROUP)

Name	Type
dbo.usp_FactStudentFeesPaidArchived_Select	STOREDPROCEDURE
dbo.usp_FactStudentTotalFeesArchive_Select	STOREDPROCEDURE
dbo.usp_FactStudentTotalFeesForClassArchived_Select	STOREDPROCEDURE

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[IT_STUDENT_FEES_ARCH_A_PAYMENT_GROUP] Script Date: 03/09/2017 16:45:41 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IT_STUDENT_FEES_ARCH_A_PAYMENT_GROUP](
    [ISN_IT_STUDENT_FEES_ARCH_A] [int] NOT NULL,
    [PAYMENT_GROUP_COUNT] [smallint] NOT NULL,
    [STUDENT_TERM] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_ID_XREF] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_TY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_SEQ] [int] NULL,
    [FEE_AMOUNT] [numeric](17, 2) NULL,
    [FEE_PAYMENT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_NBR] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)