RY_RPT_SRVY_DLG(SQL Table) |
Index Back |
|---|---|
Document ReportData will be populate by the Survey Data Engine for the Survey ACE report. The report is base on user specified date range and Dialog ID, to get the suvey score from the latest completed dialog execution for each individule. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_RPT_ID | Number(18,0) | DECIMAL(18) NOT NULL | Report Id for ACR report temporay data |
| 2 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL |
Dialog ID field to identify both design time and run time dialog.
Prompt Table: RY_DIALOGIR_VW |
| 3 | RY_DIALOG_NAME | Character(254) | VARCHAR2(254) NOT NULL | Field is used to capture a Dialog Name. |
| 4 | RY_IND_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 5 | RY_FLOW_INS_ID | Number(18,0) | DECIMAL(18) NOT NULL | Dialog Flow Instance ID |
| 6 | RY_STATUS_SRVY | Character(1) | VARCHAR2(1) NOT NULL |
Survey Status - 'Open' or 'Complete'
C=Complete I=Initial O=Open |
| 7 | RY_SURVEY_SENT | Character(1) | VARCHAR2(1) NOT NULL | Indecate if the e-mail has been sent. |
| 8 | RY_SRVY_SCORE | Signed Number(19,0) | DECIMAL(18) NOT NULL | Survey Overall score -- overall running score for a survey instance. |
| 9 | RY_ORA_EXT_ID | Number(18,0) | DECIMAL(18) NOT NULL | Survey External Id - external system id for integration |
| 10 | RY_ORA_EXT_BU | Character(5) | VARCHAR2(5) NOT NULL | Survey External Business Unit for integration |
| 11 | RY_ORA_EXT_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Survey External Type -- external system type for integration |
| 12 | RY_ORA_EXT_INS_ID | Number(18,0) | DECIMAL(18) NOT NULL | Survey External Instance Id -- survey instance id from external system for integration |
| 13 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 14 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |