Properties

Date Created: 5/1/99 10:33:02 AM Def. Updatable: True

Last Updated: 5/22/99 2:21:18 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

request_id Number (Long) 4

employee_id Number (Integer) 2

assigned_date Date/Time 8

Table Indexes

Name Number of Fields

employee_id 1

Fields: employee_id, Ascending

Employeeassigned_request 1

Fields: employee_id, Ascending

PrimaryKey 2

Fields: request_id, Ascending

employee_id, Ascending

request_id 1

Fields: request_id, Ascending

Requestassigned_request 1

Fields: request_id, Ascending

Properties

Date Created: 5/1/99 10:35:58 AM Def. Updatable: True

Last Updated: 5/8/99 1:16:28 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

department_id Text 10

department_desc Text 50

Table Indexes

Name Number of Fields

department_id 1

Fields: department_id, Ascending

PrimaryKey 1

Fields: department_id, Ascending

Properties

Date Created: 4/30/99 4:53:31 PM Def. Updatable: True

Last Updated: 5/22/99 2:22:36 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

employee_id Number (Integer) 2

employee_name Text 50

employee_position Text 30

employee_email Text 20

employee_phone Text 20

department_id Text 10

Table Indexes

Name Number of Fields

DepartmentEmployee 1

Fields: department_id, Ascending

employee_id 1

Fields: employee_id, Ascending

Employeedepartment_id 1

Fields: department_id, Ascending

PrimaryKey 1

Fields: employee_id, Ascending

Properties

Date Created: 4/30/99 4:45:50 PM Def. Updatable: True

Last Updated: 5/22/99 2:22:58 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

priority_id Text 10

priority_desc Text 50

priority_resp Text 50

Table Indexes

Name Number of Fields

PrimaryKey 1

Fields: priority_id, Ascending

priority 1

Fields: priority_id, Ascending

Properties

Date Created: 4/30/99 4:49:52 PM Def. Updatable: True

Last Updated: 5/22/99 2:23:19 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

process_id Text 10

process_desc Text 50

Table Indexes

Name Number of Fields

PrimaryKey 1

Fields: process_id, Ascending

Date Created: 4/30/99 4:59:51 PM Def. Updatable: True

Last Updated: 5/22/99 2:24:11 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

request_id Number (Long) 4

priority_id Text 10

employee_id Number (Integer) 2

process_id Text 10

request_date Date/Time 8

request_status Text 20

problem_desc Text 50

resolution_des Text 250

closed_date Date/Time 8

Name Number of Fields

ApplicationRequest 1

Fields: process_id, Ascending

EmployeeRequest 1

Fields: employee_id, Ascending

PrimaryKey 1

Fields: request_id, Ascending

PriorityRequest 1

Fields: priority_id, Ascending

request_id 1

Fields: request_id, Ascending

Requestemployee_id 1

Fields: employee_id, Ascending

Properties

Date Created: 5/1/99 10:33:02 AM Def. Updatable: True

Last Updated: 5/22/99 2:21:18 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

request_id Number (Long) 4

AllowZeroLength: False

Attributes: Fixed Size

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Decimal Places: 0

Default Value: 0

Description: Request id

DisplayControl: Text Box

Ordinal Position: 1

Required: True

Source Field: request_id

Source Table: assigned_request

employee_id Number (Integer) 2

AllowZeroLength: False

Attributes: Fixed Size

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Decimal Places: 0

Default Value: 0

Description: Employee id. Person who is working with the problem

DisplayControl: Text Box

Ordinal Position: 2

Required: True

Source Field: employee_id

Source Table: assigned_request

assigned_date Date/Time 8

AllowZeroLength: False

Attributes: Fixed Size

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Date when the request was assigned

Ordinal Position: 3

Required: True

Source Field: assigned_date

Source Table: assigned_request

Properties

Date Created: 5/1/99 10:35:58 AM Def. Updatable: True

Last Updated: 5/8/99 1:16:28 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

department_id Text 10

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

DisplayControl: Text Box

Ordinal Position: 1

Required: True

Source Field: department_id

Source Table: Department

department_desc Text 50

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

DisplayControl: Text Box

Ordinal Position: 2

Required: True

Source Field: department_desc

Source Table: Department

Properties

Date Created: 4/30/99 4:53:31 PM Def. Updatable: True

Last Updated: 5/22/99 2:22:36 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

employee_id Number (Integer) 2

