RC_SOLN_MGT_TBL(SQL Table) |
Index Back |
|---|---|
Solution Management Setup Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCORE_THRESHOLD | Number(3,0) | SMALLINT NOT NULL | Score Field that is used in Natural Language Processing Search. This is used in Case Solution Module. |
| 2 | LIMIT_BY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Limit Number of Solution Shown on the Grid. This field is used in Solution Component.
R=Rows returned S=Score Default Value: R |
| 3 | MAX_ROWS | Number(3,0) | SMALLINT NOT NULL | Maximum Number for Rows allowed. This field is used in Solution Management Component. |
| 4 | ENFORCE_SETID_IND | Character(1) | VARCHAR2(1) NOT NULL |
Enforce Set ID Logic
Y/N Table Edit Default Value: Y |
| 5 | FREQ_USED_SOLN_CNT | Number(3,0) | SMALLINT NOT NULL | Total Count of Frequently Used Solutions |
| 6 | ALT_SCORING_IND | Character(1) | VARCHAR2(1) NOT NULL |
Alternate Scoring
Y/N Table Edit Default Value: N |
| 7 | RC_SOLUTION_IND | Character(1) | VARCHAR2(1) NOT NULL |
Solution Indicator
Y/N Table Edit Default Value: Y |
| 8 | RC_RESOLUTION_IND | Character(1) | VARCHAR2(1) NOT NULL |
Independent Text Solution
Y/N Table Edit Default Value: Y |
| 9 | RC_CASE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Case Indicator
Y/N Table Edit Default Value: Y |
| 10 | RC_PST_IND | Character(1) | VARCHAR2(1) NOT NULL |
Problem Solving Technique
Y/N Table Edit Default Value: Y |