Data section

The following fields are in the Data section.

Fields Descriptions
Term Enter the effective term for which the factor rule is in effect. This rule is in effect until a new, greater term record is created for this factor. This is a required field.

List Term Code Validation (STVTERM)

Level Level. Enter the level for which the factor rule is in effect. This field is not required.

List Level Code Validation (STVLEVL)

Campus Campus. Enter the campus for which the factor rule is in effect. This field is not required.

List Campus Validation (STVCAMP)

College College. Enter the college for which the factor rule is in effect. This field is not required.

List College Validation (STVCOLL)

Degree Enter the degree for which the factor rule is in effect. This field is not required.

List Degree Code Validation (STVDEGC)

Program Enter the program for which the factor rule is in effect. This field is not required.

List All Program Codes (SMAPRLE)

Field of Study Type Field of study type for the curriculum for which the factor rule is in effect.

List Learner Field of Study (GTVLFST)

Field of Study Code Code for the field of study (major) for which the factor rule is in effect. This field is not required.

List All Major Codes (STVMAJR)

Curricula Pulldown field used to specify if the curricular elements defined on the rule must come from the primary curriculum record, secondary curriculum record, or any curricula.

Valid values are:

Primary

Secondary

Any

The default value is Primary.

Admission Type Admit type. Enter the admit type for which the factor rule is in effect. This field is not required.

List Admission Type Validation (STVADMT)

Student Type Student type. Enter the student type for which the factor rule is in effect. This field is not required.

List Student Type Code Validation (STVSTYP)

Residence Code Residency. Enter the residency type for which the factor rule is in effect. This field is not required.

List Residence Code Validation (STVRESD)

Factor Enter the factor code for which the rating rule is in effect. This field is required. See example below.

List Admissions Factor Code Validation (STVAFCT)

Table Name Enter the table name to be used with the factor code for the generated SQL statement. This field is not required and is validated against ALL_TABLES. See example below.

List User Table Names

Select Column Enter the database table column to be used in the select condition of the generated SQL statement. List displays the available columns from ALL_TAB_COLUMNS based on the table name entered in the Table Name field. Select the column for the condition you want met when associating the Select Column with the Factor field. This field is not required. See example below.

List User Table Columns

Where Column Enter the database table column to be used in the where condition of the generated SQL statement. List displays the available columns from ALL_TAB_COLUMNS based on the table name entered in the Table Name field. This field is not required. See example below.

List User Table Columns

Value Enter an alpha-numeric value for the factor value. If an SQL statement is to be generated, this value is used in the where condition. Otherwise, this value will be a static value for the factor code. This field is not required. See example below.
Activity Date This is the date the record was created. This field is display only.

Example

To assign the test score associated with a test code of S01 to the factor code of TestS01, enter the following values:

Field Value
Factor TestS01
Table Name SORTEST
Select Column SORTEST_TEST_SCORE
Where Column SORTEST_TESC_CODE
Value S01