RY_DIALOG_SRCH

(SQL View)
 Index Back

Dialog Search Record

This record will exist for the Dialog Configurable Search.

SELECT a.DIALOG_ID , 'D' , a.BUSINESS_UNIT , a.RY_DIALOG_NAME , a.RY_DIALOG_STATUS , a.RYE_OWNER , a.START_DT , a.END_DT FROM PS_RYEDIALOG a

  • Related Language Record: RY_DLG_SRCH_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
    2 RY_MODEL_CD Character(1) VARCHAR2(1) NOT NULL Model Code for the Dialog Designer
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

    Prompt Table: SP_BU_RY_NONVW

    4 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
    5 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
    6 RYE_OWNER Character(30) VARCHAR2(30) NOT NULL Dialog Designer:Owner ID used for Dialogs
    7 START_DT Date(10) DATE Start date field to store start date value.
    8 END_DT Date(10) DATE This field stores the end date values.