SGRCalculationSettings (ver12.0.1)

AllDroppedCalculationMode

12.0.1

Varchar2(16)

Defines how to handle rollup when all standard grade section records for the standard grade rollup are dropped. Valid values: AVERAGE, LAST_DROPPED. Required.

CurrentForYear

12.0.1

Number(1,0)

Defines if this setting group is currently used for standard grade rollup calculations. Valid values: 0 = False, 1 = True. Required.

CurrentForYearCheck

12.0.1

Number(1,0)

Virtual Column. Enforces that only one row is marked as current for a given year. Is the SGRCalculationSettingsID when CurrentForYear = 0, is -1 * YearId when CurrentForYear = 1. Unique.

ExcludeDropped

12.0.1

Number(1,0)

Defines if the rollup should exclude dropped standard grade section records from the standard grade rollup. Valid values: 0 = False, 1 = True. Required.

ExcludeExempt

12.0.1

Number(1,0)

Defines if the rollup should exclude teacher marked exempt standard grade section records from the standard grade rollup. Valid values: 0 = False, 1 = True. Required.

SGRCalculationSettingsID

12.0.1

Number(16,0)

Primary Key. Unique sequential number generated by the application. Indexed. Required.

WhenCreated

12.0.1

Timestamp(6)

Date and time the record was created. Defaults to system date. Required.

WhenModified

12.0.1

Timestamp(6)

Date and time the record was modified. Defaults to system date. Required.

WhoCreated

12.0.1

Varchar2(100)

The user login that created the record. Defaults to database user. Required.

WhoModified

12.0.1

Varchar2(100)

The user login that modified the record. Defaults to database user. Required.

YearID

12.0.1

Number(10,0)

A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Required.