Other Links

ERD Definitions

DFD Definitions
 
 

ERD Definitions

 

1. Department - administrative part of the company; the company is divided into departments
1. Department ID, pk - unique department id (INT)
2. Department Name – department name (TEXT(30))
2. Employee - Employee of the company
1. Employee ID, pk - unique Employee id (TEXT(9))
2. Password – Employee’s password to access expense system (TEXT(9))
3. First Name - Employee’s first name (TEXT(20))
4. Last Name - Employee’s last name (TEXT(20))
5. Status - Employee’s status; has two values: (GUID)
1. A - active; those who are currently Employed by the company and are allowed to submit expense reports 
2. I - inactive; those not currently Employed by the company and/or are not allowed to submit expense reports
6. Email - Employee’s e-mail address (TEXT(35))
7. Direct Deposit Number - bank account number to which the reimbursements are deposited (INT)
8. Department ID, fk – department id (INT)
9. Security - Employee’s security level; has three values: (GUID)
1. G - general; system user allowed to submit expense reports
2. F - finance; system user allowed to approve/disapprove individual expense items
3. M - manager; system user allowed to approve/disapprove whole expense reports
3. Expense - expense report being submitted 
1. Expense ID, pk - unique expense report id (LONG)
2. Employee ID, fk – submitting Employee’s id (TEXT(9))
3. Submission Date - date on which report is submitted (DATE)
4. Date Reimbursed - date on which a particular event is reimbursed (DATE)
5. Purpose Of Trip - a text field that describes purpose of business trip being reimbursed (TEXT(50))
6. Business Days - number of business days during trip (INT)
7. Personal Days - number of personal days during trip (INT)
8. Manager Approval - a flag that indicated whether the report has been approved by manager; has two values: (GUID)
1. Y - yes
2. N – no
9. Bank Confirmation Number – confirmation number received from the bank regarding the deposit made (TEXT(30))
4. Expense Detail - details about particular events being submitted for reimbursement
1. Expense Detail ID, pk - unique expense detail id (INT)
2. Expense ID, pk, fk – expense report id of the report to which the detail belongs (LONG)
3. Expense Type ID, fk – id of a particular expense category (INT)
4. Expense Date - a particular date of the event being reimbursed (DATE)
5. Date Approved - date on which the detail has been approved by Department Manager (DATE)
6. Town - town in which the even being reimbursed occurred (TEXT(25))
7. Amount Submitted - requested amount of a particular event to be reimbursed (CURRENCY)
8. Amount Approved - amount of a particular event to be reimbursed, approved by finance (CURRENCY)
9. Name of Entertainment Facility - name of entertainment facility (TEXT(20))
5. Entertainment Detail – details about a particular entertainment expense
1. Person Entertained, pk – name of entertained person (TEXT(50))
2. Expense Detail ID, pk, fk - expense detail id (INT)
3. Expense ID, pk, fk – expense report id of the report to which the detail belongs (LONG)
4. Entertained Company Name - company Employing person’s entertained (TEXT(30))
5. Entertained Company Business Relationship - business relationship with the company being entertained (TEXT(50))
6. Expense Type - classification of an incurred expense (e.g. breakfast)
1. Expense Type ID, pk – id of a particular expense category (INT)
2. Expense Description - word description of an expense type (TEXT(30))

Notes:

 

1. Entity names are typed in bold.
2. Attribute names are underlined.
3. If an attribute is a primary key, "pk" follows its name.
4. If an attribute is a foreign key, "fk" follows its name.
5. The type of an attribute is specified in CAPITALIZED ITALICS following attribute’s description. The types are:
1. INT – integer
2. LONG – long integer, used for automatically generated integers 
3. TEXT(size) – text, where "size" is the number of characters allowed in the field
4. CURRENCY – currency in US dollars and cents
5. DATE – date
6. GUID – an enumerated type with restricted number of pre-specified values

DFD Definitions

 

