SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PS_CLASS_ATTENDNCE](
	[EMPLID] [varchar](11) NOT NULL,
	[ACAD_CAREER] [varchar](4) NOT NULL,
	[INSTITUTION] [varchar](5) NOT NULL,
	[STRM] [varchar](4) NOT NULL,
	[CLASS_NBR] [int] NOT NULL,
	[CLASS_ATTEND_DT] [dbo].[PSDATE] NOT NULL,
	[ATTEND_TO_TIME] [dbo].[PSTIME] NOT NULL,
	[ATTEND_TMPLT_NBR] [smallint] NOT NULL,
	[CLASS_ATTEND_TYPE] [varchar](4) NOT NULL,
	[ATTEND_PRESENT] [varchar](1) NOT NULL,
	[ATTEND_TARDY] [varchar](1) NOT NULL,
	[ATTEND_LEFT_EARLY] [varchar](1) NOT NULL,
	[ATTEND_REASON] [varchar](4) NOT NULL,
	[ATTEND_FROM_TIME] [dbo].[PSTIME] NULL,
	[CONTACT_MINUTES] [smallint] NOT NULL,
	[INSTRUCTOR_ID] [varchar](11) NOT NULL,
	[LAST_NAME_SRCH] [varchar](30) NOT NULL,
	[FIRST_NAME_SRCH] [varchar](30) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF