GPScoreConfig (ver20.11.0.0)
This table contains details of meeting a graduation requirement for a test score that is included in a graduation plan. This is new functionality for Test Group Requirements.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 20.11.0.0 | Number(19) | Unique sequential number generated by the application. Indexed. Required. |
| GPVersionId | 20.11.0.0 | Number(10) | Foreign key to GPVersion.ID. |
| GPNodeId | 20.11.0.0 | Number(10) | Foreign key to GPNode.ID |
| NumScoreOp | 20.11.0.0 | Number(1) | Numeric value representing the comparison operator for determining a passing numeric score using PassNumScore. Valid values: 0 is =, 1 is >, 2 is <>, 3 is <, 4 is <=. |
| PassAlphaScore | 20.11.0.0 | Varchar2(20) | Generally a list of non-numeric values which qualify as a passing score. For example, A, B, C or Pass. |
| PassNumScore | 20.11.0.0 | Float(126) | Number used to determine a passing score for the test based on NumScoreOp. |
| PassPercentScore | 20.11.0.0 | Float(126) | Percent value used to determine a passing score for the test based on PercentScoreOp. |
| PercentScoreOp | 20.11.0.0 | Number(1) | Numeric value representing the comparison operator for determining a passing percent score using PassPercentScore. Valid values: 0 is =, 1 is >, 2 is <>, 3 is <, 4 is <=. |
Weight | 20.11.0.0 | Number(10) | Weight of this Score when used in a Summation. (See GPNode.isSummation). |
| SortOrder | 20.11.0.0 | Number(10) | Order of the score among its siblings. |
WhenCreated | 20.11.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 20.11.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 20.11.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 20.11.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |