P2RB_SV

Social Insurance payroll Belgium | #transactional | Component: Belgium
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
BEGWU Unemployment payment
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
ARBER Expiration Date of Work Permit
BEANC Seniority
REDST Start Date for Employer’s Deduction (00090)
OREDD Start Date Reduction Replaced Worker
ALLST Allowance Start Date
EERST Start Date for Employee’s Restructuration Reduction
RDCST First Hiring Date (00896)
NMEDT New Maribel Employment Date (01148)
ILLDT Six Month Illness Date (00728)
SEXSD Service Exemption Start Date (01191)
DENOD Definitive Nomination Date (01092)
Column Name Description
TEILK Indicator Part-Time Employee Show values
DYSCH Create Daily Work Schedule Dynamically Show values
BEGFB Early Retirement with Fixed Compensation Show values
BEGGH Entitled Family Member Show values
RSZLM Wage Reduction Show values
BVEKI Partner's Income Show values
FIXVA Workdays System Show values
REMES Reorganization Measure (00051) Show values
EMPLP Employment Promotion Measure (00052) Show values
APTYP Apprenticeship Type (00055) Show values
RETIR Retired (00054) Show values
MODRM Remuneration Method (00056) Show values
CORIG Place of Issue of Certificate (00094) Show values
BVCOA Legal Cohabitation Show values
MARBR DmfA: Social Maribel (00794) Show values
REMTY Reorganization Measure Type Show values
CAPEX Capelo Eligibility (01012) Show values
DISPD Dismissal Period Show values
CFWPT Counter Former Work Placement Trainee Show values
STYPE Contribution Type (00083) Show values
TMPFT Temporary Full-Time Contract Show values
PSPCC PSP Contribution Calculation Basis Derogation (01176) Show values
SEREX Work Exemption (00826) Show values
CARME Career Measure (01194) Show values
TRASI Training Situation (01193) Show values
SUPCE Exemption/Supplementary Pension Scheme (01013) Show values
FLYCL Flying Staff Class (00059) Show values
PSTWO Posted Worker (00893) Show values
ESWDS Exceptional Working Days System (00393) Show values
ESMWH Exceptional Mean Working Hours (00554) Show values
REAME Regional Aid Measure (01237) Show values
CAPFO Force Capelo data Show values
Column Name Description Domain name
CNTR1 National assignment indicator RAW1
CNTR2 National assignment indicator RAW1
ANSTA Employment status NUM1
JUPER Legal Person JUPER
PERID Personnel ID Number CHAR20
ENTKM Distance in Kilometers DEC3
WKWNG Company Housing CHAR1
EMPCT Employment percentage BSGRD
WOSTD Hours per week STDAZ
MOSTD Monthly hours STDAZ
ARBST Daily Working Hours STDAZ
BSGRD Capacity Utilization Level BSGRD
BEAAN Contract time amount DEC3
BETIM Contract period CHAR3
BEUWG Contractual Mean Working Hours per week DEC3_2
BECNR Contract Number CHAR15
BEMCH Meal voucher CHAR1
BREGM Regulation contract months per year CHAR2
RSZPN Pension Number CHAR10
RSZRR INSS - National ID Number (00024)
RSZVW Personnel Number PERNR
RSZFS Factory Shutdown Fund P12_RSZFS
BVETL Conversion flag CHAR001
PPAID Percentage of Remuneration on a Yearly Basis DEC3_2
BEUW2 Mean Number of Hours per Week DEC3_2
OSSIN Social Security Number of Replaced Worker （00092） PERNR
ASSIN Social Security ID Number of Applicant (00093) PERNR
RFSCH Reference Person's Work Schedule SCHKN
LOCUN Local Unit ID (00042) NUM10
RSKAC Activity With Risk (00041) P12_ACTCODE
ALLCD Allowance Code RSZWG
NACEC Employee Activity Code (NACE) (00228) P12P_ONSSAPLCODE76
OLDRR Old National ID Number
DISHW Historical Dismissal Weeks DEC3_2
RCAIN Reason for Career Interruption P12_RCAIN
PERSM Percentage Social Maribel DEC3_2
SECDT Sector Detail (01215) P12_SECDT
RSZLA Official Language SPRAS
Master Data Relations | to Other Relations ↓ Join Conditions
Collective Agreement
  • Collective Agreement
  • Start Date
  • Client
  • P2RB_SV.BECAO == T5B6B.BECAO
  • P2RB_SV.BEGDA == T5B6B.ENDDA
  • P2RB_SV.MANDT == T5B6B.MANDT
