PTSF_AUDIT_SRCE

(SQL Table)
Index Back

# 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 NOT NULL 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 PTSF_SRCH_PROVIDER Character(30) VARCHAR2(30) NOT NULL Search Provider

Default Value: SES

5 PTSF_SRCH_ENG_INS Character(30) VARCHAR2(30) NOT NULL Search Instance Name
6 PTSF_ADMIN_SRV_URL Long Character(256) VARCHAR2(256) NOT NULL Administrator Service URL
7 PTSF_ADMIN_USRNAME Long Character(256) VARCHAR2(256) NOT NULL Admin User Name for Login
8 PTSF_ADMIN_PASSWD Character(254) VARCHAR2(254) NOT NULL Admin Password
9 PTSF_QRY_SERV_URL Long Character(256) VARCHAR2(256) NOT NULL Query Service URL
10 PTSF_QRY_PROXY_USR Long Character(256) VARCHAR2(256) NOT NULL Query Proxy User Name
11 PTSF_QRY_PROXY_PWD Character(254) VARCHAR2(254) NOT NULL Query Proxy Password
12 PTSF_SS_URL Long Character(256) VARCHAR2(256) NOT NULL Security Service URL
13 PTSF_SS_USER_NAME Long Character(256) VARCHAR2(256) NOT NULL Security Service User Name
14 PTSF_SS_PASSWORD Character(254) VARCHAR2(254) NOT NULL Security Service Password