RC_PREDEFN_IDROLE_TYPE_ID_CUSTPrompt Table: BO_ROLE_TYPE
RC_DEFINED_SRCHY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
RC_DEFINED_SRCH(SQL Table) |
Index Back |
|---|---|
Predefined Case Search CriteraUsed in Self-Service Help Desk and Support. This is system data. |
| # | 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 |
| 5 | ENABLE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enabled field.
Y/N Table Edit Default Value: N |
| 6 | DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Flag
Y/N Table Edit Default Value: N |