Table - dbo.UTL_CODE_TABLE

Property	Value
Name	UTL_CODE_TABLE_GENERIC
Schema	dbo
Row Count	178023
Data Size	5008 KB
Index Size	3064 KB
Create Date	8/15/2012 2:10 PM
Description

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
cnxarraycolumn	smallint(5, 0)	False	False	False
EDIT_RULES	varchar(45)	True	False	False
FIELD_ATTR	varchar(1)	True	False	False
FIELD_LNGTH	int(10, 0)	True	False	False
FIELD_NAME	varchar(20)	True	False	False
FIELD_VALUE	varchar(30)	True	False	False
GENERIC_COUNT	smallint(5, 0)	False	False	False
ISN_UTL_CODE_TABLE	int(10, 0)	False	False	False
REQUIRED	bit(1, 0)	True	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
UNOZNOVLNI2V3	False	ISN_UTL_CODE_TABLE, cnxarraycolumn

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.usp_DimApplication_Select	StoredProcedure
dbo.usp_DimCurriculum_Select	StoredProcedure
dbo.usp_DimStudent_Select	StoredProcedure
dbo.usp_FactActiveStudentGrades	StoredProcedure
dbo.usp_FactActiveStudentGrades_Old	StoredProcedure
dbo.usp_FactApplicationStatus_Select	StoredProcedure
dbo.usp_FactStudentFeesPaid_Select	StoredProcedure
dbo.usp_FactStudentFeesPaidArchived_Select	StoredProcedure
dbo.usp_FactStudentTotalFees_Select	StoredProcedure
dbo.usp_FactStudentTotalFeesArchive_Select	StoredProcedure
dbo.usp_FactStudentTotalFeesForClass_Select	StoredProcedure
dbo.usp_FactStudentTotalFeesForClassArchived_Select	StoredProcedure

Name	Type
dbo.usp_DimApplication_Select	STOREDPROCEDURE
dbo.usp_DimCurriculum_Select	STOREDPROCEDURE
dbo.usp_DimStudent_Select	STOREDPROCEDURE
dbo.usp_FactActiveStudentGrades	STOREDPROCEDURE
dbo.usp_FactActiveStudentGrades_Old	STOREDPROCEDURE
dbo.usp_FactApplicationStatus_Select	STOREDPROCEDURE
dbo.usp_FactStudentFeesPaid_Select	STOREDPROCEDURE
dbo.usp_FactStudentFeesPaidArchived_Select	STOREDPROCEDURE
dbo.usp_FactStudentTotalFees_Select	STOREDPROCEDURE
dbo.usp_FactStudentTotalFeesArchive_Select	STOREDPROCEDURE
dbo.usp_FactStudentTotalFeesForClass_Select	STOREDPROCEDURE
dbo.usp_FactStudentTotalFeesForClassArchived_Select	STOREDPROCEDURE

Object

Property

Value

Object

Property

Value

/****** Object: Table [dbo].[UTL_CODE_TABLE_GENERIC] Script Date: 03/09/2017 16:46:36 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[UTL_CODE_TABLE_GENERIC](
    [ISN_UTL_CODE_TABLE] [int] NOT NULL,
    [GENERIC_COUNT] [smallint] NOT NULL,
    [FIELD_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIELD_ATTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIELD_LNGTH] [int] NULL,
    [REQUIRED] [bit] NULL,
    [EDIT_RULES] [varchar](45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIELD_VALUE] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)

cnxarraycolumn	EDIT_RULES	FIELD_ATTR	FIELD_NAME	FIELD_VALUE	GENERIC_COUNT	ISN_UTL_CODE_TABLE	REQUIRED	RowUpdatedOn
8					10	10729	true	2017-02-06T10:46:22.551-05:00
1				VA	2	25357	false	2017-02-06T10:46:23.986-05:00
0				083906888	1	78966	false	2017-02-06T10:46:29.087-05:00
0				WEST UNIVERSITY PLAC	2	48401	false	2017-02-06T10:46:26.638-05:00
1				MT	2	40891	false	2017-02-06T10:46:25.764-05:00
1				NJ	2	18333	false	2017-02-06T10:46:23.221-05:00
1				SC	2	28207	false	2017-02-06T10:46:24.329-05:00
0				MANVILLE	2	41540	false	2017-02-06T10:46:25.827-05:00
1				NJ	2	18270	false	2017-02-06T10:46:23.206-05:00
0				AURORA	2	49972	false	2017-02-06T10:46:26.81-05:00