SMART Messages

SMART Logo

 
DATE May 22, 2012
Module AP/Travel
Subject *** New Queries Now Available in SMART ***

Three new queries are now available in SMART. 1) KS_EX_EE_PROFILE_DATA, 2) KS_EX_PROXY_LIST_BY_EMPLID, and 3) KS_AP_SPEEDCHARTS. Two are for Travel and Expenses information and one is for Accounts Payable information. The queries may be found using the following navigation.

Navigation: Reporting Tools->Query->Query Viewer

Search by Query Name.

Travel & Expense

Query Name: KS_EX_EE_PROFILE_DATA

Description: Employee Profile Data

Fields: Valid for Expenses, Default Profile, Employee ID, Employee Last Name, Employee First Name, Supervisor ID, Supervisor Last Name, Supervisor First Name, GL Business Unit, Department, Fund, Budget Unit, Program, Payment Method

Security Roles Required: KGL_KS_GL_VIEWER and (KAP_Agy_Expense_Processor or KAP_Agy_T_E_Approver)

Note: Unless otherwise indicated, the search prompts are optional and may be left blank. A more detailed search may return results faster.

Query Name: KS_EX_PROXY_LIST_BY_EMPLID

Description: Authorized Proxies by Employee ID

Fields: Employee ID, Employee Last Name, Employee First Name, Proxy Operator ID, Proxy Last Name, Proxy First Name, Business Unit, Default Profile

Security Roles Required: KGL_KS_GL_VIEWER and (KAP_Agy_Expense_Processor or KAP_Agy_T_E_Approver)

Note: Unless otherwise indicated, the search prompts are optional and may be left blank. A more detailed search may return results faster.

Accounts Payable

Query Name: KS_AP_SPEEDCHARTS

Description: Current effective dated SpeedChart rows for the effective date chosen.

Fields: SetID, SetID Description, SpeedChart, Distribution Line Number, Effective Date, Status, Description, Long Description, Security Type, User, Primary Permission List, Percent, GL Business Unit, Department ID, Fund, Budget Unit, Program, Account, Service Location, Agency Use, ChartField 2, PC Business Unit, Project ID, Activity, Source Type, Category, Subcategory

Security Role Required: KGL_KS_GL_VIEWER

Note: Unless otherwise indicated, the search prompts are optional and may be left blank. A more detailed search may return results faster.

The SMART Team

 

 

Quick Links

Search the Site

Contact Us

Send us an email

Sign Up

Sign up for the SMART InfoList