IFPUG I40-420 Practice Test Questions Answers

The Procurement application requires the ability to maintain information on each new supplier. The information that must be maintained on the Supplier logical file includes:

 Supplier id

 Supplier name

 Supplier mailing address

 Supplier skill

As a result of creating a new supplier record, the supplier's annual costs should be automatically calculated and saved with the other supplier information.

Orders are maintained in the Order logical file by the Procurement application. The Accounts Payable logical file is updated for each order. Line items for each order are stored in the Order Detail subgroup of the order logical file.

Backorders and delivery errors are tracked by the Procurement application on the Transparency Track Record logical file. This file is compared to each supplier's values in the Service Level Agreement logical file which is maintained by the Contract application. The Procurement application produces a report for the Legal Office of suppliers that are performing outside of their Service Level Agreement.

From the Names of Possible Functions listed identify the data functions for the Procurement application. Select N/A if a Name of Possible Function does not apply.

Identify the functions used.

LIBRARY INFORMATION SYSTEM (LIS)

The Lend Text functions allow the LIS user to register information about the texfs lending in the Lend logical file. Data stored and maintained in Lend are: ISBN code, enroll code, lend date, due date, return date.

LIS maintains information about the Distributors from whom the library orders books, magazines and other publications. Account number, distributor name and 10 other logical pieces of information are maintained.

Library Branch data is stored in LIS and is maintainable by the library staff. Information Is maintained on 10 branches. Data maintained includes branch id, branch name, location, directions, hours of operation, and 17 other logical pieces of information.

Purchase Wish List logical file is maintained by LIS. Employees enter books, magazines, video recordings, audio recordings and personal computer software that they believe the library patrons would be interested in borrowing. This list is used as a source when making purchase decisions. The information is grouped by media type and information is collected based on the media type.

There are 8 common pieces of data collected for all media types

book information contains 10 additional logical pieces

of data o magazine information contains 13 additional logical

pieces of data o video recordings information contains 12 additional

logical pieces of data o audio recordings information contains 14 additional

logical pieces of data

Employee logical file is maintained in the LIS application and contains information about the library staff, including employee id, name, address, full or part time status, and title.

Determine the complexity of the following functions:

Select the complexity for each function

The Account Reconciliation Application (ARA) is used by banking operations to match credit (in) and debit (out) transactions within client accounts. Both credit and debit transactions are received from several other applications and stored as the Client Reconciliation logical file. ARA is capable of automatically matching transactions based on the Business Parameters logical file which is maintained by users in the ARA.

Access permissions in the User Access logical file are maintained by users in the ARA, and contain online user account permissions and approval levels.

The users can maintain their own report forms in the Reporting logical file. All reports use the Currency logical file, which is maintained by an external application, to convert the local payment currency to Euros.

From the Names of Possible Functions listed identify the data functions for the ARA. Select N/A if a Name of Possible Function does not apply.

Identify the functions used:

The Human Resources (HR) application includes functionality to maintain the Department logical file.

The user enters a department number and presses the View button to display an existing department. An error message is displayed if the department does not exist.

When the user adds or updates a department, the cost center is validated against the Cost Center logical file. The Cost Center logical file is maintained in the Payroll application.

The user Adds a new department by entering department #, Name, phone #, mail stop, cost center and manager. The user completes the add by pressing the Add button. An error message displayed if the department # already exists.

The user Updates information about the displayed department. Name, phone #, mail stop, cost center and manager may be changed. The user completes the update by pressing the Update button.

The user Deletes the displayed department by pressing the Delete button.

A manager must be selected using the Manager Drop Down list, which displays manager name and department number. The Employee logical file is maintained in the HR application and is the source for the Manager Drop Down list.

Determine the complexity for department transactions.

Select the complexity for each function.

Several data functions are described in the scenario for the Internet Application (IA):

The user may query store locations where an order can be picked up. The Store Location logical file is updated in the IA as new locations open

The user may pay their internet shopping bill using the purchase item option. This option updates the Customer logical file with the date of purchase, the Inventory logical file with stock number and quantity, and Purchase History logical file with date, stock number, price and discounts applied.

Prior to the completion of the purchase item option the purchase amount is converted from US dollars into the user' s local currency. The currency conversion requires reference data from the Currency Exchange logical file, which Is maintained through the Financial application. The Currency Exchange file is updated daily. The payment code is used to determine how the payment will be made.

If this is the user's first purchase, customer Information is added to the Customer logical file. As part of adding customer information the Country file is referenced in order to store country code in the Customer logical file rather than country name.

From the Names of Possible Functions listed identify the data functions for the IA. Select N/A if a Name of Possible Function does not apply.

Identify the data functions used: