RY_DOC_IDRY_DATA_NAMERY_DOC_NAME_VW(SQL View) |
Index Back |
|---|---|
Document name Lookup viewFor Single Email Report's Configuration search Document name Lookup |
| SELECT doc.RY_DOC_ID ,md.RY_DATA_NAME ,doc.RY_MD_ID FROM PS_RY_DOC doc ,PS_RY_DOC_VAR docvar ,PS_RY_MDATA md WHERE docvar.RY_DOC_TYPE >=20 AND docvar.RY_DOC_TYPE <= 22 AND doc.RY_MD_ID=docvar.RY_MD_ID AND doc.RY_MD_ID=md.RY_MD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_DOC_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Document ID - Dialog Document Main Sys ID |
| 2 | RY_DATA_NAME |
Character(80) | VARCHAR2(80) NOT NULL | Document Name - Dialog Document, OLM |
| 3 | RY_MD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata ID - Dialog document metadata table |