HRS_QSTN_NOE_VW

(SQL View)
 Index Back

Question Table

Question Table

SELECT A.HRS_QSTN_ID ,A.HRS_QSTN_CD ,CASE WHEN A.HRS_QUES_TYPE <> ' ' THEN A.HRS_QUES_TYPE WHEN A.HRS_OPN_ENDED_QSTN = 'Y' THEN 'O' WHEN ( SELECT COUNT (HRS_QSTN_ID) FROM PS_HRS_QSTN_ANS D WHERE A.HRS_QSTN_ID = D.HRS_QSTN_ID AND D.CORRECT_ANSWER = 'Y') = 1 THEN 'S' ELSE 'M' END ,A.STATUS ,A.STATUS_DT ,A.DESCR ,A.DESCRSHORT ,A.HRS_OPN_ENDED_QSTN ,A.HRS_POINTS ,A.DESCRLONG FROM PS_HRS_QSTN_TBL A WHERE A.STATUS='A' AND (A.HRS_OPN_ENDED_QSTN <> 'Y' AND A.HRS_QUES_TYPE <> 'O')

  • Related Language Record: HRS_QSTN_TL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID
    2 HRS_QSTN_CD Character(10) VARCHAR2(10) NOT NULL Question Code
    3 HRS_QUES_TYPE Character(1) VARCHAR2(1) NOT NULL Question Type
    D=Date
    M=Multiple Choice
    N=Numeric
    O=Open Ended
    S=Single Choice
    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 HRS_OPN_ENDED_QSTN Character(1) VARCHAR2(1) NOT NULL Open Ended Questions
    9 HRS_POINTS Signed Number(5,0) DECIMAL(4) NOT NULL Default points assigned to an answer.
    10 DESCRLONG Long Character CLOB Long Description