SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[PS_TERM_TBL]( [INSTITUTION] [varchar](5) NOT NULL, [ACAD_CAREER] [varchar](4) NOT NULL, [STRM] [varchar](4) NOT NULL, [DESCR] [varchar](30) NOT NULL, [DESCRSHORT] [varchar](10) NOT NULL, [TERM_BEGIN_DT] [dbo].[PSDATE] NOT NULL, [TERM_END_DT] [dbo].[PSDATE] NOT NULL, [SESSION_CODE] [varchar](3) NOT NULL, [WEEKS_OF_INSTRUCT] [smallint] NOT NULL, [TERM_CATEGORY] [varchar](1) NOT NULL, [ACAD_YEAR] [varchar](4) NOT NULL, [TRANSCIPT_DT_PRT] [varchar](2) NOT NULL, [HOLIDAY_SCHEDULE] [varchar](6) NOT NULL, [SIXTY_PCT_DT] [dbo].[PSDATE] NOT NULL, [USE_DYN_CLASS_DATE] [varchar](1) NOT NULL, [SSR_TRMAC_LAST_DT] [dbo].[PSDATE] NOT NULL, [SSR_SSENRLDISP_BDT] [dbo].[PSDATE] NOT NULL, [SSR_SSENRLDISP_EDT] [dbo].[PSDATE] NOT NULL, [SSR_SSPLNRDISP_BDT] [dbo].[PSDATE] NOT NULL, [SSR_SSPLNRDISP_EDT] [dbo].[PSDATE] NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF