Difference between revisions of "03072016 TO 04012016"

Revision as of 09:49, 4 April 2016 (view source) Admin (Talk | contribs) (→‎Completed Projects) ← Older edit		Revision as of 09:49, 4 April 2016 (view source) Admin (Talk | contribs) (→‎RC Utility module improvement and integration (COMPLETED)) Newer edit →
Line 17:		Line 17:
	** Timekeeping audit trail		** Timekeeping audit trail
−	=== RC Utility module improvement and integration <u>(COMPLETED)</u> ===	+	=== RC Utility module improvement and integration <u>(IMPLEMENTED IN ESSI)</u> ===
	* Integrate RC resetting of password		* Integrate RC resetting of password
	:: - Integrate from old created module to the new module		:: - Integrate from old created module to the new module

---

Revision as of 09:49, 4 April 2016

Completed Projects

Migration of timekeeping module - For - UAT / Parallel testing

- waiting for the test results bugs and improvements

• SCOPE of this module
  • Timekeeping DTR
  • OBTP File entry
  • Overtime entry
  • Special Overtime entry
  • Undertime entry
  • SL / VL entry
  • Leave adjustment
  • SL / VL recon
  • Time vs Rate (new)
  • Attendance logs (new)
  • Timekeeping test server for UAT
  • Timekeeping audit trail

RC Utility module improvement and integration (IMPLEMENTED IN ESSI)

• Integrate RC resetting of password

- Integrate from old created module to the new module

- editing of user information module

- resetting of clearance module

• Integrate updating identities

- Integrate from old created module to the new module

• Create user rights access for this program

- Add additional features to give the user access rights to this programs

- Done 03/17/2016

DMRS Website (COMPLETED - Waiting for the Additional Improvement)

- Already presented to DMRS Depatartment(Ms. Tiff) on March 11, 2016., They told ADT that they will talk about this regarding the improvement of this web site

SAP Master Data Automation - COMPLETED - For UAT

- Already acknowledge by SAP/ABAP Team. Waiting for the result of the UAT

Create a test server for internal testing (COMPLETED)

- Create a test server for all module that will be develop, this will serve as a development server for all ADT

SPGC Project Management COMPLETED

- This system will be use in monitoring and logging of project/task for ADT

SPGC Document Wiki COMPLETED

- This system will be use in online logging of documentation and report of ADT

On-Going Projects

Enhancement of Online Filing System - In - Progress 80%

- Posting Module - On-Hold

- Login module - Done

- File Leave module - Done

- OT module - Done

- OBTP module - Done

- UT module - Done

- User Rights Access - Done

- Approval Module - Done

- Employee Maintenance - Done

- Department Maintenance - Done

- Change of password - Done

Manhour Computation In - Progress

- Need to put back in-progress to comply to new timekeeping adjusted module.. need to finish the timekeeping to proceed in development of this.

• Completed
  • Penalty Computation
  • Manhour Computation OBTP
  • Saturday and rest day OT
  • Special OT Computation
  • Regular OT Computation
  • Tardy Computation

Payroll Computation For UAT

- For UAT of HR. Waiting for their feedback and other improvements/bugs that may arise, need to finish first the Manhour Computation

Migration of quotabase to web - In-Progress

- need to finish first the manhour computation to proceed

• COMPLETED
  • migrate the old shift code to new shift code and assign it to employees.
  • mapping of old to new shift code to table.
  • manhour computation leave file.
  • manhour computation no of days
  • add validation and testing if the data computed are correct..

Sterling Global Payroll - For Review

- System is now ready. Waiting for the availability of user to review and UAT the system

Supports

Payroll Supports

• [SUPPORT] SSS LOAN ERROR - Need to adjust the text file : requested by Normuel Oliva
• [SUPPORT] Check amount of 13th month computed to 14000297 in his lastpay : requested by Normuel Oliva
• [SUPPORT] Weekly SAP GL Not tally due to the document dates of SDSA is not equal : Requested By AJ
• [SUPPORT] Weekly SDSA total amount is not tally
• [SUPPORT] SGMP adding of company for payroll system
• [SUPPORT] Withholding tax is not tally from payroll report to SAP report due to the add back of SDSA happened last cutoff
• [SUPPORT] Error 2 hours credited to miles cataag : Req. By Lynel
• [SUPPORT] Wrong Tagging of PhilHealth Number in text file : Requested by Lea Ricafrente
• [SUPPORT] Send instruction to Ms. Cleng how to get the dbf file of in and out of the employees and also the payroll verification records.
• [SUPPORT] Request monthly attendance report for NOV. (DOS BASED) : Requested By Cleng
• [SUPPORT] Update Weekly Payperiod: Requested By Shean
• [SUPPORT] Invalid Cut-off in Weekly Payroll : Requested By Shean
• [SUPPORT] Generate headcount report in excel : Requested By Lea Ricafrente
• [SUPPORT] Error in opening filed leave in ETK : requested By Sir Kiko
• [BUG] Bank Advice and Disk generation was not tally Requested by Ms. Edna
• [SUPPORT] Checking SDSA of 10002658 & 20051048 Requested By AJ
• [SUPPORT] Create a new SDSA code Requested by Normuel
• [SUPPORT] Unable to add finger print ID due to duplicate FPID
• [SUPPORT] Uploading of cash card disk due to change of change of digit length from 22 to 21
• [SUPPORT] Error in uploading QB Marilao TK due to posting of pay period is already done. requested by AJ
• [SUPPORT] requested to remove BUHIA, DARIUS ROBREDILLO, SAPANTA, MICHAEL TALION and ADLAON, ALBERT JOSE ABIADA in generation of bank advice and disk
• [SUPPORT] Requested to get the in and out of 1010 and 1044 FPID, DOS Based system do not have a company for SP-Land
• [SUPPORT] In and out of 13001784 and 13002185,16001148 requested by Lynelle
• [SUPPORT] Filed leave of Jeff Ferrer problem, HR told us that they Jeffs leave should not have a Deminimis and other allowance need to meet with HR regarding with the policy
• [SUPPORT] Mia SDSA cant be uploaded in the system
• [SUPPORT] Include new SDSA for SAP GL of SLAC
• [SUPPORT] SDSA of 20054935 of taxrefund this cut off Req. AJ
• [SUPPORT] SDSA of Rapsing status
• [SUPPORT] Separation of KAL AND MAKATI MBTC Disk for VIP. Req. by Lynell
• [SUPPORT] Special Holiday pay of 16000655
• [SUPPORT] UCPB cash card - error on UCPB program while uploading
• [SUPPORT] Unable to record in SDSA VIP Module due to special characters # remarks
• [SUPPORT] Update the document date of Mr. Porras Andrew requested by Normuel
• [SUPPORT] Update SDSA encoding date of 20049251
• [SUPPORT] Wrong number of hours assigned to Ms. Joan Chung
• [SUPPORT] Wrong uploaded VIP Cut-off
• [SUPPORT] Additional Access to AJ in payment entry requested by Ms. Gina
• [SUPPORT] SDSA inforamtion for Shean
• [SUPPORT] Adjust leave credited to Mr. CESAR SANTIAGO CASTILLO last 2016-03-23: Ms. Lynelle
• [SUPPORT] Allow Ms. Aj to access the generation of Payroll Journal requested by Ms. Gina
• [SUPPORT] Allow Ms. Lea to access the generation of Payroll Journal
• [SUPPORT] BRILLANTES,ALMA CORAZON's SSS Number exist: Ms. Lynelle
• [SUPPORT] Creation of new shiftcode requsted by Lea
• [SUPPORT] Delete MALACA, ARIEL y MANABAT in EFILE: Ms. Chesca
• [SUPPORT] Error occur upon reformatting attlogs: Mr. Paul
• [SUPPORT] Error occur when transferring uploaded qb payroll: Ms. Aj
• [SUPPORT] Error occur while reformatting: Ms. Maggi Capait (dapitan)
• [SUPPORT] Generation of SAPGL separate the CASH-NET and HOLD-NET: Ms. Gina
• [SUPPORT] Hold Salary of 12002358 MICUTUAN, PANFILO JR BOCO: Ms. Edna
• [SUPPORT] In and out of David and Carrera,Raymart Reyes: Ms. Lynelle
• [SUPPORT] In and out of SPLAND employees: Ms. Eli
• [SUPPORT] In and out of the newly hired employees: Ms. Eli
• [SUPPORT] Include the EMPLOYMENT status for the SDSA record request of Ms. Shean
• [SUPPORT] Install weblink: Ms. Lea & Mr. Paul
• [SUPPORT] Instruct Paul Santuico in uploading Manhour
• [SUPPORT] OMNOM EMPLOYEE'S Generation of report: Ms. Princess & Mr. Paul
• [SUPPORT] Online Filing Access: Paul Santuico
• [SUPPORT] Record of 14004291 from april 2015 to june 2015: Ms. Aj and Ms. Feh Intia
• [SUPPORT] Reports for all cash payroll employee (per location): Ms. Flordelissa disk
• [SUPPORT] SDSA Payments of 20049251 did not display: Normuel
• [SUPPORT] SDSA records of all employees: Ms. Shean
• [SUPPORT] Separation Date of Ms. Annabel Alvarez: Normuel
• [SUPPORT] Separation Pay of 14004291 employee: Ms. AJ
• [SUPPORT] SPPE SAPGL not tally: Ms. AJ
• [SUPPORT] Update Separation date of Mr. Hector Villaverde: Ms. Lynelle
• [SUPPORT] Update Separation date of NECESITO,MYLENE: Feh Intia

Roundcube / Webmail Supports

• Create RC

Add Ms. Maricel B. David in public Addressbook: Mr. Arvin

Ms. Ople

Mr. Joseph Bordeos

Create user vhien dino

e433sh

e433ic

e433sc

e210sh / myBasics Sterling Square - Storehead

e210ic / myBasics Sterling Square - Inventory Controller

e210sc / myBasics Sterling Square - Senior Cashier

e211sh / myBasics City Mall Tiaong - Storehead

e211ic / myBasics City Mall Tiaong - Inventory Controller e211sc / myBasics City Mall Tiaong - Senior Cashier

e405sh / Expressions Savemore Baliuag - Storehead

e405ic / Expressions Savemore Baliuag - Inventory Controller

e405sc / Expressions Savemore Baliuag - Senior Cashier

e406sh / Expressions SM Trece - Storehead

e406ic / Expressions SM Trece - Inventory Controller

e406sc / Expressions SM Trece - Senior Cashier

e432sh / Expressions City Mall Tiaong - Storehead

e432ic / Expressions City Mall Tiaong - Inventory Controller

e432sc / Expressions City Mall Tiaong - Senior Cashier

e360sh / Expressions Rob. Gen.Tri. - Storehead

e360ic / Expressions Rob. Gen.Tri. - Inventory Controller

e360sc / Expressions Rob. Gen.Tri. - Senior Cashier

e527sh / Expressions New Point Angeles - Storehead

e527ic / Expressions New Point Angeles - Inventory Controller

e527sc / Expressions New Point Angeles - Senior Cashier

Raul Ephraim Agcopra - Regional Sales Manager (Mindanao) -raagcopra

Easter Rosalind Quiatchon - (Davao Finance Cordinator) - dav_coordinator

For Manuel Laron

Ms. Maylen T. Gapas- Treasury Manager

Ms. Camille C. Concepcion- Loans /Treasury Asst.

Alfred Orpiano - Buyer (SLAC Nueva Ecija)

Anthony de Leon - Buyer (SLAC Laguna).

• Update RC name

from Mary Anne Tadique

to Ma. Antonette Soriano

Cha-cha Floro <mar_hr_nurse@local.com>

• Resetting of RC password

tal_landlease_staff1

Ms. Nacu

Ms. Perlita Skaar

• Resetting Webmail Password

rmd_catsup2

Mr. Romy Ribis

Ms. Christy De Vega

Ms. Pinky Rose Polistico

• Error Occur in sending mail using webmail due to slow connection
• Checking of information of email sapcd6. requested by arvin
• Create Webmail Account

Jhonson G. Hapita - CDG Supervisor

username: cdg_sup1

Aries D. Varias - Supervisor

username: cdg_sup

Grethel C. Espiritu - CDG Staff

username: cdg_staff

Clearance Support

• Display position and department of all Prob Employee
• Clearance was not send
• No Name in the clearance user
  • e521ic - Rafael Luis Casquero
  • vlpineda - Virginia L. Pined
  • e522sh- Kimberly Ann MOlon
  • omnom4- Princess Stephany D. Tan
  • mtopinion - Michelle T. Opinion
  • e483sh Cecilia Sonsona to Allan Habel
• Resetting of clearance
  • MARIA THERESA MANGALUS
  • PATRICIA MAY NAZ
  • BESSIE BAJASAN
  • MARK JOSEPH LUCENA

Other In-House Support/Development

• Importing item data to POS
• Back up server to DVD/external HDD
• Dashboard posting "Reminders For RC Users": requested by Sir Kiko
• Back up server to DVD/external HDD
• Include inserting employee record in myusers table.
• Dashboard posting: requested by Loiguie
• Dashboard posting: requested By Admin mean
• Dashboard posting: requested By Marj
• Dashboard posting "For earth hour"
• reset of ETK user of Arvin Dilapdilap
• error in uploading of new item in POS,can't process the file due to button not working.
• SPBilling remove the prevbal and prevpenalty in column
• Update POS SLAC prices: requested By Brian Lim
• DASHBOARD POSTING: Ms. Joan Chung
• Duplicate copy of water reading/consumptions from 2014 to 2016: Mr. Sanje
• Error in opening POS SHOWROOM: Ms. Leony
• ETK reset pw 15000667
• Dashboard posting: Ms. Rose
• I.O exception occur while uploading SLAC Sales Report: Leony
• Online Filing Access: Paul Santuico
• POS Nueva no price included after uploading new iTEM: Ms. Chona
• raw file DSR records from March 1 - 15 : Ms. Lannie
• REVISED POSTED ANNOUNCEMENT: Ms. Marj
• Undefined items in SLAC sales report: Ms. Lannie
• testing of virtual backup server.

Documentation

• Create a list of server names
• Create RC Utility module manual
• Create a report regarding Farmacia ni dok POS
• Create a check list to be discussed
• Biometrics User's manual
• Set up Biometrics