Some changes and enhancements have been made to TE in order to accommodate Student functionality.
Year/Term Table (YTMTBP)
The following fields have been added to the Year/Term table:
|
Field Name |
Type |
Description |
|
S5FDAD |
Num(7,0) |
First final grd dte |
|
S5LDAD |
Num(7,0) |
Last final grd dte |
|
S5FFGD |
Num(7,0) |
First midtrm grd dte |
|
S5LFGD |
Num(7,0) |
Last midtrm grd dte |
Year/Term/Subterm (YTSTBP)
This file and its L0, L1, and L2 logical files were added with the following fields:
|
Field |
Type |
Description |
|
D6CQAA |
Char(4) |
Year code |
|
D6CMAA |
Char(2) |
Term code |
|
D6AUAB |
Char(2) |
Subterm |
|
D6NJAZ |
Char(4) |
Year sort field |
|
D6Q6AK |
Num(7,0) |
Term begin date |
|
D6Q7AK |
Num(7,0) |
Term end date |
|
D6Q8AK |
Char(30) |
Year/term description |
|
D6Q9AK |
Char(1) |
Print IP on trans |
|
D6QUAK |
Num(7,0) |
Census date |
|
D6DZAM |
Num(5,2) |
Census percentage |
|
D6PRST |
Char(1) |
Prereg Sts |
|
D6FDAD |
Num(7,0) |
First drop add dte |
|
D6LDAD |
Num(7,0) |
Last drop add dte |
|
D6FFGD |
Num(7,0) |
First final grd dte |
|
D6LFGD |
Num(7,0) |
Last final grd dte |
|
D6FMGD |
Num(7,0) |
First midtrm grd dte |
|
D6LMGD |
Num(7,0) |
Last midtrm grd dte |
|
D6USR |
Char(10) |
User name |
|
D6JOB |
Char(10) |
Job name |
|
D6JDT |
Num(7,0) |
Job date |
|
D6JTM |
Num(6,0) |
*Job time |
It is updated through the Year/term table (opt 3 on CNTRL2 menu) by using Opt 2.
Section Master (SCTMSP)
The following Future Use fields were used to achieve functionality needed by CRM Student.
|
Field |
Type |
Description |
|
R7A0AG |
Char(45) |
Section note is now being used in JICS |
|
R7NWAZ |
Char(1) |
Future use R7/R9 2 is being used for the Public Registration flag |
|
R7NNAZ |
Num(10,2) |
Future use 10/2a is being used for the Must Pay Amount on a course. |
|
R7NZAZ |
Char(1) |
Future use R7/R9 5 is being used for the Must Pay flag |
F21 has been added to the Section Schedule entry screen (opt 4 on NEWTRM menu) to allow data entry on Web related information.
Student Course History (STCHSP)
The following Future Use and User Defined fields were used to achieve functionality needed by CRM Student.
|
Field |
Type |
Description |
|
R9U1A3 |
Char(1) |
User-defined/1A #3 is being used for the Must Pay Paid flag |
|
R9NZAZ |
Char(1) |
Future use R7/R9 5 is being used for the Must Pay flag |
Copy New Courses to New Term (Opt 10 on NEWTRM menu)
Several new fields were added to the copy process to facilitate new functionality in CRMs Student and Faculty.
Degree/AIM Cross Reference (DAREFP)
This file and its L0 and L1 logical files were added with the following fields:
|
Field |
Type |
Description |
|
CDVJAA |
Char(15) |
RE Degree Type |
|
CDAVYR |
Char(4) |
ADVISING YEAR |
|
CDVKAA |
Char(5) |
Type Code |
|
CDAHNB |
Num(9,0) |
Sequence Number 9/0 |
|
CDAJCD |
Char(5) |
Aim Label |
|
CDAGCD |
Char(8) |
Advising Requirement Code |
|
CDVLAA |
Char(1) |
Primary Aim |
|
CDUSR |
Char(10) |
User name |
|
CDJOB |
Char(10) |
Job name |
|
CDJDT |
Num(7,0) |
Job date |
|
CDJTM |
Num(6,0) |
*Job time |
The information in this table allows JICS to connect the current degree information on the Degree History file (DGRHSP) to the appropriate AIMS.
Degree History (opt 3 on STUDNT menu)
The following User Defined field was used to achieve functionality needed by CRM Student:
|
Field |
Type |
Description |
|
RSU5A2 |
Char(5) |
User-defined/5A #2 is being used for the Advising Year |
Student Master (opt 1 on STUDNT menu)
Update Reg. Hold 6 for an Advisor hold.
The following Future Use field was used to achieve functionality needed by CRM Student.
|
Field |
Type |
Description |
|
SBQ9AJ |
Char(2) |
Future use 1 is being used for the FERPA flag |