DWOperations - Indexes Index

Name	Table Name	Clustered	Is System
PK_DimRelativeDay_CopyFromDW	dbo.DimRelativeDay_CopyFromDW	True	False
PK_ETLExecutionLog	dbo.ETLExecutionLog	True	False
PK_SSISConfigurations_Log	dbo.ETLExecutionLog_SSISConfigurations	True	False
PK_FactEnrollmentSnapshot_TermRelativeDays	dbo.FactEnrollmentSnapshot_TermRelativeDays	True	False
PK_Lookup_SeqentialNbrs	dbo.Lookup_SequentialNbrs	True	False
PK_DimAssignment_Obsolete_DependencyCheck	dbo.Obsolete_DimAssignment_DependencyCheck	True	False
PK_DimBudgeted_Obsolete_DependencyCheck	dbo.Obsolete_DimBudgeted_DependencyCheck	True	False
PK_DimChartOfAccount_Obsolete_DependencyCheck	dbo.Obsolete_DimChartOfAccount_DependencyCheck	True	False
PK_DimCheckComponentType_Obsolete_DependencyCheck	dbo.Obsolete_DimCheckComponentType_DependencyCheck	True	False
PK_DimCheckType_Obsolete_DependencyCheck	dbo.Obsolete_DimCheckType_DependencyCheck	True	False
PK_DimCompensationType_Obsolete_DependencyCheck	dbo.Obsolete_DimCompensationType_DependencyCheck	True	False
PK_DimCurriculum_Obsolete_DependencyCheck	dbo.Obsolete_DimCurriculum_DependencyCheck	True	False
PK_DimEmployee_Obsolete_DependencyCheck	dbo.Obsolete_DimEmployee_DependencyCheck	True	False
PK_DimFeeType_Obsolete_DependencyCheck	dbo.Obsolete_DimFeeType_DependencyCheck	True	False
PK_DimGlCode_Obsolete_DependencyCheck	dbo.Obsolete_DimGlCode_DependencyCheck	True	False
PK_DimGlTransDetail_Obsolete_DependencyCheck	dbo.Obsolete_DimGlTransDetail_DependencyCheck	True	False
PK_DimOrgUnit_Obsolete_DependencyCheck	dbo.Obsolete_DimOrgUnit_DependencyCheck	True	False
PK_DimPayable_Obsolete_DependencyCheck	dbo.Obsolete_DimPayable_DependencyCheck	True	False
PK_DimPayee_Obsolete_DependencyCheck	dbo.Obsolete_DimPayee_DependencyCheck	True	False
PK_DimPosition_Obsolete_DependencyCheck	dbo.Obsolete_DimPosition_DependencyCheck	True	False
PK_DimPurchaseOrder_Obsolete_DependencyCheck	dbo.Obsolete_DimPurchaseOrder_DependencyCheck	True	False
PK_ObsoletedboDimStudentSK	dbo.Obsolete_DimStudent	True	False
PK_DimStudentReceipt_Obsolete_DependencyCheck	dbo.Obsolete_DimStudentReceipt_DependencyCheck	True	False
PK_DimTimeType_Obsolete_DependencyCheck	dbo.Obsolete_DimTimeType_DependencyCheck	True	False
PK_DimUser_Obsolete_DependencyCheck	dbo.Obsolete_DimUser_DependencyCheck	True	False
PK_DimZipCounty_Obsolete_DependencyCheck	dbo.Obsolete_DimZipCounty_DependencyCheck	True	False
ncidx__ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract__STDNT_ID__EFF_TRM__REF_NUM	dbo.ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract	False	False
ncidx__ST_STDNT_CLS_LOG__EnrollmentSS_Extract__STDNT_ID__EFF_TRM__REF_NUM	dbo.ST_STDNT_CLS_LOG__EnrollmentSS_Extract	False	False
PK_DimRelativeDay	dbo.Staged_dbo_DimRelativeDay	True	False
PK_dbo_DimTerm	dbo.Staged_dbo_DimTerm	True	False
PK_Verify_dbo_DimApplication	dbo.Verify_dbo_DimApplication	True	False
PK_DimAssignment	dbo.Verify_dbo_DimAssignment	True	False
PK_DimBudgetComponentType	dbo.Verify_dbo_DimBudgetComponentType	True	False
PK_DimBudgeted	dbo.Verify_dbo_DimBudgeted	True	False
PK_dbo.DimChartOfAccount	dbo.Verify_dbo_DimChartOfAccount	True	False
PK_DimCheckComponentType	dbo.Verify_dbo_DimCheckComponentType	True	False
PK_DimCheckType	dbo.Verify_dbo_DimCheckType	True	False
PK_DimCompensationType	dbo.Verify_dbo_DimCompensationType	True	False
PK_DimCurriculum	dbo.Verify_dbo_DimCurriculum	True	False
PK_DimEmployee	dbo.Verify_dbo_DimEmployee	True	False
PK_DimFeeType	dbo.Verify_dbo_DimFeeType	True	False
PK_DimGlCode	dbo.Verify_dbo_DimGlCode	True	False
PK_dbo.DimGlTransDetail	dbo.Verify_dbo_DimGlTransDetail	True	False
PK_Verify_dbo_DimInstitutionalRetentionCohort	dbo.Verify_dbo_DimInstitutionalRetentionCohort	True	False
PK_dbo.DimOrgUnit	dbo.Verify_dbo_DimOrgUnit	True	False
PK_DimPayable	dbo.Verify_dbo_DimPayable	True	False
PK_DimPayee	dbo.Verify_dbo_DimPayee	True	False
PK_DimPosition	dbo.Verify_dbo_DimPosition	True	False
PK_Verify_dbo_DimProgramRetentionCohort	dbo.Verify_dbo_DimProgramRetentionCohort	True	False
PK_DimPurchaseOrder	dbo.Verify_dbo_DimPurchaseOrder	True	False
PK_DimStudent	dbo.Verify_dbo_DimStudent	True	False
PK_Verify_dbo_DimStudentObjective	dbo.Verify_dbo_DimStudentObjective	True	False
PK_DimStudentReceipt	dbo.Verify_dbo_DimStudentReceipt	True	False
PK_Verify_dbo_DimStudentSuccessCohort	dbo.Verify_dbo_DimStudentSuccessCohort	True	False
PK_Verify_dbo_DimStudentTerm	dbo.Verify_dbo_DimStudentTerm	True	False
PK_DimTimeType	dbo.Verify_dbo_DimTimeType	True	False
PK_DimUser	dbo.Verify_dbo_DimUser	True	False
PK_DimZipCounty	dbo.Verify_dbo_DimZipCounty	True	False
Index_ZIPCodes_AreaCode	dbo.ZIPCodes	False	False
Index_ZIPCodes_City	dbo.ZIPCodes	False	False
Index_ZIPCodes_CityAliasName	dbo.ZIPCodes	False	False
Index_ZIPCodes_CityStateKey	dbo.ZIPCodes	False	False
Index_ZIPCodes_County	dbo.ZIPCodes	False	False
Index_ZIPCodes_Latitude	dbo.ZIPCodes	False	False
Index_ZIPCodes_Longitude	dbo.ZIPCodes	False	False
Index_ZIPCodes_PrimaryRecord	dbo.ZIPCodes	False	False
Index_ZIPCodes_State	dbo.ZIPCodes	False	False
Index_ZIPCodes_ZipCode	dbo.ZIPCodes	False	False