SCR_PROF_QST_V

(SQL View)
 Index Back

Profile Factors


SELECT Q.QUESTION_ID , S.SUP_OB_TEMPLATE_ID ,S.SEQ_NBR ,Q.SUP_CONTACT_TYPE ,Q.BID_FACTOR_TYPE ,Q.COMMENTS_2000 ,Q.REQUIRED_FLG ,'' ,'' FROM PS_SUP_PROFILE_QST Q , PS_SUP_REG_PROFQST S WHERE Q.QUESTION_ID = S.QUESTION_ID AND S.SUPOB_REG_OPT_TYPE = 'RS' AND S.SELECTED_FLAG = 'Y'

  • Related Language Record: SUP_PROF_Q_V_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    2 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id
    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    4 SUP_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Question Type
    A=Both
    B=Business
    I=Individual
    5 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
    A=Attachment
    C=Monetary
    D=Date
    L=List
    N=Numeric
    S=Separator
    T=Text
    Y=Yes/No
    6 COMMENTS_2000 Long Character CLOB NOT NULL Comment Text
    7 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    8 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier