RY_DOC_EL_CH_VW(SQL View) |
Index Back |
|---|---|
A view for customer useThis view is provied for Online Marketing customer. |
| SELECT PS_RY_MDATA_ELEM.RY_MD_ELEM_ID , PS_RY_MDATA.RY_DATA_NAME , PS_RY_MDATA.RY_DATA_PERM_NAME , PS_RY_MDATA_ELEM.RY_ELEM_NAME , PS_RY_MDATA_ELEM.RY_ELEM_PERM_NAME , PS_RY_DOC_ELEM_PR.LABEL_TEXT , PS_RY_MDATA_ELEM.RY_ELEM_TYPE , PS_RY_MDATA_ELEM.RY_DB_DATATYPE , PS_RY_MDATA_ELEM.RY_DB_DATATYPE_LEN , PS_RY_MDATA_ELEM.RY_DATA_STATUS , PS_RY_DIALOG.DIALOG_ID , PS_RY_DIALOG.RY_DIALOG_NAME FROM PS_RY_MDATA , PS_RY_MDATA_ELEM , PS_RY_DOC , PS_RY_DOC_ELEM_PR , PS_RY_DIALOG 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_DOC.DIALOG_ID= PS_RY_DIALOG.DIALOG_ID AND PS_RY_DOC.RY_MD_ID = PS_RY_MDATA.RY_MD_ID AND PS_RY_MDATA_ELEM.RY_MD_ELEM_ID=PS_RY_DOC_ELEM_PR.RY_MD_ELEM_ID AND PS_RY_MDATA_ELEM.RY_ELEM_TYPE LIKE '%Choice' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_MD_ELEM_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata Element ID - Dialog Document |
| 2 | RY_DATA_NAME | Character(80) | VARCHAR2(80) NOT NULL | Document Name - Dialog Document, OLM |
| 3 | RY_DATA_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |
| 4 | RY_ELEM_NAME | Character(90) | VARCHAR2(90) NOT NULL | Element Name - Dialog Document |
| 5 | RY_ELEM_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |
| 6 | LABEL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Activity Name |
| 7 | RY_ELEM_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Element Type - Dialog Document |
| 8 | RY_DB_DATATYPE | Character(10) | VARCHAR2(10) NOT NULL | Document Element Data Type - Dialog Document |
| 9 | RY_DB_DATATYPE_LEN | Number(19,0) | DECIMAL(19) NOT NULL | Dialog Document DataType Length - Dialog Document |
| 10 | RY_DATA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
A=Active D=Design I=Inactive P=Pause |
| 11 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
| 12 | RY_DIALOG_NAME | Character(254) | VARCHAR2(254) NOT NULL | Field is used to capture a Dialog Name. |