Joint Commission (00046)
  • P2RB_SV.MANDT == T5B6C.MANDT
  • P2RB_SV.BEGPC == T5B6C.BEGPC
Employment Percentage
  • Employment Percentage
  • Client
  • P2RB_SV.BEREG == T5B73.BEREG
  • P2RB_SV.MANDT == T5B73.MANDT
Weekly Workdays Schedule
  • P2RB_SV.MANDT == T5B72.MANDT
  • P2RB_SV.BERGM == T5B72.BERGM
Frequency of payment
  • P2RB_SV.MANDT == T5B71.MANDT
  • P2RB_SV.BESTE == T5B71.BESTE
Company Code
  • P2RB_SV.MANDT == T001.MANDT
  • P2RB_SV.BUKRS == T001.BUKRS
Marital Status
  • Marital Status
  • Client
  • P2RB_SV.BVFAM == T5B14.BVFAM
  • P2RB_SV.MANDT == T5B14.MANDT
Contract Type
  • P2RB_SV.MANDT == T547V.MANDT
  • P2RB_SV.CTTYP == T547V.CTTYP
Employee Group
  • Employee Group
  • Client
  • P2RB_SV.PERSG == T501.PERSG
  • P2RB_SV.MANDT == T501.MANDT
Employee Subgroup
  • Employee Subgroup
  • Client
  • P2RB_SV.PERSK == T503K.PERSK
  • P2RB_SV.MANDT == T503K.MANDT
Obsolete: SI/Belcotax country
  • P2RB_SV.MANDT == T5B0F.MANDT
  • P2RB_SV.RSZBL == T5B0F.BELDK
Employer Class (SI Employer Category) (00036)
  • P2RB_SV.MANDT == T5B02.MANDT
  • P2RB_SV.RSZCA == T5B02.RSZCA
SI Position Code (00057)
  • SI Position Code (00057)
  • Client
  • P2RB_SV.RSZFF == T5B05.RSZFF
  • P2RB_SV.MANDT == T5B05.MANDT
Place/Country of Birth (00169)
  • P2RB_SV.MANDT == T5B0F.MANDT
  • P2RB_SV.RSZGL == T5B0F.BELDK
Profession Group
  • Profession Group
  • Client
  • P2RB_SV.RSZKE == T5B07.RSZKE
  • P2RB_SV.MANDT == T5B07.MANDT
Worker Code (SI Employee Category) (00037)
  • Worker Code (SI Employee Category) (00037)
  • Client
  • P2RB_SV.RSZKN == T5B01.RSZKN
  • P2RB_SV.MANDT == T5B01.MANDT
Obsolete: SI Nationality
  • P2RB_SV.MANDT == T5B08.MANDT
  • P2RB_SV.RSZNA == T5B08.BENAT
Employee Notification (00053)
  • Employee Notification (00053)
  • Client
  • P2RB_SV.RSZNO == T5B04.RSZNO
  • P2RB_SV.MANDT == T5B04.MANDT
Employee Specification
  • Employee Specification
  • Client
  • P2RB_SV.RSZSP == T5B03.RSZSP
  • P2RB_SV.MANDT == T5B03.MANDT
SI Contribution Reduction
  • P2RB_SV.MANDT == T5B09.MANDT
  • P2RB_SV.RSZWG == T5B09.RSZWG
Work Schedule Rule
  • ?
  • Work Schedule Rule
  • Start Date
  • Client
  • ?
  • ?
  • P2RB_SV.[column in domain "MOSID"] == T508A.MOSID
  • P2RB_SV.SCHKZ == T508A.SCHKZ
  • P2RB_SV.BEGDA == T508A.ENDDA
  • P2RB_SV.MANDT == T508A.MANDT
  • P2RB_SV.[column in domain "DZEITY"] == T508A.ZEITY
  • P2RB_SV.[column in domain "HIDENT"] == T508A.MOFID
Currency Key
  • P2RB_SV.MANDT == TCURC.MANDT
  • P2RB_SV.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel Subarea
  • Personnel Subarea
  • ?
  • P2RB_SV.MANDT == T001P.MANDT
  • P2RB_SV.BTRTL == T001P.BTRTL
  • P2RB_SV.[column in domain "PERSA"] == T001P.WERKS
Personnel Area
  • P2RB_SV.MANDT == T500P.MANDT
  • P2RB_SV.WERKS == T500P.PERSA