HRS_QSTN_I

(SQL View)
 Index Back

Question Table Interface View

Question Table Interface View

SELECT A.HRS_QSTN_ID , A.HRS_QSTN_CD , A.HRS_QSTN_TYPE , A.STATUS , A.STATUS_DT , A.DESCR , A.DESCRSHORT , A.DESCRLONG ,%subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_QSTN_TBL A

  • Related Language Record: HRS_QSTN_LNG_I

    • # 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_QSTN_TYPE Character(2) VARCHAR2(2) NOT NULL Question Type which can be either Multiple Answers or Open Ended.
    10=Single Answer
    20=Multiple Answers
    90=Open Ended
    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 DESCRLONG Long Character CLOB Long Description
    9 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    10 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    11 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    12 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id