CRSE_COMP_LAM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID Prompt Table: CRSE_CATALOG
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr Prompt Table: CRSE_OFFER
4	SSR_COMPONENT	Character(3)	VARCHAR2(3) NOT NULL	Course Component. CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial
5	SEQUENCE_NO	Number(3,0)	SMALLINT NOT NULL	Sequence #
6	LAM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Assignment Category Prompt Table: LAM_TYPE
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
9	LAM_REQUIRED_INST	Character(1)	VARCHAR2(1) NOT NULL	Required by Institution Y/N Table Edit Default Value: N
10	MARK_OUT_OF	Number(3,0)	SMALLINT NOT NULL	Gradebook: Maximum points for an assignment.
11	LAM_WEIGHT	Number(3,0)	SMALLINT NOT NULL	Weight in Points
12	NUMBER_DAYS	Number(3,0)	SMALLINT NOT NULL	Gradebook field - number of days from beginning of class until assignment starts.
13	LAM_DURATION	Number(3,0)	SMALLINT NOT NULL	Duration
14	GRADING_DURATION	Number(3,0)	SMALLINT NOT NULL	Estimated Grading Duration
15	LAM_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Required Y/N Table Edit Default Value: Y
16	ASSESSED	Character(1)	VARCHAR2(1) NOT NULL	Assessed Y/N Table Edit Default Value: Y
17	INCL_IN_MID_TERM	Character(1)	VARCHAR2(1) NOT NULL	Include for Mid Term Grade Y/N Table Edit Default Value: N
18	COPY_GRADES	Character(1)	VARCHAR2(1) NOT NULL	Import Grades Y/N Table Edit Default Value: N
19	DESCRLONG_NOTES	Long Character	CLOB	Long Description