RY_PROF_ELEM_VW

(SQL View)
 Index Back

View for RY MDATA and MDATA_EL

SQL view for joining RY_MDATA and RY_MDATA_ELEM tables

SELECT PS_RY_MDATA_ELEM.RY_MD_ELEM_ID , PS_RY_MDATA.RY_MD_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_MDATA_ELEM.RY_ELEM_TYPE , PS_RY_MDATA_ELEM.RY_DB_DATATYPE , PS_RY_MDATA_ELEM.RY_DATA_STATUS , RY_IS_ONE_TO_MANY FROM PS_RY_MDATA , PS_RY_MDATA_ELEM WHERE PS_RY_MDATA.RY_MD_ID = PS_RY_MDATA_ELEM.RY_MD_ID AND RY_GROUP_ID IN ( 'C', 'F')

# 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_MD_ID Number(18,0) DECIMAL(18) NOT NULL Metadata ID - Dialog document metadata table
3 RY_DATA_NAME Character(80) VARCHAR2(80) NOT NULL Document Name - Dialog Document, OLM
4 RY_DATA_PERM_NAME Character(32) VARCHAR2(32) NOT NULL Field used by Online Marketing.
5 RY_ELEM_NAME Character(90) VARCHAR2(90) NOT NULL Element Name - Dialog Document
6 RY_ELEM_PERM_NAME Character(32) VARCHAR2(32) NOT NULL Field used by Online Marketing.
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_DATA_STATUS Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.
A=Active
D=Design
I=Inactive
P=Pause
10 RY_IS_ONE_TO_MANY Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.