RY_QUERY_COL_VW(SQL View) |
Index Back |
|---|---|
View for all Profile elementsSQL view for joining RY_MDATA, RY_MDATA_ELEM, and RY_PROF_DB_DEF tables |
| SELECT RY_GROUP_ID , PS_RY_MDATA.RY_IS_ONE_TO_MANY , PS_RY_MDATA.RY_MD_ID , PS_RY_MDATA.RY_DATA_NAME , PS_RY_MDATA.RY_DATA_PERM_NAME , PS_RY_MDATA_ELEM.RY_MD_ELEM_ID , PS_RY_MDATA_ELEM.RY_ELEM_NAME , PS_RY_MDATA_ELEM.RY_ELEM_PERM_NAME , PS_RY_MDATA_ELEM.RY_ELEM_TYPE , PS_RY_MDATA_ELEM.RY_DB_DATATYPE , PS_RY_MDATA_ELEM.RY_DATA_STATUS , PS_RY_PROF_DB_DEF.IS_PROF_QUESTION , PS_RY_PROF_DB_DEF.PROF_ELEM_INDEX FROM PS_RY_MDATA , PS_RY_MDATA_ELEM , PS_RY_PROF_DB_DEF WHERE PS_RY_MDATA.RY_MD_ID = PS_RY_MDATA_ELEM.RY_MD_ID AND PS_RY_MDATA_ELEM.RY_MD_ELEM_ID = PS_RY_PROF_DB_DEF.RY_MD_ELEM_ID(+) AND PS_RY_MDATA_ELEM.RY_DATA_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_GROUP_ID | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
C=Individuals D=Document F=Organizations |
| 2 | RY_IS_ONE_TO_MANY | Character(1) | VARCHAR2(1) NOT NULL | Field used by Online Marketing. |
| 3 | RY_MD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata ID - Dialog document metadata table |
| 4 | RY_DATA_NAME | Character(80) | VARCHAR2(80) NOT NULL | Document Name - Dialog Document, OLM |
| 5 | RY_DATA_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |
| 6 | RY_MD_ELEM_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata Element ID - Dialog Document |
| 7 | RY_ELEM_NAME | Character(90) | VARCHAR2(90) NOT NULL | Element Name - Dialog Document |
| 8 | RY_ELEM_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |
| 9 | RY_ELEM_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Element Type - Dialog Document |
| 10 | RY_DB_DATATYPE | Character(10) | VARCHAR2(10) NOT NULL | Document Element Data Type - Dialog Document |
| 11 | RY_DATA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
A=Active D=Design I=Inactive P=Pause |
| 12 | IS_PROF_QUESTION | Character(1) | VARCHAR2(1) NOT NULL | IS_PROF_QUESTION |
| 13 | PROF_ELEM_INDEX | Number(4,0) | SMALLINT NOT NULL | PROF_ELEM_INDEX |