SUBJ_COMPONENT(SQL Table) |
Index Back |
---|---|
Subject Component WorkloadSubject Component Workload multipliers. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Default Value: SUBJECT_TBL.SUBJECT Prompt Table: SUBJECT_TBL |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: SUBJECT_TBL.EFFDT |
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 | COMP_MULTIPLIER | Number(3,0) | SMALLINT NOT NULL |
Component Multiplier %
Default Value: 100 |