SCC_DA_TXN_VW(SQL View) |
Index Back |
|---|---|
Share My Info Dtl-Txn ViewShare My Info Dtl-Txn View |
| SELECT ' ' ,' ' ,' ' ,' ' ,%DateTimeIn('') ,%DateTimeIn('') ,' ' ,' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_DA_TXN_CD | Character(50) | VARCHAR2(50) NOT NULL | Transaction Code |
| 2 | SCC_DA_TXN_NAME | Character(100) | VARCHAR2(100) NOT NULL | Transaction |
| 3 | SCC_DA_LONG_DESCR | Character(250) | VARCHAR2(250) NOT NULL | Description |
| 4 | SCC_DA_TXN_UI_STAT | Character(30) | VARCHAR2(30) NOT NULL | Transaction Status |
| 5 | SCC_START_DTTM | DateTime(26) | TIMESTAMP | Last Run Date Time |
| 6 | SCC_END_DTTM | DateTime(26) | TIMESTAMP | Txn End Date Time |
| 7 | SCC_DA_RVK_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Revoke Reason
CUS=Custom Logic DEC=Declined Terms and Conditions INA=Inactive Transaction MR=Manual Revoke PD=Proxy Delete SEC=Security |
| 8 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |