SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PS_CLASS_INSTR](
	[CRSE_ID] [varchar](6) NOT NULL,
	[CRSE_OFFER_NBR] [smallint] NOT NULL,
	[STRM] [varchar](4) NOT NULL,
	[SESSION_CODE] [varchar](3) NOT NULL,
	[CLASS_SECTION] [varchar](4) NOT NULL,
	[CLASS_MTG_NBR] [smallint] NOT NULL,
	[INSTR_ASSIGN_SEQ] [smallint] NOT NULL,
	[EMPLID] [varchar](11) NOT NULL,
	[INSTR_ROLE] [varchar](4) NOT NULL,
	[GRADE_RSTR_ACCESS] [varchar](1) NOT NULL,
	[CONTACT_MINUTES] [smallint] NOT NULL,
	[SCHED_PRINT_INSTR] [varchar](1) NOT NULL,
	[INSTR_LOAD_FACTOR] [decimal](10, 4) NOT NULL,
	[EMPL_RCD] [smallint] NOT NULL,
	[ASSIGN_TYPE] [varchar](3) NOT NULL,
	[WEEK_WORKLOAD_HRS] [decimal](5, 2) NOT NULL,
	[ASSIGNMENT_PCT] [decimal](5, 2) NOT NULL,
	[AUTO_CALC_WRKLD] [varchar](1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF