ACAD_LOAD2_TBL(SQL Table) |
Index Back |
---|---|
Academic Load for Stats PeriodThis Table defines the relationship between Academic Load and the Total Units required in an Academic Statistics Period within a Level Load Rule and SetID. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL |
2 | LEVEL_LOAD_RULE | Character(5) | VARCHAR2(5) NOT NULL |
Academic Level Rule
Prompt Table: LVL_LD_RULE_TBL |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | ACAD_STATS_PD_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Academic Load Rule
C=Contiguous Terms T=Term Load Rule Applies Prompt Table: XLAT_STAT_PD_VW |
5 | UNT_TRM_TOTAL | Number(9,3) | DECIMAL(8,3) NOT NULL | Unit Term Total |
6 | ACADEMIC_LOAD | Character(1) | VARCHAR2(1) NOT NULL |
Academic Load
F=Enrolled Full-Time H=Enrolled Half-Time L=Less than Half-Time N=No Unit Load P=Enrolled Part-Time T=Three Quarter Time |
7 | FA_LOAD | Character(1) | VARCHAR2(1) NOT NULL |
Financial Aid Load
F=Enrolled Full-Time H=Enrolled Half-Time L=Less than Half-Time N=No Unit Load T=Three Quarter Time |
8 | ACADEMIC_LOAD_NSLC | Character(1) | VARCHAR2(1) NOT NULL |
This field contains the academic load value to report to the NSC.
F=Full-Time H=Half-Time L=Less Than Half-Time Q=Three Quarter Time |