RY_DRE_VW

(SQL View)
 Index Back

View of dialogs responses exp

View of dialogs that can be used for exporting the responses. 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')

SELECT A.PROCESS_INSTANCE , A.BO_ID , A.FIRST_NAME , A.LAST_NAME , A.SEX , A.PHONE , A.EMAIL_ADDR , A.CITY , A.STATE , A.COUNTRY , A.ROW_ADDED_DTTM , A.LABEL_TEXT , A.RY_DRE_RESP , A.RY_DRE_SCORE , A.TEXT_LONG FROM PS_RY_DRE_BO_FLAT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown
6 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
7 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 STATE Character(6) VARCHAR2(6) NOT NULL State
10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
12 LABEL_TEXT Character(254) VARCHAR2(254) NOT NULL Activity Name
13 RY_DRE_RESP Character(70) VARCHAR2(70) NOT NULL Response text for the dialog stored.
14 RY_DRE_SCORE Character(15) VARCHAR2(15) NOT NULL Dialog response export score calculated field as a character field.
15 TEXT_LONG Long Character CLOB Long Text