Please enable JavaScript to view this site.

XAS 7.0 Data Model

Navigation: » No topics above this level «

BasisSalaryThresholds

Scroll Prev Top Next More

Catalog: XAS

Label Plural: Basis Salary Thresholds

Name

Data Type

Label Singular

Nullable

Documentation

AUDIT_FILE_VERSION

varchar2

Audit File Version

 

BDR

number

Amount

 

 

COMPANY_ID

varchar2

Company ID

 

COMPANY_NAME

varchar2

Company Name

 

COMPANY_POSTAL_CODE

varchar2

Company Postal Code

 

COMPANY_TAX_REG_IDENT

varchar2

Wage Tax Registration Number

 

FILE_CURRENCY_CODE

varchar2

File Currency Code

 

FILE_DATE_CREATED

varchar2

File Creation Date

 

FISCAL_YEAR_NUMBER

varchar2

Fiscal Year Number

 

IDGRPRLN

varchar2

Identification Base Premium Income

 

 

INTERFACE_URL

varchar2

Interface URL

{res:itgen_interface_url_def}

LNTDVK_AANTSV

number

Salary Period Social Security Days

 

 

LNTDVK_ENDDAT

date

Salary Period End Date

 

 

LNTDVK_INGDAT

date

Salary Period Start Date

 

 

LNTDVK_INKVRHVAR_BDRGRNDSLGAFDRCHTVRMWVA

number

Employee Variable Salary Ratio itgen_xas_bdr_grndslg_afdrchtvrm_wva

 

 

LNTDVK_INKVRHVAR_BIJTELPERC

number

Employee Variable Salary Ratio Surcharge Percentage

 

 

LNTDVK_INKVRHVAR_CATPRIJSAUTO

number

Employee Variable Salary Ratio Catalogue Value Car

 

 

LNTDVK_INKVRHVAR_CDRDNGNBIJT

varchar2

Employee Variable Salary Ratio Reason no Surcharge Car

 

 

LNTDVK_INKVRHVAR_DLTFCT

number

Employee Variable Salary Ratio Part-time Factor

 

 

LNTDVK_INKVRHVAR_GEBRAUTO

number

Employee Variable Salary Ratio Uses Car

 

 

LNTDVK_INKVRHVAR_IND30RGL

varchar2

Employee Variable Salary Ratio itgen_xas_ind30_rgl

 

 

LNTDVK_INKVRHVAR_INDDLNMLVNSLPJN

varchar2

Employee Variable Salary Ratio itgen_xas_ind_dlnm_lvnslp_jn

 

 

LNTDVK_INKVRHVAR_INDGEMBEZ

varchar2

Employee Variable Salary Ratio itgen_xas_ind_gembez

 

 

LNTDVK_INKVRHVAR_INDSTUDSCH

varchar2

Employee Variable Salary Ratio Educational Debt

 

 

LNTDVK_INKVRHVAR_INDVAKBN

varchar2

Employee Variable Salary Ratio Holiday Coupons

 

 

LNTDVK_INKVRHVAR_INDVRVR

varchar2

Employee Variable Salary Ratio Transport due to Obliged Withholding

 

 

LNTDVK_INKVRHVAR_INDWIA

varchar2

Employee Variable Salary Ratio WIA Insurance

 

 

LNTDVK_INKVRHVAR_INDWW

varchar2

Employee Variable Salary Ratio WW Insurance

 

 

LNTDVK_INKVRHVAR_INDZVW

varchar2

Employee Variable Salary Ratio ZVW Insurance

 

 

LNTDVK_INKVRHVAR_INDZW

varchar2

Employee Variable Salary Ratio ZW Insurance

 

 

LNTDVK_INKVRHVAR_LBTAB

varchar2

Employee Variable Salary Ratio itgen_xas_lb_tab

 

 

LNTDVK_INKVRHVAR_LNHFKRTJN

varchar2

Employee Variable Salary Ratio itgen_xas_lnhfkrt_jn

 

 

LNTDVK_INKVRHVAR_LNLBPH

number

Employee Variable Salary Ratio Income LB/PH

 

 

LNTDVK_INKVRHVAR_LNSV

number

Employee Variable Salary Ratio Sociale Security Income

 

 

LNTDVK_INKVRHVAR_PRAWF

number

Employee Variable Salary Ratio Premium WW AWF Employer and Employee

 

 

