RY_RPT_IR_VW

(SQL View)
 Index Back

Dialog View

Dialog View Record - OLM - for interactive reporting

SELECT BUSINESS_UNIT , DIALOG_ID , RY_DIALOG_NAME , RY_DIALOG_STATUS , DESCR254 , IS_STAGING , ROW_ADDED_DTTM , ROW_LASTMANT_DTTM FROM PS_RY_DIALOG WHERE RY_DIALOG_STATUS IN ('A', 'P', 'S', 'I','Z')

  • Related Language Record: RY_RPT_IR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
    3 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
    4 RY_DIALOG_STATUS Character(1) VARCHAR2(1) NOT NULL Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 IS_STAGING Character(1) VARCHAR2(1) NOT NULL Staging Dialog
    N=No
    Y=Yes
    7 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    8 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.