RC_WF_RUN_CNTL

(SQL Table)
Index Back

Call Center Workflow Run Cntl

Runc Control record for Asyncronous workflow in Call Center.

# 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 RULE_NAME Character(30) VARCHAR2(30) NOT NULL This field is a text field of 30 character long.
4 SCHED_PRCS_NBR Number(15,0) DECIMAL(15) NOT NULL Schedule Process Number..............................................

Default Value: 1999999999

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 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.
7 EVENT_SET_ID Character(15) VARCHAR2(15) NOT NULL Event Set ID
8 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
9 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
10 REPEAT_MINUTES Number(10,0) DECIMAL(10) NOT NULL Repeat Minutes...................................................
11 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
12 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
13 MARKET Character(3) VARCHAR2(3) NOT NULL Market