LNTDVK_INKVRHVAR_PRUFO

number

Employee Variable Salary Ratio Premium Ufo

 

 

LNTDVK_INKVRHVAR_PRWAOAOF

number

Employee Variable Salary Ratio Base Premium WAO/IVE/WGA

 

 

LNTDVK_INKVRHVAR_PRWAOAOK

number

Employee Variable Salary Ratio Uniform Premium WAO / Differentiated Premium WGA

 

 

LNTDVK_INKVRHVAR_PRWGF

number

Employee Variable Salary Ratio Premium Industry Fund

 

 

LNTDVK_INKVRHVAR_SRTVAKBNCD

number

Employee Variable Salary Ratio Holiday Coupon Type Code

 

 

LNTDVK_INKVRHVAR_VRDLRGLTGPSTJN

varchar2

Employee Variable Salary Ratio itgen_xas_vrdlrgl_tgpst_jn

 

 

LNTDVK_INKVRHVAR_WRDPRGEBRAUT

number

Employee Variable Salary Ratio Value Personal Use Car

 

 

LNTDVK_INKVRHVAR_WRKNBIJDRAUT

number

Employee Variable Salary Ratio Employee Participation Car

 

 

LNTDVK_INKVRHVST_AANSLNRUWV

varchar2

Employee Fixed Salary Ratio Connection Number UWV

 

 

LNTDVK_INKVRHVST_BRPOMS

varchar2

Employee Fixed Salary Ratio Job Description

 

 

LNTDVK_INKVRHVST_CAOCD

number

Employee Fixed Salary Ratio CLA Code

 

 

LNTDVK_INKVRHVST_ENDDAT

date

Employee Fixed Salary Ratio End Date

 

 

LNTDVK_INKVRHVST_INGDAT

date

Employee Fixed Salary Ratio Start Date

 

 

LNTDVK_INKVRHVST_JRLNTBBZBEL

number

Employee Fixed Salary Ratio Annual Income for Special Income Table

 

 

LNTDVK_INKVRHVST_SRTINKCD

number

Employee Fixed Salary Ratio Income Type Code

 

 

LNTDVK_INKVRHVST_WRKNMR_GEBDAT

date

Employee Date of Birth

 

 

LNTDVK_INKVRHVST_WRKNMR_GESL

varchar2

Employee Gender

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_AANDATAUD

date

Message General Creation Date Audit File

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_AANDATBR

date

Message General Creation Date Message

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_BLJR

number

Message General Fiscal Year

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_BRCD

varchar2

Message General Message Code

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_TOTLNLBPH

number

Message General Total Salary LB/PH

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_VNRBRCD

varchar2

Message General Message Version Number

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_BDRVRLPGVRMSPONTW

number

Employer Provisional Amount Remittance S&O

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_KLNTNRLSB

varchar2

Employer Salary Administration Customer Number Payroll Service Office

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_LHNR

varchar2

Employer Salary Administration Payroll Tax Number

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_NMAPPL

varchar2

Employer Salary Administration Application Name

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VALCD

varchar2

Employer Salary Administration Currency Code

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VERAPPL

varchar2

Employer Salary Administration Application Version

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_NM

varchar2

Employer Name

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISNR

number

Street Address the Netherlands House Number

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISTOEV

varchar2

Street Address the Netherlands House Number Addition

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_PC

varchar2

Street Address the Netherlands Postal Code

 

 

LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_TWDLNM

varchar2

Employer Second Part Name

 

 

LNTDVK_INKVRHVST_WRKNMR_NAT

varchar2

Employee Nationality

 

 

LNTDVK_INKVRHVST_WRKNMR_PERSNR

varchar2

Employee Employee Number

 

 

LNTDVK_INKVRHVST_WRKNMR_SIGNNM

varchar2

Employee Significant Part Last Name

 

 

LNTDVK_INKVRHVST_WRKNMR_SOFINR

number

Employee Social Security Number

 

 

LNTDVK_INKVRHVST_WRKNMR_VOORL

varchar2

Employee Initials

 

 

LNTDVK_INKVRHVST_WRKNMR_VOORV

varchar2

Employee Prefixes

 

 

LNTDVK_PRDNR

number

Salary Period Period Number

 

 

PRODUCT_ID

varchar2

Product ID

 

PRODUCT_VERSION

varchar2

Product Version