RATING_CMP_TBL(SQL Table) |
Index Back |
|---|---|
Admission Rating Component TblRATING_CMP_TBL allows an Institution to define the components within a rating scheme they will use in evaluating individuals. |
| # | 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 | RATING_SCHEME |
Character(10) | VARCHAR2(10) NOT NULL |
Rating Scheme
Prompt Table: RATING_SCH_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | RATING_CMP |
Character(5) | VARCHAR2(5) NOT NULL |
Rating Component
Prompt Table: RTNG_CMPDEF_TBL |
| 5 | RATING_CMP_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Component Type
CUML=Cumulative INDV=Individual Default Value: INDV |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: RTNG_CMPDEF_TBL.DESCR |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: RTNG_CMPDEF_TBL.DESCRSHORT |
| 8 | DETERM_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Rating Determination Method
AUT=Automatically Calculated MAN=Manually Assigned Default Value: MAN |
| 9 | FORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL | Calculation Formula ID |
| 10 | FINAL_CMP_VALUE | Character(1) | VARCHAR2(1) NOT NULL |
Final Value
Y/N Table Edit Default Value: N |
| 11 | RTNG_CMP_PROC_ORDR | Number(3,0) | SMALLINT NOT NULL | Processing Order |
| 12 | REQUIRED | Character(8) | VARCHAR2(8) NOT NULL |
Required
Y/N Table Edit Default Value: N |