RY_RPT_DME_VW(SQL View) |
Index Back |
|---|---|
Document ReportACE Document Report SQL View for prepara data for RY_PRT_DOC_ELEM |
| SELECT E.RY_FLOW_INS_ID ,A.RY_MD_ID ,C.RY_MD_ELEM_ID ,D.LABEL_TEXT ,D.RY_QUESTION_WEIGHT ,0 ,0 ,D.RY_ELEM_WEIGHT_N ,D.RY_ELEM_WEIGHT_Y ,C.RY_ELEM_TYPE ,B.RY_DATA_PERM_NAME ,C.RY_ELEM_PERM_NAME FROM PS_RY_DOC A ,PS_RY_MDATA B ,PS_RY_MDATA_ELEM C ,PS_RY_DOC_ELEM_PR D ,PS_RY_RPT_DOC_VW E WHERE A.RY_MD_ID=B.RY_MD_ID AND A.RY_MD_ID= C.RY_MD_ID AND C.RY_MD_ELEM_ID=D.RY_MD_ELEM_ID AND RY_ELEM_TYPE IN ('Boolean','Rating Choice','Single Choice','Multiple Choice') AND A.RY_MD_ID=E.RY_MD_ID |
| # | 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 | RY_MD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata ID - Dialog document metadata table |
| 3 | RY_MD_ELEM_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata Element ID - Dialog Document |
| 4 | LABEL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Activity Name |
| 5 | RY_QUESTION_WEIGHT | Signed Number(3,0) | DECIMAL(2) NOT NULL | Survey Document quesion weight |
| 6 | RY_ANSWER_WEIGHT | Signed Number(3,0) | DECIMAL(2) NOT NULL | Survey Document answer weight |
| 7 | RY_QUESTION_SCORE | Signed Number(19,0) | DECIMAL(18) NOT NULL | Survey Overall score -- overall running score for a survey instance. |
| 8 | RY_ELEM_WEIGHT_N | Signed Number(3,0) | DECIMAL(2) NOT NULL | Weight value for booleam element No. |
| 9 | RY_ELEM_WEIGHT_Y | Signed Number(3,0) | DECIMAL(2) NOT NULL | Weight value for booleam element Yes. |
| 10 | RY_ELEM_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Element Type - Dialog Document |
| 11 | RY_DATA_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |
| 12 | RY_ELEM_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |