EXT_SUBJECT_TBL (SQL Table)	Index Back
External Subject Table Use EXT_SUBJECT_TBL to record generic subject areas. These subject areas will act as a standard with which you can classify subjects from other schools. This facilitates forming equivalencies between schools or in the admission process determining whether a student has fulfilled the requisite number of courses in a subject area.

EXT_SUBJECT_TBL

(SQL Table)

External Subject Table

Use EXT_SUBJECT_TBL to record generic subject areas. These subject areas will act as a standard with which you can classify subjects from other schools. This facilitates forming equivalencies between schools or in the admission process determining whether a student has fulfilled the requisite number of courses in a subject area.

Related Language Record: EXT_SUBJECT_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area

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: EXT_SUBJECT_TBL.DESCR

6 ACADEMIC_INTEREST Character(1) VARCHAR2(1) NOT NULL Academic Interest
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_SUBJECT_AREA	Character(4)	VARCHAR2(4) NOT NULL	External Subject Area
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: EXT_SUBJECT_TBL.DESCR
6	ACADEMIC_INTEREST	Character(1)	VARCHAR2(1) NOT NULL	Academic Interest Y/N Table Edit Default Value: N