SUP_PROF_QST_VW

(SQL View)
Index Back

Profile Questions


SELECT A.QUESTION_ID ,B.SEQ_NBR ,A.SUP_CONTACT_TYPE ,A.BID_FACTOR_TYPE ,A.COMMENTS_2000 ,A.REQUIRED_FLG ,B.SUP_OB_TEMPLATE_ID ,B.SUPOB_REG_OPT_TYPE ,A.UNIT_OF_MEASURE ,A.FULL_USR_ACCESS FROM PS_SUP_PROFILE_QST A , PS_SUP_REG_PROFQST B WHERE A.QUESTION_ID=B.QUESTION_ID AND B.SELECTED_FLAG='Y'

  • Related Language Record: SUP_PRO_Q_VW_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    3 SUP_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Question Type
    A=Both
    B=Business
    I=Individual
    4 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
    5 COMMENTS_2000 Long Character CLOB NOT NULL Comment Text
    6 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    7 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id
    8 SUPOB_REG_OPT_TYPE Character(2) VARCHAR2(2) NOT NULL On boarding manage invite options
    AD=Ad-hoc Tasks
    NB=Register New Bidders
    NS=Register New Suppliers
    NU=Register New User Accounts
    PC=Profile Change Request
    RB=Request Change for Bidder
    RS=Request Supplier Change
    9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    10 FULL_USR_ACCESS Character(1) VARCHAR2(1) NOT NULL Grant Full Access
    N=No
    Y=Yes