RDH_MERGE_AET

(SQL Table)
Index Back

CDM Merge AET Record

This is the main State record used by the CDM Merge Framework Application Engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 RBB_BPEL_INST_ID Character(100) VARCHAR2(100) NOT NULL Business Process Instance ID
4 MERGE_ID Number(15,0) DECIMAL(15) NOT NULL CDH Batch Merge ID
5 BO_ID_TO Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
6 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
7 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
8 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
10 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
11 BAS_SYSID Number(18,0) DECIMAL(18) NOT NULL Basic Data System ID
12 FROM_QTY Number(7,2) DECIMAL(6,2) NOT NULL From Quantity
13 COMMIT_FLAG Character(1) VARCHAR2(1) NOT NULL Commit Flag

Y/N Table Edit

14 DEBUG Character(1) VARCHAR2(1) NOT NULL Used to display debug messages from the application.

Y/N Table Edit