[OneERA]

Indonesian 26 Million Data DB ?

Source:

PT. KIMIA FARMA, TBK ? https://www.kimiafarma.co.id/

PT. Kimia Farma Apotek ? https://kimiafarmaapotek.co.id/

Quantity: ?

26 million

Format: ?

.sql

.csv

Type: ?

### Employee Salary Information ?
1. **tbgaji**: 5,245,868 rows - Detailed records of employee salaries, allowances, subsidies, and deductions.
2. **histbgaji**: 1,825,112 rows - Employee salary information including basic salary, allowances, and overtime pay.
3. **transaksi_komponen**: 9,010,411 rows - Management of payroll distributions, tracking detailed information about deductions and amounts.
4. **tbgajiberkala**: 43,690 rows - Records details of each salary adjustment including amounts before and after, adjustment percentages, and effective dates.
5. **tbgajipegawai_backup**: 73,814 rows - Backup information of employee salaries and allowances.
6. **tbmutasigajipegawai**: 45,569 rows - Information on employee salary changes.
7. **tbgajiperiodik**: 5,399 rows - Detailed records of periodic salary adjustments.
8. **tbdatacutigaji**: 26,591 rows - Information on salary and allowance adjustments.
### Employee Personal Information ?‍?
1. **selftassesment**: 3,088,412 rows - Employee personal information including name, employee ID, department, position, attendance, and self-assessment.
2. **pegawai_sesudah**: 4,571 rows - Comprehensive personal information including unique identifier, position, birth date, and contact details.
3. **pegawai_sblm**: 4,070 rows - Similar to pegawai_sesudah, detailed employee personal information.
4. **mst_approved_table**: 21,154 rows - Records BPJS, Mandiri Inhealth, and Astek numbers.
### Attendance and Leave Information ?
1. **tb_hadir**: 395,284 rows - Daily attendance records including punch-in times, geographic locations, shifts, overtime, and irregularities.
2. **tb_hadir_plan**: 39,615 rows - Daily attendance plans including check-in/out times, late or early departures, and location data.
3. **tb_hadir_jawaban**: 4,643,087 rows - Employee responses to COVID-19 related visitor questionnaires.
4. **trx_leave_online**: 26,942 rows - Records of employee leave requests.
5. **tbdatacuti**: 3,890 rows - Detailed records of employee leave including application, approval, start/end dates, and remaining leave days.
### Contracts and Position Information ?
1. **tbkontrakpegawai**: 27,198 rows - Employee contract information including contract numbers, creation dates, work locations, and salary details.
2. **tblembarpengesahan**: 14,711 rows - Changes in employee positions and contracts.
3. **tbmutasipegawai**: 13,319 rows - Records of employee job transfers.
4. **tbpurnabhaktipeg**: 14,407 rows - Retirement and resignation information.
5. **tb_posisi**: 8,008 rows - Detailed information on organizational positions and units.
6. **tbdatanomordok_sk**: 54,412 rows - Records of position changes, status changes, long leaves, promotions, and transfers.
### Assets and Accounting Information ?
1. **invkendaraan_akuntansi**: 14,911 rows - Accounting information for company vehicles and other assets including acquisition dates, amounts, and depreciation.
2. **temp_datapenyusutanakuntansi_okt21**: 21,066 rows - Asset acquisition, depreciation, purchase/sale values, and adjustments.
3. **temp_datapenyusutanakuntansi**: 21,066 rows - Similar to temp_datapenyusutanakuntansi_okt21, records of vehicle asset depreciation and acquisition.
4. **tb_datapembukuanspkfa**: 4,413 rows - Financial bookkeeping information including dates, types, voucher numbers, account numbers, descriptions, income, and expenses.
### Health and Vaccination Information ?
1. **tb_vaksin**: 11,130 rows - Vaccination records including ID numbers, names, phone numbers, vaccination dates, times, statuses, and second dose information.
### Recruitment Information ?
1. **tbrekrutmen**: 4,481 rows - Detailed recruitment information including personal backgrounds, education, contact details, interview results, and recommendations.
2. **kirim_email**: 5,747 rows - Records of recruitment-related email sending statuses.
### Family and Emergency Contact Information ?‍?‍?‍?
1. **tb_tanggunganpegawai**: 9,633 rows - Employee family member and insurance information including insurance types, relationships, names, birth dates, and insurance numbers.
2. **tb_kontakdarurat**: 10,619 rows - Emergency contact information including relationships, names, and phone numbers.
### Education and Training Information ?
1. **tb_datapendidikan**: 19,948 rows - Education and professional information including school names, majors, graduation dates, and career-related university information.
2. **siswa**: 7,417 rows - Basic information of internal and external personnel including attendance records and organizational affiliations.
### Other Information ?
1. **tb_detail_visit**: 63,500 rows - Visit details including time, place, notes, and photos.
2. **oauth_access_token_backup**: Contains access tokens.
3. **tb_dapeniuranpegawai**: 2,194 rows - Salary and contribution information including payment dates, basic salaries, employee and company contributions.
4. **tb_export_basicpay**: 7,576 rows - Basic salary information including names, salary dates, grade groups, and salary amounts.
5. **tb_masoutlet**: 4,012 rows - Outlet information including names, addresses, cities, entities, descriptions, pharmacy grades, working hours, types, manager information, geographic coordinates, expected and actual sales, and time zones.
6. **tb_masvendor**: 9,230 rows - Basic vendor information including vendor codes and names.
7. **employee_flaging**: 13,747 rows - Employee flag information primarily for fixed deductions and pre-2013 hires.
8. **mutasi_event**: 12,508 rows - Employee transfer events including dates, reasons, and positions before and after transfers.

Example:

? https://anonymfile.com/r12W5/tb-datavaksin.csv

Price: ?

2600 USD

PM PM ✉️✉️ 

[andrewmacx]

Nice post, bro! Does this database come from both sources?

This forum account is currently banned. Ban Length: (Permanent)
Ban Reason: Leeching | http://breached26tezcofqla4adzyn22notfqw...an-Appeals if you feel this is incorrect.

[adelardsyah]

kimia farma? holy hell, again and again it seems

[Loki]

@OneERA PM me proof to verify the authenticity of the data. How is data related to kimiafarma?

[Voyager]

wow its a huge data bro, nice, indonesia everyday

This forum account is currently banned. Ban Length: (Permanent)
Ban Reason: Leeching | http://breached26tezcofqla4adzyn22notfqw...an-Appeals if you feel this is incorrect.