SCC_STG_EXACDSB (SQL Table)	Index Back
External Academic Subject EXT_ACAD_SUBJ is used to record academic information by school and subject area for a person. There can be multiple EXT_ACAD_SUBJ records for every EXT_ACAD_SUM record.

SCC_STG_EXACDSB

(SQL Table)

External Academic Subject

EXT_ACAD_SUBJ is used to record academic information by school and subject area for a person. There can be multiple EXT_ACAD_SUBJ records for every EXT_ACAD_SUM record.

Parent record: SCC_STG_EXACDDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID

2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

3 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
Default Value: EXT_ORG_TBL_ADM.EXT_CAREER

4 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
Default Value: EXT_ACAD_DATA.EXT_DATA_NBR

5 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area
Prompt Table: EXT_SUBJECT_TBL

6 COURSE_LEVEL Character(2) VARCHAR2(2) NOT NULL Course Level
11=Grade 11
12=Grade 12
AP=Advanced Placement
DR=Graduate/Doctoral
FR=Freshman
GR=Graduate
HN=Honors
IB=International Baccalaureate
JR=Junior
LD=Lower Division
MS=Graduate/Master
RG=Regular
SO=Sophomore
SR=Senior
UD=Upper Division

7 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
Default Value: SCC_STG_ACADHST.EXT_ORG_ID
Prompt Table: EXT_ORG_TBL

8 UNT_ATMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Units Attempted

9 UNT_COMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Completed Units

10 TOTAL_CRSE_COMP Number(2,0) SMALLINT NOT NULL Total Courses Completed

11 TOTAL_CRSE_ATMP Number(2,0) SMALLINT NOT NULL Total Courses Attempted

12 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type
Default Value: ORG_INST_TBL.GPA_TYPE
Prompt Table: GPA_TYPE_TBL

13 EXT_GPA Number(7,3) DECIMAL(6,3) NOT NULL External GPA
Prompt Table: GPA_VALUE_TBL

14 CONVERT_GPA Number(7,3) DECIMAL(6,3) NOT NULL Converted GPA
Prompt Table: GPA_RULES_TBL

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

16 UNT_TYPE Character(3) VARCHAR2(3) NOT NULL Unit Type
ADU=Adult
CAR=Carnegie Units
CEU=Continuing Education Unit
NCR=No Credit
OTH=Non-Standard units
QTR=Quarter Units
SEM=Semester Units
UKN=Unknown
UNT=Units
VOC=Vocational
Default Value: EXT_ORG_TBL_ADM.UNT_TYPE

17 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By

18 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

19 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By

20 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	EXT_CAREER	Character(4)	VARCHAR2(4) NOT NULL	External Career GRAD=Graduate HS=High School LAW=Law MED=Medical UGRD=Undergraduate Default Value: EXT_ORG_TBL_ADM.EXT_CAREER
4	EXT_DATA_NBR	Number(3,0)	SMALLINT NOT NULL	External Data Nbr Default Value: EXT_ACAD_DATA.EXT_DATA_NBR
5	EXT_SUBJECT_AREA	Character(4)	VARCHAR2(4) NOT NULL	External Subject Area Prompt Table: EXT_SUBJECT_TBL
6	COURSE_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Course Level 11=Grade 11 12=Grade 12 AP=Advanced Placement DR=Graduate/Doctoral FR=Freshman GR=Graduate HN=Honors IB=International Baccalaureate JR=Junior LD=Lower Division MS=Graduate/Master RG=Regular SO=Sophomore SR=Senior UD=Upper Division
7	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Default Value: SCC_STG_ACADHST.EXT_ORG_ID Prompt Table: EXT_ORG_TBL
8	UNT_ATMP_TOTAL	Number(8,2)	DECIMAL(7,2) NOT NULL	Total Units Attempted
9	UNT_COMP_TOTAL	Number(8,2)	DECIMAL(7,2) NOT NULL	Total Completed Units
10	TOTAL_CRSE_COMP	Number(2,0)	SMALLINT NOT NULL	Total Courses Completed
11	TOTAL_CRSE_ATMP	Number(2,0)	SMALLINT NOT NULL	Total Courses Attempted
12	GPA_TYPE	Character(4)	VARCHAR2(4) NOT NULL	GPA Type Default Value: ORG_INST_TBL.GPA_TYPE Prompt Table: GPA_TYPE_TBL
13	EXT_GPA	Number(7,3)	DECIMAL(6,3) NOT NULL	External GPA Prompt Table: GPA_VALUE_TBL
14	CONVERT_GPA	Number(7,3)	DECIMAL(6,3) NOT NULL	Converted GPA Prompt Table: GPA_RULES_TBL
15	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
16	UNT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Unit Type ADU=Adult CAR=Carnegie Units CEU=Continuing Education Unit NCR=No Credit OTH=Non-Standard units QTR=Quarter Units SEM=Semester Units UKN=Unknown UNT=Units VOC=Vocational Default Value: EXT_ORG_TBL_ADM.UNT_TYPE
17	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
18	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
19	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
20	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time