SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PS_CRSE_COMPONENT](
	[CRSE_ID] [varchar](6) NOT NULL,
	[EFFDT] [dbo].[PSDATE] NOT NULL,
	[SSR_COMPONENT] [varchar](3) NOT NULL,
	[OPTIONAL_SECTION] [varchar](1) NOT NULL,
	[DEFAULT_SECT_SIZE] [smallint] NOT NULL,
	[CONTACT_HOURS] [decimal](7, 3) NOT NULL,
	[FINAL_EXAM] [varchar](2) NOT NULL,
	[EXAM_SEAT_SPACING] [smallint] NOT NULL,
	[DYN_DT_INCLUDE] [varchar](1) NOT NULL,
	[AUTO_CREATE_CMPNT] [varchar](1) NOT NULL,
	[ATTEND_GENERATE] [varchar](1) NOT NULL,
	[WEEK_WORKLOAD_HRS] [decimal](5, 2) NOT NULL,
	[OEE_WORKLOAD_HRS] [decimal](5, 2) NOT NULL,
	[LMS_FILE_TYPE] [varchar](3) NOT NULL,
	[LMS_PROVIDER] [varchar](30) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF