RY_TRXN_SYS_IDRY_EXT_IDRY_W_TRXN_VW(SQL View) |
Index Back |
|---|---|
Transaction report SQL viewDialog Event Wire Transaction report SQL view |
| SELECT trxn.RY_TRXN_SYS_ID ,ext.RY_EXT_ID , trxn.ROW_ADDED_DTTM , trxn.ROW_LASTMANT_DTTM , trxn.RY_TRXN_ID , trxn.STATUS_CODE , ' ' DESCR254 ,trxn.RY_URL FROM PS_RY_WIRE_EXTSYS ext ,PS_RY_WIRE_TRXN trxn WHERE ext.RY_EXT_SYS_ID=trxn.RY_EXT_SYS_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_TRXN_SYS_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 2 | RY_EXT_ID |
Character(40) | VARCHAR2(40) NOT NULL | Field used by Online Marketing. |
| 3 | ADD_TO_QUEUE_DTTM | DateTime(26) | TIMESTAMP | This is the date and time it was added to the queue. |
| 4 | RY_LASTMODIFY_DT | DateTime(26) | TIMESTAMP | Online Marketing Last Modified Date |
| 5 | RY_TRXN_ID | Character(40) | VARCHAR2(40) NOT NULL | Field used by Online Marketing. |
| 6 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL | Status Code |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 8 | RY_URL | Long Character(2000) | VARCHAR2(2000) | Template URL - Document Element |