Difference between revisions of "03072016 TO 04012016"

From SPGC Document Wiki
Jump to: navigation, search
(RC Utility module improvement and integration (COMPLETED))
(RC Utility module improvement and integration (IMPLEMENTED IN ESSI))
Line 17: Line 17:
 
** Timekeeping audit trail
 
** Timekeeping audit trail
  
=== RC Utility module improvement and integration <u>(IMPLEMENTED IN ESSI)</u> ===
+
=== RC Utility module improvement and integration <u>Implemented in expression</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:50, 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 expression

  • 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