1. Employee Id
1. Employee Id
2. Department ID 
1. Department ID
3. Unstructured Employee Information
1. Employee Id 
2. Password 
4. Unstructured Expense information
1. Submission Date
2. Purpose Of Trip
3. Business Days
4. Personal Days
5. Date Of Expense
6. Amount Submitted
7. Town
8. Name Of Entertainment Facility
9. Persons Entertained
10. Entertained Company Name
11. Entertained Company Business Relationship
5. Employee Details
1. Employee ID
2. Direct Deposit Number
3. Department ID
4. Email
6. Employee Information
1. Email
2. Direct Deposit Number
3. Department Id
4. First Name
5. Last Name
7. Unstructured Expense Information
1. Submission Date
2. Purpose Of Trip
3. Personal Days
4. Business Days
5. Expense Date
6. Town
7. Amount Submitted
8. Name Of Entertainment Facility
9. Expense Description
10. Person Entertained
11. Entertained Company Name
12. Entertained Company Business Relationship
8. Expense Information
1. Employee ID
2. Submission Date
3. Purpose of Trip
4. Business Days
5. Personal Days
9. Expense Details
1. Expense Id
2. Expense Type Id
3. Expense Date
4. Town
5. Amount Submitted 
6. Name Of Entertainment Facility
10. Entertainment Details
1. Persons Entertained
2. Expense Detail ID
3. Expense ID
4. Entertained Company Name
5. Entertained Company Business Relationship
11. Expense & Employee Info
1. Employee Id 
2. Department Id
3. Email
4. Direct Deposit Number
5. Expense Id
6. Submission Date
7. Purpose Of Trip
8. Business Days
9. Personal Days
10. Persons Entertained
11. Expense Detail ID
12. Expense ID
13. Entertained Company Name
14. Entertained Company Business Relationship
12. Expense Report
1. Employee Id
2. Expense Id
3. Submission Date
4. Purpose Of Trip
5. Business Days
6. Personal Days
7. Total Amount Submitted
8. Expense Detail Id
9. Expense Type Id
10. Expense Date
11. Town
12. Name Of Entertainment Facility
13. Entertained Company Name
13. Decision Information
1. Amount Approved
2. Yes/ No
14. Approved Amount
1. Expense ID
2. Expense Detail ID
3. Amount Approved
15. Status
1. Employee Id 
2. Total Amount Approved 
3. Expense Id
16. Expense Amount & Bank A/C Info
1. First Name
2. Last Name
3. Direct Deposit Number
4. Department Id 
5. Total Amount Approved 
6. Expense Id
7. Date Submitted
17. Payment Report
1. Employee Id
2. Expense ID
3. Total Amount Approved
4. Direct Deposit Number
5. Date Submitted
18. Payment Instructions
1. Employee ID
2. Disbursement Date
19. Direct Deposit 
1. First Name
2. Last Name
3. Direct Deposit Number
20. Date Reimbursed & Bank Confirmation Number
1. Date Reimbursed
2. Bank Confirmation Number
3. Expense ID
21. Confirmation Number
1. First Name
2. Last Name
3. Confirmation Number
22. Deposit Confirmation
1. Employee Id
2. Expense Id
3. Date Reimbursed
23. Expense Information For Management Reporting
1. Expense ID
2. Employee ID
3. Purpose Of Trip
4. Business Days
5. Personal Days
24. Expense Details For Management Reporting
1. Expense Detail ID
2. Expense ID
3. Expense Date
4. Town
5. Amount Submitted
6. Amount Approved
7. Name Of Entertainment Facility
8. Expense Type ID
25. Entertainment Details For Management Reporting
1. Person Entertained
2. Expense Detail ID
3. Expense ID
4. Entertained Company Name
5. Entertained Company Business Relationship
26. Employee Information For Reporting
1. Employee ID
2. Department ID
3. Status
4. First Name
5. Last Name
27. Report
1. Employee ID
2. Department ID
3. Status
4. First Name
5. Last Name
6. Person Entertained
7. Expense Detail ID
8. Entertained Company Name
9. Entertained Company Business Relationship
10. Expense Date
11. Town
12. Amount Submitted
13. Amount Approved
14. Name Of Entertainment Facility
15. Purpose Of Trip
16. Business Days
17. Personal Days

Notes:

1. Data Flows are numbered lines.
2. Their data structure fields are corresponding lettered lines.
3. For definition of  data structure fields, please refer to ERD definitions.

Questions and Comments: webmaster