ACAD_GROUP_TBL (SQL Table)	Index Back
Academic Group Table Use Academic Group Table to record information about the high level organizational entities in your academic organization. An Academic Group typically equates to "college", but can encompass non-college entities such as "Continuing Education". Normally there is a one-to-one correspondence between the entries found in the Academic Group table and the entries contained in the "College" level of the Academic Organization Tree.

ACAD_GROUP_TBL

(SQL Table)

Academic Group Table

Use Academic Group Table to record information about the high level organizational entities in your academic organization. An Academic Group typically equates to "college", but can encompass non-college entities such as "Continuing Education". Normally there is a one-to-one correspondence between the entries found in the Academic Group table and the entries contained in the "College" level of the Academic Organization Tree.

Related Language Record: ACAD_GROUP_LANG

Parent Record Of CATLG_CAR_TBL CRSE_EQUIV_LNG CRSE_EQUIV_TBL CRSE_OFFER_SCTY CRSE_OFFER_SLNG STND_MTGPAT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: ACAD_GROUP_TBL.DESCR

7 STDNT_SPEC_PERM Character(1) VARCHAR2(1) NOT NULL Student Specific Permissions
Y/N Table Edit
Default Value: INSTITUTION_TBL.STDNT_SPEC_PERM

8 AUTO_ENRL_WAITLIST Character(1) VARCHAR2(1) NOT NULL Auto Enroll from Wait List
Y/N Table Edit
Default Value: INSTITUTION_TBL.AUTO_ENRL_WAITLIST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	ACAD_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Academic Group
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: ACAD_GROUP_TBL.DESCR
7	STDNT_SPEC_PERM	Character(1)	VARCHAR2(1) NOT NULL	Student Specific Permissions Y/N Table Edit Default Value: INSTITUTION_TBL.STDNT_SPEC_PERM
8	AUTO_ENRL_WAITLIST	Character(1)	VARCHAR2(1) NOT NULL	Auto Enroll from Wait List Y/N Table Edit Default Value: INSTITUTION_TBL.AUTO_ENRL_WAITLIST