Some new functionality has been added to TE in order to accommodate the CRM Faculty portlets.
This functionality has been added for the Grade Entry portlet:
Student Course History (STCHSP)
The following fields were used to achieve functionality needed by CRM Student.
|
Field |
Type |
Description |
|
R9KWAA |
Num(2,0) |
Absences |
|
R9NQAZ |
Num(10,2) |
Future use 10/2d is being used for clock hours |
Faculty Master Extension (FACEXP)
The file and its L0 and L1 logical files were added with the following fields.
|
Field Name |
Type |
Description |
|
ECNMID |
Num(9,0) |
NAMMS NAME-ID |
|
ECN8AA |
Char(1) |
CanDoAuthorizations |
|
ECN9AA |
Char(1) |
CanDoCapacity |
|
ECOAAA |
Char(1) |
CanDoRequisites |
|
ECOBAA |
Char(1) |
CanDoScheduleConflicts |
|
ECMTGA |
Char(1) |
MidtermGradeAccessLevel |
|
ECFNGA |
Char(1) |
FinalGradeAccessLevel |
Year Term Table (YTMTBP)
The following new fields were added to the Year Term Table:
|
Field Name |
Type |
Description |
|
S5FFGD |
Num(7,0) |
First final grd dte |
|
S5LFGD |
Num(7,0) |
Last final grd dte |
|
S5FMGD |
Num(7,0) |
First midtrm grd dte |
|
S5LMGD |
Num(7,0) |
Last midtrm grd dte |
Year Term Subterm Table (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 |
Course Authorizations (CRSATP)
This file and its L0 and L1 logical files were added with the following fields:
|
Field |
Type |
Description |
|
EBCQAA |
Char(4) |
Year code |
|
EBCMAA |
Char(2) |
Term code |
|
EBB1AA |
Char(5) |
Crs component 1 |
|
EBB2AA |
Char(5) |
Crs component 2 |
|
EBB3AA |
Char(5) |
Crs component 3 |
|
EBB4AA |
Char(5) |
Crs component 4 |
|
EBB5AA |
Char(5) |
Crs component 5 |
|
EBB6AA |
Char(5) |
Crs component 6 |
|
EBNMID |
Num(9,0) |
NAMMS NAME-ID |
|
EBEFAV |
Num(9,0) |
Sequence # |
|
EBASTS |
Char(1) |
Authorization Status |
|
EBACND |
Char(2) |
Authorization Condition |
|
EBARSN |
Char(2) |
Authorization Reason |
|
EBENBY |
Num(9,0) |
Entered by ID |
|
EBDTEN |
Num(7,0) |
Dte Entered |
|
EBUSR |
Char(10) |
User name |
|
EBJOB |
Char(10) |
Job name |
|
EBJDT |
Num(7,0) |
Job date |
|
EBJTM |
Num(6,0) |
*Job time |