RY_SVY_DGST_LVW

(SQL View)
 Index Back

Survey Dialog Status View

View to show dialogs other than 'In Design' and 'Testing'

SELECT %Substring(A.FIELDVALUE, 1, 1) , A.LANGUAGE_CD , A.XLATSHORTNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'RY_STATUS_TRN' AND %EffdtCheck(PSXLATITEMLANG,A,%currentdatein) AND A.FIELDVALUE NOT IN ('D', 'Q')

  • Related Language Record for RY_SVY_DGSTA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_STATUS_TRN Character(1) VARCHAR2(1) NOT NULL Dialog Status field used to do translates.
    A=Live
    C=Archived
    D=In Design
    I=Completed
    P=Paused
    Q=Testing
    S=Broadcast Hold
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name