An Assets Tracking application has a batch update process. Twice a month each of the branch offices sends a transaction file to the headquarters.
Records are flagged with an "A" for equipment that is Added to the inventory; "C" for equipment that has been Upgraded or refurbished; "D" for equipment that has been Disposed of and is to be removed from inventory.
A summary inventory update report will be created that totals number of inventory records added, changed and deleted broken out by equipment type. The report will be sorted by branch and will start on a new page for each change of branch.
A detail inventory report will be available to the branches with the detail of inventory records updated.
From the Names of Possible Functions listed identify the transactional functions for the Assets Tracking application. Select N/A if a Name of Possible Functions does not apply.
Identify the functions used.
ITEM CHECK-OUT SCREEN
Library employees use the Item Check-Out screen when a member is ready check out the book(s) and/or magazine(s) he wishes to borrow. The library employee enters the member id number, and when the employee exits the member id attribute, if the member id is valid, the member name is retrieved from the Member Information logical file and displayed in the member name attribute. The library employee enters the item type (b for book, m for magazine) and the item code; the item title is retrieved from the Book Information logical file and displayed in the item title attribute. The library employee then enters the lending date and the due date, and presses the Add button. The information is stored in the Check-Out logical file.
Library employees use the Item Check-Out screen to update the due date of a book or magazine if a member requests additional lending time. The employee enters the member id number, and when the employee exits the member id attribute, if the member id is valid, the member name is retrieved from the Member Information logical file and displayed in the member name attribute, the library employee enters the item type (b for book, m for magazine) and the item code; the item title is retrieved from the Book Information logical file and displayed in the item title attribute and the lending date and due date are retrieved from the Check-Out logical file. The library employee then updates the due date, and presses the Update button. The new due date is stored in the Check-Out logical file.
The head librarian receives two reports from the Library Check-Out application. The first report is the Overdue Report which is a list of overdue items categorized into < 30 days overdue, 30 - 90 days overdue and > 90 days overdue.
The second report is the Low Usage Report that calculates which fiction books have not been checked out in the last 24 months and lists the title of those books. This report is run on demand. A High Usage Report with the number of times an item has been checked out has been put on hold and will not be released.
A proposed Member Check-Out Report with a list of books checked-out and recommended titles will not be developed until privacy issues have been resolved.
From the Names of Possible Functions listed identify the transactional functions for the current Library Check-Out application. Select N/A if a Name of Possible Function does not apply.
Identify the functions used:
The Patient Billing application includes functionality to maintain the Patient logical file.
The user enters a patient id and presses the View button to display an existing patient record, including diagnosis description and insurance company name. An error message is displayed if the patient record does not exist.
The user Adds a new patient by entering a patient ID and the remaining values. The user completes the add by pressing the Add button. An error message is displayed if the patient id already exists.
The user Updates information about the patient. All attributes can be modified except for patient id. The user completes the update by pressing the Update button
A diagnosis code must be selected using a drop down list for the primary diagnosis and the secondary diagnosis. The drop down list function is identical for primary and secondary diagnosis. The Diagnosis logical file is maintained in the Patient Billing application and is the source for the Diagnosis Code Drop Down list. The Diagnosis Code Drop Down list displays the diagnosis code, description and authorized days of hospitalization.
An insurance company code must be selected using the Insurance Company Drop Down list. The Insurance logical file is used as the source. The Insurance Company Drop Down list displays the insurance company number, group type and name.
All other drop down lists use static data as the source.
Determine the complexity for the following functions:
Select the complexity for each function:
A Call Center (CC) application is being enhanced to maintain and display 2 new pieces of information. The CC will add the 2 new DETs to all 5 of the modified transactional functions.
The Product Summary Report had 2 FTRs and 12 DETs.
Add Literature and Change Literature had 4 FTRs and 19 DETs.
The Literature Report (no calculations or derived data) had 4 FTRs and 19 DETs.
The Call Log Report (no calculations or derived data) had 1 FTRs and 19 DETs.
What is the complexity of the transactional functions after the enhancement?
Select the complexity for each function:
Identify the data and/or transactional functions in the following scenario:
In an international company, the user requires the Human Resources (HR) application to provide the following capabilities:
All hourly employees must be paid In United States dollars
When adding or changing employee information (name, social security number, number of dependents, type code, supervisory level, standard hourly rate, collective bargaining unit number, and location name), on the employee screen, the HR application must access the Currency application (CA) to retrieve a conversion rate. After retrieving the conversion rate, the HR application converts the employee's local standard hourly rate to a U.S. hourly rate using the following calculation:
standard hourly rate / conversion rate = U.S dollar hourly rate
When deleting employee information, on the employee screen, the HR application must NOT access the CA application to retrieve a conversion rate.
The HR application must maintain employee information in the HR Employee logical file
From the Names of Possible Functions listed identify the base functional components for the HR application. Select N/A if a Name of Possible Function Type 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.
Several functions are outlined within the following scenario for the Internet Application (IA):
From the company intranet the user selects the IA application.
The purchase item option allows the user to pay their internet shopping bill, after performing inquiry selection of items for purchase. The pay bill option updates the Customer, Inventory and Purchase History logical files.
If this is the user's first purchase, the Customer Information screen captures information about the customer and stores it on the Customer logical file. Once the customer information is saved and the customer chooses the next option, they are returned to the Pay Bill option.
If the user is an existing customer, they may view their customer information. The customer has the option of changing their information, but cannot delete it.
An itemized report totaling monthly customer purchases is created at the end of each month.
From the Names of Possible Functions listed identify the transactional functions for the IA application. 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.
ALERT SYSTEM - ALERT NOTIFICATION
Brokers use the Alert Profile screen to maintain the Alert Profile logical file. They can Add, Change, Delete and View alert information.
Brokers also maintain a list of many securities to monitor. The securities information is considered to be part of the Alert Profile.
The Alert Profile record is not considered complete until at least one security has been entered. The account number, alert contact name, alert phone number, and security id are required fields. The user is required to enter at least one of the remaining fields: low price threshold, high price threshold, and high volume threshold, they may enter values in all three.
When an Alert Profile record is Added a validation is performed on the account number against the Account Master logical file and a validation on the securities against the Securities logical file.
When Alert Profile records are Changed a validation is on the account number against the Account Master. All fields can be modified.
No validations are performed for the Alert Profile View.
When an Alert Profile record is Deleted the user must enter the account number, alert contact name, alert phone number. The account number is validated against the Account Master.
Error messages are displayed whenever validations fail
Select the complexity of each function:
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:
