RY_PROJECTION_IDRY_Q_PROJECTION(SQL Table) |
Index Back |
|---|---|
Query ProjectionLong Description for Query Projection |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_PROJECTION_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 2 | RY_QUERY_SPEC_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 3 | RY_MD_ELEM_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata Element ID - Dialog Document |
| 4 | ORDER_INDEX | Number(6,0) | INTEGER NOT NULL | ORDER_INDEX |
| 5 | RY_FORMULA | Character(254) | VARCHAR2(254) NOT NULL | Field used by Online Marketing. |