SCC_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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SCC_DA_PRXY_ID Number(16,0) DECIMAL(16) NOT NULL Proxy ID
3 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
4 SCC_DA_PRXY_NAME Character(70) VARCHAR2(70) NOT NULL Contact Name
5 SCC_DA_PRXY_EMAIL Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
6 SCC_DA_SECURTY_KEY Character(50) VARCHAR2(50) NOT NULL DA Security Key
7 SCC_DA_PRXY_OPRID Character(30) VARCHAR2(30) NOT NULL Proxy Oprid
8 SCC_DA_PRXY_EMPID Character(11) VARCHAR2(11) NOT NULL Proxy Emplid
9 SCC_DA_PRXY_STATUS Character(15) VARCHAR2(15) NOT NULL Contact Status
10 SCC_DA_DELEG_AGREE Character(2) VARCHAR2(2) NOT NULL I accept
11 SCC_DA_DELEG_AGRDT Date(10) DATE Delegator Agreement Date
12 SCC_DA_PRXY_AGREE Character(2) VARCHAR2(2) NOT NULL Proxy Agreement
13 SCC_DA_PRXY_AGRDT Date(10) DATE Proxy Agreement Date
14 SCC_DA_PRXY_DEL Character(1) VARCHAR2(1) NOT NULL Proxy Deleted
15 SCC_DA_NTF_REQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
16 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
17 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
18 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
19 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time