DAD_UNCONF_TMP

(SQL Table)
Index Back

DAD_UNCONF_TMP

Temporary table to hold information from the DBAgent for the peoplecode to fire off and place it in the worklist table to create the proper workflow.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
5 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
6 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
7 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
10 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type