RUN_HELPDESK(SQL Table) |
Index Back |
|---|---|
HelpDesk Crystal ReportTable used to execute Crystal report of HelpDesk Information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: RF_ADD_OPR_VW |
| 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 | RC_PRIORITY |
Character(5) | VARCHAR2(5) NOT NULL |
Case Priority
Prompt Table: RC_PRIORITY_TBL |
| 5 | RC_STATUS |
Character(5) | VARCHAR2(5) NOT NULL |
Case Status
Prompt Table: RC_STATUS_TBL |
| 6 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 7 | RC_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Specialty type. Used on HD case. |
| 8 | CUSTOMER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Customer Type
1=User 1 2=User 2 3=User 3 4=User 4 |
| 9 | DATE_RANGE | Character(1) | VARCHAR2(1) NOT NULL | Sched Ship Date Range |
| 10 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 11 | FROM_DATE | Date(10) | DATE | From Date |
| 12 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 13 | NAME_ASSIGNED_TO | Character(80) | VARCHAR2(80) NOT NULL |
The name of the assigned agent.
Prompt Table: RC_PROV_PER_VW |
| 14 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RSF_PERSON_VW |
| 15 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 16 | RC_BUS_PROCESS_ID | Character(15) | VARCHAR2(15) NOT NULL |
Business Process ID used in Business Process tracking.
Prompt Table: RC_BUS_PROCESS |
| 17 | RC_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
CallCenter Category. Used in HD.
Prompt Table: RC_CATEGORY_VW |
| 18 | RC_DETAIL | Character(5) | VARCHAR2(5) NOT NULL | Detail field on HD Case. Used in Quick Code. |
| 19 | CASE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Case Type
Prompt Table: RC_CASETYPE_TBL |
| 20 | RC_FREQ_USED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Frequently used flag. |
| 21 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 22 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 23 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 24 | THRU_DATE | Date(10) | DATE | Through Date |