Bulk Data Import - Field List (Indonesia)

Created by Kamiworkforce Support Admin, Modified on Thu, 24 Aug, 2023 at 4:40 PM by Wandy Prawira

This article guides what to fill up on your Import templates so you don't get lost.


Key Identifiers

(Please pay close attention to these critical fields)

Field NameFormat

Notes


Employee ID

Alphanumeric


REQUIRED
  • If Employee ID does not already exist in ZipHR, a NEW EMPLOYEE will be created.
  • If Employee ID already exists in ZipHR, the data will be edited on that existing employee.

Active

Yes, No



Select NO if it is an employee that is no longer employed by the company.


ZipHR will store inactive employee data without any charge.


Name

Alphanumeric



REQUIRED


Middle Name

Alphanumeric



Not required


Surname

Alphanumeric



Not required


Alias

Alphanumeric



Nickname, not required


Mobile+62 number

REQUIRED


Either a mobile number or company email is required as primary identifier for system access and security purposes.  


 


If neither is provided upon creation of a new employee, ZipHR will create a temporary email for the employee until the employee's real email or mobile is entered.


Company Email

name@mail.com


Personal Info
GenderListMale, Female
Date of BirthYYYY/MM/DD 
Marital status (3)ListMarried, Single, Divorced
NationalityListFilipino, Indonesian, Malaysian, American ...
Personal Emailname@gmail.com 
Home Phone11 digits 
Tablet Check-In CodeInteger 
Address Line 1Text 
Address Line 2Text 
City/TownText 
State/ProvinceText 
Zip CodeInteger 
Identification documentListSupporting details for identification
Identification Number16 chars
Identification Issue DateYYYY/MM/DD
Identification Expiry DateYYYY/MM/DD
ReligionListFixed list, not customizable
- Islam
- Protestantism
- Catholicism
- Hinduism
- Buddhism
- Confucianism
- Other
Dependent full nameText

Dependent details of the employee. If none, leave it blank.


ID NumberText
RelationshipList
Birth PlaceText
Blood TypeText
Marital StatusList
Emergency Contact NameTextEmergency contact details of employee
Emergency Contact SurnameText
Emergency Contact RelationshipText
Emergency Contact Phone NumberText
NotesTextAny comment or feedback to the employee
Employment Info
Employment TypeList

Fixed list, not customizable
- Full Time
- Light Worker
- Non-permanent
- Part-Time

- Trainee
- Contractor


Office Phone+62 number 
PositionList

These items may be user-defined in >>My Teams >Team Organization


 


If the item has not already been created, the import will AUTOMATICALLY CREATE the item to your Team Organization settings.


DepartmentList
BranchList
GroupsList
SubsidiaryList
Cost CenterList
Hire DateYYYY/MM/DDCritical to calculate leave balances and payroll
Contract Expiry DateYYYY/MM/DDIf applicable
Probation Period (Days)IntegerSpecified policies are deactivated if in Probation Period
Notice Period (Days)IntegerIf applicable
Termination DateYYYY/MM/DD 
Leave Policy Start DateYYYY/MM/DDThe date upon which leave balances were migrated to ZipHR
Access
User RightsListUser Rights are customizable per each module's settings.

My Team



Active, Inactive



Active determines the module an employee can have access to. This also determines the number of active users the system should billed for each module.


 


If you enable all our core modules, then it should be marked as "Active" so they will be able to see their schedules and payslip in the app.


 


Inactive will restrict employees from having access to a certain module.


Calendar
Payroll
Performance
Expenses
Benefits
Invoices

Tasks


Recruitment
Attendance
Check-In RequiredCheckboxIs employee required to record attendance?
Activate Mobile Check-InCheckboxCan employee check-in via ZipHR mobile app?
Activate Remote Check-InCheckboxCan employee check-in from a remote location?
Enable Geo-TrackingCheckboxDo you track the employee's movements during the work day?
Geo-Tracking DistanceIntegerTrack employee every time they move more than X meters
Check-In Required For BreakCheckboxIs employee required to record break times?
Fixed Break TimeCheckboxIs the employee's break time flexible?
Tardy Grace OverrideTimeDoes the employee enjoy a greater tardy grace than others?
Activate Web BundyCheckboxDo you allow employee to check-in via the web app?
Follow Holiday RulesCheckboxAre Holiday Rules automatically applied?
Check-in Tardy Grace OnlyCheckbox

Tardy Grace only applied to check-in and NOT check-out
Event TemplateText

Customizable in Calendar > More Options > Settings > Event Templates


Ensure to input the exact Event Template name created in the app in this field.


Event Template Start DateYYYY/MM/DD 
Payroll
Basic WageDecimalCritical to calculate payroll
Wage PeriodListIs the Basic Wage a Monthly, Daily, or Hourly rate?
Minimum Wage EmployeeCheckboxIf Yes, Min Wage will auto-set as Basic Wage
Minimum Wage MultiplierPercent 
Wages Tax ExemptCheckboxIf employee is MWE, his Wages should be tax exempt
Work Days/WeekInteger (1-7) 
Expected Working Hours Per DayTime (0:00-24:00) 
Batch CycleListPayroll Batch in which you issue payroll 
Wage TypeListGross, Gross-up, or Nett wage payments
Monthly Wage BasisListAverage number of working days per month
Fixed Monthly DaysIntegerFixed number of working days per month (if not EEMR)
BPJS KesehatanCheckbox
Activate contributions


Jaminan Hari Tua (JHT)
Jaminan Pensiun (JP)
Jaminan Kecelakaan Kerja (JKK)
Jaminan Kematian (JKM)
Payment MethodListIs it Electronic, Cash, or Cheque?
Bank Account Holder NameText 
Bank Account NumberInteger 
Tax Start DateYYYY/MM/DDFirst day employed in the current year
Tax CodeText and numbersTax Code based on the type of work
Fixed Tax Rate0-100If the employee is taxed at a fixed rate
Tax Group (PTKP)TextTax group based on marital status and dependants
Bank NameText 
NPWPInteger (15 chars) 
Income Tax Type
List
- PPH 21
- PPH 21 non-NPWP
- PPH 26
BPJS Kesehatan & Labour NumberInteger 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article