Difference between revisions of "03212016 TO 04012016"

From SPGC Document Wiki
Jump to: navigation, search
(→‎Completed Projects)
 
(16 intermediate revisions by the same user not shown)
Line 6: Line 6:
 
: - resetting of clearance module
 
: - resetting of clearance module
  
−
=== Migration of timekeeping module - <u>For - UAT /Parallel testing</u> ===
+
=== Migration of timekeeping module - <u>For - UAT / Parallel testing</u> ===
−
: - Setup a meeting with HR regarding the computation of manhour QB.. already send an email waiting for verification
+
: - waiting for the test results bugs and improvements
 
* COMPLETED
 
* COMPLETED
−
** migrate the old shift code to new shift code and assign it to employees.
+
** Timekeeping DTR
−
** mapping of old to new shift code to table.
+
** OBTP File entry
−
** manhour computation leave file.
+
** Overtime entry
−
** manhour computation no of days
+
** Special Overtime entry
−
** add validation and testing if the data computed are correct..
+
** 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
  
 
== On-Going Projects ==
 
== On-Going Projects ==
  
−
=== Enhancement of Online Filing System - <u>In - Progress</u> ===
+
=== Enhancement of Online Filing System - <u>In - Progress 80%</u> ===
 +
: - Posting Module - On-Hold
 
: - Login module - Done
 
: - Login module - Done
 
: - File Leave module - Done
 
: - File Leave module - Done
−
: - OT module - In-Progress
+
: - OT module - Done
−
: - OBTP module - To Do
+
: - OBTP module - Done
−
: - UT module - To Do
+
: - UT module - Done
−
: - User Rights Access - To Do
+
: - User Rights Access - Done
−
: - Approval Module - In-Progress 20%
+
: - Approval Module - Done
−
: - Posting Module - In-Progress 10%
+
: - Employee Maintenance - Done
 +
: - Department Maintenance - Done
 +
: - Change of password - Done
  
−
=== Migration of quotabase to web - <u>On-Hold</u> ===
+
=== Migration of quotabase to web - <u>In-Progress</u> ===
 
: - need to finish first the manhour computation to proceed
 
: - 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..
  
−
=== Manhour Computation <u>For UAT - Waiting for feedback</u>===
+
=== Manhour Computation <u>In - Progress</u>===
−
: - For UAT of HR. Waiting for their feedback and other improvements/bugs that may arise
+
: - 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 <u>For UAT - Waiting for feedback</u> ===
+
=== Payroll Computation <u>For UAT</u> ===
 
: - For UAT of HR. Waiting for their feedback and other improvements/bugs that may arise, need to finish first the Manhour Computation
 
: - For UAT of HR. Waiting for their feedback and other improvements/bugs that may arise, need to finish first the Manhour Computation
  
Line 41: Line 64:
 
== Supports ==
 
== Supports ==
 
=== Payroll Supports ===
 
=== Payroll Supports ===
−
* [BUG] Bank Advice and Disk generation was not tally Requested by Ms. Edna
+
* [SUPPORT] Additional Access to AJ in payment entry requested by Ms. Gina
−
* [SUPPORT] Checking SDSA of 10002658 & 20051048 Requested By AJ
+
* [SUPPORT] SDSA inforamtion for Shean
−
* [SUPPORT] Create a new SDSA code Requested by Normuel
+
* [SUPPORT] Adjust leave credited to Mr. CESAR SANTIAGO CASTILLO last 2016-03-23: Ms. Lynelle 
−
* [SUPPORT] Unable to add finger print ID due to duplicate FPID
+
* [SUPPORT] Allow Ms. Aj to access the generation of Payroll Journal requested by Ms. Gina
−
* [SUPPORT] Uploading of cash card disk due to change of change of digit length from 22 to 21
+
* [SUPPORT] Allow Ms. Lea to access the generation of Payroll Journal
−
* [SUPPORT] Error in uploading QB Marilao TK due to posting of pay period is already done. requested by AJ
+
* [SUPPORT] BRILLANTES,ALMA CORAZON's SSS Number exist: Ms. Lynelle
−
* [SUPPORT] requested to remove BUHIA, DARIUS ROBREDILLO, SAPANTA, MICHAEL TALION and ADLAON, ALBERT JOSE ABIADA in generation of bank advice and disk
+
* [SUPPORT] Creation of new shiftcode requsted by Lea
−
* [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] Delete MALACA, ARIEL y MANABAT in EFILE: Ms. Chesca
−
* [SUPPORT] In and out of 13001784 and 13002185,16001148 requested by Lynelle
+
* [SUPPORT] Error occur upon reformatting attlogs: Mr. Paul
−
* [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] Error occur when transferring uploaded qb payroll: Ms. Aj
−
* [SUPPORT] Mia SDSA cant be uploaded in the system
+
* [SUPPORT] Error occur while reformatting: Ms. Maggi Capait (dapitan)
−
* [SUPPORT] Include new SDSA for SAP GL of SLAC
+
* [SUPPORT] Generation of SAPGL separate the CASH-NET and HOLD-NET: Ms. Gina
−
* [SUPPORT] SDSA of 20054935 of taxrefund this cut off Req. AJ
+
* [SUPPORT] Hold Salary of 12002358 MICUTUAN, PANFILO JR BOCO: Ms. Edna
−
* [SUPPORT] SDSA of Rapsing status
+
* [SUPPORT] In and out of David and Carrera,Raymart Reyes: Ms. Lynelle
−
* [SUPPORT] Separation of KAL AND MAKATI MBTC Disk for VIP. Req. by Lynell
+
* [SUPPORT] In and out of SPLAND employees: Ms. Eli
−
* [SUPPORT] Special Holiday pay of 16000655
+
* [SUPPORT] In and out of the newly hired employees: Ms. Eli
−
* [SUPPORT] UCPB cash card - error on UCPB program while uploading
+
* [SUPPORT] Include the EMPLOYMENT status for the SDSA record request of Ms. Shean
−
* [SUPPORT] Unable to record in SDSA VIP Module due to special characters # remarks
+
* [SUPPORT] Install weblink: Ms. Lea & Mr. Paul
−
* [SUPPORT] Update the document date of Mr. Porras Andrew requested by Normuel
+
* [SUPPORT] Instruct Paul Santuico in uploading Manhour
−
* [SUPPORT] Update SDSA encoding date of 20049251
+
* [SUPPORT] OMNOM EMPLOYEE'S Generation of report: Ms. Princess & Mr. Paul
−
* [SUPPORT] Wrong number of hours assigned to Ms. Joan Chung
+
* [SUPPORT] Online Filing Access: Paul Santuico
−
* [SUPPORT] Wrong uploaded VIP Cut-off
+
* [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 ===
 
=== Roundcube / Webmail Supports ===
−
* Checking of information of email sapcd6. requested by arvin
+
* 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).
 +
 
 
* Resetting of RC password
 
* Resetting of RC password
 
:::Ms. Nacu
 
:::Ms. Nacu
 
:::Ms. Perlita Skaar
 
:::Ms. Perlita Skaar
−
* Resetting Webmail Password
+
* Update Identities
−
:::Mr. Romy Ribis
+
:::Cha-cha Floro <mar_hr_nurse@local.com>
−
:::Ms. Christy De Vega
+
−
:::Ms. Pinky Rose Polistico
+
  
 
=== Clearance Support ===
 
=== Clearance Support ===
−
* No name in clearance
+
* Display position and department of all Prob Employee
−
**e521ic - Rafael Luis Casquero
+
* Resetting of clearance
−
**vlpineda - Virginia L. Pined
+
** MARIA THERESA MANGALUS
−
**e522sh- Kimberly Ann MOlon
+
** PATRICIA MAY NAZ
−
**omnom4- Princess Stephany D. Tan
+
** BESSIE BAJASAN
−
**mtopinion - Michelle T. Opinion
+
** MARK JOSEPH LUCENA
 +
* Update Name
 +
**e483sh Cecilia Sonsona to Allan Habel
  
 
=== Other In-House Support/Development ===
 
=== Other In-House Support/Development ===
−
* Importing item data to POS
+
* DASHBOARD POSTING: Ms. Joan Chung
−
* Back up server to DVD/external HDD 
+
* Duplicate copy of water reading/consumptions from 2014 to 2016: Mr. Sanje
−
* Include inserting employee record in myusers table.
+
* Error in opening POS SHOWROOM: Ms. Leony
−
* Dashboard posting: requested by Loiguie
+
* ETK reset pw 15000667
−
* Dashboard posting: requested By Admin mean
+
* Dashboard posting: Ms. Rose
−
* Dashboard posting: requested By Marj
+
* I.O exception occur while uploading SLAC Sales Report: Leony
−
* Dashboard posting "For earth hour"
+
* Online Filing Access: Paul Santuico
−
* reset of ETK user of Arvin Dilapdilap
+
* POS Nueva no price included after uploading new iTEM: Ms. Chona
−
* error in uploading of new item in POS,can't process the file due to button not working.
+
* raw file DSR records from March 1 - 15 : Ms. Lannie
−
* SPBilling remove the prevbal and prevpenalty in column
+
* REVISED POSTED ANNOUNCEMENT: Ms. Marj
−
* Update POS SLAC prices: requested By Brian Lim
+
* Undefined items in SLAC sales report: Ms. Lannie
−
 
+
* testing of virtual backup server.
−
=== Documentation ===
+
−
*Create a check list to be discussed
+
−
* Biometrics User's manual
+
−
* Set up Biometrics
+
−
 
+
−
== Meetings ==
+
−
 
+
−
* Meetings with aileen of meycauyan regarding the new Biometrics they will be using
+

Latest revision as of 09:06, 4 April 2016

Completed Projects

Facility to reset a clearance - In - Progress - 100%

- editing of user information module
- resetting of clearance module

Migration of timekeeping module - For - UAT / Parallel testing

- waiting for the test results bugs and improvements
  • COMPLETED
    • 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

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

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..

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

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] 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

  • 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).
  • Resetting of RC password
Ms. Nacu
Ms. Perlita Skaar
  • Update Identities
Cha-cha Floro <mar_hr_nurse@local.com>

Clearance Support

  • Display position and department of all Prob Employee
  • Resetting of clearance
    • MARIA THERESA MANGALUS
    • PATRICIA MAY NAZ
    • BESSIE BAJASAN
    • MARK JOSEPH LUCENA
  • Update Name
    • e483sh Cecilia Sonsona to Allan Habel

Other In-House Support/Development

  • 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.
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=03212016_TO_04012016&oldid=186"