EX_SEC_AT_KB_VW (SQL View)	Index Back
EX - SF Security View for KIB Used for Document Level Security for the Authorized users in Expenses Insights.

EX_SEC_AT_KB_VW

(SQL View)

EX - SF Security View for KIB

Used for Document Level Security for the Authorized users in Expenses Insights.

SELECT A.SHEET_ID , 'U:' %Concat A.OPRID_ENTERED_BY FROM %Table(EX_SHEET_HDR) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

2 EX_SECURITY_REPORT Character(40) VARCHAR2(40) NOT NULL EX - Security Attribute for Expense Report document level security.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
2	EX_SECURITY_REPORT	Character(40)	VARCHAR2(40) NOT NULL	EX - Security Attribute for Expense Report document level security.