RY_MD_ELEM_IDA=Active
D=Design
I=Inactive
P=Pause
RYEMDATA_ELEM(SQL Table) |
Index Back |
|---|---|
Metadata ElementOnline Marketing Design Time Metadata Element Record |
| # | 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_ELEM_NAME | Character(90) | VARCHAR2(90) NOT NULL | Element Name - Dialog Document |
| 4 | RY_ELEM_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Element Type - Dialog Document |
| 5 | RY_DB_DATATYPE | Character(10) | VARCHAR2(10) NOT NULL | Document Element Data Type - Dialog Document |
| 6 | RY_DB_DATATYPE_LEN | Number(19,0) | DECIMAL(19) NOT NULL | Dialog Document DataType Length - Dialog Document |
| 7 | RY_DATA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
A=Active D=Design I=Inactive P=Pause |
| 8 | RY_ELEM_PERM_NAME | Character(32) | VARCHAR2(32) NOT NULL | Field used by Online Marketing. |