GPProgressSubjectProgram (ver21.11.0.0)
For reporting purposes, this table contains a summary of ACP programs and their progress. Data is accessed by selecting a group of students and then navigating to [Select Function] arrow > Graduation Progress Report Data Capture (or Special Functions > Group Functions > Graduation Progress Report Data Capture).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CareerTechProgramID | 21.11.0.0 | Number(10,0) | Foreign key to the CareerTechProgram table. Required. |
| GPProgressSubjectID | 21.11.0.0 | Number(19,0) | Foreign key to the related GPProgressSubject table. Required. |
| HasEnoughCredits | 21.11.1.0 | Number(1,0) | Boolean (1 = true, 0 = false) indicating if the student has accumulated the number of credits required for this program. |
| ID | 21.11.0.0 | Number(19,0) | Primary key. System assigned; unique, indexed. Required. |
| IsComplete | 21.11.0.0 | Number(1,0) | Boolean (1 = true, 0 = false) indicating if this program has been completed successfully. Required. |
| IsInProgress | 21.11.0.0 | Number(1,0) | Boolean (1 = true, 0 = false) indicating if this program is in progress. Required. |
| IsNotStarted | 21.11.0.0 | Number(1,0) | Boolean (1 = true, 0 = false) indicating if progress on this program has been started. Required. |
| IsPassedByCredentials | 21.11.0.0 | Number(1,0) | Boolean (1 = true, 0 = false) indicating if this program has been passed by credentials instead of courses. |
| MinGPAMet | 21.11.0.1 | Number(1,0) | Boolean value indicating that this program meets minimum GPA requirements (value = 1). Null if there is no minimum GPA requirement. |
| ProgramGPA | 21.11.1.1 | Float | GPA that has been calculated for this program if there is a minimum GPA requirement. |