OPRIDKEY_CASE_IDKEY_BUSINESS_UNITSEQ_NBR_4Default Value: %date
RC_SA_RSLT_KEYS(SQL Table) |
Index Back |
|---|---|
Solution Advisor Results Keys |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | KEY_CASE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Case ID |
| 3 | KEY_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | SEQ_NBR_4 |
Number(4,0) | SMALLINT NOT NULL | Sequence Nbr 4 |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | RC_SCORE | Number(6,2) | DECIMAL(5,2) NOT NULL | Survey Score |
| 7 | RC_TEXT_SCORE | Character(4) | VARCHAR2(4) NOT NULL | Field to display search score as text (in percentage) |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 9 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | CASE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. |
| 12 | RSLN_SEQ_NBR | Number(8,0) | INTEGER NOT NULL | Resolution Sequence Number |
| 13 | RC_SCRIPT_ID | Character(18) | VARCHAR2(18) NOT NULL | Branch Script ID |
| 14 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 15 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |