As part of the School Start up routine, Teacher records that are no longer needed in the new school year should be deleted. If the Delete button is not available, it is because the teacher number is associated with existing tables.
Cause
The most common tables the teacher record may still be associated with are MST and SMS, but there are several other tables as well.
Resolution
Run these SQL statements to identify table(s) the teacher record is still associated with:
- Replace @tn with actual Teacher number and @sc with actual School Number
select 'FromCAR', * from CAR where tn = @tn and sc = @sc
select 'FromGRD', * from GRD where tn = @tn and sc = @sc
select 'FromSTU', * from STU where cu = @tn and sc = @sc
select 'FromATT', * from ATT where tn = @tn and sc = @sc
select 'FromMST', * from MST where tn = @tn and sc = @sc
select 'FromYTD', * from YTD where tn = @tn and sc = @sc
select 'FromDAC', * from DAC where tn = @tn and sc = @sc
select 'FromCSD', * from CSD where tn = @tn
select 'FromASL', * from ASL where tn = @tn and sc = @sc
select 'FromSMS', * from SMS where tn = @tn and sc = @sc
select 'FromSSS', * from SSS where tn = @tn and sc = @sc
select 'FromCSE', * from CSE where tn = @tn and sc = @sc
select 'FromGBK', * from GBK where tn = @tn and sc = @sc
select 'FromGBB', * from GBK where tn = @tn and sc = @sc
select 'FromLNC', * from LNC where tn = @tn and sc = @sc
select 'FromTBC', * from TBC where tc = @tn and sc = @sc
select 'FromINV', * from INV where tn = @tn
select 'FromGRD', * from GRD where tn = @tn and sc = @sc
select 'FromSTU', * from STU where cu = @tn and sc = @sc
select 'FromATT', * from ATT where tn = @tn and sc = @sc
select 'FromMST', * from MST where tn = @tn and sc = @sc
select 'FromYTD', * from YTD where tn = @tn and sc = @sc
select 'FromDAC', * from DAC where tn = @tn and sc = @sc
select 'FromCSD', * from CSD where tn = @tn
select 'FromASL', * from ASL where tn = @tn and sc = @sc
select 'FromSMS', * from SMS where tn = @tn and sc = @sc
select 'FromSSS', * from SSS where tn = @tn and sc = @sc
select 'FromCSE', * from CSE where tn = @tn and sc = @sc
select 'FromGBK', * from GBK where tn = @tn and sc = @sc
select 'FromGBB', * from GBK where tn = @tn and sc = @sc
select 'FromLNC', * from LNC where tn = @tn and sc = @sc
select 'FromTBC', * from TBC where tc = @tn and sc = @sc
select 'FromINV', * from INV where tn = @tn
The SQL statements can also be run as Aeries Web queries (with the exception of the TBC table)
- Replace @tn with actual Teacher number and @sc with actual School Number
LIST CAR IF TN = @tn AND SC = @sc
LIST GRD IF TN = @tn AND SC = @sc
LIST STU IF CU = @tn AND SC = @sc
LIST ATT ATT IF TN = @tn AND SC = @sc
LIST GRD IF TN = @tn AND SC = @sc
LIST STU IF CU = @tn AND SC = @sc
LIST ATT ATT IF TN = @tn AND SC = @sc
LIST MST IF TN = @tn AND SC = @sc
LIST YTD IF TN = @tn AND SC = @sc
LIST DAC IF TN = @tn AND SC = @sc
LIST CSD IF TN = @tn
LIST ASL IF TN = @tn AND SC = @sc
LIST SMS IF TN = @tn AND SC = @sc
LIST SSS IF TN = @tn AND SC = @sc
LIST CSE IF TN = @tn AND SC = @sc
LIST GBK IF TN = @tn AND SC = @sc
LIST GBB IF TN = @tn AND SC = @sc
LIST LNC IF TN = @tn AND SC = @sc
LIST INV IF TN = @tn
LIST YTD IF TN = @tn AND SC = @sc
LIST DAC IF TN = @tn AND SC = @sc
LIST CSD IF TN = @tn
LIST ASL IF TN = @tn AND SC = @sc
LIST SMS IF TN = @tn AND SC = @sc
LIST SSS IF TN = @tn AND SC = @sc
LIST CSE IF TN = @tn AND SC = @sc
LIST GBK IF TN = @tn AND SC = @sc
LIST GBB IF TN = @tn AND SC = @sc
LIST LNC IF TN = @tn AND SC = @sc
LIST INV IF TN = @tn
After the table(s) are identified, the appropriate page can be accessed to edit the record and remove the TN.
If the school is Elementary w/MST or Secondary and the SSS/SMS has already been copied to SEC/MST, it may be necessary to change the Scheduling Setup > Scheduling Status to Scheduling Students into classes for the current school year to make any necessary changes to the Scheduling Master Schedule or Course Request records. The user will not do anything in the Schedule Setup other than change the Scheduling Status to Scheduling Students into classes for the current school year. Once the records have been corrected, change Scheduling Setup > Scheduling Status back to Scheduling Tables are Inactive.