Interface data is a string with data that can be processed by the interface; Basic amount in Elvire (xxxxxx_BD) multiplied by 100. (to become the exact amount, devide this amount by 100). BETPER_END_DT The identifier of a payperiod is the the last day of the period AOV_NR_HRM Contract number in L4 (AOV_NR_HRM) JUR_NR Company number in L4 Action taken by the interface; U(pdate), N(ew) Result of action taken by the interface; E(rrors), O(k) Interface record type is an empty tag BIC code of an accountnumber BBAN code of an accountnumber IBAN code of an accountnumber UREN_WEEK number of hours in a week . Syntax : HHMM where the minutes are expressed in hundreds. Example : 38 hours 20 minutes =3833 BURG_ST_CD The civil state of the employee AFD Division of the company: Kwartaal onder de vorm YYYYQ ADV_REG_NR registration number of the work regulations. Must be mentioned on the declaration of the social security to obtain reduction in case of 'working time reduction' OMVANG_CD size of the company (possible values OMVA) JUR_NR Company number in L4 AOV_NR_HRM . ID of contract in HR system Instruction Number generated in front end application (PS). Is used for feedback. BETPER_END_DT A pay period is a period for which an employee receives a salary VBETPER_END_DT The starting period in the selection TBETPER_END_DT The end period in the selection C4-subdocuments to print. Possible values : 1=C4;2=Annex C4;3=C4+annex C4 + EmploymentCertificate;4=EmploymentCertificate The period for which the document should be produced. Should the salary be printed on the document ?Y/N The starting date of the period covered by a cancellation premium (start verbrekingsperiode) The end date of the period covered by a cancellation premium (einde verbrekingsperiode) AOV_BEG_DT; The date the employment contract started. AOV_END_DT The date the employment contract ended The date the employee has voluntary retired Description of the reason of unemployment The number of paid-days the employee has still right after finishing the contract or after finishing the period covered by the cancellation premium. The way the notice is done. Value A =onder registred CoverValue. D = By Process server (Summon) Date on which the letter under registred cover has been send or date on which .... OPZEG_VAN_DT The starting date of the period covered by the cancellation of the contract . OPZEG_END_DT The end date of the period covered by the cancellation of the contract The date to which the term of notice is extended. The reason why the term of notice is extended.1=Industrial Accident;2=Unemployment;3=Vacation;4=Other In case the term of Notice is extented for reason 4(=other), than the reason must be described by using this element. UREN_WEEK_VT Number of hours the employer has to work in a week Number of hours the worker(arbeider) has to work in a week (UREN_WEEK_VT) Number of hours the clerck (bediende) has to work in a week (UREN_WEEK_VT) Should only Staf information be printed on the C131-document? Y/N Date the disability started Possible values : Z= illness NZ = New Ilness O= Accident BR = Maternity Leave BZ = occupational disease AO = Industrial Accident VM = Paternity leave as replacement of maternity leave VV = Paternity Leave Registration of this element is required if disability type has a value VV or MB. Possible values if disability type = VV : V=paternity Leave A=adoption Leave Possible values if disability type = MB: V = full removal from work G : partial removal from work The subscription number the employee has with the Mutual Benefit Fund Is the disability Starting date the last workingday ? Is the new abscene caused bij the same disease ? (herval?) The initial date of the Industrial Accident(arbeidsongeval) Has the employee right to an enemployment allowance due to a waiting period ? Value 1= Information document for the Mutual Benefit Fund Value 2= vacation certificate (value 2 not allowed for GPI) Tye of C131 document : Possibele value C131A or C131B Indicates the type of the object whose number will be found in de reference(Possible values : PER, AOV,SCH) Reference in HR system, ex DebtID, ContractID,... 1=Error, 2=Warning, 3=Information For interfacing: indicates the module generating the message; could be WKA, BAS, LOO, SCH... For computationrun: indicates the module originating the message; could be VSP, TEL, B/N... To be determined by each module Description of the mistake in French Description of the mistake in Dutch Additional data to describe the message; for interfacing, can be the offending record Interface: interfacemessage and interfacelog Computationrun: computationfeedback and computationlog Simulation: combination of interface, computationrun, export Name of the inputfile (when relevant) Identification of the police zone. 5 digit number Code indicating if the file contains final (DRAFT) or intermediate (FINAL) wagecalculations. Code indicating if the employee is pre- ("A") or postpayed ("P") Code indicating if the wage element has been paid or has been included in a debt (that the employee has to pay back to the employer). 1=paid 2=included in debt Code indicating the type of run: Wages, Bonus, .... AFW_CD possible values : 10 (Monthly wages),11 (variable premium),8 (end-of-year bonus),9(vacation pay),13(Competantion premium) Identification of the wage calculation in the wage-calculation system Date of calculation for the wage-element MODULE_CD uit MBET. indicates the kind of payment. Possible values 1: Wages to the employee. 2:Child Allowance to the employee 3: Wages to the Creditor 4. Child Allowance to the Creditor 6. Ordonnancering Amount paid to employee or creditor (xxxxxx_BD) multiplied by 100. (to become the exact amount, devide this amount by 100). Proposed date for the payment of the wages MUNT. The currency in which the salary is calculated (EUR or BEF) Identification of the Creditor(Nr_HRM van de derde) REF_NR Identification number of the employee in the system (stamnummer-nummer or matricule) VNM First name of the employee NM Last name of the employee GEB_DT Birthdate of the person RIJKSREG_NR National social security number Debit amount. divide by 100 for the exact amount. Credit amount. divide by 100 for the exact amount. The amount in the accounting file that is unpaid divide by 100 for the exact amount The amount in the accounting file that is paid divide by 100 for the exact amount LEX_CD Salary code 4 digits numeric (see list) Base salary code for the wage element. Only for resultcodes like Tax, Social security, etc. This code allows us to split Tax on the input salarycodes. Type of salary for the presentation of the lists based on the Accounting file Analytical code for the wage element (for future use). Functional code for the wage element Economic code for the wage element Base economic code for the wage element. Code where the wage element was originally attibuted to. Accounting code attributed to the wage element Accounting code attributed to the wage element Identification which links to the debt. Name of the third party to which part of the salary must be paid. (Creditor) Name of the benificiary of the payment FRAC_END_DT The identifier of a fraction is the enddate of the fraction: TBOEK_CD Posting=2 or CounterPosting=1 DAGEN_AT Devide by 100 for exact value AFD Division in the company: BD Amount. Devide by 100 for exact amount. EENHEDEN_AT Quantity: devide by 100 for exact value. EENH_BD Devide by 100.000 for exact value. PT Devide by 100 for exact value. VERMIND_TELL Divide by 10.000 to obtain value. Diminuation of the wages due to absences. VERMIND_NOEM Divide by 10.000 to obtain value. BEGIN_DT EINDE_DT AT1 Divide by 100.000 to obtain value AT2 Divide by 100.000 to obtain value BD1 Divide by 100.000 to obtain value BD2 Divide by 100.000 to obtain value PAR1 PAR2 AFD Division in the company : AFD (in extension) TEKST WDP NR Identification number of a computation profile for reference from the wage elements TIMESTAMP Creation date and time of the file. RSZ_CAT_NR Official Category of an employee assigned by the Social Security (possible values : RCAT) VAKGELD_RGL_CD How does VacationPay be calculated ?. Private method(value1) or Government method(value2) BZBIJDR_CD . Defines the way the special contribution should be calculated. Possible values :1,2 or 4 BV_JAARLOON_CD (. Defines the way de exceptional tax should be calculated (possible values :BVJL) OVERHEID_CD : Indicates if the Company represents a Government Institution (Y) or a private company (N) JUR_VORM_CD : indicates the juridical form of the private company (possible values : JVRM) OMVANG_CD indicates the size of the company (possible values OMVA) GEM_OMVANG_CD : indicates the average size of the company . (possible values : GOMV ) FSO_CD : indicates which type of Social security contribution should be payed to the Closing CompanyFund . (Possible values : GFSO) SO_MA_CD : : Code indicates which type of Social Maribel is applicable to the company (possible values SMAR) GEZINSLAST_FL: indicates if the employee has family that is financial chargeable to him (for calculation of RZIV and RVP) BURGST_DT : The starting date of the the civil state of the employee valid in the pay period. BURG_HUW_DT : the date the employee has married MVAL_BV_CD : indicates if the employee is disabled (Y) or not (N) (for the tax calculation) EG_MVAL_CD : indicates if the spouse is disabled(Y) or not (N). (for the calculation of tax) VAL_K_TLST_AT : indicates the number of abled children that are financial chargeable to the employee (for tax calculation) MVAL_K_TLST_AT : indicates the number of disabled children that are financial chargeable to the employee (for tax calculation) MVAL_MEER65_AT : indicates the number of disabled persons older than 65 that are financial chargeable to the employee (for tax calculation) VAL_MEER65_AT : indicates the number of abled persons older than 65 that are financial chargeable to the employee (for tax calculation) VAL_A_TLST_AT : indicates the number of abled 'other' persons that are financial chargeable to the employee (for tax calculation) MVAL_AT_TLST_AT : indicates the number of 'other' persons that are financial chargeable to the employee (for tax calculation) BURGST_AW_CD : The civil state the employee is in at the moment of computation. (possible values : BURG) BURGST_BP_CD : the civil state the employee is in at the last day of the pay period (possible values : BURG) EG_BRP_BP_CD : profession of the spouse at the last day of the pay period. Used for the declaration of the social security (Possible values : BECH) EG_INK_CD : income code of the spouse of the employee (used for tax calculation) IN_JUR_DT : initial date the employee started to work in the company. SAMENTR_BN_NR : The number indicates the contracts that should be joined in the tax calculation SAMENTR_BN_FL : The flag indicates if contracts should be joined(Y) or not in the tax calculation(N). AANWERV_KDR_DT : indicicates the starting date the employee has been recruited in a specific framework. AANWERV_KDR_CD : Indicates the framework in which the employee has been recruited. This framework allows the company to receive a reduction in social security contribution. (Possible values : AWKA) WERKREG_CD : indicates the number of days the employee works in a week. (multiplied by 100). Example 250 = 2 and a half days /week BREUK_TEW_TELL : the number of hours the employee works in a week in comparison with a full time job . (multiplied by 1000). Example 39500 = 39,500 BREUK_TEW_NOEM : indicates the number of hours in a week an employee with a full time job works (multiplied by 1000). Example 39500 = 39,500 BREUK_TEW_TOEP : indicates if the employment fraction should be applied (Y) or not (N) when computing salary reduction MVAL_RSZ_CD : indicates of the employee is disabled (Y) or not(N) for the calculation of the social security contribution. TEW_AKK_CD :indicates if there is an employment agreement applicable to the workers in the company (Y) or not(N) BEDRPLAN_CD : indicates if there is a businessplan applicable to the workers in the company (Y) or not(N) AANSL_KWA_RSZ : indicates the quarter the company is subscribed at the Social Security. Syntax : YYYYQ PC_OFF_NR : number of the official PC applicable to the employees of the company (possible values :PCOM) TYPE_CTR1_CD : type of contract of the employee (possible values : TPC1) ONV_DLT_WN_CD : Type of unvoluntaruy Partial Employment contract (possible values : ONVD) PENS_ST_CD : Pension System applicable to the statutary employee working for the government.(possible values : PENS) SECTOR_CD : indicates the type of contract drawn between the employer and the employee. (Possible values : SECT) HERSTR_MOEI_CD : indicates if the company has the official status of a company in restructuring(1) or in difficulty(2). (Possible values : HRML) BRUGP_BCB_CD : Prepension code applicable to the employee in prepension.(possible values : BRPS) LL_CD : type of student (possible values : TPLL) FOOI_CD : type of worker paid byTips. Necessary for the calculation of the social security contribution. (possible values : TPFO) TYPE_WN_CD : type of employee (possible values TPWN) TYPE_WN2_CD : Type of employee (possible values : TPW2) STATUUT_CD : Statut of the employee . (Possible values : STAT) BET_FREQ_CD : The frequency by which the wages are paid (weekly,monthly,..) (Possible values : BFRQ) RSZ_VOORNR : The perfix of the social security number granted by the Social Security (possible values: VRSZ) AND_SOC_VRZ_CD : other social provisions applicable to the employee (possible values : ASOV) TYPE_WN_BV_CD : indicates the way the tax should be calculated for the employee. (Possible values : TPWB) TYPE_WN_BVA_CD : indicates the way the tax contribution should be declared for the employee. (Possible values : TPWA) ACTIV_PPO_CD : activity exercised by the employee and mentioned on the declaration of the Social Security Local Government. (possible values: ACPP) GPC_RSZ_NR: The grouping of the PC where to the employee belongs . FIRMAWAGEN_FL : Indicates if the employee is in possession of a company car (Y) or not (N). RSZ_RSZPPO_CD : Indicates if the company belongs to the private sector/federalGovernment (value 1) or to the Local Government (2). Important for the declaration of the Social Security. FAC_VOLGNR : unit of invoicing. The level the invoices are drawed up. FOOI_TYPE_CD : Type of tip mentioned on the tax declaration. (possible values : RTFO) GRENSARB_CD : indicates the country the employee (frontier worker) resides. (Possible values : GRNS) AB_BET_WGR_FL : indicates if the train/bus subscription is paid directly by the employer to the train or bus society.. PENS_KAS_NR : indicates if employer's contribution pension should be calculated and/or be paid to 'Pool der Parastatalen. Possibble values : 1= Pool der parastatalen (RSZ) 2= own employer's contribution (RSZPPO) MA_CD : Indicates if Maribel is applicable to the company(Y) or not (N) MA_HO_LA: Indicates if the high amount(1) or low amount(2) of Maribel is applicable to the company. ONR_DEELT_CD : indicates if the employee is partial or full employed and if this employment is regular or irregular.(possible values: RORD) UITDIENS_RD_CD : the reason of the ending of the employment. (Possible values : RUDC) VMY_CD (derived from POL_VOLGNR_GRP) : Insurance company where the company has took out of an insurance POLIS_NR (derived from POL_VOLGNR_GRP) Policy Number with the Insurance company RVP_FL In prepension before 31/12/1996(value 1) or after 31/12/1996( value 2)? KND_NT_GHWD_FL : indicates the child was begeted before the mother was married. RIZIV_FL. Illness and disablement insurance for retired employees. Value 1 : subjected to the insurance but with a limit , Value 2 : not subjected to the insurance Value 3 : Subjected to the insurance without a limit RIZIV_VRDL_CD indicates the advantage that will be paid to the retired employee (possible values RRIV) RIZIV_FREQ_CD . indicates how frequent the advantage will be paid (ones a year, two times a year,...) (possible values RRIF) SBO_CTR_CD : code of the jobagreement .( Possible values : RSBO) UREN_WEEK_PPO :Number of hours the employee of the local Government works in a week. Syntax : HHMM where the minutes are expressed in hundreds. Example : 38 hours 20 min = 3833 CPP_CD : Code to be mentioned on the Social Security Declaration of the Local government (before 2005) (possible values RCPP) META_FBZ_FL Only applicable to the metal Sector (possible values RAPF) BEZOLD_JR_COEF a percentage that indicates the number of days with salary proportionally to the effective number of days to work. Example : 260/248 = 1,0484 . The syntax in the XML is this result multiplied by 10000 (so 10484) MAATR_ARB_CD : measures taken to reorganise the working time. (possible values RDMA) ADV_REG_NR1 registration number of the works regulations. Must be mentioned on the declaration of the social security to obtain reduction in case of 'working time reduction'. ADV_REG_NR2registration number of the works regulations. Must be mentioned on the declaration of the social security to obtain reduction in case of 'working time reduction'. ADV_REG_NR3registration number of the works regulations. Must be mentioned on the declaration of the social security to obtain reduction in case of 'working time reduction'. ADV_REG_NR4registration number of the works regulations. Must be mentioned on the declaration of the social security to obtain reduction in case of 'working time reduction'. NOTIE_RSZ_CD necessary for the declaration of the social Security (possible values RSNO) BEREK_SAL_CD : the way the salary should be calculated (by Hours, by piece , fix monthwage,..) (Possible values : WBSA) LEERKR_BEZ_CD : Is the teacher paid for 10 or 12 months? ARB_ONG_GD: degree of disablement for the disabled employee who receives an insurance. Syntax : degree multplied bij 100. Example: a degree of 40,00 is reflected in this XSD as 4000 WLH_BEG_DT : Start date of the period covered by an unemployment contribution paid by the employer(government) for the statutary employee who was discharged. WLH_END_DT : End date of the period covered by an unemployment contribution paid by the employer(government) for the statutary employee who was discharged. ZIU_BEG_DT : Start date of the period covered by an Illness/disablement contribution paid by the employer(government) for the statutary employee who was discharged. ZIU_END_DT: end date of the period covered by an Illness/disablement contribution paid by the employer(government) for the statutary employee who was discharged. BEWIJS_KOST_FL : indicates if the employee proves his real cost on his personall tax declaration. K_SCH_AT number of children that are financial chargeable to the employee (for debt calculation) PPO_VOORNR : Type of LocalGovernment (possible values : P10,P20,P30 or P40) NACE_CD : the national activity code of the company. (possible values : NACE) FCTIE_RSZ_STS : Function Status to be mentioned on the Social Security declaration of the Local Government (possible values :SFPP) SBO_DT : The starting date of the jobagreement BEREK_VG_CD : The method the vacation pay should be calculated.(possible values : AVAK) BREUK_DMA_TELL : used for the declaration of DMFA BSF_CD : fuel type of the company car (possible values RBSF) PLAAT_NR : The number plate of the company car. Should be mentioned on the Social Security declaration. CO2 : CO2 emission of the company car. Necesarry to calculate the social security contribution. GBR_NR : The number of the company the employee is send out to by his employer. GBR_OMVANG_CD : size of the company the employee is send out to. AANWERV_VRM_DT prior to AANWERV_KDR_DT if registrated. MEER6M_ZIEK_DT : Date on which the employee is more than 6 month absent due to illness. GEMEENSCHAP_CD :The community the company is located , determines which laws are applicable to the company. GEWEST_CD . The region the company is located , determines which laws are applicable to the company.(value 1 : flemish,2=french,3=german) INSCH_END_DT : end date of the 'bringin workers' premium PPL_DETACH_NR : PPL_DETACH_CD To be mentioned on the declaration of the social security Local Government. Value 1 : Delegated to an other employer. Value 2:Delegated by an other employer AANW_WN_KDR_CD (possible values AWKA) . To be registered if the employer whishes to choose another social security reduction then reduction for restructuring.(employee reduction) AANW_WN_KDR_DT EERSTE_BEG_DT : Date first recruitment. Necessary for calculation Social Security for building sector. Account AFD Division of a contract Percentage the employee does scientific research during his work. SGR_SL Employees are set within groups in order to perform the computation NIVEAU_CD Level of the salary Code(Possible values : zie RTP_CD = RBNN) The year in which the financial expense is made (. Financieel dienstjaar: voor de boekhouding van LP) The year to which the wage costs are charged. (Jaar van aanwijzing: voor de boekhouding van LP) The year to which the income belongs, from a taxation point of view (Fiscaal jaar: voor de boekhouding van LP) The quarter to which the income belongs, from a social security point of view (Kwartaal voor RSZ (PPO)) AFD . only applicable on Federal Policy. Derived from 'division' in table GSTPAO2. Necessary to form the Base allocation of a wage element. (O12_SECTION) Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. This element iis deriverd from the New DOPA, wage element and status of an employee.Together with the OrdArtikel, it forms the BaseAllocation (O10_TAAL_CD)Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values : 1=F, 2=N (O04_EXPEN_TYPE) AARD_UITGAVE .Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values 02(=zonder visum rekenhof), 12(=?) (O05_CORRES)Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values : 06 = Federale Politie en geIntegreerde functionering, 18= ? (O09_BUDGET_CD) Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. 17 (=Police) 99 (=Out of Budget) (O11_BUDGET_TP)SOORT BUDGET Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values : 10 (samen met budget 17); 70 (=samen met Budget 99) (O13_TITEL) Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'.Possible values : 0(gebudgeteerde kredieten) ; 9(orderrekening) (O14_ART)L Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'.This element iis deriverd from the New DOPA, wage element and status of an employee.Together with the OrdSection, it forms the BaseAllocation (O02_CRED_TYPE) SOORT KREDIET Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values :1= Lopende kredieten; 3 = overgedragen kredieten (O03_TYPE) TYPE ORDONNANCERING Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values :0= niet patrimoniaal (O07_CTRL_EXPEN) CONTROLE VOORL UITGAVE Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Control of the temporary Expense Possible values: unkwon (O08_TRANSFER_NR) OVERSCHRIJVING_AT Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values : OP(operationeel); CS(CAlog statutair); CC(CAlog contractueel) Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values : STAT /CNTR (O15_PREST_CD) Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. Possible values : 0 (O17_VISUM_NR) Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. (O18_INVENT_CD) INVENTARIS_CD Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'.(patrimonial instructions) (O01_BUD_JAAR)Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'. (DRD_SOORT) Only applicable on Federal Police. Necessary to draw up the 'ordonnantie'.Possible values 'WN, 'SCH,'RSZ,'VAK,'BV','FOP' (FISC_KENGETAL). Necessary to draw up the fiscal declaration. Type of fiscal document (GSD_CD) (gemeenschappelijke sociale dienst). Necessary to calculate the contribution the employer has to pay to the Social Service (possible values : P = PPO, G= GPI, V= Vlaanderen) (HER_BEGIN_DT) The date the period of 'company in reorganisation' starts. Necessary if RestucturingDifficultyCode = 1 or 2 (HER_EINDE_DT) . The date the period of 'company in reorganisation' ends. Necessary if RestructuringDifficultyCode = 1 or 2 (HER_ERKEN_DT) The date the company is acknowledge as a company in restructuring or difficulty. Necessary if RestructuringDifficultyCode is 1 or 2. (HER_ONSLAG_DT) The date the employees are given redundancy notice(collectief ontslagdatum).