OPRIDPrompt Table: SP_SETID_NONVW
Prompt Table: RC_TREE_VW
Default Value: %date
I=Invalid
V=Valid
Default Value: I
RC_SA_PST_VW(SQL View) |
Index Back |
|---|---|
Solution Advisor PST ViewPST = Problem Solving Technique (an application of Branch Scripting) |
| SELECT K.OPRID , K.KEY_CASE_ID , K.KEY_BUSINESS_UNIT , K.RECNAME , K.RC_SCORE , K.RC_TEXT_SCORE , K.SETID , K.RC_SCRIPT_ID , K.EFFDT , P.EFF_STATUS , ' ' , P.DESCRLONG FROM PS_RC_SA_RSLT_KEYS K , PS_RC_BSCRIPT P WHERE K.RECNAME = 'RC_PST_VW' AND K.SETID = P.SETID AND K.EFFDT = P.EFFDT AND P.SCRIPT_TYPE = 'GUID' AND P.EFF_STATUS= 'A' |
| # | 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 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | RC_SCORE | Number(6,2) | DECIMAL(5,2) NOT NULL | Survey Score |
| 6 | RC_TEXT_SCORE | Character(4) | VARCHAR2(4) NOT NULL | Field to display search score as text (in percentage) |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 8 | RC_SCRIPT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Branch Script ID
Prompt Table: RC_TREE_VW |
| 9 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 10 | RC_SCRIPT_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Valid
I=Invalid V=Valid Default Value: I |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | COMMENTS | Long Character | CLOB | Comment |