INSTITUTIONPrompt Table: INSTITUTION_TBL
GPA_TYPEPrompt Table: GPA_RULES_EFFDT
EFFDTDefault Value: %date
FROM_GPAPrompt Table: GPA_VALUE_TBL
TO_GPAPrompt Table: GPA_VALUE_TBL
CONVERT_GPAGPA_RULES_TBL(SQL Table) |
Index Back |
|---|---|
GPA Rules Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | GPA_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
GPA Type
Prompt Table: GPA_RULES_EFFDT |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | FROM_GPA |
Number(7,3) | DECIMAL(6,3) NOT NULL |
From GPA
Prompt Table: GPA_VALUE_TBL |
| 5 | TO_GPA |
Number(7,3) | DECIMAL(6,3) NOT NULL |
To GPA
Prompt Table: GPA_VALUE_TBL |
| 6 | CONVERT_GPA |
Number(7,3) | DECIMAL(6,3) NOT NULL | Converted GPA |