RBT_DEFINE_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 | MARKET | Character(3) | VARCHAR2(3) NOT NULL |
Market
Default Value: GBL |
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 |