Table - dbo.UTL_CODE

Property	Value
Name	UTL_CODE_TABLE
Schema	dbo
Row Count	101536
Data Size	11848 KB
Index Size	1568 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
CODE	varchar(10)	True	False	False
CODE_EDIT_RULES	varchar(45)	True	False	False
CODE_FIELD_ATTR	varchar(1)	True	False	False
CODE_FIELD_LNGTH	int(10, 0)	True	False	False
DESCRIPTION	varchar(30)	True	False	False
EFF_DATE_MAINT	varchar(1)	True	False	False
END_DATE	varchar(8)	True	False	False
END_DATE_INV	varchar(8)	True	False	False
HOLD	int(10, 0)	True	False	False
ISN_UTL_CODE_TABLE	int(10, 0)	False	False	False
LONG_DESCRIPTION	varchar(60)	True	False	False
OWNER_SYSTEM	varchar(3)	True	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False
START_DATE	varchar(8)	True	False	False
START_DATE_INV	varchar(8)	True	False	False
STATUS	varchar(1)	True	False	False
TABLE_NAME	varchar(10)	True	False	False

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
U3T5EUXWVFT3ID	False	ISN_UTL_CODE_TABLE

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.arch_AR_Adjustments	View
dbo.arch_AR_Obligations	View
dbo.arch_AR_Receipt	View
dbo.arch_AR_ReceiptPayment	View
dbo.arch_AR_Receivables	View
dbo.arch_GlSummary	View
dbo.arch_PurchaseOrderHeader	View
dbo.arch_Student	View
dbo.arch_StudentClassAcademicHistory	View
dbo.arch_StudentPrimaryAward	View
dbo.smc_GlSummary	View
dbo.uvw_CODE_Country	View
dbo.uvw_CODE_County	View
dbo.uvw_CODE_Language	View
dbo.uvw_CODE_State	View
dbo.usp_DimApplication_Select	StoredProcedure
dbo.usp_DimAssignment_Select	StoredProcedure
dbo.usp_DimAssignment_Select_OLD	StoredProcedure
dbo.usp_DimCheckComponentType_Select	StoredProcedure
dbo.usp_DimCurriculum_Select	StoredProcedure
dbo.usp_DimEmployee_Select	StoredProcedure
dbo.usp_DimEmployee_Select_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_Old	StoredProcedure
dbo.usp_DimPosition_Select	StoredProcedure
dbo.usp_DimPosition_Select_OLD	StoredProcedure
dbo.usp_DimProgramRetentionCohort_Select	StoredProcedure
dbo.usp_DimStudent_Select	StoredProcedure
dbo.usp_DimStudentObjective_Select	StoredProcedure
dbo.usp_DimStudentReceipt_Select	StoredProcedure
dbo.usp_DimStudentSuccessCohort_Select	StoredProcedure
dbo.usp_DimStudentTerm_Select	StoredProcedure
dbo.usp_FactActiveStudentGrades	StoredProcedure
dbo.usp_FactActiveStudentGrades_Old	StoredProcedure
dbo.usp_FactApplicationStatus_Select	StoredProcedure
dbo.usp_FactProgramRetentionSnapshot_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.uvw_CODE_Country	VIEW
dbo.uvw_CODE_County	VIEW
dbo.uvw_CODE_Language	VIEW
dbo.uvw_CODE_State	VIEW
dbo.arch_StudentPrimaryAward	VIEW
dbo.arch_Student	VIEW
dbo.usp_DimApplication_Select	STOREDPROCEDURE
dbo.usp_DimAssignment_Select	STOREDPROCEDURE
dbo.usp_DimAssignment_Select_OLD	STOREDPROCEDURE
dbo.usp_DimCheckComponentType_Select	STOREDPROCEDURE
dbo.usp_DimCurriculum_Select	STOREDPROCEDURE
dbo.usp_DimEmployee_Select	STOREDPROCEDURE
dbo.usp_DimEmployee_Select_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_Old	STOREDPROCEDURE
dbo.usp_DimPosition_Select	STOREDPROCEDURE
dbo.usp_DimPosition_Select_OLD	STOREDPROCEDURE
dbo.usp_DimProgramRetentionCohort_Select	STOREDPROCEDURE
dbo.usp_DimStudent_Select	STOREDPROCEDURE
dbo.usp_DimStudentObjective_Select	STOREDPROCEDURE
dbo.usp_DimStudentReceipt_Select	STOREDPROCEDURE
dbo.usp_DimStudentSuccessCohort_Select	STOREDPROCEDURE
dbo.usp_DimStudentTerm_Select	STOREDPROCEDURE
dbo.usp_FactActiveStudentGrades	STOREDPROCEDURE
dbo.usp_FactActiveStudentGrades_Old	STOREDPROCEDURE
dbo.usp_FactApplicationStatus_Select	STOREDPROCEDURE
dbo.usp_FactProgramRetentionSnapshot_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
dbo.arch_AR_Adjustments	VIEW
dbo.arch_AR_Obligations	VIEW
dbo.arch_AR_Receipt	VIEW
dbo.arch_AR_ReceiptPayment	VIEW
dbo.arch_AR_Receivables	VIEW
dbo.arch_GlSummary	VIEW
dbo.arch_PurchaseOrderHeader	VIEW
dbo.arch_StudentClassAcademicHistory	VIEW
dbo.smc_GlSummary	VIEW

