SCC_DA_PRXY_IDEMPLIDSCC_DA_TXN_CDCUS=Custom Logic
DEC=Declined Terms and Conditions
INA=Inactive Transaction
MR=Manual Revoke
PD=Proxy Delete
SEC=Security
SCC_DA_RVTXN_VW(SQL View) |
Index Back |
|---|---|
Share My Info Dtl-Txn ViewShare My Info Dtl-Txn View |
| SELECT P.SCC_DA_PRXY_ID ,P.EMPLID ,P.SCC_DA_TXN_CD ,T.SCC_DA_TXN_NAME ,T.SCC_DA_LONG_DESCR ,P.SCC_DA_TXN_STATUS ,P.SCC_DA_TXN_STATUS ,P.SCC_START_DTTM ,P.SCC_END_DTTM ,P.SCC_DA_RVK_REASON ,P.SCC_ROW_UPD_OPRID FROM PS_SCC_DA_PRXY_TXN P , PS_SCC_DA_TXN_HDR T WHERE T.SCC_DA_TXN_CD=P.SCC_DA_TXN_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_DA_PRXY_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Proxy ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SCC_DA_TXN_CD |
Character(50) | VARCHAR2(50) NOT NULL | Transaction Code |
| 4 | SCC_DA_TXN_NAME | Character(100) | VARCHAR2(100) NOT NULL | Transaction |
| 5 | SCC_DA_LONG_DESCR | Character(250) | VARCHAR2(250) NOT NULL | Description |
| 6 | SCC_DA_TXN_UI_STAT | Character(30) | VARCHAR2(30) NOT NULL | Transaction Status |
| 7 | SCC_DA_TXN_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Transaction Status |
| 8 | SCC_START_DTTM | DateTime(26) | TIMESTAMP | Last Run Date Time |
| 9 | SCC_END_DTTM | DateTime(26) | TIMESTAMP | Txn End Date Time |
| 10 | 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 |
| 11 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |