Difference between revisions of "Program Support Table"

Latest revision as of 23:35, 16 June 2013

Degree Identifiers

• Degree: This is the up to 4 character code for the degree. Typically this identifies the level of the degree, and the length.
• Conc: This is the major code for this degree (which should match a subject in the conc.dbf support table.
• Longname: This is the human readable name for this program. Note that standard academic nomenclature should be used. So the degree may contain the word "of," as in Bachelor of Arts, whereas the major should be separated with "in."

Enabling fields

• Active_app: this allows this program to appear in the application tabs and to be used with on-line applications.
• Active_reg: this allows this program to appear in progress of applications.

GPA fields:

• Graduating GPA Overall: This is the field Passgpa.
• Graduating Major GPA: This is the field Passmgpa.
• Graduation with distinction. Up to three levels of graduation with distinction are permitted. cum laude is in the Distinctn field, , magna cum laude is in the Distinctn2 field, while summa cum laude is in the Distinctn3 field. If a level is left at 0.00, it indicates that you do not have that level of distinction.

Faculty:

This is the faculty home for this program.

Program Length and Loads

Credits or Courses

Although course based programs are becoming extremely rare, both can be used in CrossRoad. Check the field Crs_v_cred for programs that are credit based.

Length

Prog_len should have the number of credits required in the program.

Minimum number of senior level credits

Minsenior should contain the number of credits after the introductory level that are required for this degree.

Maximum transfer

The field Maxxfr should have the maximum number of transfer credits available. Note that if this is left at 0 then no transfer will be counted towards the program.

Full time threshold

Ftthresh holds the minimum number of credits per term that a student must take to be considered full-time. This is normally 60% of the normal full-load.

Year of Study determination

Thresholds for students to be classified as being in a particular year of study should be entered. For any year that is not part of the program, 999 should be entered.

• Yr1thresh: this is the number of credits earned to be considered year 1. This is normally 0.00
• Yr2thresh: this is the number of credits earned to be considered year 2.
• Yr3thresh: this is the number of credits earned to be considered year 3.
• Yr4thresh: this is the number of credits earned to be considered year 4.

Loads

This is entered in credits. Any year that is not part of the program should be left at 0.00.

• Yr1load: This is the normal number of credits taken by students in the first year of the program
• Yr2load: This is the normal number of credits taken by students in the second year of the program
• Yr3load: This is the normal number of credits taken by students in the third year of the program
• Yr4load: This is the normal number of credits taken by students in the fourth year of the program

External Program Codes

• CIP: Classification of Instructional Programs as used by provincial and federal reporting agencies.
• PESC Award Code: This is required if XML transcripts are being produced.
• CISCode: This is the degree code for reporting in the Province of Alberta.
• QuaCode: This and the following fields all relate to former Stats Can reporting.
• Qualif:
• Prgcat:
• Approv:

Other fields

• Notes: This is a free form note field.
• Admitted: This is an inactive field relating to quota controls.
• Maximum: This is an inactive field relating to quota controls.