28\/11\/2021 Expense Reporting Database Page 3<\/p>\n
Expense Reporting Database Tables<\/p>\n
You will use the Expense Reporting Database in assignments 1 to 4. This document describes the business process supported, database diagram with tables and relationships, columns, and populated tables with rows.<\/p>\n
Business Processes Supported<\/p>\n
The Expense Reporting Database contains tables to track users and expense reports (report summary and items) along with support tables for organizational units, expense categories, assets, and budget limits on expense category spending. Table 1 briefly summarizes the meaning of each table.<\/p>\n
Table 1: Tables in the Expense Reports Database<\/p>\n
Table Name<\/p>\n
Description<\/p>\n
Users<\/p>\n
Details about users who can submit expense reports<\/p>\n
ExpenseReport<\/p>\n
Details about summaries of reimbursable items<\/p>\n
ExpenseItem<\/p>\n
Details about individual items for reimbursement on expense reports<\/p>\n
ExpCat<\/p>\n
Details about expense categories in which expense items are associated<\/p>\n
Asset<\/p>\n
Details about company assets that are associated with some expense items<\/p>\n
OrgUnit<\/p>\n
Details about organizational units in which users are members<\/p>\n
BudgetItem<\/p>\n
Details about expense budgets by organizational unit and expense category<\/p>\n
The Expense Reporting Database supports two business processes, expense reporting and budgeting of expense categories for organizational units. For expense reporting (Figure 1), users provide documentation for expense items and then submit an expense report with all items for approval. Each expense item involves an expense category, an optional asset, and an expense amount. Each expense report has dates for submission and status (pending, approved, or denied) along with the identifiers of the submitting user and approving user. The status defaults to pending on submission but changes to approved or denied upon completion of the review process. The review of an expense report compares amounts of each expense item to limits for associated expense categories. <\/p>\n
Figure 1: Expense Reporting Workflow<\/p>\n
The expense reporting process involves inserts and updates of the ExpenseReport and ExpenseItem tables with references to the Asset, Users, and ExpCat tables. In the review of an expense report, updates to approved expense amounts (ExpApprAmt) in expense items can be reduced from actual expense amounts (ExpAmt) if limits of associated expense categories are exceeded. Approval of an expense report triggers updates to the BudgetItem table to increase actual amounts of expense categories used for expense items.<\/p>\n
For annual budgeting, an organizational unit estimates the amount for each expense category. Each approved expense report increases the actual amount for expense categories referenced in expense items of the expense report. Periodically, a budget analyst in an organizational unit compares the actual amounts to budgeted amounts for selected expense categories. Estimated amounts in a new year can be adjusted based on comparisons of estimated and actual amounts of the current and previous years. The annual budgeting process involves insertions and updates to the BudgetItem table with references to the ExpCat and OrgUnit, tables. <\/p>\n
Database Diagram<\/p>\n
Figure 2 shows an Oracle database diagram with notation indicating important parts of the database design. In Figure 2, P indicates a primary key, F indicates a foreign key, U\/UF indicates unique columns that are not primary keys, and the red dot indicates a required column. In the BudgetItem table, the combination of BIYear (U), OrgNo (UF), and ECNo (UF) is unique. Solid lines indicate required relationships in which foreign keys do not accept null values with Figure 2 showing six required relationships. Dashed lines indicate optional relationships in which the associated foreign keys allow null values with Figure 2 showing three optional relationships. Figure 2 indicates two relationships from Users to ExpenseReport, required SubmitUserNo and optional ApprUserNo. OrgUnit contains an optional self-referencing relationship represented by OrgParentNo indicating the hierarchical structure of organization units. The X by ExpenseItem in the 1-M relationship indicates the CASCADE DELETE for action on referenced rows.<\/p>\n
Columns<\/p>\n
Tables 2 to 7 describe the columns in each table. The Data Type column indicates the types of values in each column. The Comments column indicates restrictions on columns such as the maximum characters, nulls allowed, and foreign keys. Note that actions on referenced rows are the default RESTRICT except for CASCADE DELETE for ExpenseItem.ERNo.<\/p>\n
Figure 2: Oracle Database Diagram for the Expense Reporting Database<\/p>\n
Table 2: Columns in the Asset Table<\/p>\n
Column<\/p>\n
Data Type<\/p>\n
Comments<\/p>\n
AssetNo<\/p>\n
Positive whole number<\/p>\n
Primary key<\/p>\n
AssetDesc<\/p>\n
Variable length string<\/p>\n
Max of 255 characters; nulls not allowed<\/p>\n
Table 3: Columns in the Users Table<\/p>\n
Column Name<\/p>\n
Data Type<\/p>\n
Comments<\/p>\n
UserNo<\/p>\n
Whole number<\/p>\n
Primary key<\/p>\n
UserFirstName<\/p>\n
Variable length string<\/p>\n
Max of 50 characters; nulls not allowed<\/p>\n
UserLastName<\/p>\n
Variable length string<\/p>\n
Max of 50 characters; nulls not allowed<\/p>\n
UserPhone<\/p>\n
Variable length string<\/p>\n
Max of 20 characters; nulls allowed<\/p>\n
UserEmail<\/p>\n
Variable length string<\/p>\n
Max of 50 characters; unique; nulls not allowed<\/p>\n
OrgNo<\/p>\n
Positive whole number<\/p>\n
Foreign Key to the OrgUnit table; nulls not allowed <\/p>\n
Table 4: Columns in the ExpCat Table<\/p>\n
Column<\/p>\n
Data Type<\/p>\n
Comments<\/p>\n
ECNo<\/p>\n
Positive whole number<\/p>\n
Primary key<\/p>\n
ECName<\/p>\n
Variable length string<\/p>\n
Max of 255 characters; nulls not allowed<\/p>\n
ECLimit<\/p>\n
Dollar Amount<\/p>\n
Monetary amount allowed per expense category expanse item; default is 0 (zero); nulls not allowed<\/p>\n
Table 5: Columns in the OrgUnit Table<\/p>\n
Column<\/p>\n
Data Type<\/p>\n
Comments<\/p>\n
OrgNo<\/p>\n
Positive whole number<\/p>\n
Primary key<\/p>\n
OrgName<\/p>\n
Variable length string<\/p>\n
Maximum length of 50 characters; nulls not allowed<\/p>\n
OrgParentNo<\/p>\n
Whole number<\/p>\n
Refers to OrgNo; nulls allowed for root organizational units (organizations without a parent organization)<\/p>\n
Table 6: Columns in the BudgetItem Table<\/p>\n
Column<\/p>\n
Data Type<\/p>\n
Comments<\/p>\n
BINo<\/p>\n
Positive whole number<\/p>\n
Primary key<\/p>\n
BIYear<\/p>\n
Whole number<\/p>\n
4-digit year. Must be greater than or equal to 2000; default should be current year; use a function to generate the default value; nulls not allowed<\/p>\n
BIAmt<\/p>\n
Dollar Amount<\/p>\n
The budgeted monetary amount for the year; nulls not allowed; default is 0 (zero)<\/p>\n
BIActual<\/p>\n
Dollar Amount<\/p>\n
An ongoing sum of the actual monetary amount of expenses approved for the category\/org unit combination in the year; default is 0 (zero)<\/p>\n
OrgNo<\/p>\n
Whole Number<\/p>\n
Foreign Key to the OrgUnit table; nulls not allowed<\/p>\n
ECNo<\/p>\n
Whole number<\/p>\n
Foreign Key to the ExpCat table; nulls not allowed<\/p>\n
Table 7: Columns in the ExpenseReport Table<\/p>\n
Column<\/p>\n
Data Type<\/p>\n
Comments<\/p>\n
ERNo<\/p>\n
Whole number<\/p>\n
Primary key<\/p>\n
ERDesc<\/p>\n
Variable length string<\/p>\n
Max of 255 characters; nulls not allowed<\/p>\n
ERSubmitDate<\/p>\n
Timestamp<\/p>\n
Date and time submitted; default should be the current timestamp (use a function to generate the default value); nulls not allowed<\/p>\n
ERStatusDate<\/p>\n
Timestamp<\/p>\n
Date and time when the status changed; defaults to the current timestamp; changes when the expense report is approved or denied; use a function to generate the default value; nulls not allowed<\/p>\n
ERStatus<\/p>\n
Variable length string<\/p>\n
Default value is \u201cPENDING\u201d meaning that the expense report is waiting for approval; this field should be limited to one of the following values \u201cPENDING\u201d, \u201cAPPROVED\u201d, or \u201cDENIED\u201d; nulls not allowed<\/p>\n
SubmitUserNo<\/p>\n
Whole number<\/p>\n
Foreign key to the Users table; identifies the user who submitted the expense report; nulls not allowed<\/p>\n
ApprUserNo<\/p>\n
Whole number<\/p>\n
Foreign key to the Users table; identifies the user who approves the expense report; nulls allowed<\/p>\n
Table 8: Columns in the ExpenseItem Table<\/p>\n
Column<\/p>\n
Data Type<\/p>\n
Comments<\/p>\n
EINo<\/p>\n
Whole number<\/p>\n
Primary key<\/p>\n
ExpDesc<\/p>\n
Variable length string<\/p>\n
Max of 255 characters; nulls not allowed<\/p>\n
ExpDate<\/p>\n
Date\/Time<\/p>\n
Date that the expense was incurred; default should be the current date (use a function to generate the default value)<\/p>\n
ExpAmt<\/p>\n
Dollar amount<\/p>\n
Monetary amount of the expense; nulls not allowed; default is 0 (zero)<\/p>\n
ExpApprAmt<\/p>\n
Dollar amount<\/p>\n
Monetary approved amount of the expense; default is 0 (zero)<\/p>\n
ERNo<\/p>\n
Positive whole number<\/p>\n
Foreign key to the ExpenseReport table; identifies the expense report that contains the item; nulls not allowed; CASCADE DELETE for action on referenced rows<\/p>\n
ECNo<\/p>\n
Whole number<\/p>\n
Foreign key to the ExpCat table; nulls not allowed<\/p>\n
AssetNo<\/p>\n
Whole number<\/p>\n
Foreign key to the Asset table; Nulls allowed<\/p>\n
Populated Tables with Rows<\/p>\n
Asset<\/p>\n
AssetNo<\/p>\n
AssetDesc<\/p>\n
1<\/p>\n
Company Car<\/p>\n
2<\/p>\n
Company Jet<\/p>\n
3<\/p>\n
Company Van<\/p>\n
4<\/p>\n
Company Truck<\/p>\n
5<\/p>\n
Company Apartment<\/p>\n
ExpCat<\/p>\n
ECNo<\/p>\n
ECName<\/p>\n
ECLimit<\/p>\n
1<\/p>\n
Meal<\/p>\n
50.00 <\/p>\n
2<\/p>\n
Car Rental<\/p>\n
100.00 <\/p>\n
3<\/p>\n
Snack<\/p>\n
25.00 <\/p>\n
4<\/p>\n
Local Transportation<\/p>\n
100.00 <\/p>\n
5<\/p>\n
Airfare<\/p>\n
5,000.00 <\/p>\n
6<\/p>\n
Entertainment<\/p>\n
25.00 <\/p>\n
7<\/p>\n
Lodging<\/p>\n
300.00 <\/p>\n
8<\/p>\n
Admission Fee<\/p>\n
2,000.00 <\/p>\n
9<\/p>\n
Gas<\/p>\n
35.00 <\/p>\n
OrgUnit<\/p>\n
OrgNo<\/p>\n
OrgName<\/p>\n
OrgParentNo<\/p>\n
1<\/p>\n
Accounting<\/p>\n
2<\/p>\n
Sales<\/p>\n
3<\/p>\n
IT<\/p>\n
4<\/p>\n
IT Development<\/p>\n
3<\/p>\n
5<\/p>\n
Accounts Receivable<\/p>\n
1<\/p>\n
6<\/p>\n
IT Support<\/p>\n
3<\/p>\n
7<\/p>\n
Accounts Payable<\/p>\n
1<\/p>\n
Users<\/p>\n
UserNo<\/p>\n
UserFirstName<\/p>\n
UserLastName<\/p>\n
UserPhone<\/p>\n
UserEmail<\/p>\n
OrgNo<\/p>\n
1<\/p>\n
Sue<\/p>\n
Herdon<\/p>\n
(206)339-3312<\/p>\n
sherdon@org.com<\/p>\n
3<\/p>\n
2<\/p>\n
Bill<\/p>\n
Jones<\/p>\n
(303)205-8833<\/p>\n
bjones@org.com<\/p>\n
6<\/p>\n
3<\/p>\n
Joe<\/p>\n
Smith<\/p>\n
(303)443-9943<\/p>\n
jsmith@org.com<\/p>\n
4<\/p>\n
4<\/p>\n
William<\/p>\n
Freed<\/p>\n
(303)445-3355<\/p>\n
wfreed@org.com<\/p>\n
1<\/p>\n
5<\/p>\n
Sara<\/p>\n
Jonson<\/p>\n
(303)445-3321<\/p>\n
sjonson@org.com<\/p>\n
7<\/p>\n
6<\/p>\n
Tom<\/p>\n
Sanchez<\/p>\n
(303)445-3322<\/p>\n
tsanchez@org.com<\/p>\n
5<\/p>\n
7<\/p>\n
Marry<\/p>\n
Blake<\/p>\n
(303)445-3333<\/p>\n
mblake@org.com<\/p>\n
2<\/p>\n
8<\/p>\n
Jaime<\/p>\n
Garcia<\/p>\n
(303)357-4566<\/p>\n
jgarcia@org.com<\/p>\n
3<\/p>\n
ExpenseReport<\/p>\n
ERNo<\/p>\n
ERDesc<\/p>\n
ERSubmitdate<\/p>\n
ERStatusDate<\/p>\n
ERStatus<\/p>\n
SubmitUserNo<\/p>\n
ApprUserNo<\/p>\n
1<\/p>\n
Sales Presentation<\/p>\n
8\/10\/2020 10:00<\/p>\n
8\/26\/2020 11:00<\/p>\n
APPROVED<\/p>\n
3<\/p>\n
4<\/p>\n
2<\/p>\n
Conference<\/p>\n
8\/16\/2020 10:00<\/p>\n
8\/17\/2020 10:00<\/p>\n
APPROVED<\/p>\n
3<\/p>\n
1<\/p>\n
3<\/p>\n
Training Course<\/p>\n
9\/23\/2020 11:30<\/p>\n
9\/25\/2020 11:00<\/p>\n
APPROVED<\/p>\n
2<\/p>\n
1<\/p>\n
4<\/p>\n
IT Group Lunch<\/p>\n
9\/29\/2020 10:00<\/p>\n
9\/29\/2020 16:30<\/p>\n
APPROVED<\/p>\n
1<\/p>\n
4<\/p>\n
5<\/p>\n
Sales Presentation<\/p>\n
9\/30\/2020 10:00<\/p>\n
10\/1\/2020 13:10<\/p>\n
APPROVED<\/p>\n
7<\/p>\n
4<\/p>\n
6<\/p>\n
Conference<\/p>\n
10\/3\/2020 11:30<\/p>\n
10\/3\/2020 15:10<\/p>\n
PENDING<\/p>\n
5<\/p>\n
7<\/p>\n
Entertainment<\/p>\n
10\/5\/2020 10:30<\/p>\n
10\/15\/2020 14:30<\/p>\n
DENIED<\/p>\n
5<\/p>\n
4<\/p>\n
ExpenseItem<\/p>\n
EINo<\/p>\n
ExpDesc<\/p>\n
ExpDate<\/p>\n
ExpAmt<\/p>\n
ExpApprAmt<\/p>\n
ERNo<\/p>\n
ECNo<\/p>\n
AssetNo<\/p>\n
1<\/p>\n
Car<\/p>\n
8\/9\/2020<\/p>\n
150.00 <\/p>\n
150.00 <\/p>\n
1<\/p>\n
7<\/p>\n
2<\/p>\n
Hilton<\/p>\n
8\/9\/2020<\/p>\n
99.00 <\/p>\n
99.00 <\/p>\n
1<\/p>\n
7<\/p>\n
3<\/p>\n
Gas<\/p>\n
8\/9\/2020<\/p>\n
35.00 <\/p>\n
20.00 <\/p>\n
1<\/p>\n
9<\/p>\n
1<\/p>\n
4<\/p>\n
Junk Food<\/p>\n
8\/10\/2020<\/p>\n
10.00 <\/p>\n
10.00 <\/p>\n
1<\/p>\n
3<\/p>\n
5<\/p>\n
Comfort Inn<\/p>\n
8\/16\/2020<\/p>\n
225.00 <\/p>\n
225.00 <\/p>\n
2<\/p>\n
7<\/p>\n
6<\/p>\n
Airfare<\/p>\n
8\/13\/2020<\/p>\n
325.00 <\/p>\n
325.00 <\/p>\n
2<\/p>\n
5<\/p>\n
7<\/p>\n
Dinner<\/p>\n
8\/15\/2020<\/p>\n
23.94 <\/p>\n
23.94 <\/p>\n
2<\/p>\n
1<\/p>\n
8<\/p>\n
Dinner<\/p>\n
8\/14\/2020<\/p>\n
32.50 <\/p>\n
32.50 <\/p>\n
2<\/p>\n
1<\/p>\n
9<\/p>\n
Dinner<\/p>\n
8\/13\/2020<\/p>\n
19.64 <\/p>\n
19.64 <\/p>\n
2<\/p>\n
1<\/p>\n
10<\/p>\n
Concert Tickets<\/p>\n
8\/15\/2020<\/p>\n
25.00 <\/p>\n
25.00 <\/p>\n
2<\/p>\n
6<\/p>\n
11<\/p>\n
Breakfast<\/p>\n
8\/15\/2020<\/p>\n
10.32 <\/p>\n
10.32 <\/p>\n
2<\/p>\n
3<\/p>\n
12<\/p>\n
Motel 6<\/p>\n
9\/23\/2020<\/p>\n
57.95 <\/p>\n
57.95 <\/p>\n
3<\/p>\n
7<\/p>\n
13<\/p>\n
Gas<\/p>\n
9\/23\/2020<\/p>\n
15.94 <\/p>\n
15.94 <\/p>\n
3<\/p>\n
9<\/p>\n
3<\/p>\n
14<\/p>\n
Apartment 1<\/p>\n
9\/29\/2020<\/p>\n
299.00 <\/p>\n
255.00 <\/p>\n
4<\/p>\n
7<\/p>\n
5<\/p>\n
15<\/p>\n
Breakfast<\/p>\n
9\/29\/2020<\/p>\n
15.00 <\/p>\n
13.88 <\/p>\n
4<\/p>\n
1<\/p>\n
16<\/p>\n
Flight<\/p>\n
9\/30\/2020<\/p>\n
3,500.00 <\/p>\n
3,000.00 <\/p>\n
5<\/p>\n
5<\/p>\n
2<\/p>\n
17<\/p>\n
Airport Bus<\/p>\n
9\/30\/2020<\/p>\n
100.00 <\/p>\n
25.00 <\/p>\n
5<\/p>\n
4<\/p>\n
18<\/p>\n
Trade Show<\/p>\n
10\/1\/2020<\/p>\n
150.00 <\/p>\n
125.00 <\/p>\n
5<\/p>\n
8<\/p>\n
19<\/p>\n
Party<\/p>\n
10\/10\/2020<\/p>\n
350.00<\/p>\n
0<\/p>\n
7<\/p>\n
1<\/p>\n
BudgetItem<\/p>\n
BINo<\/p>\n
BIYear<\/p>\n
OrgNo<\/p>\n
ECNo<\/p>\n
BIAmt<\/p>\n
BIActual<\/p>\n
1<\/p>\n
2020<\/p>\n
1<\/p>\n
1<\/p>\n
4,000.00 <\/p>\n
76.08 <\/p>\n
2<\/p>\n
2020<\/p>\n
1<\/p>\n
2<\/p>\n
3,000.00 <\/p>\n
0.00 <\/p>\n
3<\/p>\n
2020<\/p>\n
1<\/p>\n
3<\/p>\n
2,000.00 <\/p>\n
10.32 <\/p>\n
4<\/p>\n
2020<\/p>\n
1<\/p>\n
4<\/p>\n
500.00 <\/p>\n
0.00 <\/p>\n
5<\/p>\n
2020<\/p>\n
1<\/p>\n
5<\/p>\n
10,000.00 <\/p>\n
325.00 <\/p>\n
6<\/p>\n
2020<\/p>\n
1<\/p>\n
6<\/p>\n
2,000.00 <\/p>\n
25.00 <\/p>\n
7<\/p>\n
2020<\/p>\n
1<\/p>\n
7<\/p>\n
10,000.00 <\/p>\n
225.00 <\/p>\n
8<\/p>\n
2020<\/p>\n
1<\/p>\n
8<\/p>\n
6,000.00 <\/p>\n
0.00 <\/p>\n
9<\/p>\n
2020<\/p>\n
1<\/p>\n
9<\/p>\n
5,000.00 <\/p>\n
0.00 <\/p>\n
10<\/p>\n
2020<\/p>\n
2<\/p>\n
1<\/p>\n
10,000.00 <\/p>\n
167.00 <\/p>\n
11<\/p>\n
2020<\/p>\n
2<\/p>\n
2<\/p>\n
7,500.00 <\/p>\n
98.00 <\/p>\n
12<\/p>\n
2020<\/p>\n
2<\/p>\n
3<\/p>\n
4,000.00 <\/p>\n
10.75 <\/p>\n
13<\/p>\n
2020<\/p>\n
2<\/p>\n
4<\/p>\n
1,500.00 <\/p>\n
5.50 <\/p>\n
14<\/p>\n
2020<\/p>\n
2<\/p>\n
5<\/p>\n
15,000.00 <\/p>\n
650.00 <\/p>\n
15<\/p>\n
2020<\/p>\n
2<\/p>\n
6<\/p>\n
5,000.00 <\/p>\n
6.79 <\/p>\n
16<\/p>\n
2020<\/p>\n
2<\/p>\n
7<\/p>\n
12,000.00 <\/p>\n
0.00 <\/p>\n
17<\/p>\n
2020<\/p>\n
2<\/p>\n
8<\/p>\n
7,500.00 <\/p>\n
0.00 <\/p>\n
18<\/p>\n
2020<\/p>\n
2<\/p>\n
9<\/p>\n
7,500.00 <\/p>\n
0.00 <\/p>\n
19<\/p>\n
2020<\/p>\n
3<\/p>\n
1<\/p>\n
4,000.00 <\/p>\n
0.00 <\/p>\n
20<\/p>\n
2020<\/p>\n
3<\/p>\n
2<\/p>\n
3,000.00 <\/p>\n
0.00 <\/p>\n
21<\/p>\n
2020<\/p>\n
3<\/p>\n
3<\/p>\n
2,000.00 <\/p>\n
0.00 <\/p>\n
22<\/p>\n
2020<\/p>\n
3<\/p>\n
4<\/p>\n
500.00 <\/p>\n
24.00 <\/p>\n
23<\/p>\n
2020<\/p>\n
3<\/p>\n
5<\/p>\n
10,000.00 <\/p>\n
0.00 <\/p>\n
24<\/p>\n
2020<\/p>\n
3<\/p>\n
6<\/p>\n
2,000.00 <\/p>\n
75.00 <\/p>\n
25<\/p>\n
2020<\/p>\n
3<\/p>\n
7<\/p>\n
10,000.00 <\/p>\n
0.00 <\/p>\n
26<\/p>\n
2020<\/p>\n
3<\/p>\n
8<\/p>\n
10,000.00 <\/p>\n
0.00 <\/p>\n
27<\/p>\n
2020<\/p>\n
3<\/p>\n
9<\/p>\n
5,000.00 <\/p>\n
0.00 <\/p>\n
28<\/p>\n
2020<\/p>\n
4<\/p>\n
1<\/p>\n
1,500.00 <\/p>\n
0.00 <\/p>\n
29<\/p>\n
2020<\/p>\n
4<\/p>\n
2<\/p>\n
1,200.00 <\/p>\n
0.00 <\/p>\n
30<\/p>\n
2020<\/p>\n
4<\/p>\n
3<\/p>\n
1,000.00 <\/p>\n
10.00 <\/p>\n
31<\/p>\n
2020<\/p>\n
4<\/p>\n
4<\/p>\n
250.00 <\/p>\n
0.00 <\/p>\n
32<\/p>\n
2020<\/p>\n
4<\/p>\n
5<\/p>\n
4,000.00 <\/p>\n
0.00 <\/p>\n
33<\/p>\n
2020<\/p>\n
4<\/p>\n
6<\/p>\n
1,500.00 <\/p>\n
0.00 <\/p>\n
34<\/p>\n
2020<\/p>\n
4<\/p>\n
7<\/p>\n
2,000.00 <\/p>\n
99.00 <\/p>\n
35<\/p>\n
2020<\/p>\n
4<\/p>\n
8<\/p>\n
8,000.00 <\/p>\n
0.00 <\/p>\n
36<\/p>\n
2020<\/p>\n
4<\/p>\n
9<\/p>\n
650.00 <\/p>\n
35.00 <\/p>\n
37<\/p>\n
2020<\/p>\n
5<\/p>\n
1<\/p>\n
1,500.00 <\/p>\n
0.00 <\/p>\n
38<\/p>\n
2020<\/p>\n
5<\/p>\n
2<\/p>\n
1,200.00 <\/p>\n
0.00 <\/p>\n
39<\/p>\n
2020<\/p>\n
5<\/p>\n
3<\/p>\n
1,000.00 <\/p>\n
0.00 <\/p>\n
40<\/p>\n
2020<\/p>\n
5<\/p>\n
4<\/p>\n
250.00 <\/p>\n
0.00 <\/p>\n
41<\/p>\n
2020<\/p>\n
5<\/p>\n
5<\/p>\n
4,000.00 <\/p>\n
0.00 <\/p>\n
42<\/p>\n
2020<\/p>\n
5<\/p>\n
6<\/p>\n
1,500.00 <\/p>\n
0.00 <\/p>\n
43<\/p>\n
2020<\/p>\n
5<\/p>\n
7<\/p>\n
2,000.00 <\/p>\n
0.00 <\/p>\n
44<\/p>\n
2020<\/p>\n
5<\/p>\n
8<\/p>\n
5,500.00 <\/p>\n
0.00 <\/p>\n
45<\/p>\n
2020<\/p>\n
5<\/p>\n
9<\/p>\n
350.00 <\/p>\n
0.00 <\/p>\n
46<\/p>\n
2020<\/p>\n
6<\/p>\n
1<\/p>\n
1,500.00 <\/p>\n
0.00 <\/p>\n
47<\/p>\n
2020<\/p>\n
6<\/p>\n
2<\/p>\n
1,200.00 <\/p>\n
0.00 <\/p>\n
48<\/p>\n
2020<\/p>\n
6<\/p>\n
3<\/p>\n
1,000.00 <\/p>\n
2.99 <\/p>\n
49<\/p>\n
2020<\/p>\n
6<\/p>\n
4<\/p>\n
250.00 <\/p>\n
0.00 <\/p>\n
50<\/p>\n
2020<\/p>\n
6<\/p>\n
5<\/p>\n
4,000.00 <\/p>\n
0.00 <\/p>\n
51<\/p>\n
2020<\/p>\n
6<\/p>\n
6<\/p>\n
1,500.00 <\/p>\n
5.95 <\/p>\n
52<\/p>\n
2020<\/p>\n
6<\/p>\n
7<\/p>\n
2,000.00 <\/p>\n
57.95 <\/p>\n
53<\/p>\n
2020<\/p>\n
6<\/p>\n
8<\/p>\n
5,500.00 <\/p>\n
1,000.00 <\/p>\n
54<\/p>\n
2020<\/p>\n
6<\/p>\n
9<\/p>\n
350.00 <\/p>\n
15.94 <\/p>\n
55<\/p>\n
2020<\/p>\n
7<\/p>\n
1<\/p>\n
1,500.00 <\/p>\n
0.00 <\/p>\n
56<\/p>\n
2020<\/p>\n
7<\/p>\n
2<\/p>\n
1,200.00 <\/p>\n
0.00 <\/p>\n
57<\/p>\n
2020<\/p>\n
7<\/p>\n
3<\/p>\n
1,000.00 <\/p>\n
0.00 <\/p>\n
58<\/p>\n
2020<\/p>\n
7<\/p>\n
4<\/p>\n
250.00 <\/p>\n
0.00 <\/p>\n
59<\/p>\n
2020<\/p>\n
7<\/p>\n
5<\/p>\n
4,000.00 <\/p>\n
0.00 <\/p>\n
60<\/p>\n
2020<\/p>\n
7<\/p>\n
6<\/p>\n
1,500.00 <\/p>\n
0.00 <\/p>\n
61<\/p>\n
2020<\/p>\n
7<\/p>\n
7<\/p>\n
2,000.00 <\/p>\n
0.00 <\/p>\n
62<\/p>\n
2020<\/p>\n
7<\/p>\n
8<\/p>\n
8,000.00 <\/p>\n
0.00 <\/p>\n
63<\/p>\n
2020<\/p>\n
7<\/p>\n
9<\/p>\n
650.00 <\/p>\n
0.00 <\/p>\n
64<\/p>\n
2019<\/p>\n
1<\/p>\n
1<\/p>\n
3000<\/p>\n
3250.08<\/p>\n
65<\/p>\n
2019<\/p>\n
1<\/p>\n
2<\/p>\n
4000<\/p>\n
3500<\/p>\n
66<\/p>\n
2019<\/p>\n
1<\/p>\n
3<\/p>\n
2000<\/p>\n
2100.32<\/p>\n
67<\/p>\n
2019<\/p>\n
1<\/p>\n
4<\/p>\n
500<\/p>\n
352<\/p>\n
68<\/p>\n
2019<\/p>\n
1<\/p>\n
5<\/p>\n
9900<\/p>\n
9877<\/p>\n
69<\/p>\n
2019<\/p>\n
1<\/p>\n
6<\/p>\n
2000<\/p>\n
1580<\/p>\n
70<\/p>\n
2019<\/p>\n
1<\/p>\n
7<\/p>\n
10000<\/p>\n
10225<\/p>\n
71<\/p>\n
2019<\/p>\n
1<\/p>\n
8<\/p>\n
6000<\/p>\n
6000<\/p>\n
72<\/p>\n
2019<\/p>\n
1<\/p>\n
9<\/p>\n
5000<\/p>\n
6200<\/p>\n
73<\/p>\n
2019<\/p>\n
2<\/p>\n
1<\/p>\n
10000<\/p>\n
9167<\/p>\n
74<\/p>\n
2019<\/p>\n
2<\/p>\n
2<\/p>\n
7500<\/p>\n
7498<\/p>\n
75<\/p>\n
2019<\/p>\n
2<\/p>\n
3<\/p>\n
4000<\/p>\n
3910.75<\/p>\n
76<\/p>\n
2019<\/p>\n
2<\/p>\n
4<\/p>\n
1500<\/p>\n
1635.5<\/p>\n
77<\/p>\n
2019<\/p>\n
2<\/p>\n
5<\/p>\n
15000<\/p>\n
14650<\/p>\n
78<\/p>\n
2019<\/p>\n
2<\/p>\n
6<\/p>\n
5000<\/p>\n
4996.79<\/p>\n
79<\/p>\n
2019<\/p>\n
2<\/p>\n
7<\/p>\n
12000<\/p>\n
12870<\/p>\n
80<\/p>\n
2019<\/p>\n
2<\/p>\n
8<\/p>\n
7500<\/p>\n
6500<\/p>\n
81<\/p>\n
2019<\/p>\n
2<\/p>\n
9<\/p>\n
7500<\/p>\n
7800<\/p>\n
82<\/p>\n
2019<\/p>\n
3<\/p>\n
1<\/p>\n
4000<\/p>\n
3950<\/p>\n
83<\/p>\n
2019<\/p>\n
3<\/p>\n
2<\/p>\n
3000<\/p>\n
2970<\/p>\n
84<\/p>\n
2019<\/p>\n
3<\/p>\n
3<\/p>\n
2000<\/p>\n
2150<\/p>\n
85<\/p>\n
2019<\/p>\n
3<\/p>\n
4<\/p>\n
500<\/p>\n
424<\/p>\n
86<\/p>\n
2019<\/p>\n
3<\/p>\n
5<\/p>\n
10000<\/p>\n
9990<\/p>\n
87<\/p>\n
2019<\/p>\n
3<\/p>\n
6<\/p>\n
2000<\/p>\n
2075<\/p>\n
88<\/p>\n
2019<\/p>\n
3<\/p>\n
7<\/p>\n
10000<\/p>\n
9880<\/p>\n
89<\/p>\n
2019<\/p>\n
3<\/p>\n
8<\/p>\n
10000<\/p>\n
11990<\/p>\n
90<\/p>\n
2019<\/p>\n
3<\/p>\n
9<\/p>\n
5000<\/p>\n
4770<\/p>\n
91<\/p>\n
2019<\/p>\n
4<\/p>\n
1<\/p>\n
1500<\/p>\n
1450<\/p>\n
92<\/p>\n
2019<\/p>\n
4<\/p>\n
2<\/p>\n
1200<\/p>\n
1110<\/p>\n
93<\/p>\n
2019<\/p>\n
4<\/p>\n
3<\/p>\n
1000<\/p>\n
1110<\/p>\n
94<\/p>\n
2019<\/p>\n
4<\/p>\n
4<\/p>\n
250<\/p>\n
255<\/p>\n
95<\/p>\n
2019<\/p>\n
4<\/p>\n
5<\/p>\n
4000<\/p>\n
4440<\/p>\n
96<\/p>\n
2019<\/p>\n
4<\/p>\n
6<\/p>\n
1500<\/p>\n
1390<\/p>\n
97<\/p>\n
2019<\/p>\n
4<\/p>\n
7<\/p>\n
2000<\/p>\n
1899<\/p>\n
98<\/p>\n
2019<\/p>\n
4<\/p>\n
8<\/p>\n
8000<\/p>\n
7440<\/p>\n
99<\/p>\n
2019<\/p>\n
4<\/p>\n
9<\/p>\n
650<\/p>\n
635<\/p>\n
100<\/p>\n
2019<\/p>\n
5<\/p>\n
1<\/p>\n
1500<\/p>\n
1330<\/p>\n
101<\/p>\n
2019<\/p>\n
5<\/p>\n
2<\/p>\n
1200<\/p>\n
1290<\/p>\n
102<\/p>\n
2019<\/p>\n
5<\/p>\n
3<\/p>\n
1000<\/p>\n
960<\/p>\n
103<\/p>\n
2019<\/p>\n
5<\/p>\n
4<\/p>\n
250<\/p>\n
250<\/p>\n
104<\/p>\n
2019<\/p>\n
5<\/p>\n
5<\/p>\n
4000<\/p>\n
3690<\/p>\n
105<\/p>\n
2019<\/p>\n
5<\/p>\n
6<\/p>\n
1500<\/p>\n
1790<\/p>\n
106<\/p>\n
2019<\/p>\n
5<\/p>\n
7<\/p>\n
2000<\/p>\n
1990<\/p>\n
107<\/p>\n
2019<\/p>\n
5<\/p>\n
8<\/p>\n
5500<\/p>\n
5450<\/p>\n
108<\/p>\n
2019<\/p>\n
5<\/p>\n
9<\/p>\n
350<\/p>\n
340<\/p>\n
109<\/p>\n
2019<\/p>\n
6<\/p>\n
1<\/p>\n
1500<\/p>\n
1400<\/p>\n
110<\/p>\n
2019<\/p>\n
6<\/p>\n
2<\/p>\n
1200<\/p>\n
1420<\/p>\n
111<\/p>\n
2019<\/p>\n
6<\/p>\n
3<\/p>\n
1000<\/p>\n
1112.99<\/p>\n
112<\/p>\n
2019<\/p>\n
6<\/p>\n
4<\/p>\n
250<\/p>\n
240<\/p>\n
113<\/p>\n
2019<\/p>\n
6<\/p>\n
5<\/p>\n
4000<\/p>\n
3610<\/p>\n
114<\/p>\n
2019<\/p>\n
6<\/p>\n
6<\/p>\n
1500<\/p>\n
1485.95<\/p>\n
115<\/p>\n
2019<\/p>\n
6<\/p>\n
7<\/p>\n
2000<\/p>\n
2057.95<\/p>\n
116<\/p>\n
2019<\/p>\n
6<\/p>\n
8<\/p>\n
5500<\/p>\n
5000<\/p>\n
117<\/p>\n
2019<\/p>\n
6<\/p>\n
9<\/p>\n
350<\/p>\n
415.94<\/p>\n
118<\/p>\n
2019<\/p>\n
7<\/p>\n
1<\/p>\n
1500<\/p>\n
1450<\/p>\n
119<\/p>\n
2019<\/p>\n
7<\/p>\n
2<\/p>\n
1200<\/p>\n
1110<\/p>\n
120<\/p>\n
2019<\/p>\n
7<\/p>\n
3<\/p>\n
1000<\/p>\n
880<\/p>\n
121<\/p>\n
2019<\/p>\n
7<\/p>\n
4<\/p>\n
250<\/p>\n
260<\/p>\n
122<\/p>\n
2019<\/p>\n
7<\/p>\n
5<\/p>\n
4000<\/p>\n
3990<\/p>\n
123<\/p>\n
2019<\/p>\n
7<\/p>\n
6<\/p>\n
1500<\/p>\n
1450<\/p>\n
124<\/p>\n
2019<\/p>\n
7<\/p>\n
7<\/p>\n
2000<\/p>\n
2001<\/p>\n
125<\/p>\n
2019<\/p>\n
7<\/p>\n
8<\/p>\n
8000<\/p>\n
7960<\/p>\n
126<\/p>\n
2019<\/p>\n
7<\/p>\n
9<\/p>\n
650<\/p>\n
560<\/p>\n","protected":false},"excerpt":{"rendered":"
28\/11\/2021 Expense Reporting Database Page 3 Expense Reporting Database Tables You will use the Expense Reporting Database in assignments 1 to 4. This document describes the business process supported, database diagram with tables and relationships, columns, and populated tables with rows. Business Processes Supported The Expense Reporting Database contains tables to track users and expense […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10],"class_list":["post-78252","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-writing"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/78252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=78252"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/78252\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=78252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=78252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=78252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}