RY_DM_STATUS_VW

(SQL View)
Index Back

Pocess tracking view for UI

Dialog Mover process tracking view for UI

SELECT RY_RECORD_ID ,DIALOG_ID ,RY_DIALOG_NAME ,RY_DM_PROC_TYPE ,RY_DM_PROC_STATUS ,ROW_LASTMANT_DTTM ,ROW_LASTMANT_OPRID ,' ' FROM PS_RY_DM_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_RECORD_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
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_DM_PROC_TYPE Character(1) VARCHAR2(1) NOT NULL Dialog Mover: Export/Import type field.
E=Export
I=Import
5 RY_DM_PROC_STATUS Character(4) VARCHAR2(4) NOT NULL Dialog Mover: Export/Import status field.
CAND=Cancelled
CANL=Canceling
FAIL=Failed
FINS=Finished
RUN=Running
STAR=Started
6 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
7 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
8 RY_CC_ACTION Character(10) VARCHAR2(10) NOT NULL Field used by Online Marketing.