RB_STG_REC_TBL (SQL Table)	Index Back
Dynamic Stage Record Table This table is populated at Run time with dynamic record names corresponding to templates used in a Import map. These record names are generated on the fly and are used by Matching and Error processing stages in Data Import.

RB_STG_REC_TBL

(SQL Table)

Dynamic Stage Record Table

This table is populated at Run time with dynamic record names corresponding to templates used in a Import map. These record names are generated on the fly and are used by Matching and Error processing stages in Data Import.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

2 LI_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL template identifier

3 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_VENDOR_EC
06=ITM_VNDR_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
11=MANUFACTURER_EC
12=ITEM_MFG_EC
13=EN_REVISION_EC

4 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	LI_TEMPLATE_ID	Character(31)	VARCHAR2(31) NOT NULL	template identifier
3	RECORDNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name 01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_VENDOR_EC 06=ITM_VNDR_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 11=MANUFACTURER_EC 12=ITEM_MFG_EC 13=EN_REVISION_EC
4	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID