PROD_SPECS_MD

(SQL Table)
Index Back

Product Specifications Staging

Staging table for messaging.

  • Related Language Record: PROD_SPECS_MDLN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
    601=Consumer Sync
    701=BOM Sync
    801=Item Revision
    901=Item Bus Unit Sync
    902=Item Sync
    2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 PROD_SPEC_TYPE_SEQ Number(2,0) SMALLINT NOT NULL Sequence Number
    6 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    7 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.

    Y/N Table Edit

    Default Value: N

    8 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

    Default Value: T

    9 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

    Prompt Table: PSURLDEFN

    10 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    11 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.
    12 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    13 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    14 DESCRLONG Long Character CLOB Long Description