SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PS_CLASS_ASSOC](
	[CRSE_ID] [varchar](6) NOT NULL,
	[CRSE_OFFER_NBR] [smallint] NOT NULL,
	[STRM] [varchar](4) NOT NULL,
	[SESSION_CODE] [varchar](3) NOT NULL,
	[ASSOCIATED_CLASS] [smallint] NOT NULL,
	[UNITS_MINIMUM] [decimal](5, 2) NOT NULL,
	[UNITS_MAXIMUM] [decimal](5, 2) NOT NULL,
	[UNITS_ACAD_PROG] [decimal](5, 2) NOT NULL,
	[UNITS_FINAID_PROG] [decimal](5, 2) NOT NULL,
	[GRADING_BASIS] [varchar](3) NOT NULL,
	[GRADE_ROSTER_PRINT] [varchar](1) NOT NULL,
	[SSR_COMPONENT] [varchar](3) NOT NULL,
	[BILLING_FACTOR] [decimal](5, 3) NOT NULL,
	[CRSE_CONTACT_HRS] [decimal](5, 2) NOT NULL,
	[RQRMNT_GROUP] [varchar](6) NOT NULL,
	[USE_CATLG_RQS] [varchar](1) NOT NULL,
	[RQMNT_DESIGNTN] [varchar](4) NOT NULL,
	[CRSE_COUNT] [decimal](4, 2) NOT NULL,
	[INSTRUCTOR_EDIT] [varchar](2) NOT NULL,
	[USE_BLIND_GRADING] [varchar](1) NOT NULL,
	[SEL_GROUP] [varchar](10) NOT NULL,
	[COMPONENT_PRIMARY] [varchar](3) NOT NULL,
	[UPDATE_STDNT_ENRL] [varchar](1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF