QUERY_SEC_APPLY (SQL Table)	Index Back
Query Security Audit

QUERY_SEC_APPLY

(SQL Table)

Query Security Audit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SECURITY_APPLIED Character(2) VARCHAR2(2) NOT NULL Security
01=Applied
02=Not Applied
03=Error
Default Value: 02

2 IN_PROCESS Character(1) VARCHAR2(1) NOT NULL Process
Default Value: N

3 LAST_RUN_DTM DateTime(26) TIMESTAMP Last Run On

4 LAST_RUN_OPRID Character(30) VARCHAR2(30) NOT NULL Last Run By

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SECURITY_APPLIED	Character(2)	VARCHAR2(2) NOT NULL	Security 01=Applied 02=Not Applied 03=Error Default Value: 02
2	IN_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Process Default Value: N
3	LAST_RUN_DTM	DateTime(26)	TIMESTAMP	Last Run On
4	LAST_RUN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Run By