AUDIT_DA_PROXY

(SQL Table)
Index Back

Delegate Access Proxy Record

This record has all Proxy related Info

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 SCC_DA_PRXY_ID Number(16,0) DECIMAL(16) NOT NULL Proxy ID
6 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
7 SCC_DA_PRXY_NAME Character(70) VARCHAR2(70) NOT NULL Contact Name
8 SCC_DA_PRXY_EMAIL Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
9 SCC_DA_SECURTY_KEY Character(50) VARCHAR2(50) NOT NULL DA Security Key
10 SCC_DA_PRXY_OPRID Character(30) VARCHAR2(30) NOT NULL Proxy Oprid
11 SCC_DA_PRXY_EMPID Character(11) VARCHAR2(11) NOT NULL Proxy Emplid
12 SCC_DA_PRXY_STATUS Character(15) VARCHAR2(15) NOT NULL Contact Status
13 SCC_DA_DELEG_AGREE Character(2) VARCHAR2(2) NOT NULL I accept
14 SCC_DA_DELEG_AGRDT Date(10) DATE Delegator Agreement Date
15 SCC_DA_PRXY_AGREE Character(2) VARCHAR2(2) NOT NULL Proxy Agreement
16 SCC_DA_PRXY_AGRDT Date(10) DATE Proxy Agreement Date
17 SCC_DA_PRXY_DEL Character(1) VARCHAR2(1) NOT NULL Proxy Deleted
18 SCC_DA_NTF_REQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
19 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
20 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
21 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
22 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time