DATA MAINTENANCE

Headline text

Main Page > Application Development Team > System Manual > SPGC EPAYROLL

Navigating to Data Maintenance

I.COMPANY

Figure 1.0

Figure 1.1

1.Search Field: Through this field, users can search employees on the system by the use of company’s name.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add company entry.
5.Edit: To edit the company entry.

Once you click Add Button, it will show table company entry. You may see figure 2.0 for your reference.

Figure 1.2

• Company Code – In this module the user can select the Company code entry to complete the process.
• Name – In this module the user can select the Name entry to complete the process.
• SSS – In this module the user can select the SSS Number entry to complete the process d.
• TIN No – In this module the user can select the TIN Number entry to complete the process.
• PhilHealth No  – In this module the user can select the PhilHealth Number entry to complete the process.
• HDMF No – In this module the user can select the HDMF Number entry to complete the process.
• Address  – In this module the user can select the Address entry to complete the process.
• Tel. No – In this module the user can select the Tel. number entry to complete the process.
• ZIP Code– In this module the user can select the ZIP code entry to complete the process.
• Company Signatory–  This module is the signature of Company to complete the process.
• Position– In this module the user can select the Position entry to complete the process.

Before you save, make sure to fill out all the needed fields correctly.

II.PAYROLL PERIOD

Figure 2.0

1.Pay Class: In this module you can select Weekly, Monthly and VIP depends to your Pay class.
2.Company: In this module you can select the company name.

Once selecting the module, it will show table pay period. You may see figure 2.1 for your reference.

Figure 2.1

1.Search Field: Through this field, users can search Payroll Period on the system by the use of Pay Class and Company’s name.
2.Add: Allows you to add Payroll Period entry.
3.Edit: To edit the Payroll Period entry.

Figure 2.2

•Month – In this module the user can select the Month of entry to complete the process.
•Period – In this module the user can select the period entry to complete the process.
•No. of days – In this module the user can select the number of days to complete the process.
•Period From – This module the user can select the start of the pay period.
•Period To – This module the user can select the end of the pay period.
•Assumed To – This module the user can select the assumed of date of pay period.
•Remote Cut Off from - This module is the start cut off of the Payroll offsite.
•Remote Cut Off to - This module is the end of cut off of the Payroll offsite.

1.Before you save, make sure to fill out all the needed fields correctly.
2.If you check the posted below, the Payroll is not allowed to modify and if you want to modify the Payroll uncheck Posted below to modify you’re Payroll and press save button.

Note: You can only modify those Payroll Period which is not posted yet.

Figure 2.3

1.You can only modify those Payroll Period which is not posted yet.
2.If you want to modify the company entries just click edit.

III.SDSA

Figure 3.0

1.Search Field: Through this field, users can search employees on the system by the use of company’s name or SDSA
2.Reset: To reset the history you search.
3.Print: To print the important information.

Once you select company name and SDSA, it will show the information. You may see figure 3.1 for your reference.

Figure 3.1

1.This form will show the information about the SDSA.

IV.DEPARTMENT

Figure 4.0

1.Search Field: Through this field, users can search employees on the system by the use of company’s name or Cost Center.
2.Reset: To reset the history you search.
3.Print: To print the important information.

Once selecting the company name, it will show table information. You may see figure 4.1 for your reference.

Figure 4.1

1.Add: Allows you to add Department Cost Center entry.
2.Edit: To edit the Department Cost Center entry.

Figure 4.2

•Department Cost Center – In this module the user can select the Dept. Cost Center to complete the process.
•Name – this module the user can select the Name of  department to complete the process.

Note: After fill up Department, if you check the Active below the department will be active. And if you uncheck the Active below the department will be inactive. And Press the save button.

1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the Department Cost Center entries just click edit.  And check the Active button if you want to active this entry.

V.WORK SCHEDULE

Figure 5.0

1.Search Field: Through this field, users can search Work Schedule on the system by the use of Work Schedule.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Work Schedule entry.
5.Edit: To edit the Work Schedule entry.

Once you click Add Button, it will show table Work Schedule entry. You may see figure 5.1 for your reference.

Figure 5.1 Note * In regular schedule will be start in 8am to 11am and then in PM in is 12pm to 6pm.

Full night schedule will be start in 10pm to 2am and then 3am to 6am. AM in schedule fall on Night Shift example is when your schedule will fall in night shift. PM out schedule fall on night shift example is when your schedule will fall in before night shift.

If you check the checkbox button, example in AM out you will out all day in AM out.

