RY_SVY_DGSTA_VW

(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.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'RY_STATUS_TRN' AND %EffdtCheck(PSXLATITEM,A,%currentdatein) AND A.EFF_STATUS='A' AND A.FIELDVALUE NOT IN ('D', 'Q')

  • Related Language Record: RY_SVY_DGST_LVW

    • # 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 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name