RY_MDATA(SQL Table) |
Index Back |
---|---|
Meta DataDocument Meta Data - Dialog Document |
# | 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 |