RY_MD_IDRY_MD_ELEM_IDRY_MDATA_EL_VW(SQL View) |
Index Back |
|---|---|
Meta Data ElementMeta Data Element excluding "Multiple Choice" |
| SELECT A.RY_MD_ID , A.RY_MD_ELEM_ID , A.RY_ELEM_NAME , A.RY_ELEM_TYPE FROM PS_RY_MDATA_ELEM A , PS_RY_PROF_DB_DEF B WHERE A.RY_ELEM_TYPE <> 'Multiple Choice' AND A.RY_MD_ELEM_ID = B.RY_MD_ELEM_ID AND B.IS_PROF_QUESTION = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_MD_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Metadata ID - Dialog document metadata table |
| 2 | RY_MD_ELEM_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Metadata Element ID - Dialog Document |
| 3 | RY_ELEM_NAME | Character(90) | VARCHAR2(90) NOT NULL | Element Name - Dialog Document |
| 4 | RY_ELEM_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Element Type - Dialog Document |