|
TABLE: FACILITY ROOM ACCOUNT
What is the Facility Room
Account table?
This
table contains data about
what accounts are assigned
to what rooms. The data comes
from the production Facilities
database. Only rooms that
have organized research activity
will have an associated account.
What is
the key (unique identifier
for a row) for Facility Room
Account?
Facility
Code, Room, and Account
What is
the timing of the table?
This
table is refreshed nightly
from the Facilities production
database.
Why would
you use it?
You could use this table to
find the account or financial
manager assigned to a room.
What should
you watch out for?
While there may be multiple
accounts assigned to a room,
the system doesn't contain
information about percentages
assigned to each account for
the room. If no accounts are
present for a room it is because
the room shows no research
utilization.
|
