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.

GPVersionId20.11.0.0Number(10)Foreign key to GPVersion.ID.
GPNodeId20.11.0.0Number(10)Foreign key to GPNode.ID
NumScoreOp20.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 <=.
PassAlphaScore20.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.
PassNumScore20.11.0.0
Float(126)Number used to determine a passing score for the test based on NumScoreOp.
PassPercentScore20.11.0.0
Float(126)Percent value used to determine a passing score for the test based on PercentScoreOp.
PercentScoreOp20.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).

SortOrder20.11.0.0Number(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. 

Copyright © 2021 PowerSchool Group LLC