[AccessD] Fwd: FW: table design

[James Button]

A possible approach to the accounting department 'needs' and 'requirements'
And - get that agreed in writing - and minutes of at least one meeting

Phone charges go to the department manager where the phone was assigned
It is the managers responsibility to notify 'Accounts' of the assignment of the
phone ( and other devices) and of the SIM from their department pool to
individuals 
And to recover the device and SIM  and return them to the appropriate
acquisitions management department.

Alternatively they will have to accept the assignment of costs as managed by
'Accounts'

Yup 
I have been employees at government sites and on their projects as well as
multinationals 

First response when a new task/project is mentioned -
"Certainly - can you provide a cost centre budget for the feasibility and
associated document preparation work,  please. "

Surprising how much work never gets any budget allocation for even that.


Oh! and re phone 1 and 2 - 

Phone 1 gets lost - 
Or cannot be found 
Maybe the battery is totally flat so it doesn't ring, and location services
don't work
Or it's in the sewerage system !
Or in the foreign hire car.


And  I wasn't really intending to join in on the design - 
Just indicating possibilities for which I believe you should consider design
allowances, or avoidance techniques.

Especially if you get told you should answer with either a "yes2 or a "no" to
questions 
As in If I 'Save'  will the file be overwritten?
(No mention of the app, or the working (team etc.) environment, or even the
user's logged-in and access status and authority.)

JimB
 


-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of David McAfee
Sent: Friday, September 25, 2020 7:22 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Cc: James Button <jamesbutton at blueyonder.co.uk>
Subject: Re: [AccessD] Fwd: FW: table design

James, you think like I do. Lol!

These department heads hate when I come into planning meetings because I
bring up all of these scenarios. I am always informed that the said
scenarios will never happen then usually do right after hahaha.

I'll answer the rest of your questions inline:


You can have multiple phones on an account
>

Yes we do.  1500 phones on 6 accounts



Have the SIM's moved between phones
>

I was told this doesn't happen but have found examples of it happening



Have phones passed on between assignees either intended to be permanently,
> for a short period, or just a day loaner.



Not supposed to, but yes. This usually happens by their supervisor when
someone goes on a leave of absence.




Also - Phones assigned to 'posts', and to teams - as in manager says who
> gets
> the phone for weekend on-call
>

I have found this scenario as well. Some offices have dedicated "on call"
phones that users take home. These are still assigned to the correct cost
center for accounting purposes. I was thinking of creating an employee such
as "On Call Location X" in my employee table to handle this purpose. I was
also thinking of creating an "unassigned" employee to deal with that
situation.

This is one of the things that I've been flip flopping about. I'm not sure
if I should make my inventory bins and employee assignments the same table.

Phone 1 is with Joe, which gets dropped.
It gets assigned to quarantine/repair
Phone 2 gets assigned to Joe.
Phone 1 is now repaired and is assigned to "unassigned"
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com