RB_STG_SQL_TBL (SQL Table)	Index Back
Pre-ETL Static SQL Table This table stores miscellaneous SQLs to be executed at Matching time or Pre-ETL time. These SQLs are used for managing complex exceptional SQLs which cannot be autogenerated at Matching time.

RB_STG_SQL_TBL

(SQL Table)

Pre-ETL Static SQL Table

This table stores miscellaneous SQLs to be executed at Matching time or Pre-ETL time. These SQLs are used for managing complex exceptional SQLs which cannot be autogenerated at Matching time.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

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

3 LI_SQL_TYPE Character(2) VARCHAR2(2) NOT NULL SQL Type
01=Matching
02=Pre-ETL
03=Update Trigger
04=Insert Trigger

4 SQL_STMT_2540 Long Character(2540) CLOB SQL Statement length 2540

5 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
2	LI_TEMPLATE_ID	Character(31)	VARCHAR2(31) NOT NULL	template identifier
3	LI_SQL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	SQL Type 01=Matching 02=Pre-ETL 03=Update Trigger 04=Insert Trigger
4	SQL_STMT_2540	Long Character(2540)	CLOB	SQL Statement length 2540
5	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