PROD_MSG_NW_TAO (SQL Table)	Index Back
Product Messages Insert Temp table to be used to insert product messages. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14)

PROD_MSG_NW_TAO

(SQL Table)

Product Messages Insert

Temp table to be used to insert product messages. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: PROD_ITEM

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

5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

6 MESSAGE_CD Character(6) VARCHAR2(6) NOT NULL Message Code
Prompt Table: MESSAGE_TBL

7 START_DT Date(10) DATE NOT NULL Start date field to store start date value.

8 END_DT Date(10) DATE NOT NULL This field stores the end date values.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
3	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PROD_ITEM
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	MESSAGE_CD	Character(6)	VARCHAR2(6) NOT NULL	Message Code Prompt Table: MESSAGE_TBL
7	START_DT	Date(10)	DATE NOT NULL	Start date field to store start date value.
8	END_DT	Date(10)	DATE NOT NULL	This field stores the end date values.