SETIDAG_CAT_TYPE001=Role
002=Department
003=Priority
004=Source
005=Location
0=0 - Not Applicable
1=1 - Low
2=2 - Medium Low
3=3 - Medium
4=4 - Medium High
5=5 - High
Default Value: 0
RF_AG_SRCH_WGHT(SQL Table) |
Index Back |
|---|---|
Agreement Search WeightingsAgreement Search Category Weighting Factors (for use in agreement search) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | AG_CAT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Agreement Category types for use in Agreement Search and weighting
001=Role 002=Department 003=Priority 004=Source 005=Location |
| 3 | AG_CAT_WEIGHT | Character(1) | VARCHAR2(1) NOT NULL |
Agreement Search Auto-selection Weighting Factor
0=0 - Not Applicable 1=1 - Low 2=2 - Medium Low 3=3 - Medium 4=4 - Medium High 5=5 - High Default Value: 0 |