PTSF_AUDIT_SRCE

index back

PeopleSoft Field NameField TypeColumn TypeDescription
AUDIT_OPRIDCharacter(30)VARCHAR2(30) NOT NULLThe OPRID of the user who made the changes audited on an audit record.
AUDIT_STAMPDateTime(26)TIMESTAMP NOT NULLDate and Time Stamp
AUDIT_ACTNCharacter(1)VARCHAR2(1) NOT NULLAudit 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_PROVIDERCharacter(30)VARCHAR2(30) NOT NULLSearch Provider

Default: SES

PTSF_SRCH_ENG_INSCharacter(30)VARCHAR2(30) NOT NULLSearch Instance Name
PTSF_ADMIN_SRV_URLLong Character(256)VARCHAR2(256) NOT NULLAdministrator Service URL
PTSF_ADMIN_USRNAMELong Character(256)VARCHAR2(256) NOT NULLAdmin User Name for Login
PTSF_ADMIN_PASSWDCharacter(254)VARCHAR2(254) NOT NULLAdmin Password
PTSF_QRY_SERV_URLLong Character(256)VARCHAR2(256) NOT NULLQuery Service URL
PTSF_QRY_PROXY_USRLong Character(256)VARCHAR2(256) NOT NULLQuery Proxy User Name
PTSF_QRY_PROXY_PWDCharacter(254)VARCHAR2(254) NOT NULLQuery Proxy Password
PTSF_SS_URLLong Character(256)VARCHAR2(256) NOT NULLSecurity Service URL
PTSF_SS_USER_NAMELong Character(256)VARCHAR2(256) NOT NULLSecurity Service User Name
PTSF_SS_PASSWORDCharacter(254)VARCHAR2(254) NOT NULLSecurity Service Password
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19