RUN_CASES(SQL Table) |
Index Back |
|---|---|
Cases Crystal Report |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RC_NONVW |
| 4 | CASE_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Case Type
Prompt Table: RC_CASETYPE_TBL |
| 5 | RC_PRIORITY |
Character(5) | VARCHAR2(5) NOT NULL |
Case Priority
Prompt Table: RC_PRIORITY_TBL |
| 6 | RC_STATUS |
Character(5) | VARCHAR2(5) NOT NULL |
Case Status
Prompt Table: RC_STATUS_TBL |
| 7 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 8 | DATE_RANGE | Character(1) | VARCHAR2(1) NOT NULL | Sched Ship Date Range |
| 9 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
Prompt Table: RC_ASSIGN_VW |
| 10 | FROM_DATE | Date(10) | DATE NOT NULL | From Date |
| 11 | THRU_DATE | Date(10) | DATE NOT NULL | Through Date |
| 12 | CUSTOMER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Customer Type
1=User 1 2=User 2 3=User 3 4=User 4 |
| 13 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL |
Generic 50 character name field for storing names.
Prompt Table: RC_CUST_VW |
| 14 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 15 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 16 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: RC_CASE |
| 17 | RC_FREQ_USED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Frequently used flag. |