1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the Work Schedule entry just click edit.

VI.HOLIDAY

Figure 6.0

1.Search Field: Through this field, users can search Holiday Master on the system by the use of Holiday.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Holiday Master entry.
5.Edit: To edit the Holiday Master entry.

Once you click Add Button, it will show table Holiday Master entry. You may see figure 6.1 for your reference.

Figure 6.1

•Holi Date – In this module the user can select the Holiday Date to complete the process.
•Type – In this module the user can select the type of holiday if Regular holiday, Legal holiday, Special holiday or Area holiday.
•Location – In this module the user can select the location to complete the process.

1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the Work Schedule entry just click edit.

VII.SAP GL Proc Parameters

Figure 7.0

1.Select the Company you want to View.

Once you select the Company you want to view, it will show GL Code Breakdown Parameters and SDSA Breakdown Parameters. You may see figure 2.0 for your reference.

Figure 7.1

1.After you choose a company this data will show. If you want to modify the GL Code Breakdown just click in the left side of form and choose. And if you want to modify the SDSA Breakdown just click the add icon in the right side.
2.After this data press the save button bellow.

Figure 7.2

VIII.BRANCH CODE

Branch Code allows you to add Branch and Modify only

Figure 8.0

1.Search Field: Through this field, users can search Holiday Master on the system by the use of Holiday.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Holiday Master entry.
5.Edit: To edit the Holiday Master entry.

Once you click Add Button, it will show table Holiday Master entry. You may see figure 8.1 for your reference.

Figure 8.1

•Branch Code – In this module the user can select the branch code to complete the process.
•Branch Name – In this module the user can select the branch name to complete the process.

1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the Branch entry just click edit.

IX.PAYROLL TABLE

In this Payroll Table you can add Pag ibig ,SSS and Tax Entries and it’s process is the same. In the Tax table there are two types of Tax , Tax Additional Rate and Annual Tax Table. It is the same Process of Pag Ibig Entry and SSS you can Add, Edit and Search.

Figure 9.0

1.Search Field: Through this field, users can search the Pag ibig ,SSS and Tax on the system by the use of the Pag ibig ,SSS and Tax entries.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Pag ibig ,SSS and Tax Entries.
5.Edit: To edit the Pag ibig ,SSS and Tax Entries.

Once you click Add Button, it will show the table. You may see figure 9.1 for your reference.

This table is example of how to add Pag Ibig entry. In the SSS and Tax entry it is the same process of Pag Ibig entry

Figure 9.1

•Lower Range – This module contains to set the lower range of pag ibig entry.
•Upper Range – This module contains to set the upper range of pag ibig entry.
•Employee Percentage - This module contains to set the percentage of employee.
•Employer Percentage – This module contains to set the percentage of employer.
•Employee Fixed Contribution – This module contains to set the fixed Contribution of employee.
•Employer Fixed Contribution – This module contains to set the fixed Contribution of employer.

1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the data inputted just click edit.

X.EMPLOYMENT INFORMATION

In this table you can search, add and edit the Benefit, Position, Location and Job level of employee. And it’s process is the same.

Figure 10.0

1.Search Field: Through this field, users can search Benefits, Position, Location and Job Level.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Benefits, Position, Location and Job Level entries.
5.Edit: To edit the Benefits, Position, Location and Job Level entries.

Once you click Add Button, it will show the table example of Benefits Entry. You may see figure 10.1 for your reference.

This table is example of how to add Benefits entry. In the Position, Location and Job Level. It is the same Process of Benefits entry

Figure 10.1

•Benefit Code – In this module the user must select the Benefit Code to complete the process.
•Benefit Description – In this module the user must select the Benefits Description to complete the process.

1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the data inputted just click edit.

XI.WAGE ORDER

In this table you can search, add and edit the Region, Region Area, Class and Wage Order of employee. And it’s process is the same.

Figure 11.0

1.Search Field: Through this field, users can search Region, Region Area, Class and Wage Order.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to Region, Region Area, Class and Wage Order entries.
5.Edit: To edit the Region, Region Area, Class and Wage Order entries.

Once you click Add Button, it will show the example table of Region Entry. You may see figure 11.1 for your reference.

This table is example of how to add Region entry. In the Region Area, Class and Wage Order. It is the same Process of Region entry.

Figure 11.1

•Region Code – In this module the user must select the Region Code to complete the process.
•Region Name – In this module the user must select the Region Name to complete the process.

I.Before you save, make sure to fill out all the needed fields correctly.
II.If you want to modify the data inputted just click edit.