AUDIT_OPRIDAUDIT_STAMPAUDIT_ACTNA=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
Default: SES
PTSF_AUDIT_SRCE |
index back |
|---|
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| AUDIT_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| AUDIT_STAMP |
DateTime(26) | TIMESTAMP NOT NULL | Date and Time Stamp |
| 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 |
| PTSF_SRCH_PROVIDER | Character(30) | VARCHAR2(30) NOT NULL |
Search Provider
Default: SES |
| PTSF_SRCH_ENG_INS | Character(30) | VARCHAR2(30) NOT NULL | Search Instance Name |
| PTSF_ADMIN_SRV_URL | Long Character(256) | VARCHAR2(256) NOT NULL | Administrator Service URL |
| PTSF_ADMIN_USRNAME | Long Character(256) | VARCHAR2(256) NOT NULL | Admin User Name for Login |
| PTSF_ADMIN_PASSWD | Character(254) | VARCHAR2(254) NOT NULL | Admin Password |
| PTSF_QRY_SERV_URL | Long Character(256) | VARCHAR2(256) NOT NULL | Query Service URL |
| PTSF_QRY_PROXY_USR | Long Character(256) | VARCHAR2(256) NOT NULL | Query Proxy User Name |
| PTSF_QRY_PROXY_PWD | Character(254) | VARCHAR2(254) NOT NULL | Query Proxy Password |
| PTSF_SS_URL | Long Character(256) | VARCHAR2(256) NOT NULL | Security Service URL |
| PTSF_SS_USER_NAME | Long Character(256) | VARCHAR2(256) NOT NULL | Security Service User Name |
| PTSF_SS_PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Security Service Password |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |