Sort Order for Curriculum Records

Records can be sorted by current or not current, depending on the setting of the Current field, which indicates if the curriculum is the most current for the priority (Y) or is not the most current (N).

The default for the Curriculum window is to display all curriculum records for the given ID, term, and key sequence number.

The following sort order is used to determine how records will be displayed after the population to be displayed has been determined. This sort order applies to all places where curriculum data is displayed.

For SORLCUR:

Module (On SOILCUR only; as module is a default value on all other forms, and each page only displays data for its module.)
Term Code (if the module is not LEARNER or OUTCOME)
Key Sequence
Current and Active
Priority number, in ascending order (As the lowest priority number is the most important, it is displayed first.)
SORLCUR sequence number, in descending order (This is so the most recently entered records are displayed first.)

For SORLFOS:

Field of study type: major, minor, and then concentration
Current and Active
Priority, in ascending order
SORLFOS sequence number, in descending order

Fields	Descriptions
Record of	This field displays the number of curriculum records that exist for the ID based on the data entered in the key block, for example Record 1 of 5. You can scroll through the records. As you scroll through the records, the data in the Curriculum and Field of Study blocks changes for each record.
Current	This field specifies if the record is the current row for the priority. Valid values are selected (Current) or cleared (Not Current). Current = Displays the most recent row for each given priority (i.e., the highest sequence number for each priority). This assumes you are only displaying rows for the given learner module and key sequence number. Not Current = Displays rows for the given learner module and key sequence number that are not the most recent.
Activity	This is the curriculum activity status code. List Curriculum Activity Status (STVCACT)
Key Sequence	This is the key sequence number of the module record that is associated with the curriculum record. This sequence number will be the same as either the recruiting, application, or degree sequence number, or it will be 99 for a learner sequence record.
Term	This is the term code for the module’s curriculum record. List Term Code Validation (STVTERM)
Catalog Term	This is the catalog term code for the module’s curriculum record. List Term Code Validation (STVTERM)
Priority	This is the priority number that defines the curriculum rank.
Program	This is the program for the module’s curriculum record. List All Program Codes (SMAPRLE) Help Base Curriculum Rules by Program Count Hits Change Curriculum Edit Curriculum Rules (SOACURR)
Level	This is the level for the module’s curriculum record. List Level Code Validation (STVLEVL) Help Base Curriculum Rules by Level Count Hits Change Curriculum
Campus	This is the campus for the module’s curriculum record. List Campus Validation (STVCAMP) Help Base Curriculum Rules by Campus Count Hits Change Curriculum
College	This is the college for the module’s curriculum record. List College Validation (STVCOLL) Help Base Curriculum Rules by College Count Hits Change Curriculum
Degree	This is the degree for the module’s curriculum record. List Degree Code Validation (STVDEGC) Help Base Curriculum Rules by Degree Count Hits Change Curriculum
User ID	This field displays the user ID of the person who created the record.
Activity Date	This field displays the date the record was created or modified.
Start Date	This is the start date of the curriculum. (This field is not used at this time.)
End Date	This is the end date of the curriculum. (This field is not used at this time.)

Mouse	Keyboard	Result
Replace	N/A	Copies record, inactivates record, inserts new blank record
Update	N/A	Copies record, performs non-destructive update
Duplicate	N/A	Copies record, inserts duplicate record