SCH_AENRL_CRT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCH_CRITERIA_ID	Character(12)	VARCHAR2(12) NOT NULL	Enrollment Group
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: SCH_AENRL_CRT.DESCR
6	QRYNAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name Prompt Table: TL_QRYNAME_VW
7	TL_EXCLUDE_PRVW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Y/N Table Edit Default Value: N
8	SCH_AENRL_ASGN	Character(1)	VARCHAR2(1) NOT NULL	Schedule Assignment D=Use Default Schedule P=Select Predefined Schedule Default Value: P
9	SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Scheduling Organizational Group Code Prompt Table: SCH_GROUP_TBL
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
11	SCHEDULE_ID	Character(16)	VARCHAR2(16) NOT NULL	The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition). Prompt Table: SCH_DEFN_CMN_VW
12	USE_DFLT_WS	Character(1)	VARCHAR2(1) NOT NULL	Indicator for Primary Schedule A=Create Personal Schedule N=Select Predefined Schedule Y=Use Default Schedule Default Value: N