{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Personalfragebogen","Assistent","Listen","Listen (englisch)","Logo","Verwaltung"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Personalfragebogen","index":0,"n_rows":355,"n_cols":41,"rows_kept":355,"cut":false,"hidden":false,"merged":[[351,19,351,35],[352,19,352,35],[354,19,356,35],[351,39,351,47],[352,39,352,47],[354,39,356,47],[351,3,351,7],[352,3,352,7],[354,3,356,7],[351,11,351,15],[352,11,352,15],[354,11,356,15],[342,19,342,35],[343,19,343,35],[345,19,347,35],[342,39,342,47],[343,39,343,47],[345,39,347,47],[342,3,342,7],[343,3,343,7],[345,3,347,7],[342,11,342,15],[343,11,343,15],[345,11,347,15],[330,3,330,23],[331,3,331,23],[333,3,335,23],[330,27,330,47],[331,27,331,47],[333,27,335,47],[312,39,312,47],[313,39,313,47],[315,39,317,47],[321,3,321,23],[322,3,322,23],[324,3,326,23],[321,27,321,47],[322,27,322,47],[324,27,326,47],[312,3,312,23],[313,3,313,23],[315,3,317,23],[312,27,312,35],[313,27,313,35],[315,27,317,35],[300,27,300,35],[301,27,301,35],[303,27,305,35],[300,39,300,47],[301,39,301,47],[303,39,305,47],[291,39,291,47],[292,39,292,47],[294,39,296,47],[291,27,291,35],[292,27,292,35],[294,27,296,35],[300,3,300,7],[301,3,301,7],[303,3,305,7],[300,11,300,15],[301,11,301,15],[303,11,305,15],[300,19,300,23],[291,19,291,23],[292,19,292,23],[294,19,296,23],[291,3,291,7],[292,3,292,7],[294,3,296,7],[291,11,291,15],[292,11,292,15],[294,11,296,15],[301,19,301,23],[303,19,305,23],[279,3,279,23],[280,3,280,23],[282,3,284,23],[279,27,279,47],[280,27,280,47],[282,27,284,47],[270,27,270,35],[271,27,271,35],[273,27,275,35],[270,39,270,47],[271,39,271,47],[273,39,275,47],[270,3,270,11],[271,3,271,11],[273,3,275,11],[270,15,270,23],[271,15,271,23],[273,15,275,23],[261,3,261,23],[262,3,262,23],[264,3,266,23],[261,27,261,47],[262,27,262,47],[264,27,266,47],[240,39,240,47],[241,39,241,47],[243,39,245,47],[249,3,249,23],[250,3,250,23],[252,3,254,23],[249,27,249,47],[250,27,250,47],[252,27,254,47],[240,3,240,23],[241,3,241,23],[243,3,245,23],[240,27,240,35],[241,27,241,35],[243,27,245,35],[228,3,228,23],[229,3,229,23],[231,3,233,23],[228,27,228,47],[229,27,229,47],[231,27,233,47],[219,3,219,23],[220,3,220,23],[222,3,224,23],[219,27,219,47],[220,27,220,47],[222,27,224,47],[192,3,194,3],[192,4,194,11],[192,15,194,15],[192,16,194,23],[192,27,194,27],[192,28,194,35],[207,3,207,23],[208,3,208,23],[210,3,212,23],[207,27,207,47],[208,27,208,47],[210,27,212,47],[198,3,198,23],[199,3,199,23],[201,3,203,23],[198,27,198,47],[199,27,199,47],[201,27,203,47],[176,27,176,47],[177,27,177,47],[179,27,181,47],[185,3,185,47],[186,3,186,47],[188,3,190,3],[188,4,190,11],[188,15,190,15],[188,16,190,23],[188,27,190,27],[176,3,176,11],[177,3,177,11],[179,3,181,11],[176,15,176,23],[177,15,177,23],[179,15,181,23],[188,28,190,35],[188,39,190,39],[188,40,190,47],[167,3,167,23],[168,3,168,23],[170,3,172,23],[167,27,167,47],[168,27,168,47],[170,27,172,47],[158,3,158,23],[159,3,159,23],[161,3,163,23],[158,27,158,47],[159,27,159,47],[161,27,163,47],[140,39,140,47],[141,39,141,47],[143,39,145,47],[149,3,149,23],[150,3,150,23],[152,3,154,23],[149,27,149,47],[150,27,150,47],[152,27,154,47],[140,3,140,23],[141,3,141,23],[143,3,145,23],[140,27,140,35],[141,27,141,35],[143,27,145,35],[122,27,122,47],[123,27,123,47],[125,27,127,47],[131,3,131,23],[132,3,132,23],[134,3,136,23],[131,27,131,47],[132,27,132,47],[134,27,136,47],[122,3,122,11],[123,3,123,11],[125,3,127,11],[122,15,122,23],[123,15,123,23],[125,15,127,23],[110,3,110,23],[111,3,111,23],[113,3,115,23],[110,27,110,47],[111,27,111,47],[113,27,115,47],[101,3,101,23],[102,3,102,23],[104,3,106,23],[101,27,101,47],[102,27,102,47],[104,27,106,47],[93,3,93,23],[95,3,97,23],[92,27,92,47],[93,27,93,47],[95,27,97,47],[83,3,83,23],[84,3,84,23],[86,3,88,23],[83,27,83,47],[84,27,84,47],[86,27,88,47],[74,3,74,23],[75,3,75,23],[77,3,79,23],[74,27,74,47],[75,27,75,47],[77,27,79,47],[66,3,66,19],[68,3,70,19],[92,3,92,23],[68,21,70,23],[68,27,70,29],[57,3,57,23],[59,3,61,23],[56,27,56,47],[57,27,57,47],[59,27,61,47],[65,3,65,19],[65,31,65,47],[66,31,66,47],[68,31,70,47],[56,3,56,23],[36,3,36,35],[38,3,40,35],[35,39,35,47],[36,39,36,47],[38,39,40,47],[47,3,47,23],[65,21,65,23],[66,21,66,23],[17,3,17,23],[18,3,18,23],[20,3,22,23],[24,3,26,23],[28,3,30,23],[35,3,35,35],[48,3,48,23],[50,3,52,23],[47,27,47,47],[48,27,48,47],[50,27,52,47],[65,27,65,29],[66,27,66,29]]}
[]
[]
[null,null,null,"Personalfragebogen"]
[]
[null,null,null,"Dieser Personalfragebogen dient zur Vorerfassung von Personaldaten für das DATEV-"]
[null,null,null,"Lohnabrechnungsprogramm. Zur Wahrung der Aufbewahrungsfrist wird der ausgefüllte"]
[null,null,null,"Personalfragebogen von dem Arbeitgeber / der lohnabrechnenden Stelle gespeichert."]
[]
[null,null,null,"Die mit diesem Balken gekennzeichneten Felder sind"]
[null,null,null,"vom Arbeitgeber auszufüllen"]
[]
[null,null,null,"Die rot umrahmten Felder sind für das Erzeugen einer Exportdatei zwingend erforderlich"]
[]
[]
[]
[]
[]
[null,null,null,"Firma"]
[]
[]
[null,null,null,""]
[]
[]
[]
[null,null,null,""]
[]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[]
[null,null,null,"Name des Mitarbeiters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personalnummer"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Persönliche Angaben"]
[]
[]
[null,null,null,"Familienname",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorname"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Geburtsname",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geburtsdatum (TT.MM.JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Straße",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hausnr.",null,null,null,null,null,"PLZ",null,null,null,"Ort"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Anschriftenzusatz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versicherungsnummer gem. Sozialvers.-Ausweis"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Geburtsort (nur bei fehlender Versicherungs-Nr.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geburtsland (nur bei fehlender Versicherungs-Nr.)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Geschlecht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staatsangehörigkeit"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Schwerbehindert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arbeitnehmernummer Sozialkasse - Bau"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIC"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Beschäftigung"]
[]
[]
[null,null,null,"Eintrittsdatum (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,"Ersteintrittsdatum (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,"Beschäftigungsbetrieb"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Berufsbezeichnung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgeübte Tätigkeit (Kennziffer gem. BA oder Bezeichnung)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Art der Beschäftigung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probezeit",null,null,null,null,null,null,null,null,null,null,null,"Dauer der Probezeit"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Üben Sie weitere Beschäftigungen aus?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handelt es sich hierbei um eine geringfügige Beschäftigung?"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Höchster Schulabschluss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Höchste Berufsausbildung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Beginn der Ausbildung (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voraussichtliches Ende der Ausbildung (TT.MM.JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Wöchentliche Arbeitszeit",null,null,null,null,null,null,null,null,null,null,null,"Urlaubsanspruch (Kalenderjahr)",null,null,null,null,null,null,null,null,null,null,null,"Vertragsform"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Ggf. Verteilung der wöchentlichen Arbeitszeit (Std.)"]
[]
[]
[null,null,null,"Mo","",null,null,null,null,null,null,null,null,null,null,"Di","",null,null,null,null,null,null,null,null,null,null,"Mi","",null,null,null,null,null,null,null,null,null,null,"Do",""]
[]
[]
[]
[null,null,null,"Fr","",null,null,null,null,null,null,null,null,null,null,"Sa","",null,null,null,null,null,null,null,null,null,null,"So",""]
[]
[]
[]
[]
[]
[null,null,null,"Kostenstelle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abteilungsnummer"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Im Baugewerbe beschäftigt seit (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personengruppe"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Befristung"]
[]
[]
[null,null,null,"Art der Befristung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Befristung Arbeitsvertrag zum (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abschluss Arbeitsvertrag am (TT.MM.JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Steuer"]
[]
[]
[null,null,null,"Identifikationsnummer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steuerklasse",null,null,null,null,null,null,null,null,null,null,null,"Faktor"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Kinderfreibetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Konfession"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Sozialversicherung"]
[]
[]
[null,null,null,"Gesetzl. Krankenkasse (bei PKV: letzte ges. Krankenkasse)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elterneigenschaft"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"KV",null,null,null,null,null,null,null,null,null,null,null,"RV",null,null,null,null,null,null,null,null,null,null,null,"AV",null,null,null,null,null,null,null,null,null,null,null,"PV"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"UV-Gefahrtarif",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEÜV-Status"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Entlohnung"]
[]
[]
[null,null,null,"Bezeichnung",null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)",null,null,null,null,null,null,null,"Stundenlohn",null,null,null,null,null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Bezeichnung",null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)",null,null,null,null,null,null,null,"Stundenlohn",null,null,null,null,null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"VWL - nur notwendig, wenn Vertrag vorliegt"]
[]
[]
[null,null,null,"Empfänger VWL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,null,null,null,null,"AG-Anteil (Höhe monatlich)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"seit wann (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vertragsnummer"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIC"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Angaben zu steuerpflichtigen Vorbeschäftigungszeiten im laufenden Kalenderjahr"]
[]
[]
[null,null,null,"von (TT.MM.JJJJ)",null,null,null,null,null,null,null,"bis (TT.MM.JJJJ)",null,null,null,null,null,null,null,"Art der Beschäftigung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl der Beschäftigungstage"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"von (TT.MM.JJJJ)",null,null,null,null,null,null,null,"bis (TT.MM.JJJJ)",null,null,null,null,null,null,null,"Art der Beschäftigung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl der Beschäftigungstage"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Assistent","index":1,"n_rows":96,"n_cols":9,"rows_kept":96,"cut":false,"hidden":true,"merged":[]}
["Firma","Company name",null,null,"D21;D25;D29",null,";;"]
["Name des Mitarbeiters, Personalnummer","Employee name, Personnel number",null,null,"D39;AN39",null,";"]
["Familienname","Surname",null,null,"D51",null,""]
["Vorname","Given name",null,null,"AB51",null,""]
["Geburtsname","Maiden name",null,null,"D60",null,""]
["Geburtsdatum (TT.MM.JJJJ)","Date of birth (DD.MM.YYYY)",null,null,"AB60",null,""]
["Straße, Hausnr.","Street, House No.",null,null,"D69;V69",null,";"]
["PLZ, Ort","Postcode, City",null,null,"AB69;AF69",null,";"]
["Anschriftenzusatz","Additional information",null,null,"D78",null,""]
["Versicherungsnummer gem. Sozialvers.-Ausweis","Insurance number (as per social insurance card)",null,null,"AB78",null,""]
["Geburtsort (nur bei fehlender Versicherungs-Nr.)","Place of birth (only if without insurance number)",null,null,"D87",null,""]
["Geburtsland (nur bei fehlender Versicherungs-Nr.)","Country of birth (only if without insurance number)",null,null,"AB87",null,""]
["Geschlecht","Gender","False","True","D96",null,null,null,"cbx_Geschlecht"]
["Staatsangehörigkeit","Nationality",null,null,"AB96",null,""]
["Schwerbehindert","Severely disabled","True","True","D105",null,null,null,"cbx_Schwerbehindert"]
["Arbeitnehmernummer Sozialkasse - Bau","Employee number, pension fund - construction",null,null,"AB105",null,""]
[]
[]
["IBAN","IBAN",null,null,"D114",null,""]
["BIC","BIC",null,null,"AB114",null,""]
[]
["Eintrittsdatum Ersteintrittsdatum","Date employment contract begins First day",null,null,"D126;P126",null,";"]
["Beschäftigungsbetrieb","Place of employment","True",null,"AB126",null,""]
["Berufsbezeichnung","Description of profession",null,null,"D135",null,""]
["Ausgeübte Tätigkeit (Kennziffer gem. BA oder Bezeichnung)","Job performed","True",null,"AB135",null,""]
["Art der Beschäftigung","Type of employment","False","True","D144",null,null,null,"cbx_Art_der_Beschaeftigung"]
["Probezeit","Probation period","True","True","AB144;AN144",null,null,null,"cbx_Probezeit"]
["Üben Sie weitere Beschäftigungen aus?","Do you carry out any other jobs?","False","True","D153",null,null,null,"cbx_Nebenbeschaeftigung"]
["Handelt es sich hierbei um eine geringfügige Beschäftigung?","Does this concern a low income employment?","False","True","AB153",null,null,null,"cbx_Geringfuegig"]
["Höchster Schulabschluss","Highest level of education","False","True","D162",null,null,null,"cbx_Schulabschluss"]
["Höchste Berufsausbildung","Highest level of professional training","False","True","AB162",null,null,null,"cbx_Berufsausbildung"]
["Beginn der Ausbildung (TT.MM.JJJJ)","Date apprenticeship begins (DD.MM.YYYY)",null,null,"D171",null,""]
["Voraussichtliches Ende der Ausbildung (TT.MM.JJJJ)","Planned date apprenticeship ends (DD.MM.YYYY)",null,null,"AB171",null,""]
["Wöchentliche Arbeitszeit Urlaubsanspruch","Weekly working hours Holiday entitlement",null,null,"D180;P180",null,";"]
["Vertragsform","Type of contract","True","True","AB180",null,null,null,"cbx_Vertragsform"]
["Wöchentliche Arbeitszeit","Weekly working hours",null,null,"E189;Q189;AC189;AO189;E193;Q193;AC193",null,";;;;;;"]
["Kostenstelle","Cost centre","True",null,"D202",null,""]
["Abteilungsnummer","Department number","True",null,"AB202",null,""]
["Im Baugewerbe beschäftigt seit (TT.MM.JJJJ)","Employed in construction industry since (DD.MM.YYYY)",null,null,"D211",null,""]
["Personengruppe","Person group","True","True","AB211",null,null,null,"cbx_Personengruppe"]
[]
["Art der Befristung","Type of fixed-term contract","True","True","D223",null,null,null,"cbx_Art_der_Befristung"]
[" "," ","True","True","AB223",null,";"]
["Befristung Arbeitsvertrag zum (TT.MM.JJJJ)","Employment contract fixed until (DD.MM.YYYY)","True",null,"D232",null,""]
["Abschluss Arbeitsvertrag am (TT.MM.JJJJ)","Employment contract concluded on (DD.MM.YYYY)","True",null,"AB232",null,""]
[]
[]
["Identifikationsnummer","Identification No.",null,null,"D244",null,""]
["Steuerklasse, Faktor","Tax class, Factor",null,null,"AB244;AN244",null,";"]
["Kinderfreibetrag","Number of exemptions for children",null,null,"D253",null,""]
["Konfession","(Religious) Denomination","False","True","AB253",null,null,null,"cbx_Konfession"]
[]
[]
["Gesetzl. Krankenkasse (bei PKV: letzte ges. Krankenkasse)","Statutory health insurance (HI) (in case of private HI: last statutory HI)",null,null,"D265",null,""]
[]
["Elterneigenschaft","Parenthood","False","True","AB265",null,null,null,"cbx_Elterneigenschaft"]
["KV RV","Health insureance Pension insurance","True","True","D274;P274",null,";",null,"cbx_KV;cbx_RV"]
["AV PV","Retirement insurance Provision insurance","True","True","AB274;AN274",null,";",null,"cbx_AV;cbx_PV"]
["UV-Gefahrtarif","Accident insurance risk tariff","True",null,"D283",null,""]
[]
[]
[]
["Entlohnung","Remuneration",null,null,"D295;L295;T295;AB295;AN295",null,";;;;"]
["Entlohnung 2","Remuneration 2",null,null,"D304;L304;T304;AB304;AN304",null,";;;;"]
[]
[]
[]
[]
[]
[]
["Empfänger VWL","Recipient",null,null,"D316",null,""]
["Betrag, AG-Anteil","Amount Employer share",null,null,"AB316;AN316",null,";"]
["seit wann (TT.MM.JJJJ)","since (DD.MM.YYYY)",null,null,"D325",null,""]
["Vertragsnummer","Contract number",null,null,"AB325",null,""]
[]
[]
["IBAN","IBAN",null,null,"D334",null,""]
["BIC","BIC",null,null,"AB334",null,""]
["Angaben zu steuerpflichtigen Vorbeschäftigungszeiten","Information of taxable previous employment periods",null,null,"D346;L346;T346;AN346",null,";;;"]
["Angaben zu steuerpflichtigen Vorbeschäftigungszeiten 2","Information of taxable previous employment periods 2",null,null,"D355;L355;T355;AN355",null,";;;"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DEÜV-Status","DEÜV-status","True","True","AB283",null,null,null,"cbx_DEUEV"]

{"sheet":"Listen","index":2,"n_rows":24,"n_cols":31,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Arbeitsvertrag","Arbeitsvertrag","Ausbildungsvertrag"]
["Bescheinigung über LSt.-Abzug","Bescheinigung über LSt.-Abzug/Anzahl der Beschäftigungstage bei Vorarbeitgebern","Bescheinigung über LSt.-Abzug","männlich","ledig","ja","ja","Hauptbeschäftigung","ja","ja","ja","1 - Ohne Schulabschluss","1 - Ohne beruflichen Ausbildungsabschluss","1 - Unbefristet in Vollzeit","101 - Sozialversicherungspflichtig Beschäftigte","Arbeitnehmer/in","Befristet","Konfessionslos",0.02,"ja","ja","0 - Kein Beitrag","0 - Kein Beitrag","0 - Kein Beitrag zur BA","0 - Kein Beitrag zur gesetzlichen PV","Verzicht auf die RV-Option","Gesetzlich","geringfügig entlohnt","ja","ja","0 - keine Angabe"]
["SV-Ausweis","SV-Ausweis","SV-Ausweis","weiblich","verheiratet","nein","nein","Nebenbeschäftigung","nein","nein","nein","2 - Haupt-/Volksschulabschluss","2 - Abschluss einer anerkannten Berufsausbildung","2 - Unbefristet in Teilzeit","102 - Auszubildende ohne besondere Merkmale","Arbeitnehmer/in in Elternzeit","Unbefristet","rk - Römisch-Katholische Kirchensteuer",0.2,"nein","nein","1 - Allgemeiner Beitrag","1 - Beitrag zur Rentenversicherung","1 - Voller Beitrag zur BA","1 - Voller Beitrag zur gesetzlichen PV","Ausübung der RV-Option (Verzicht auf RV-Freiheit)","Privat","nicht geringfügig entlohnt","nein","nein","1 - Ehegatte/Lebenspartner/Abkömmling"]
["Mitgliedsbescheinigung Krankenkasse","Antrag zur Befreiung von der RV-Pflicht","Mitgliedsbescheinigung Krankenkasse",null,"geschieden",null,null,null,null,null,null,"3 - Mittlere Reife oder gleichwertiger Abschluss","3 - Meister-/Techniker- oder gleichwertiger Fachschulabschluss","3 - Befristet in Vollzeit","103 - Beschäftigte in Altersteilzeit","Arbeitslose/r","Zweckbefristet","ev - Evangelische Kirchensteuer",null,null,null,"3 - Ermäßigter Beitrag","3 - 1/2 Beitrag zur Rentenversicherung","2 - Halber Beitrag zur BA","2 - Halber Beitrag zur gesetzlichen PV",null,null,"kurzfristig beschäftigt",null,null,"2 - geschäftsführender Gesellschafter (GmbH)"]
["Bescheinigung der privaten Krankenversicherung","Bescheinigung der privaten Krankenversicherung","VWL-Vertrag",null,"verwitwet",null,null,null,null,null,null,"4 - Abitur/Fachabitur","4 - Bachelor","4 - Befristet in Teilzeit","104 - Hausgewerbetreibende","Beamtin/Beamter",null,"lt - Evangelisch lutherisch",null,null,null,"4 - Beitrag zur landwirtschaftlichen KV","5 - Geringfügig entlohnt"]
["VWL-Vertrag","VWL-Vertrag","Nachweis Elterneigenschaft",null,"dauernd getrennt",null,null,null,null,null,null,"9 - Abschluss unbekannt","5 - Diplom/Magister/Master/Staatsexamen",null,"105 - Praktikanten","Hausfrau/Hausmann",null,"rf - Evangelisch reformiert",null,null,null,"5 - Arbeitgeberbeitrag zur landwirtschaftlichen KV"]
["Nachweis Elterneigenschaft","Schul-/Studienbescheinigung","Vertrag Betriebliche Altersversorgung",null,null,null,null,null,null,null,null,null,"6 - Promotion",null,"106 - Werkstudenten","Schüler/in",null,"ak - Altkatholische Kirchensteuer",null,null,null,"6 - Pauschalbetrag für geringfügig Beschäftigte"]
["Vertrag Betriebliche Altersversorgung","Schwerbehindertenausweis","Schwerbehindertenausweis",null,null,null,null,null,null,null,null,null,"9 - Abschluss unbekannt",null,"107 - Behinderte Menschen in anerkannten Werkstätten oder gleichartigen Einrichtungen","Schulentlassene/r",null,"is - Israelitische / Jüdische Kultussteuer",null,null,null,"9 - Freiwillige KV, Firmenzahler"]
["Schwerbehindertenausweis","Unterlagen Sozialkasse Bau/Maler","Unterlagen Sozialkasse Bau/Maler",null,null,null,null,null,null,null,null,null,null,null,"108 - Bezieher von Vorruhestandsgeld","Selbstständige/r",null,"fb - Freireligiöse Landesgemeinde Baden"]
["Unterlagen Sozialkasse Bau/Maler",null,null,null,null,null,null,null,null,null,null,null,null,null,"109 - Geringfügig entlohnte Beschäftigte","Student/in",null,"ib - Israelitische Religionsgemeinschaft Baden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"110 - Kurzfristig Beschäftigte","Sozialhilfeempfänger/in",null,"fo - Freireligiöse Gemeinde Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"111 - Personen in berufsfördernden Maßnahmen zur Rehabilitation","Studienbewerber/in",null,"fp - Freireligiöse Landesgemeinde Pfalz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"112 - Mitarbeitende Familienangehörige in der Landwirtschaft","Wehr-/Zivildienstleistender",null,"fm - Freireligiöse Gemeinde Mainz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"113 - Nebenerwerbslandwirte",null,null,"jü - Jüdisch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"114 - Nebenerwerbslandwirte - saisonal beschäftigt",null,null,"iw - Israelitische Religionsgemeinschaft Württembergs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116 - Ausgleichsgeldempfänger nach dem FELEG",null,null,"if - Israelitische Kultussteuer Frankfurt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"118 - Unständig Beschäftigte",null,null,"il - Israelitische Kultussteuer Land"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"119 - Versicherungsfreie Altersvollrentner und Versorgungsbezieher wegen Alters",null,null,"fr - Französisch reformiert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"190 - Beschäftigte, die nur in der gesetzlichen Unfallversicherung versichert sind",null,null,"fa - Freie Religionsgemeinschaft Alzey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"900 - Nicht meldepflichtig Beschäftigte",null,null,"fg - Freireligiöse Landesgemeinde Pfalz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs - Freireligiöse Gemeinde Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ih - Jüdische Kultussteuer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jd - Jüdische Kultussteuer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jh - Jüdische Kultussteuer"]

{"sheet":"Listen (englisch)","index":3,"n_rows":24,"n_cols":31,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Employment contract","Employment contract","Apprenticeship contract"]
["Income tax card/written confirmation of income tax","Income tax card/number of days employed at previous employers","Income tax card/written confirmation of income tax","male","unwed","yes","yes","Regular employment","yes","yes","yes","1 - No school leaving certificate","1 - No vocational training","1 - Permanent full-time contract","101 - Employees subject to social insurance contributions","Employee","Fixed-term","Non-denominational",0.02,"yes","yes","0 - Private health insurance","0 - No contribution","0 - No contribution to occupational pension","0 - No contribution to statutory nursing care insurance","Refuse pension insurance option","State","Mini job","yes","yes","0 - no specification"]
["Social insurance ID","Social insurance ID","Social insurance ID","female","married","no","no","Additional employment","no","no","no","2 - Haupt-/Volksschulabschluss (completion of secondary education)","2 - Officially recognised vocational training","2 - Permanent part-time contract","102 - Apprentices with no special attributes","Employee on parental leave","Permanent","rk - Roman-catholic church tax",0.2,"no","no","1 - General contribution","1 - Pension insurance contribution","1 - Full contribution to occupational pension","1 - Full contribution to statutory nursing care insurance","Excercise pension insurance option (waive pension insurance exemption)","Private","Non-mini job employment","no","no","1 - spouse/cohabitant/descendant"]
["State insurance membership certificate","Application for exemption of pension insurance","State insurance membership certificate",null,"divorced",null,null,null,null,null,null,"3 - School leaving certificate or equivalent","3 - Master craftsman/technican/similar degree","3 - Fixed-term full-time contract","103 - Employees in partial retirement","Unemployed","Fixed-term ending on completion of assignment","ev - Protestant church tax",null,null,null,"3 - Reduced contribution","3 - 1/2 pension insurance contribution","2 - 1/2 contribution to occupational pension","2 - 1/2 contribution to statutory nursing care insurance",null,null,"Short-term employment",null,null,"2 - managing partner (GmbH)"]
["Certificate of private health insurance","Certificate of private health insurance","Capital-forming benefits (VWL) contract",null,"widowed",null,null,null,null,null,null,"4 - Abitur/Fachabitur (equivalent of A levels in UK)","4 - Bachelor's degree","4 - Fixed-term part-time contract","104 - Self-employed persons","Civil servant",null,"lt - Protestant Lutheran",null,null,null,"4 - Contribution to agricultural sickness fund","5 - Low income"]
["Capital-forming benefits (VWL) contract","Capital-forming benefits (VWL) contract","Proof of parenthood",null,"permanently separated",null,null,null,null,null,null,"9 - Unknown","5 - Diploma/graduate degree/master's degree/state examination certificate",null,"105 - Interns","Housewife/house husband",null,"rf - Protestant reformed",null,null,null,"5 - Employer contribution to agricultural sickness fund"]
["Proof of parenthood","School/university certificate","Company retirement provision contract",null,null,null,null,null,null,null,null,null,"6 - PhD",null,"106 - Student trainees","School pupil",null,"ak - Old Catholic church tax",null,null,null,"6 - Flat-rate contribution for low-wage employees"]
["Company retirement provision contract","Severely disabled ID","Severely disabled ID",null,null,null,null,null,null,null,null,null,"9 - Unknown",null,"107 - Handicapped people in accredited sheltered workshops or similar facilities","Unqualified",null,"is - Israelite / Jewish “Kultussteuer” (community tax)",null,null,null,"9 - Paid by company"]
["Severely disabled ID","Pension fund documents construction/painting","Pension fund documents construction/painting",null,null,null,null,null,null,null,null,null,null,null,"108 - Early retirement pensioners","Self-employed",null,"fb - Non-denominational state parish Baden"]
["Pension fund documents construction/painting",null,null,null,null,null,null,null,null,null,null,null,null,null,"109 - Low income employees","Student",null,"ib - Israelite religious parish Baden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"110 - Short-term employees","Social welfare recipient",null,"fo - Non-denominational parish Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"111 - Persons participating in job-supporting measures for rehabilitation","University applicant",null,"fp - Non-denominational state parish Palatinate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"112 - Family members working in farming","Military/social service",null,"fm - Non-denominational parish Mainz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"113 - Part-time farmers ",null,null,"jü - Jewish"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"114 - Part-time farmers – working seasonally",null,null,"iw - Israelite religious parish Württemberg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116 - Persons receiving compensation money according to FELEG (Law encouraging the cessation of farm work)",null,null,"if - Israelite “Kultussteuer” (community tax) Frankfurt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"118 - Short-term contract workers",null,null,"il - Israelite “Kultussteuer” (community tax) State"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"119 - Full pensioners exempted from insurance and persons qualifying for pension related benefits due to age",null,null,"fr - French reformed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"190 - Employees only insured with statutory accident insurance",null,null,"fa - Non-denominational parish Alzey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"900 - Employees not subject to registration",null,null,"fg - Non-denominational state parish Palatinate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs - Non-denominational parish Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ih - Jewish “Kultussteuer” (community tax)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jd - Jewish “Kultussteuer” (community tax)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jh - Jewish “Kultussteuer” (community tax)"]

{"sheet":"Logo","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Verwaltung","index":5,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Gewählter Fragebogen","Neue MA"]
["Sprache PFB","Deutsch"]
["Eigenes Logo","X"]
[]
["Initialisierung durchgeführt","X"]
["Fragebogen erzeugt","X"]
["Fragebogen geändert"]
["Beraternummer"]
["Mandantennummer"]
[]
["Allgemein"]
["Persönliche Angaben",44]
["Beschäftigung",119]
["Befristung",216]
["Steuer",237]
["Sozialversicherung",258]
["Entlohnung",288]
[]
["VWL",309]
["Vorbeschäftigungszeiten",339]
[]
[]
["Bea"]
["Angaben zu den Arbeitspapieren"]
["Arbeitnehmererklärung"]