PROD_SPC_UP_AET

(SQL Table)
Index Back

Product Specs State Record

State record for product specifications 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 SetID
3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
4 PROD_SPEC_TYPE_SEQ Number(2,0) SMALLINT NOT NULL Sequence Number
5 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
6 WS_CONCAT_SPEC Character(1) VARCHAR2(1) NOT NULL Used on Prod Spec page to denote where two prod spec line should be combined into one.
7 WS_USE_AS_URL Character(1) VARCHAR2(1) NOT NULL Used on Prod specs to denote where a URL is used in a product spec line.
H=Use As HTML
T=Use As Text
U=Use As URL
8 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
9 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
10 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.
11 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
12 DESCRLONG Long Character CLOB Long Description