RUN_RCC2005

(SQL Table)
Index Back

Run control record

Run control record used on call center report or process.

# 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 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 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID

Prompt Table: RC_CUST_TYPE_VW

7 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
8 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
9 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
10 FROM_DATE Date(10) DATE NOT NULL From Date
11 THRU_DATE Date(10) DATE NOT NULL Through Date
12 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

Prompt Table: RC_CASETYPE_TBL

13 CUSTOMER_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Type
1=User 1
2=User 2
3=User 3
4=User 4

Default Value: 1

14 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

Prompt Table: RC_CUST_TYPE_VW