Object

Property

Value

Object

Property

Value

/****** Object: Table [dbo].[UTL_CODE_TABLE] Script Date: 03/09/2017 16:46:36 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[UTL_CODE_TABLE](
    [ISN_UTL_CODE_TABLE] [int] NOT NULL,
    [STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TABLE_NAME] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CODE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DESCRIPTION] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LONG_DESCRIPTION] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OWNER_SYSTEM] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CODE_FIELD_ATTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CODE_FIELD_LNGTH] [int] NULL,
    [CODE_EDIT_RULES] [varchar](45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_DATE_MAINT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE_INV] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_DATE_INV] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)

CODE	CODE_EDIT_RULES	CODE_FIELD_ATTR	DESCRIPTION	EFF_DATE_MAINT	END_DATE	END_DATE_INV	HOLD	ISN_UTL_CODE_TABLE	LONG_DESCRIPTION	OWNER_SYSTEM	RowUpdatedOn	START_DATE	START_DATE_INV	STATUS	TABLE_NAME
211870870			LEE SAVINGS BANK		21991231	78008768	1529348	84969	LEE SAVINGS BANK		2017-02-06T10:46:20.913-05:00	20101105	79898894	A	BANK-ACCT
54515451			DAIRY PRODUCTS STORES		21991231			73437	DAIRY PRODUCTS STORES	FIA	2017-02-06T10:46:20.211-05:00	20080206		A	MCC-GLC
020409			Range Science and Management		21991231	78008768	1514057	98791	Range Science and Management		2017-02-06T10:46:21.911-05:00	20100101	79899898	A	CIP-2010
74051			OCHELATA, OK		21991231	78008768	1822324	47012	OCHELATA, OK		2017-02-06T10:46:18.822-05:00	20011021	79988978	A	ZIP-LOCAL
091214960			THE AMERICAN BANK OF THE NORTH		21991231	78008768	1529227	79519	THE AMERICAN BANK OF THE NORTH		2017-02-06T10:46:20.585-05:00	20101105	79898894	A	BANK-ACCT
25443			SHEPHERDSTOWN, WV		21991231	78008768	1819572	26478	SHEPHERDSTOWN, WV		2017-02-06T10:46:17.371-05:00	20011021	79988978	A	ZIP-LOCAL
29698			GREENVILLE, SC		21991231	78008768	1820118	28579	GREENVILLE, SC		2017-02-06T10:46:17.543-05:00	20011021	79988978	A	ZIP-LOCAL
122003396			CALIFORNIA BANK AND TRUST		21991231	78008768	1529313	83402	CALIFORNIA BANK AND TRUST		2017-02-06T10:46:20.803-05:00	20101105	79898894	A	BANK-ACCT
30809			EVANS, GA		21991231	78008768	1820161	29216	EVANS, GA		2017-02-06T10:46:17.59-05:00	20011021	79988978	A	ZIP-LOCAL
80733			HILLROSE, CO		21991231	78008768	1822592	50271	HILLROSE, CO		2017-02-06T10:46:19.041-05:00	20011021	79988978	A	ZIP-LOCAL