RYEMDATA

(SQL Table)
Index Back

Metadata

Online Marketing Design Time Metadata Record

# 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_DATA_NAME Character(80) VARCHAR2(80) NOT NULL Document Name - Dialog Document, OLM
3 RY_GROUP_ID Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.
C=Individuals
D=Document
F=Organizations
4 RY_DATA_STATUS Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.
A=Active
D=Design
I=Inactive
P=Pause
5 RY_DATA_PERM_NAME Character(32) VARCHAR2(32) NOT NULL Field used by Online Marketing.
6 RY_IS_ONE_TO_MANY Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.
7 RY_HAS_DEL_ELEMS Character(1) VARCHAR2(1) NOT NULL This flag is an indicator of whether or not a document contains deleted Document Elements. Such elements will exist in the RY_MDATA_ELEM_D and RYEMDATA_ELEM_D tables.

Default Value: N