ADM_AVG_EVAL(SQL Table) |
Index Back |
---|---|
Admission Average EvaluationAD02A - Averages ADM_AVG_EVAL is used to record 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
Prompt Table: INSTITUTION_TBL |
2 | EVALUATION_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Evaluation Code
Prompt Table: EVALUATION_TBL |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | CRSE_COUNT | Number(5,2) | DECIMAL(4,2) NOT NULL | Course Count |
5 | COURSE_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Course Level
11=Grade 11 12=Grade 12 AP=Advanced Placement DR=Graduate/Doctoral FR=Freshman GR=Graduate HN=Honors IB=International Baccalaureate JR=Junior LD=Lower Division MS=Graduate/Master RG=Regular SO=Sophomore SR=Senior UD=Upper Division |
6 | EXT_ACAD_LEVEL | Character(4) | VARCHAR2(4) NOT NULL |
External Academic Level
0=Unknown 01=Pre-Eighth Grade 1=Eighth Grade 2=Ninth Grade 3=Tenth Grade 4=Eleventh Grade 5=Twelfth Grade 6=Postsecondary First Year 7=Postsecondary Sophomore 8=Postsecondary Junior 9=Postsecondary Senior 90=Post-Secondary 91=Postsecondary Professional 92=Postsecondary Master 93=Postsecondary Doctoral 94=Postdoctoral A1=Basic User/Breakthrough (NLD) A2=Basic User/Waystage (NLD) B1=Independ. User/Threshold (NLD) B2=Independ. User/Vantage (NLD) C1=Prof. User/Effective (NLD) C2=Proficient User/Master (NLD) |
7 | MIN_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Minimum Score |
8 | REPEAT_GRADE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Repeated Grade Processing
F=First Taken H=Highest Grade L=Last Taken |