PRODNOTEKEY_AET (SQL Table)	Index Back
Prod Notes KeyWords State Rec State record for product notes keywords. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14)

PRODNOTEKEY_AET

(SQL Table)

Prod Notes KeyWords State Rec

State record for product notes keywords. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 1

5 KEY_WORD Character(20) VARCHAR2(20) NOT NULL Key Word

6 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

8 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
5	KEY_WORD	Character(20)	VARCHAR2(20) NOT NULL	Key Word
6	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
8	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.