RY_RPT_DOC_VW(SQL View) |
Index Back |
|---|---|
Document ReportTo prepare data for the Survey ACE Document Report |
| SELECT A.RY_FLOW_INS_ID ,A.RY_MD_ID , A.RY_RECORD_ID FROM PS_RY_DOC_SEQ A ,PS_RY_DOC B WHERE A.RY_MD_ID=B.RY_MD_ID AND B.RY_IS_SURVEY_DOC='Y' AND B.RY_STATUS = 'A' |
| # | 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_SEQ_NUM | Number(18,0) | DECIMAL(18) NOT NULL | Document Report |