Aeries Database Changes 11/06/2020 : Aeries Software

Aeries Database Changes 11/06/2020

started a topic over 2 years ago

Is New?	Table	Field	Comments
FALSE	RPO	UID	Increased the Report Print Options (RPO) User ID (UID) field from a smallint to an int to match the related User and Group Name (UGN) field.
FALSE	AHS	RA, RS	Added Remote Asynchronous (RA) and Remote Synchronous (RS) counts to the Attendance History Summary (AHS) table.
FALSE	GPD	TM	Removed Term (TM) from the PrimaryKey and ForeignKey Constraints of the Grading Periods (GPD) table.
FALSE	GPC	TM	Removed Term (TM) from the Grading Period Calculations (GPC) table.
FALSE	GPS	TM	Removed Term (TM) from the Grading Period Scores (GPS) table.
FALSE	PSS		Added relationship from Post-Secondary Survey (PSS) to the IDN table.
FALSE	STJ	NOS, IT	Added Number of Students (NOS) and Instruction Type (IT) to the Staff Job Assignments (STJ) table.
FALSE	CRQ	SA	Increased Subject Area (SA) in the Course Requests Cross Reference (CRQ) table to match Courses (CRS) fields.