RC_PREDEFN_IDROLE_TYPE_ID_CUSTPrompt Table: BO_ROLE_TYPE
RC_DEFINED_SRCHRC_DEFN_SRCH_VW(SQL View) |
Index Back |
|---|---|
Pre-defined search viewPre Defined search view to contain only pre-defined searches that are enabled. |
| SELECT RC_PREDEFN_ID , ROLE_TYPE_ID_CUST , RC_DEFINED_SRCH , DESCR50 FROM PS_RC_DEFINED_SRCH WHERE ENABLE_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RC_PREDEFN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Pre-defined search definition to be used for the configurable component. (applicable for call center self-service case components) |
| 2 | ROLE_TYPE_ID_CUST |
Number(12,0) | DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
Prompt Table: BO_ROLE_TYPE |
| 3 | RC_DEFINED_SRCH |
Character(5) | VARCHAR2(5) NOT NULL | Predefined Search - Used in the Self-Service Search for Help Desk and Support. This is system data. |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |