CASE_IDBUSINESS_UNITSEQ_NUMPrompt Table:
RF_PROVGRP_VW
Set Control Field: BUSINESS_UNIT
Prompt Table:
RC_GRP_MEM_VW4
Set Control Field: BUSINESS_UNIT
Prompt Table:
RB_OPR_PR_NM_VW
Set Control Field: BUSINESS_UNIT
RC_ASSIGN_HIST(SQL Table) |
Index Back |
|---|---|
Assignment HistoryThis record contains all of the provide group and agent assignments that have been made to each case. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CASE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table:
RF_PROVGRP_VW
|
| 5 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
Prompt Table:
RC_GRP_MEM_VW4
|
| 6 | ELAPSED_TIME | Character(10) | VARCHAR2(10) NOT NULL | The field stores the amount of time that has elapsed while a provider group and agent are assigned to a case |
| 7 | SLA_CONSUMED | Number(3,0) | SMALLINT NOT NULL | The SLA Consumed is used in Case Assignment History to store the percentage of SLA that has been consumed by each assignee on a case. |
| 8 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 9 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
ID of user who added the row.
Prompt Table:
RB_OPR_PR_NM_VW
|