SOLUTION_IDADHC=Adhoc Solution
CAND=Canned Solution
FILE=File
LINK=Link
S=Standard Solution
W=Workaround Solution
N=Not Expired
Y=Expired
Default Value: N
Prompt Table: RC_SOLN_NEW_VW
RC_SA_SOLNID_VW(SQL View) |
Index Back |
|---|
| SELECT SOLUTION_ID ,RC_SOLUTION_TYPE ,RC_SUMMARY ,SYMPTOM_DESCR ,SOLUTION_DESCR ,EXPIRY_IND ,EXPIRY_DATE ,EXPIRY_REASON ,NEW_SOLUTION_ID FROM PS_RC_SOLUTION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOLUTION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 2 | RC_SOLUTION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Solution Type
ADHC=Adhoc Solution CAND=Canned Solution FILE=File LINK=Link S=Standard Solution W=Workaround Solution |
| 3 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 4 | SYMPTOM_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Symptom Description |
| 5 | SOLUTION_DESCR | Long Character | CLOB | Solution Description |
| 6 | EXPIRY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Expiry Indicator
N=Not Expired Y=Expired Default Value: N |
| 7 | EXPIRY_DATE | Date(10) | DATE | Expiry Date |
| 8 | EXPIRY_REASON | Character(80) | VARCHAR2(80) NOT NULL | Expiry reason |
| 9 | NEW_SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Superceding Solution ID
Prompt Table: RC_SOLN_NEW_VW |