RY_FLOW_INS_IDC=Complete
I=Initial
O=Open
RY_FLOW_INST(SQL Table) |
Index Back |
|---|---|
Flow InstanceOnline marketing runtime table tracking flow instance for dialog execution. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_FLOW_INS_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Dialog Flow Instance ID |
| 2 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
| 3 | RY_IND_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 4 | RY_SRVY_SCORE | Signed Number(19,0) | DECIMAL(18) NOT NULL | Survey Overall score -- overall running score for a survey instance. |
| 5 | RY_STATUS_SRVY | Character(1) | VARCHAR2(1) NOT NULL |
Survey Status - 'Open' or 'Complete'
C=Complete I=Initial O=Open |
| 6 | RY_ORA_EXT_ID | Number(18,0) | DECIMAL(18) NOT NULL | Survey External Id - external system id for integration |
| 7 | RY_ORA_EXT_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Survey External Type -- external system type for integration |
| 8 | RY_ORA_EXT_BU | Character(5) | VARCHAR2(5) NOT NULL | Survey External Business Unit for integration |
| 9 | RY_ORA_EXT_INS_ID | Number(18,0) | DECIMAL(18) NOT NULL | Survey External Instance Id -- survey instance id from external system for integration |
| 10 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 11 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |