HRS_QSTN_SET_I

(SQL View)
 Index Back

Question Set Interface View

Question Set Interface View

SELECT A.HRS_QSTN_SET_ID ,A.HRS_QSTN_SET_CD ,A.STATUS ,A.STATUS_DT ,A.DESCR ,A.DESCRSHORT ,A.COMPETENCY ,%subrec(HRS_AUDIT_SBR,A) ,A.DESCRLONG FROM PS_HRS_QSTN_SET A WHERE A.STATUS = 'A'

  • Related Language Record: HRS_QSET_LNG_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_QSTN_SET_ID Number(15,0) DECIMAL(15) NOT NULL Question set identifier
    2 HRS_QSTN_SET_CD Character(10) VARCHAR2(10) NOT NULL Question Set Code
    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    4 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: HRS_QSTN_SET.DESCR

    7 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    8 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    9 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    10 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    11 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    12 DESCRLONG Long Character CLOB Long Description