2004-10-27 Work Log

9:20 - 10:00 ARP WIP.
Tonny's scheduled 8" wafer qty doesn't match mine. Still working on the root cause.

10:00 - 10:30 Meeting.
Discussion with Fendi and Tonny about data version and stuff.

10:30 - 11:00 T-A report.
Tom asked me to add one prompt question for user to select invoice numbers. Report has been released.

11:00 - 11:32 ARP WIP.
Emailed Tonny about my findings.

11:32 - 11:40 Turnkey WIP.
David claimed that he couldn't find a certain part. The reason is that he entered six codes into a 7 codes prompt, so no data was found. Explained how to use.

11:45 - 11:54 ARP CASD.
Fendi asked me to add a version question in the prompt. I found out there is not September data, so I asked Tonny to fix it.

11:54 - 12:06 T-A report.
Tom claimed that there was something wrong with the data, but I found no error.

13:00 - 14:00 ARP WIP.
Found two extra pieces of wafers for fab. The reason is that part was not belonged to a certain customer in real time wip. Have informed Tonny about it.

14:00 - 14:05 ARP DP.
Originally there was no data for September version. Tonny fixed it, but the demand year/month is still wrong. Have informed Tonny about it.

14:05 - 15:00 Proofreading and Archiving.
Arthur has asked me to refine Joseph's email. I've read it once, couldn't understand it, and don't want to read it anymore...

15:15 - 16:00 ARP Shipping.
Some difference between DP shipping and ARP Shipping. Reason: there are two customers under one customer family in DW, but there is only one customer under that customer family in DP. Therefore, there is more records in our ARP report. Informed Fendi and Tom about my discovery. Waiting for a conclusion.

16:15 - 16:33 ARP Cycle Time.
Confirmed with Cathy about TI abnormal lot definition. Gave Tonny a new sql statement to create a view.

16:33 - 17:20 ARP Formatting.
Formatted cycle time report for 5 customers.

17:20 - 17:26 Daily Monitoring.
One error.

17:26 - 17:50 ARP Formatting.

17:50 - 18:00 ARP Performance Testing.
Not good at all.

18:10 - 18:20 Meeting.
Discussed with THM about my NTO universe.

18:20 - 19:00 ARP NTO.
Meeting with Tonny to discuss about the time frame of data to be kept. Experimented with the solution THM suggested, but couldn't use it because I couldn't get the right result with that solution. Experimented with other solutions, but decided that I should wait for Tonny's revision.

Missing work log

Wonder why there is no work log for the 25th? Because everyone in the city had a typhoon day off! Yipee! A three day weekend!

But THM and I still got up that early morning. I, personally got up at 7:30am. We didn't know the day was off until we went to pick up our bike. The landlord saw us, and asked, "isn't today an off-work day?" We were like, "uh? What are you talking about?"

Then THM called our manager to find out, it's true! Gosh! It was so embarrassing, and stupid of us. I should've watched the news.

Anyway, it was a wet day, of course.

Personal Log

9:00 - 9:45 ARP NTO.
Gave Fendi NTO sql statement to do SIT. Asked her to install Teradata ODBC, so she'd be able to use Queryman in the future.

9:45 - 11:45 ARP CASD.
Re-constructed report and preparing SIT sql for Fendi.

11:45 - 12:00 ARP NTO.
Change SIT sql so that Fendi can run it on pl/sql developer.

12:00 - 12:13 ARP CASD.

13:00 - 13:30 Web Browsing.

13:30 - 15:00 ARP NTO.

15:00 - 17:15 Turnkey WIP.
David had questions about metal stages. I tried to find out the reason of his problem.

17:15 - 19:00 ARP NTO.
Data validation. A product body created in 1998 showed up in the report for ADI when querying product created in 2004/09. Reason: that certain product was created for more than 1 customer. Currently, the defition of tape out date is by product. Fendi wants to change to the definition to by product and customer.

19:00 - 19:15 BO usage log.

19:30 - 20:00 ARP NTO.
I think my NTO universe is weird. I'm afraid that I'll get duplicate records in my report. The interesting thing is that I don't! I want Zach to look at my universe to be sure, but he is busy. I will ask him tomorrow.

Sylvia's Personal Log

9:00 - 10:13 ARP Shipping Summary.Fendi needed to do SIT, but she couldn't install Teradata ODBC, so I had to load the report to the portal.

10:13 - 10:30 2004/10 Receipt.I have overworked 0.5 day.

10:30 - 11:30 ARP NTO.It seems that there is some weird things with my report. The data looked okay. I need to look into my report and universe design.

11:30 - 12:00 Modified SMART BO usage report. Removed week number. Analyzed our usage.

12:00 - 13:00 Lunch in Alto Cafe.Spent $395 for THM's and my lunch. I had a cup of hot chocolate, but it was not hot at all. In fact, it was a bit cold. Wasn't worth my money.

13:00 - 13:50 ARP NTO.

13:50 - 15:00 MCKOA sent an email saying that there was something wrong with our report data. It turned out that there was no data in the source, and that he didn't maintain metal stages. I explained my findings and sent him a turnkey help file hoping that he'll maintain his own data. I also logged this issue in our issue log file, but no body reads it anyway. Don't know why I still bother.

15:00 - 15:15 THM's Receipt.

15:15 - 15:30 Logging.

15:30 - 15:48 Restroom.It seems the impact of the ache around my stomach area from last night continues...

15:48 - 16:00 dotProject Update.It seems that logging my activities is taking a bit time from me. No wonder I didn't like doing it in the past. But I need to keep this habbit in order to remember my daily events.

16:30 - 16:50 Moving to a temp place.

16:50 - 17:05 Shopping for snacks.

17:05 - 17:20 ARP NTO.I think I know the reason.

17:20 - 17:40 Daily Monitor.Asked Zach to give me his hosts file. Changed mine to his, then my informatica worked again. Daily monitor is okay.

17:40 - 18:20 ARP NTO.
I think I figured it out. I think I can let Fendi do NTO SIT on Monday.