[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?

[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