SP_SUR_COPY_VW

(SQL View)
 Index Back

Survey Definition Copy View

View of Survey Definition used for copying survey that does not default in the setid.

SELECT SETID , SP_SURVEY_ID , DESCR , SP_SUR_LIFE_STATUS FROM PS_SP_SUR_DEFN

  • Related Language Record: SP_SUR_CPYVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COPY_TO_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SP_SUR_LIFE_STATUS Character(1) VARCHAR2(1) NOT NULL Survey Life Cycle Status
    D=Draft
    O=Obsolete
    P=Published
    R=Retired

    Default Value: D