AllowZeroLength: False

Attributes: Fixed Size

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Decimal Places: 0

Default Value: 0

Description: Employee id. All employees who work for the company. Either

technicians or users.

DisplayControl: Text Box

Ordinal Position: 1

Required: True

Source Field: employee_id

Source Table: Employee

employee_name Text 50

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Name of the employee

DisplayControl: Text Box

Ordinal Position: 2

Required: True

Source Field: employee_name

Source Table: Employee

employee_position Text 30

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Position (Technical lead, DBA, user, financial analyst, etc)

DisplayControl: Text Box

Ordinal Position: 3

Required: False

Source Field: employee_position

Source Table: Employee

employee_email Text 20

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Email address

employee_email (continued)

DisplayControl: Text Box

Ordinal Position: 4

Required: True

Source Field: employee_email

Source Table: Employee

employee_phone Text 20

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Employee Telephone

DisplayControl: Text Box

Ordinal Position: 5

Required: True

Source Field: employee_phone

Source Table: Employee

department_id Text 10

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Department id where he/she works for

DisplayControl: Text Box

Ordinal Position: 6

Required: True

Source Field: department_id

Source Table: Employee

Table: Priority

Properties

Date Created: 4/30/99 4:45:50 PM Def. Updatable: True

Last Updated: 5/22/99 2:22:58 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

priority_id Text 10

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Priority id

DisplayControl: Text Box

Ordinal Position: 1

Required: True

Source Field: priority_id

Source Table: Priority

priority_desc Text 50

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Description of the priority

DisplayControl: Text Box

Ordinal Position: 2

Required: True

Source Field: priority_desc

Source Table: Priority

priority_resp Text 50

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Response time approx. will take to fix it, according with this priority

DisplayControl: Text Box

Ordinal Position: 3

Required: True

Source Field: priority_resp

Source Table: Priority

Table: process

Properties

Date Created: 4/30/99 4:49:52 PM Def. Updatable: True

Last Updated: 5/22/99 2:23:19 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

process_id Text 10

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Process id. This could a particular screen on the whole application

such as Past due accounts

DisplayControl: Text Box

Ordinal Position: 1

Required: True

Source Field: process_id

Source Table: process

process_desc Text 50

AllowZeroLength: True

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Description

DisplayControl: Text Box

Ordinal Position: 2

Required: True

Source Field: process_desc

Source Table: process

Table: Request

Properties

Date Created: 4/30/99 4:59:51 PM Def. Updatable: True

Last Updated: 5/22/99 2:24:11 PM OrderByOn: False

RecordCount: 0

Columns

Name Type Size

request_id Number (Long) 4

AllowZeroLength: False

Attributes: Fixed Size, Auto-Increment

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Request id

Ordinal Position: 1

Required: False

Source Field: request_id

Source Table: Request

priority_id Text 10

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Priority id

DisplayControl: Text Box

Ordinal Position: 2

Required: False

Source Field: priority_id

Source Table: Request

employee_id Number (Integer) 2

AllowZeroLength: False

Attributes: Fixed Size

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Decimal Places: 0

Default Value: 0

Description: Employee id. User who makes the request

DisplayControl: Text Box

Ordinal Position: 3

Required: True

Source Field: employee_id

Source Table: Request

(Continued)

process_id Text 10

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Process id

DisplayControl: Text Box

Ordinal Position: 4

Required: False

Source Field: process_id

Source Table: Request

request_date Date/Time 8

AllowZeroLength: False

Attributes: Fixed Size

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Date when the request is made

Ordinal Position: 5

Required: True

Source Field: request_date

Source Table: Request

request_status Text 20

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Status of the request (open,closed,cancelled)

DisplayControl: Text Box

Ordinal Position: 6

Required: True

Source Field: request_status

Source Table: Request

problem_desc Text 50

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Description of the problem

DisplayControl: Text Box

Ordinal Position: 7

Required: True

Source Field: problem_desc

Source Table: Request

Table: Request

resolution_des Text 250

AllowZeroLength: False

Attributes: Variable Length

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Description of the resolution

DisplayControl: Text Box

Ordinal Position: 8

Required: False

Source Field: resolution_des

Source Table: Request

closed_date Date/Time 8

AllowZeroLength: False

Attributes: Fixed Size

Collating Order: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

Description: Date when the request is closed

Ordinal Position: 9

Required: False

Source Field: closed_date

Source Table: Request