SOLN_ADV_LOG_NBRY/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
RC_SOLN_ADV_LOG(SQL Table) |
Index Back |
|---|---|
Solution Advisor LogLog record for solution advisor. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOLN_ADV_LOG_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Solution Advisor Log Number |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 4 | 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. |
| 5 | RC_CASE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Case Indicator
Y/N Table Edit |
| 6 | RC_PST_IND | Character(1) | VARCHAR2(1) NOT NULL |
Problem Solving Technique
Y/N Table Edit |
| 7 | RC_RESOLUTION_IND | Character(1) | VARCHAR2(1) NOT NULL |
Independent Text Solution
Y/N Table Edit |
| 8 | RC_SOLUTION_IND | Character(1) | VARCHAR2(1) NOT NULL |
Solution Indicator
Y/N Table Edit |
| 9 | RC_SOLN_COUNT | Number(3,0) | SMALLINT NOT NULL | Solution Count |
| 10 | RC_RSLN_COUNT | Number(3,0) | SMALLINT NOT NULL | Resolution Count |
| 11 | RC_CASE_COUNT | Number(7,0) | INTEGER NOT NULL | Case Count |
| 12 | RC_PST_COUNT | Number(3,0) | SMALLINT NOT NULL | PST Count |