RY_MD_ELEM_IDA=Active
D=Design
I=Inactive
P=Pause
RY_MD_ELEM_VW(SQL View) |
Index Back |
|---|---|
VC Profile Adapter VWVC Profile Adapter VW - For showing all the elements for a given profile |
| SELECT A.RY_MD_ELEM_ID , A.RY_MD_ID , A.RY_ELEM_NAME , A.RY_ELEM_TYPE , A.RY_DB_DATATYPE , A.RY_DB_DATATYPE_LEN , A.RY_DATA_STATUS , A.RY_ELEM_PERM_NAME , B.RY_DOC_ID FROM PS_RYEMDATA_ELEM A , PS_RYEDOC B WHERE A.RY_MD_ID = B.RY_MD_ID |
| # | 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. |
| 9 | RY_DOC_ID | Number(18,0) | DECIMAL(18) NOT NULL | Document ID - Dialog Document Main Sys ID |