Pass the IFPUG Certification I40-420 Questions and answers with ExamsMirror

LIBRARY INFORMATION SYSTEM (LIS) - REPORTS

LIS produces five reports:

• Text Out On Loan

References Customer logical file

References Text logical file

Displays 8 fields

• Text Overdue

References Customer logical file

References Text logical file

Displays 4 fields

• Text With Multiple Hold Requests

References Text logical file

References Publisher Guide logical file

References Customer logical file

Displays 25 fields

• Inventory List

References Inventory logical file

Displays 12 fields including 1 calculated field

• Text On Order

References Order logical file

References Publisher Guide logical file

References Text logical file

References Employee logical file

Displays 15 fields including 2 calculated fields

Determine the complexity of the following functions.

Select the complexity for each function:

The Procurement application user requires the ability to control how and when reports are printed. The following list shows the specific user requirements for generating reports:

Display a list of reports that are available to be printed.

The user selects a report to be printed. If report control information exists for the requested report, the report control is displayed from the Report Control logical file.

If report control information has not been specified for the requested report, the user may add the following report controls:

report id

sort sequence

printer port

whether or not to generate a microfiche copy

whether or not to generate a paper copy

If report control information exists for the requested report, the user may update or delete the report controls.

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

Identify the functions used:

The Stock Purchasing (SP) and Point of Sale (POS) applications have the following requirements.

The POS application maintains details of customer purchases in the Item Purchases logical file.

The SP application is used to place orders with suppliers based on daily inventory levels.

The SP application is used to maintain supplier information. The Supplier Information logical file contains descriptions of items the supplier stocks and supplier contact information.

The Inventory logical file is maintained by the SP application through a daily batch process which references the Item Purchases logical file.

When the batch process is complete, the SP application displays a list of items that are below 20% of normal inventory levels. The user selects items to be ordered and specifies the supplier. The SP application then generates a purchase order for each supplier. The purchase orders are sent electronically to each supplier and stored in the Order logical file.

From the Names of Possible Functions listed identify the data function both the SP and POS applications. Select N/A if a Name of Possible Function does not apply.

Identify the functions used:

The Organization consists of three levels of organizational hierarchy. There are one or more Groups to a Department and one or more Departments to a Division. When a Division is deleted all associated Departments and Groups are also deleted. Organization data (including all three parts) is maintained by the Payroll application.

All the remaining tables are maintained by the HR application.

All the remaining data is maintained by the HR application.

The HR application stores information on the employee in the Employee logical file. Employee dependent information about the spouse and children of the employee are stored on the Employee Dependent table.

Health insurance plan, dental insurance plan, life insurance, and accident insurance data is stored in the Benefits logical file.

Pay rate, bonus percentage, vacation accrual rate, vacation balance, and pension accrual rate are stored on the Compensation logical file.

Training classes attended and scheduled are stored in the Training logical file.

The health insurance table contains the code and description for all Health Insurance plans offered to the employees for health coverage.

The dental insurance table contains the code and description for all Dental Insurance plans offered to the employee for dental coverage

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

Identify the data functions used:

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:

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:

PAYROLL APPLICATION - MAINTAIN EMPLOYEE TIME SCREEN

Employees can Add or Update their weekly hours information by entering the project and absence data on the Maintain Employee Time screen. Data is saved to the Employee Payroll ILF.

To begin the Add or Update from the Maintain Employee Time screen, the employee enters his/her employee badge number presses the Retrieve button. Retrieve will fill in the employee name and supervisor badge number from the Employee Master ILF, and will display the current pay period start date and end date from the Payroll Master ILF.

Employees can Delete existing weekly hours information by entering his/her employee badge number and pressing the delete button on the Maintain Employee Time screen. When the employee presses the delete button the current pay period hours will be removed from the Employee Payroll ILF.

PAYROLL APPLICATION - EMPLOYEE PROJECT ACTIVITY REPORT

The Employee Project Activity report is produced for each employee and routed electronically to that employee's email address. Each employee's project task hours for the current pay period are read from the Employee Payroll ILF. The report calculates and displays both daily and weekly total hours for the current pay period.

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

Identify the functions used.

A Corporate Finance application is being developed.

The application adds or updates the Receivable logical file and the Payable logical file. The user requires that this information is sent to the Accounts application to keep accounting records consistent. The combined receivable and payable data is sent to the Accounts application daily at 8:00 PM.

When implementing a solution to send the receivable and payable information, it was decided to include a header and trailer record with the accounts information. These records are used by the Corporate Finance user to ensure that everything was technically correct when transmitting the file.

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

Identify the functions used:

The Foreign Exchange System (FXS) allows banking operations to monitor trades processed from different foreign exchange trading systems which are located in London, New York and Hong Kong.

The Trade logical file is maintained using a series of batch jobs which copy each of the three foreign exchange data sets into FXS usable format. Once processed, the Add Trade batch function loads the data Into the Trade logical file and adds a date/time stamp.

A Daily Trade Detail report is produced listing all trades monitored. This report is sorted by trading location.

Two monthly reports are produced. A Monthly Summary Trade report is produced that contains summary trade numbers by trading location. A Monthly Trade Monitoring report is produced that lists all trades monitored, is sorted by trade date and contains a consolidated trade value.

From the Names of Possible Functions listed identify the base functional components for the FXS application. Select N/A if a Name of Possible Function Type does not apply.

Identify the functions used:

A Call Center (CC) application is being enhanced to track two new pieces of Information. The CC will reference the two new DETs in five modified data functions.

Productlogical file prior to the enhancement had 2 RETs and 25 DETs, the CC application had previously referenced 12 of those DETs.

Literaturelogical file previously referenced 5 RETs and 19 DETs. The two new DETs are being added to another RET NOT previously referenced.

Call Log logical file prior to the enhancement had 2 RETs and 19 DETs, the CC previously referenced all the DETs.

Customerlogical file prior to the enhancement had 1 RET and 36 DETs, the CC previously referenced only 25 of the DETs.

Contactlogical file prior to the enhancement had 1 RET and 68 DETs, the CC previously referenced all DETs.

Determine the complexity of the following functions:

Select the complexity for each function: