RY_D_COL_MAP_VW(SQL View) |
Index Back |
|---|---|
Name Map for Column-QuestionList the mapping between Document Column Name and Question text. This view is a join among 3 tables: MData, MData_Elem and Doc_Elem_Pr. |
| SELECT PS_RY_MDATA.RY_DATA_PERM_NAME , PS_RY_MDATA_ELEM.RY_ELEM_PERM_NAME , PS_RY_DOC_ELEM_PR.LABEL_TEXT FROM PS_RY_MDATA , PS_RY_MDATA_ELEM , PS_RY_DOC_ELEM_PR WHERE PS_RY_MDATA.RY_GROUP_ID='D' AND PS_RY_MDATA.RY_MD_ID= PS_RY_MDATA_ELEM.RY_MD_ID AND PS_RY_MDATA_ELEM.RY_MD_ELEM_ID=PS_RY_DOC_ELEM_PR.RY_MD_ELEM_ID AND (RY_ELEM_PERM_NAME LIKE 'RYD%' OR RY_ELEM_PERM_NAME LIKE 'PS_RYD%') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_DATA_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |
| 2 | RY_ELEM_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |
| 3 | LABEL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Activity Name |