SCD_UPD_QUES_VW

(SQL View)
 Index Back

Questions Update View

Questions Update View - used by Pivot grid search

SELECT SCD_QUESTION_ID , SCD_QUESTION_GROUP , SCD_QUEST_TYPE , SCD_QUESTN_STATUS , SCD_QUESTION_TEXT , SCD_DESCR30 FROM PS_SCD_QUESTIONS

  • Related Language Record: SCD_UPDQUES_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Question ID
    2 SCD_QUESTION_GROUP Character(15) VARCHAR2(15) NOT NULL Question Group

    Prompt Table: SCD_QUEST_GRPS

    3 SCD_QUEST_TYPE Character(2) VARCHAR2(2) NOT NULL Question Type
    K=KPI
    S=Subjective

    Default Value: S

    4 SCD_QUESTN_STATUS Character(2) VARCHAR2(2) NOT NULL Question Status
    AV=Available
    NA=Not Available
    PE=Pending
    5 SCD_QUESTION_TEXT Character(254) VARCHAR2(254) NOT NULL Question Text
    6 SCD_DESCR30 Character(30) VARCHAR2(30) NOT NULL 30 Character Description