INSTITUTIONDefault Value: ADM_APPL_DATA.INSTITUTION
Prompt Table: INSTITUTION_TBL
EVALUATION_CODEEFFDTDefault Value: %date
EXT_ORG_IDPrompt Table: EXT_ORG_TBL
AVG_CRSE_GRPSCHOOL_CRSE_NBRPrompt Table: %EDITTABLE
Y/N Table Edit
Default Value: N
ADM_AVG_EVL_CRS(SQL Table) |
Index Back |
|---|---|
Admission Avg Program CoursesAD02A - Canadian Extensions: ADM_AVG_PRG_CRS is used to record the courses to be used in the program specific Criteria for average calculations. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: ADM_APPL_DATA.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | EVALUATION_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Evaluation Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 5 | AVG_CRSE_GRP |
Character(1) | VARCHAR2(1) NOT NULL | Course Group for Average Calc |
| 6 | SCHOOL_CRSE_NBR |
Character(10) | VARCHAR2(10) NOT NULL |
School Course Nbr
Prompt Table: %EDITTABLE |
| 7 | WILDCARD_IND | Character(1) | VARCHAR2(1) NOT NULL |
WildCard Indicator
Y/N Table Edit Default Value: N |
| 8 | SCHOOL_CRSE_CMPR | Character(10) | VARCHAR2(10) NOT NULL | School Course Compare |
| 9 | MIN_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Minimum Score |