In addition to the prompt page, parameter and necessary query, the prompt wizard will also create these
What are filters?
100
Once a day, once a week, once a month – this is how often the expense archive job runs
What is once a day?
100
Used to store one data item on the page
What is a Singleton?
200
An invaluable tool to change data types
What is convert?
200
This provided $3.35 Billion to U.S. airlines in 2013
What are baggage fees?
200
Used to isolate the screaming brats from the adults
What is Exclude Itemizations?
200
The Sent for Payment Date is copied to this date until it is later updated
What is Paid Date?
200
This is placed on the detail page to allow drill downs
What is a Bookmark?
300
? Sent for Payment Date ?
What is a parameter for the Sent for Payment Date?
300
The 3 types of matches between a travel reservation and an expense entry.
What is Exact, Fuzzy, None?
300
********** DAILY DOUBLE **********
********** DAILY DOUBLE **********
********** DAILY DOUBLE **********
********** DAILY DOUBLE **********
This finds the distinct rows from one query and returns only those rows that do not appear in query two
What is Except Join?
300
An expense report can be Recalled or Returned to Employee up until this action
What is Extracted for Payment?
300
0..n = 0..n is commonly referred to as this
What is a Full Outer Join?
400
Returns the first non-null argument (or null if all arguments are null) where 2 or more arguments are in ‘expression list’.
What is Coalesce?
400
This is what PNR means and is also referred to as this
What is Passenger Name Record and Record Locator?
400
Used to join a credit card transaction with the GL Code
What is Expense Type Name?
400
These do not play well with each other in the same query
Name on Card
Report Key
Entry Transaction Date
Account Code 1
What are Account Code 1 and Name on Card?
400
Typically used to report on who ate the steak, when you do not want duplicate records
What is a Repeater?
500
Returns the smallest integer that is greater than or equal to a ‘numeric expression’.
What is Ceiling?
500
True or False - The Concur Locator is the same value as the Airline Locator
What is FALSE?
500
If you need the Audit Trail enabled, he is the NEW Wizard
Who is Joel Badia?
500
This expression will create a blank data item in date format
What is "cast (null , date)"?
500
Normally, this is a setting that needs to be changed in a Union for an Accrual Report