Admissions Rating Factor Rules (SAARRFT) page / Main window |
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. |
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 |