EMPLIDSCC_DA_PRXY_IDSCC_DA_TXN_CDSCC_START_DTTMCUS=Custom Logic
DEC=Declined Terms and Conditions
INA=Inactive Transaction
MR=Manual Revoke
PD=Proxy Delete
SEC=Security
Y/N Table Edit
SCC_DA_PRXY_TXN(SQL Table) |
Index Back |
|---|---|
DA Proxy TransactionThis record has details of transaction a proxy has been delegated access to |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SCC_DA_PRXY_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Proxy ID |
| 3 | SCC_DA_TXN_CD |
Character(50) | VARCHAR2(50) NOT NULL | Transaction Code |
| 4 | SCC_START_DTTM |
DateTime(26) | TIMESTAMP | Last Run Date Time |
| 5 | SCC_DA_EXP_DTTM | DateTime(26) | TIMESTAMP | The date the file was created |
| 6 | SCC_DA_TXN_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Transaction Status |
| 7 | SCC_END_DTTM | DateTime(26) | TIMESTAMP | Txn End Date Time |
| 8 | SCC_DA_DELEG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Delegator Oprid |
| 9 | 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 |
| 10 | SCC_DA_RLTM_UPD | Character(1) | VARCHAR2(1) NOT NULL |
PAV Realtime Update Flag
Y/N Table Edit |
| 11 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 12 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 13 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 14 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |