| # |
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 |
REPORT_LISTING |
Character(4) |
VARCHAR2(4) NOT NULL |
Listing of Reports that can be run against the system
ADET=Activity Detail
ASUM=Activity Summary
CVOL=Chat Volume
EEFF=ERMS Effectiveness
EINT=ERMS Integration
ETEM=ERMS Template Usage
EVOL=ERMS Volume
TTTU=Top Ten Templates Used
|
| 4 |
SELECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field is a flag for selection .
Y/N Table Edit
Default Value: N
|
| 5 |
RB_START_DATE |
Date(10) |
DATE |
Starting Date field is widely used.
|
| 6 |
END_DATE |
Date(10) |
DATE |
End date field to store an end date.
|
| 7 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
RB_PRSN_NM_VW
|
| 8 |
GROUP_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Contact Management - Group Name
Prompt Table:
RB_WF_GRP_NM_VW
|
| 9 |
RB_RPT_GRP_WL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Group Worklist Nameg
Prompt Table:
RB_WF_GRP_NM_VW
|
| 10 |
WORKLIST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Worklist Flag.........................................................
Y/N Table Edit
Default Value: N
|
| 11 |
MAILBOX_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mail Box Id is an Id associated with Mail Boxes
Prompt Table:
RB_MB_RPT_VW
|
| 12 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
Prompt Table:
RB_RPT_PRDGR_VW
|
| 13 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
RB_RPT_PROD_VW
|
| 14 |
PERIOD_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Radio Button field for alowing the user to select between running a report hourly or daily/weekly/monthly
DAY=Daily
HOUR=Hourly
MON=Monthly
WEEK=Weekly
Default Value: HOUR
|
| 15 |
GROUP_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
Dropdown list for Chat / Email Reports. In order to list the field values to sort on.
EDT=End Date
GRP=Group Name
MBOX=Mailbox
PRD=Product
PRDG=Product Group
QUE=Queue
SDT=Start Date
UID=Person ID
WLST=Worklist
|