Status Kevin Morgan 07/05 -- 07/09

To: Susan DiFabio ARG38F/CONV/MISC 32

TUSC 8

Total 40.

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

MONDAY (TUSC HOL ) 8.0

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

TUESDAY 06-JUL-1999 (7.5 hrs - ARG38F)

CALENDAR/OO

Wrote unix shell to call the index tuning SQL script. Scheduled the

job in nightly2000. Worked with Steve to tune the daily appointnment
query,

then implmented with Dave. Continued work on the system documentation.

To Do:

\- Migrate the conference rooms

\- Finish system documentation

TMS

Diane Sandberg stopped in to discuss the password on emergency plan 432.

The user was not yet in the HR database. She was under the imppression
that

the password was removed. I explained that it can be cirumcvented by
choosing

the \"Others\" link if the test taker is nto yet in the database
Suggested the user

Suggested the user enter \"Badge# XXXXX\" in lieu of the SS#.

SRO

Lahsen Assoufid sent email about not betting into a system. It turned
out

he was unable to retrieve data from the SRO system. Ensured his IP was
in

IP_APS and IP_SRO. Granted SRO_USER an SRO_RF_USER.

XSR (EXPERIMENTAL SAFETY REV)

Lisa Keefe of IMCA-CAT requeted her password, Then I checked to ensure

she could retrieve experiments. Her CAT experiment access was inactive,

which I remedied.

STOCKROOM

Reviewed BAR_STOCK_HEADER and BAR_STOCK_DETAIL with Steve for tuning
purposes.

Also discussed re-writing some queries, to ensure there is not any

index suppression,

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

WEDNESDAY 07-JUL-1999 (8.0 hrs - ARG38F)

CALENDAR/OO

Migrated BOARD, CONFERENCE and SEMINAR calendars from Oracle Office.

All the data appeared to migrate correctly (after 2 iterations).
Configured

Anita Bakke to view all 3 calendars. Configured Barb Dalton to view the

BOARD calendar. Anita requested a report of missing information, but I
checked

the migrated data and found nothing missing - including recurring notes.
I will

meet with her tomorow to demonstrate the system, and she can show me any
data

that may have been missed. I don\'t think any was. Made some revisions
to the

migration documentation. Sent email to Barb Dalton and Anita Bakke
confirming

the migration to be complete.

MISC

Continued administering TMS system. Moving people around the role scope,

creating new users. Reset some passwords. Requested TMS list from user

office (via Marcia). Received email from Kathy O\'Brien concerning TMS.

Added Marty Knott as a calendar user.

SEALED SOURCES

Started reviewing spec for sealed sources. Will contact Bruce Glagola
tomorrow

to arrange a meeting.

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

THURSDAY 08-JUL-1999 (8.0 hrs - ARG38F)

CALENDAR/OO

Dave reported a bug with deleting and updating some recurring records.

Tracked this down to some recurring events not having root records in

CAL_RECURRING from the migration. Modified CAL0008.DELETE\...so that
this

did not matter for the records. It no lonmger checks for a root record.

Created the missing records with an SQR and CREATED_BY=FIXER. Showed

Bob Whitman and Anita Bakker how to use the new system. Their notes

did not migrate - they were a different field than the one to which I
thought

they were referring. They asked to be able to access the old system
again,

or get a printout report of the notes. Since I didnt know where they
were

in the system, I elected to give the temp password to Anita. I also
warned them

to use the old calendr for read only - any data added will be lost. Our

printer (mis3) had problems with the marings for hte report - theirs had
a problem

(apo3), but it showed more than ours. Rose\'sprint out is perfect. Added
Joanne Day,

Russ Huebner. Also added Bob Whitman and Anita Vanderwall to the system.

They also put in a request to show the name of the calendar on the
printout.

Rose approves of this. Rose also said this should be a new field -
display

calendar name.

To do:

\- Attempt migration of their notes for the CONFERENCE ROOM and the
SEMINAR ROOM

, so we can drop Oracle Office. They are only

using office to read notes currently. Table=OM_BODY.MSG_LINE (refers to
MSG_ID

in OC_EVENT)

\- They requested a \"user profile\" that contains defaults (I didnt
promise anything)

SRO

Started adding new SRO sequences KB, JH, TO per Marie

MISC

Spoke with Bruce Glagola about sealed sources. He didn\'t know he was
the

contact. Reset some passwords.

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

FRIDAY 09-JUL-1999 (8.5 hrs - ARG38F)

CALENDAR/OO

Migrated the recurring notes for Bob Whitman and Anita. Wrote SQR\'s

migrate_detail, link_detail and fix_missing_links in order to complete
the

migration. Bob complained that the detail view window is too small and
he

has to scroll through several screens. Tried opening frame in new
window, but

the text box width is hardcoded. Perhaps we can add a \"Big Detail\"
link to

the right frame (i.e. make the title \"Detail\" a link to this new 1-box
view)

that would put a full note somewhere on the screen. We should be able to

officially erase oracle office sometime next week. Then we can have a
party.

Spoke with Chris via phone as he talked me through sync\'ing the palm
pilots.

I have the back up in my office. Copied the PDF\'s to Dr. Moncton\'s
laptop

To do:

\- Complete documentation on notes (including recurring ) migration

\- We need to re-implement IP security on the cal packages. It was
dropped

temporarily because of an SNS access problem.

SRO

Restored Marie\'s TM_TIMESHEET for a particular SRO that she accidently
erased.

I dropped the copy of this table in SHERIDAN. Continued development to

make the SRO system capable of handling 3 new sequences. Working on the

tm0001 package to enable the assignment of these numbers, then will work

on the viewers. May add independed sequence internal PK to improve
performance

and eliminate some issues.

MISC

Helped Prabjhot get a new TNSNAMES.ORA that included APS4. Worked to
find

a DEV1 user that can CREATE PUBLIC SYNONYM (designer is the schema).
Added

2 new users to GEN_USER_TABLE based on nightly report. Reset PWD\'s.