Konfigurere integration med Dataverse-tabeller
Hvis du vil integrere Microsoft Dynamics 365 Human Resources med Dataverse, kan du bruge Dataintegrator. Human Resources–til–Dataverse-skabelonen gør det muligt at arbejde med data for job, stillinger, arbejdere og andre fra Human Resources til Dataverse og fra Dataverse til Human Resources, så der oprettes en skrivning i begge systemer.
Systemkrav til Human Resources
Integrationsløsningen kræver følgende versioner af Human Resources og Dynamics 365 Finance:
- Dynamics 365 Finance version 7.2 og senere
- Dynamics CRM-miljø, hvor der er oprettet en database, og Dynamics 365-apps er tilladt
Skabelon og opgaver
Følg disse trin for at aktivere Human Resources–til–Finans-skabelonen.
- Åbn Power Apps Administration.
- Vælg Dynamics 365 Apps under dit miljø, og vælg derefter App-kilde på værktøjslinjen.
- Hvis du vil installere skabelonen, skal du søge efter "Dobbeltskrivning til Human Resources" eller gå direkte til følgende adresse: https://appsource.microsoft.com/product/dynamics-365/mscrm.hcm_dualwrite.
- Når installationen er fuldført, skal du åbne Dynamics 365 Finance.
- Åbn arbejdsområdet Datastyring.
- Vælg Dobbeltskrivning.
- Følg processen for sammenkædning af dit miljø for mindst ét firma i organisationen.
- Når du er færdig med at oprette et link til dit Dataverse-miljø, skal du vælge Anvend løsning. Løsningen anvendes, og tilknytningerne installeres i integratorappen.
Note
Der er tre løsningspakker, der skal bruges til Dobbeltskrivning til Human Resources. Du kan få flere oplysninger under Adskilt orkestreringspakke til dobbeltskrivningsapplikation.
Tilknytninger af skabelon
I følgende tabeller med skabelontilknytninger angiver opgavenavnet de enheder, der bruges i de enkelte programmer. Finans står til venstre og Dataverse til højre.
Betalinger på bankkonto (dobbeltskrivning) til bankkontobetaling
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| ACCOUNTIDENTIFICATIONID | cdm_bankaccountid.cdm_accountidentification |
| BELØB | cdm_amount |
| PRIORITY | cdm_disbursementpriority |
| PERSONNELNUMBER | cdm_bankaccountid.cdm_workerid.cdm_workernumber |
| REMAINDER | cdm_isremainder |
Oplysninger om frynsegodeberegningssats (dobbeltskrivning) til Oplysninger om frynsegodeberegningssats
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| CONTRIBUTIONMETHOD | cdm_contributionmethod |
| EFFECTIVE | cdm_effective |
| EMPLOYERCONTRIBUTION | cdm_employercontribution |
| EXPIRATION | cdm_expiration |
| WORKERDEDUCTION | cdm_workerdeduction |
| NAVN | cdm_calculationrateid.cdm_name |
Overskrift for personalegodeberegningssats til personalegodeberegningssats
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| NAVN | cdm_name |
| TIERTYPE | cdm_tiertype |
Personalegodeindstilling til Personalegodeindstilling
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| ALLOWBENEFICIARYDESIGNATIONS | cdm_allowbeneficiarydesignations |
| ALLOWDEPENDENTCOVERAGE | cdm_allowdependentcoverage |
| BENEFITOPTIONID | cdm_name |
| BESKRIVELSE | cdm_description |
| ISWAIVE | cdm_iswaived |
Frynsegode til Frynsegode
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BENEFITTYPEID | cdm_name |
| CONCURRENTENROLLMENT | cdm_concurrentenrollment |
| BESKRIVELSE | cdm_description |
| PAYROLLCATEGORY | cdm_payrollcategory |
Forretningskalender til Forretningsproceskalender
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| CALENDARID | cdm_name |
| NAVN | cdm_calendarname |
| STARTDATE | cdm_startdate |
| ENDDATE | cdm_enddate |
| ISOPENMONDAY | cdm_ismondayopen |
| ISOPENTUESDAY | cdm_istuesdayopen |
| ISOPENWEDNESDAY | cdm_iswednesdayopen |
| ISOPENTHURSDAY | cdm_isthursdayopen |
| ISOPENFRIDAY | cdm_isfridayopen |
| ISOPENSATURDAY | cdm_issaturdayopen |
| ISOPENSUNDAY | cdm_issundayopen |
Forretningsproces til forretningsprocesoverskrift
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PROCESSID | cdm_processid |
| PROCESSTYPE | cdm_processtype |
| GENERICSUBTYPE | cdm_genericsubtype |
| NAVN | cdm_name |
| BESKRIVELSE | cdm_description |
| STATUS | cdm_status |
| TARGETDATE | cdm_targetdate |
| STARTDATETIME | cdm_startdatetime |
| ENDDATETIME | cdm_enddatetime |
| RESOLVEDBYPERSONNELNUMBER | cdm_resolvedbyid.cdm_workernumber |
| PROCESSOWNERPERSONNELNUMBER | cdm_processownerid.cdm_workernumber |
| SOURCETEMPLATENAME | cdm_sourcetemplateid.cdm_name |
| SOURCETEMPLATEPROCESSTYPE | cdm_sourcetemplateid.cdm_businessprocesstype |
| SOURCETEMPLATEGENERICSUBTYPE | cdm_sourcetemplateid.cdm_genericsubtype |
Opgavegruppe for bibliotek til forretningsprocesbibliotek
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PROCESSTYPE | cdm_processtype |
| NAVN | cdm_name |
| BESKRIVELSE | cdm_description |
Forretningsprocesniveau til forretningsprocesniveau
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PROCESSTYPE | cdm_businessprocesstype |
| NAVN | cdm_name |
| BESKRIVELSE | cdm_description |
| SEQUENCENUMBER | cdm_sequencenumber |
Forretningsprocesopgave til forretningsprocesopgave
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| DUEDATE | cdm_duedate |
| TASKID | cdm_taskid |
| INSTRUCTIONS | cdm_instructions |
| COMPLETIONDATETIME | cdm_completiondatetime |
| ASSIGNMENTTYPE | cdm_assignmenttype |
| ISOPTIONAL | cdm_isoptional |
| NAVN | cdm_name |
| STATUS | cdm_status |
| RESOLVEDBY_PERSONNELNUMBER | cdm_resolvedbyid.cdm_workernumber |
| TEMPLATETASKID | cdm_templatetaskid.cdm_taskid |
| ASSIGNEDWORKER_PERSONNELNUMBER | cdm_assignedworkerid.cdm_workernumber |
| PROCESSID | cdm_processheaderid.cdm_processid |
| ASSIGNEDGROUP_NAME | cdm_assignedgroupid.cdm_name |
| ASSIGNEDPOSITION_POSITIONID | cdm_assignedposition.cdm_jobpositionnumber |
Forretningsprocesskabelon til overskrift i checklisteskabelon
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PROCESSTYPE | cdm_businessprocesstype |
| GENERICSUBTYPE | cdm_genericsubtype |
| NAVN | cdm_name |
| BESKRIVELSE | cdm_description |
| CALENDARID | cdm_businessprocesscalendarid.cdm_name |
| PERSONNELNUMBER | cdm_processownerid.cdm_workernumber |
| ISACTIVE | cdm_isactive |
Forretningsprocesskabelonopgave til checklisteskabelonopgave
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| TASKID | cdm_taskid |
| NAVN | cdm_name |
| TEMPLATEHEADER_PROCESSTYPE | cdm_businessprocesstemplateheaderid.cdm_businessprocesstype |
| TEMPLATEHEADER_GENERICSUBTYPE | cdm_businessprocesstemplateheaderid.cdm_genericsubtype |
| TEMPLATEHEADER_NAME | cdm_businessprocesstemplateheaderid.cdm_name |
| BESKRIVELSE | cdm_description |
| DUEDATEOFFSETDAYS | cdm_duedateoffsetdays |
| MENUITEMTYPE | cdm_tasklinktype |
| MENUITEM | cdm_tasklink |
| CONTACTPERSON_PERSONNELNUMBER | cdm_contactpersonid.cdm_workernumber |
| ASSIGNMENTTYPE | cdm_assignmenttype |
| ASSIGNEDWORKER_PERSONNELNUMBER | cdm_assignedworkerid.cdm_workernumber |
| ASSIGNEDPOSITION_POSITIONID | cdm_assignedpositionid.cdm_jobpositionnumber |
| ASSIGNEDGROUP_NAME | cdm_assignedgroupid.cdm_name |
| ISOPTIONAL | cdm_isoptional |
| INSTRUCTIONS | cdm_instructions |
Beregningsfrekvens til beregningsfrekvens for ydelser
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| FREQUENCY | cdm_name |
| FREQUENCYCONTROL | cdm_frequencycontrol |
| ISIMMUTABLE | cdm_isimmutable |
Lønperiode til beregningsfrekvens til lønperiodefrekvens til frynsegodeberegning
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| CALCULATIONFREQUENCYID | cdm_benefitcalculationfrequencyid.cdm_name |
| PERIODSTARTDATE | cdm_payperiodid.cdm_periodstartdate |
| PAYCYCLEID | cdm_payperiodid.cdm_paycycleid.cdm_name |
Kalender til arbejdskalender
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| CALENDARID | cdm_name |
| CALENDARNAME | cdm_description |
| WORKCALENDARHOLIDAYID | cdm_workcalendarholidayid.cdm_name |
Kompensationstabel for fast handling til hændelse for fast løn
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| ACTION | cdm_name |
| ACTIVE | cdm_isactive |
| BESKRIVELSE | cdm_description |
| TYPE | cdm_eventtype |
Kompensation for fast plan til kompensation for fast plan
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PLAN | cdm_name |
| BESKRIVELSE | cdm_description |
| TYPE | cdm_type |
| EFFECTIVEDATE | cdm_effectivedate |
| EXPIRATIONDATE | cdm_expirationdate |
| VALUTA | cdm_transactioncurrencyid.isocurrencycode |
| PAYFREQUENCY | cdm_payfrequency.cdm_name |
| HIRERULE | cdm_hirerule |
| OUTOFRANGETOLERANCE | cdm_outofrangetolerance |
| RECOMMENDATIONALLOWED | cdm_recommendationallowed |
| COMPENSATIONSTRUCTURE | cdm_compensationgrid.cdm_name |
| REFPOINTSETUPID | cdm_referencepointsetupline.cdm_referencepointsetupid.cdm_name |
| CONTROLPOINT | cdm_referencepointsetupline.cdm_name |
Kompensationsgitre til kompensationsgitter
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| GRIDID | cdm_name |
| BESKRIVELSE | cdm_description |
| EFFECTIVEDATE | cdm_effectivedate |
| EXPIRATIONDATE | cdm_expirationdate |
| REFERENCESETUP | cdm_referencepointsetupid.cdm_name |
| TYPE | cdm_type |
| VALUTA | cdm_transactioncurrencyid.isocurrencycode |
Jobfunktioner til Kompensation til jobfunktion
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| JOBFUNCTIONID | cdm_name |
| BESKRIVELSE | cdm_description |
Jobtyper til kompensation til jobtype
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| JOBTYPEID | cdm_name |
| BESKRIVELSE | cdm_description |
| EXEMPTSTATUS | cdm_exemptstatus |
Kompensationslønfrekvens til kompensationslønfrekvens
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PAYRATECONVERSION | cdm_name |
| PERIOD | cdm_period |
| BESKRIVELSE | cdm_description |
| ANNUALCONVERSIONFACTOR | cdm_annualconversionfactor |
| HOURLYCONVERSIONFACTOR | cdm_hourlyconversionfactor |
| MONTHLYCONVERSIONFACTOR | cdm_monthlyconversionfactor |
| WEEKLYCONVERSIONFACTOR | cdm_weeklyconversionfactor |
Kompensationsområder til kompensationsområde
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| LOKALITET | cdm_name |
Kompensationsvariabelplan V2 til kompensationsvariabelplan
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| VARIABLEAWARDBASIS | cdm_awardbasis |
| AWARDBASISCALCULATION | cdm_awardbasiscalculation |
| CALCULATIONTYPE | cdm_calculationtype |
| BESKRIVELSE | cdm_description |
| ENABLEENROLLMENT | cdm_enableenrollment |
| ENABLELEVELS | cdm_enablelevels |
| ENABLERECOMMENDATION | cdm_enablerecommendation |
| HIRERULE | cdm_hirerule |
| LEVERAGE100PERCENT | cdm_leverage100percent |
| LEVERAGEMAXIMUM | cdm_leveragemaximum |
| LEVERAGEMINIMUM | cdm_leverageminimum |
| LEVERAGEOVEROBJECTIVE | cdm_leverageoverobjective |
| LEVERAGEUNDEROBJECTIVE | cdm_leverageunderobjective |
| PERCENTOFBASIS | cdm_percentofbasis |
| PLANID | cdm_name |
| VARIABLECOMPENSATIONTYPE | cdm_variablecompensationtypeid.cdm_name |
| UNITCURRENCYCODE | transactioncurrencyid.isocurrencycode |
| UNITRELATIONSHIP | cdm_unitrelationship |
| UNITVALUE | cdm_unitvalue |
| NUMBEROFUNITSREAL | cdm_numberofunits |
| EFFECTIVEDATE | cdm_effectivedate |
| EXPIRATIONDATE | cdm_expirationdate |
| VESTINGRULE | cdm_vestingruleid.cdm_name |
| LEVERAGETOLERANCEMAX | cdm_leveragetolerancemax |
| LEVERAGETOLERANCEMIN | cdm_leveragetolerancemin |
Kompensationsvariabeltype til kompensationsvariabelplantype
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| TYPE | cdm_awardtype |
| VARIABLECOMPENSATIONTYPE | cdm_name |
Kompensations vesteringsregler til vesteringsregel
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| NOTE | cdm_notes |
| VESTINGRULE | cdm_name |
Afdeling V2 til Afdeling
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| OPERATINGUNITNUMBER | cdm_departmentnumber |
| NAVN | cdm_name |
| SEARCHNAME | cdm_description |
| PARTYTYPE | cdm_partytype |
Momsområde for dobbeltskrivning til Momsområde
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| CITY | cdm_city |
| COUNTRYORREGION | cdm_countryorregion |
| COUNTY | cdm_county |
| STATE | cdm_stateorprovince |
| TAXREGIONNAME | cdm_name |
Arbejderidentifikation til arbejderens identifikationsnummer
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| ENTRYTYPE | cdm_entrytype |
| EXPIRATIONDATE | cdm_expirationdate |
| IDENTIFICATIONNUMBER | cdm_identificationnumber |
| IDENTIFICATIONTYPEID | cdm_identificationtypeid.cdm_name |
| ISPRIMARY | cdm_isprimary |
| ISSUEDATE | cdm_issuedate |
| ISSUINGAGENCYID | cdm_issuingagencyid.cdm_name |
| WORKERNUMBER | cdm_workerid.cdm_workernumber |
Kompensationsstruktur til kompensationsstruktur
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BELØB | cdm_amount |
| GRID | cdm_compensationgridid.cdm_name |
| LEVELID | cdm_compensationlevelid.cdm_name |
| REFERENCEPOINTLINENUMBER | cdm_referencepointid.cdm_linenumber |
| REFERENCESETUP | cdm_referencepointid.cdm_referencepointsetupid.cdm_name |
| REFERENCEPOINT | cdm_referencepointid.cdm_name |
Indtægtskode til løn indtægtskode
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| EARNINGCODE | cdm_name |
| BESKRIVELSE | cdm_description |
| INCLUDEINPAYMENTTYPE | cdm_includeinpaymenttype |
| QUANTITYUNIT | cdm_quantityunit |
| TRACKFMLAHOURS | cdm_trackfmlahours |
| ISPRODUCTIVE | cdm_isproductive |
Fast lønkompensation til medarbejder til Arbejders faste løn
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| COMPENSATIONLEVELID | cdm_compensationlevelid.cdm_name |
| TYPE | cdm_compensationtype |
| EFFECTIVEDATE | cdm_effectivedate |
| EXPIRATIONDATE | cdm_expirationdate |
| LINENUMBER | cdm_linenumber |
| PAYFREQUENCY | cdm_payfrequencyid.cdm_name |
| PAYRATE | cdm_payrate |
| PLAN | cdm_planid.cdm_name |
| POSITIONID | cdm_positionid.cdm_jobpositionnumber |
| PROCESSTYPE | cdm_processtype |
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
| ACTION | cdm_eventid.cdm_name |
| STEP | cdm_referencepointsetuplineid.cdm_name |
| REFPOINTSETUPID | cdm_referencepointsetuplineid.cdm_referencepointsetupid.cdm_name |
Ansættelse pr. firma til ansættelse
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| EMPLOYMENTENDDATE | cdm_employmentenddate |
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
| EMPLOYMENTSTARTDATE | cdm_employmentstartdate |
| WORKERTYPE | cdm_workertype |
| DIMENSIONDISPLAYVALUE | cdm_dimensiondisplayvalue |
| ADJUSTEDWORKERSTARTDATE | cdm_adjustedworkerstartdate |
| EMPLOYERNOTICEAMOUNT | cdm_employernoticeamount |
| EMPLOYERUNITOFNOTICE | cdm_employerunitofnotice |
| WORKERUNITOFNOTICE | cdm_workerunitofnotice |
| WORKERNOTICEAMOUNT | cdm_workernoticeamount |
| LASTDATEWORKED | cdm_lastdateworked |
| PROBATIONENDDATE | cdm_probationenddate |
| TRANSITIONDATE | cdm_transitiondate |
| TRANSITIONREASONCODENAME | cdm_transitionreasoncode.cdm_name |
| WORKERSTARTDATE | cdm_workerstartdate |
| VALIDTO | cdm_validto |
| VALIDFROM | cdm_validfrom |
Etnisk oprindelse til Etnisk oprindelse
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| ETHNICORIGINID | cdm_name |
| BESKRIVELSE | cdm_description |
Gruppetildeling til forretningsprocesgruppetildeling
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| NAVN | cdm_name |
| BESKRIVELSE | cdm_description |
| ISACTIVE | cdm_isactive |
Typen af identifikationstype til personidentifikationstype for arbejder
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| IDENTIFICATIONTYPEID | cdm_name |
| ALLOWEDVALUES | cdm_allowedvalues |
| FIXEDLENGTH | cdm_fixedlength |
| IDENTIFICATIONNUMBERFORMAT | cdm_identificationnumberformat |
Udstedende organ til Udstedende organ for personidentifikation
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| cdm_email | |
| EXTENSION | cdm_extension |
| FAX | cdm_fax |
| ISSUINGAGENCY | cdm_name |
| MOBILEPHONE | cdm_mobilephone |
| INTERNETADDRESS | cdm_websiteurl |
| NAVN | cdm_description |
| PAGER | cdm_pager |
| Sms | cdm_sms |
| TELEPHONE | cdm_telephone |
| TELEXNUMBER | cdm_telex |
| ADDRESSCITY | cdm_city |
| ADDRESSCOUNTY | cdm_county |
| ADDRESSDESCRIPTION | cdm_addressdescription |
| ADDRESSSTATE | cdm_stateorprovince |
| ADDRESSSTREET | cdm_street |
| ADDRESSZIPCODE | cdm_postalcode |
| ADDRESSCOUNTRYREGIONISOCODE | cdm_countryregion |
Jobstillinger til dobbeltskrivning til jobstillinger
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| POSITIONID | cdm_jobpositionnumber |
| ACTIVATION | cdm_activation |
| AVAILABLEFORASSIGNMENT | cdm_availableforassignment |
| COMPENSATIONREGIONID | cdm_compensationregionid.cdm_name |
| DEPARTMENTID | cdm_departmentid.cdm_departmentnumber |
| BESKRIVELSE | cdm_description |
| FULLTIMEEQUIVALENT | cdm_fulltimeequivalent |
| JOBID | cdm_jobid.cdm_name |
| PARENTPOSITIONID | cdm_parentjobpositionid.cdm_jobpositionnumber |
| POSITIONTYPEID | cdm_positiontypeid.cdm_name |
| PENSION | cdm_retirement |
| TITLEID | cdm_titleid.cdm_name |
| VALIDFROM | cdm_validfrom |
| VALIDTO | cdm_validto |
Job-dobbeltskrivning til Job
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| JOBID | cdm_name |
| BESKRIVELSE | cdm_description |
| JOBDESCRIPTION | cdm_jobdescription |
| ALLOWUNLIMITEDPOSITIONS | cdm_allowunlimitedpositions |
| MAXIMUMNUMBEROFPOSITIONS | cdm_maximumnumberofpositions |
| JOBFUNCTIONID | cdm_jobfunctionid.cdm_name |
| JOBTYPEID | cdm_jobtypeid.cdm_name |
| TITLEID | cdm_titleid.cdm_name |
| VALIDFROM | cdm_validfrom |
| VALIDTO | cdm_validto |
| DEFAULTFULLTIMEEQUIVALENCY | cdm_defaultfulltimeequivalent |
Sprogkoder til Sprog
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| LANGUAGECODEID | cdm_name |
| BESKRIVELSE | cdm_description |
Orlovs- og fraværsbankpostering V2 til orlovsbankpostering
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BELØB | cdm_amount |
| LEAVETYPEID | cdm_leavetypeid.cdm_type |
| LEAVEPLANID | cdm_leaveplanid.cdm_name |
| TRANSACTIONDATE | cdm_transactiondate |
| TRANSACTIONNUMBER | cdm_transactionnumber |
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
| TRANSACTIONTYPE | cdm_transactiontype |
Orlov og fraværsregistrering V2 for at lade tilmeldingen være
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| STARTDATE | cdm_startdate |
| ENDDATE | cdm_enddate |
| CUSTOMDATE | cdm_customdate |
| ACCRUALSTARTDATE | cdm_accrualstartdate |
| ACCRUALDATEBASIS | cdm_accrualdatebasis |
| ISACCRUALSUSPENDED | cdm_isaccrualsuspended |
| LEAVEPLANID | cdm_leaveplanid.cdm_name |
| TIERBASIS | cdm_tierbasis |
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
Orlov og fraværsplan V2 til orlovsplan
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| ACCRUALFREQUENCY | cdm_accrualfrequency |
| NAVN | cdm_name |
| BESKRIVELSE | cdm_description |
| STARTDATE | cdm_startdate |
| LEAVETYPEID | cdm_leavetypeid.cdm_type |
Orlovs- og fraværstype til Orlovstype
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| TYPE | cdm_type |
| EARNINGCODEID | cdm_earningcodeid.cdm_name |
Årsagskode for orlovs- og fraværstype til årsagskoden for orlovstypen
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| LEAVETYPE | cdm_typeid.cdm_type |
| REASONCODEID | cdm_reasoncodeid.cdm_name |
Oplysninger om anmodninger om orlov til oplysninger om orlovsanmodning
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BELØB | cdm_amount |
| LEAVEDATE | cdm_leavedate |
| REQUESTID | cdm_leaverequestid.cdm_leaverequestnumber |
| TYPE | cdm_leavetypeid.cdm_type |
Overskrift til anmodninger om orlov til orlovsanmodning
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| REQUESTID | cdm_leaverequestnumber |
| REQUESTDATE | cdm_requestdate |
| STATUS | cdm_status |
| COMMENT | cdm_comment |
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
Niveauer til kompensationsniveau
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| TYPE | cdm_type |
| BESKRIVELSE | cdm_description |
| LEVEL | cdm_name |
Onboardingprocesoverskrift til onboardingprocesoverskrift
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PROCESSID | cdm_processheaderid.cdm_processid |
| ONBOARDEDEMPLOYEEPERSONNELNUMBER | cdm_onboardedemployeeid.cdm_workernumber |
| EMPLOYMENTPERSONNELNUMBER | cdm_employmentid.cdm_workerid.cdm_workernumber |
| LEGALENTITYID | cdm_employmentid.cdm_companyid.cdm_companycode |
| EMPLOYMENTSTARTDATE | cdm_employmentid.cdm_employmentstartdate |
Løncyklus til løncyklus
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PAYCYCLEID | cdm_name |
| BESKRIVELSE | cdm_description |
| PAYCYCLEFREQUENCY | cdm_frequency |
Lønperiode til lønperiode
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| KOMMENTARER | cdm_description |
| DEFAULTPAYMENTDATE | cdm_defaultpaymentdate |
| PAYCYCLEID | cdm_paycycleid.cdm_name |
| PERIODENDDATE | cdm_periodenddate |
| PERIODSTARTDATE | cdm_periodstartdate |
| STATUS | cdm_status |
Lønoplysninger for stillinger til lønpositionsdetaljer
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PAYCYCLEID | cdm_paycycle.cdm_name |
| POSITIONID | cdm_position.cdm_jobpositionnumber |
| VALIDFROM | cdm_validfrom |
| VALIDTO | cdm_validto |
| ANNUALREGULARHOURS | cdm_annualregularhours |
| PAIDBYLEGALENTITY | cdm_paidby.cdm_companycode |
Standarddimensioner for dobbeltskrivningsposition til stillingsdimension
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| DIMENSIONDISPLAYVALUE | cdm_dimensiondisplayvalue |
| POSITIONID | cdm_jobpositionid.cdm_jobpositionnumber |
Stillingstype til stillingstype
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| POSITIONTYPEID | cdm_name |
| BESKRIVELSE | cdm_description |
| CLASSIFICATION | cdm_classification |
Arbejdertildelinger for stilling V2 til Arbejdertildeling
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
| POSITIONID | cdm_jobpositionid.cdm_jobpositionnumber |
| VALIDFROM | cdm_validfrom |
| VALIDTO | cdm_validto |
| IsPrimaryPosition | cdm_isprimaryposition |
Årsagskoder til årsagskode
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| REASONCODEID | cdm_name |
| BESKRIVELSE | cdm_description |
| ISABSENCEAPPLICABLE | cdm_isabsenceapplicable |
| ISAPPLICATIONAPPLICABLE | cdm_isapplicationapplicable |
| ISCOMPENSATIONAPPLICABLE | cdm_iscompensationapplicable |
| ISCREATENEWPOSITIONAPPLICABLE | cdm_iscreatenewpositionapplicable |
| ISEDITPOSITIONAPPLICABLE | cdm_iseditpositionapplicable |
| ISHIREAPPLICABLE | cdm_ishireapplicable |
| ISSKILLMAPPINGAPPLICABLE | cdm_isskillmappingapplicable |
| ISTERMINATIONAPPLICABLE | cdm_isterminationapplicable |
| ISTRANSFERAPPLICABLE | cdm_istransferapplicable |
Linje for opsætning af referencepunkt (dobbeltskrivning) til Opsætningslinje for kompensationsreferencepunkt
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| BESKRIVELSE | cdm_description |
| LINENUM | cdm_linenumber |
| REFPOINTID | cdm_name |
| REFPOINTSETUPID | cdm_referencepointsetupid.cdm_name |
Opsætninger af referencepunkter til Opsætning af kompensationsreferencepunkt
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| REFERENCESETUP | cdm_name |
| BESKRIVELSE | cdm_description |
| TYPE | cdm_compensationtype |
Færdighedstyper til færdighedstype
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| SKILLTYPE | cdm_name |
| BESKRIVELSE | cdm_description |
Titler til titel
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| TITLEID | cdm_name |
Variabel kompensation-niveau V2 til Niveau i variabel kompensationsplan
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| AWARDAMOUNT | cdm_awardamount |
| AWARDPERCENT | cdm_awardpercent |
| AWARDUNITSREAL | cdm_awardunits |
| COMPENSATIONLEVELID | cdm_compensationlevelid.cdm_name |
| PLANID | cdm_compensationvariableplanid.cdm_name |
Veteranstatus til Veteranstatus
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| VETERANSTATUSID | cdm_name |
| BESKRIVELSE | cdm_description |
| ISPROTECTEDVETERAN | cdm_isprotectedveteran |
Arbejdskalendertilmeldinger til Arbejdskalendertilmelding
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| STARTDATE | cdm_employmentid.cdm_employmentstartdate |
| PERSONNELNUMBER | cdm_employmentid.cdm_workerid.cdm_workernumber |
| CALENDARID | cdm_workcalendarid.cdm_name |
| COMPANYID | cdm_employmentid.cdm_companyid.cdm_companycode |
Arbejdskalenderfridag til Arbejdskalenderfridag
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| ID | cdm_name |
| BESKRIVELSE | cdm_description |
Arbejdskalenderfridagslinje til Arbejdskalenderfridagslinje
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| HOLIDAYID | cdm_workcalendarholidayid.cdm_name |
| NAVN | cdm_name |
| HOLIDAYDATE | cdm_holidaydate |
Arbejdere til arbejder
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PERSONNELNUMBER | cdm_workernumber |
| FIRSTNAME | cdm_firstname |
| MIDDLENAME | cdm_middlename |
| LASTNAME | cdm_lastname |
| WORKERTYPE | cdm_type |
| WORKERSTATUS | cdm_status |
| PRIMARYCONTACTEMAIL | cdm_primaryemailaddress |
| PRIMARYCONTACTPHONE | cdm_primarytelephone |
| PRIMARYCONTACTFACEBOOK | cdm_facebookidentity |
| PRIMARYCONTACTTWITTER | cdm_twitteridentity |
| PRIMARYCONTACTLINKEDIN | cdm_linkedinidentity |
| PRIMARYCONTACTURL | cdm_websiteurl |
| GENDER | cdm_gender |
| BIRTHDATE | cdm_birthdate |
| NAVN | cdm_fullname |
Arbejders bankkonti til arbejderens bankkonto
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| ACCOUNTIDENTIFICATION | cdm_accountidentification |
| ADDRESSCITY | cdm_city |
| ADDRESSCOUNTRYREGIONID | cdm_countryorregion |
| ADDRESSCOUNTY | cdm_county |
| ADDRESSDESCRIPTION | cdm_addressdescription |
| ADDRESSDISTRICTNAME | cdm_districtname |
| ADDRESSPOSTBOX | cdm_postofficebox |
| ADDRESSSTATE | cdm_stateorprovince |
| ADDRESSZIPCODE | cdm_postalcode |
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
| BANKACCOUNTNUMBER | cdm_bankaccountnumber |
| BANKACCOUNTTYPE | cdm_bankaccounttype |
| cdm_email | |
| EXTENSION | cdm_extension |
| FAX | cdm_fax |
| INTERNETADDRESS | cdm_websiteurl |
| MOBILEPHONE | cdm_mobilephone |
| ROUTINGNUMBER | cdm_routingnumber |
| TELEPHONE | cdm_telephone |
| TELEXNUMBER | cdm_telexnumber |
| BANKIBAN | cdm_iban |
| SWIFTNO | cdm_swiftcode |
| BANKLOCATIONCODE | cdm_banklocationcode |
| BRANCHNAME | cdm_branchname |
| BRANCHNUMBER | cdm_branchnumber |
| ROUTINGNUMBERTYPE | cdm_routingnumbertype |
| ACCOUNTHOLDER | cdm_accountholder |
| NAMEOFPERSON | cdm_nameofperson |
| NAVN | cdm_description |
| ADDRESSSTREET | cdm_line1 |
| ADDRESSSTREETNUMBER | cdm_line2 |
Arbejders personlige oplysninger til arbejderens personlige oplysning
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
| BIRTHDATE | cdm_birthdate |
| PERSONBIRTHCITY | cdm_birthcity |
| GENDER | cdm_gender |
| EXPATRIATEENDDATE | cdm_expatriateenddate |
| EXPATRIATESTARTDATE | cdm_expatriatestartdate |
| DISABLEDVETERAN | cdm_isdisabledveteran |
| DECEASEDDATE | cdm_deceaseddate |
| DISABLEDVERIFICATIONDATE | cdm_disabledveteranverificationdate |
| EDUCATION | cdm_education |
| ETHNICORIGINID | cdm_ethnicoriginid.cdm_name |
| ISDISABLED | cdm_isdisabled |
| ISFULLTIMESTUDENT | cdm_isfulltimestudent |
| ISEXPATRIATERULINGAPPLICABLE | cdm_isexpatriaterulingapplicable |
| MARITALSTATUS | cdm_maritalstatus |
| MILITARYSERVICESTARTDATE | cdm_militaryservicestartdate |
| MILITARYSERVICEENDDATE | cdm_militaryserviceenddate |
| NUMBEROFDEPENDENTS | cdm_numberofdependents |
| NATIVELANGUAGEID | cdm_nativelanguageidid.cdm_name |
| NATIONALITYCOUNTRYREGION | cdm_nationalitycountryregion |
| PERSONBIRTHCOUNTRYREGION | cdm_birthcountryregion |
| FATHERBIRTHCOUNTRYREGION | cdm_fatherbirthcountryregion |
| MOTHERBIRTHCOUNTRYREGION | cdm_motherbirthcountryregion |
| CITIZENSHIPCOUNTRYREGION | cdm_citizenshipcountryregion |
| VETERANSTATUSID | cdm_veteranstatusid.cdm_name |
Postadresser til arbejderens dobbeltskrivning til arbejderadresse
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
| ADDRESSLOCATIONID | cdm_addressnumber |
| ADDRESSLOCATIONROLES | cdm_addresstype |
| EFFECTIVE | cdm_effectivedate |
| EXPIRATION | cdm_expirationdate |
| ADDRESSSTREET | cdm_street |
| ADDRESSSTREETNUMBER | cdm_streetnumber |
| ADDRESSCITY | cdm_city |
| ADDRESSCOUNTRYREGIONISOCODE | cdm_countryregion |
| ADDRESSSTATE | cdm_stateorprovince |
| ADDRESSCOUNTYID | cdm_county |
| ADDRESSDESCRIPTION | cdm_description |
| ADDRESSLATITUDE | cdm_latitude |
| ADDRESSLONGITUDE | cdm_longitude |
| ADDRESSZIPCODE | cdm_postalcode |
| ADDRESSPOSTBOX | cdm_postofficebox |
| ISPRIMARY | cdm_ispreferred |
Arbejdstid til Tidsinterval i arbejdskalender
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| ENDTIME | cdm_endtime |
| STARTTIME | cdm_starttime |
| WORKCALENDARDATE | cdm_workcalendardayid.cdm_calendardate |
| WORKCALENDARID | cdm_workcalendarid.cdm_name |
| WORKCALENDARID | cdm_workcalendardayid.cdm_workcalendarid.cdm_name |
Arbejdstider til arbejdskalenderdag
| Økonomisk enhed | Dataverse-tabel |
|---|---|
| CALENDARDATE | cdm_calendardate |
| WORKCALENDARID | cdm_workcalendarid.cdm_name |
| WORKINGDAYDEFINITION | cdm_status |
Integrationsovervejelser
- Alle ændringer, der foretages af data i det ene system, skal valideres af det andet system. Hvis der opstår fejl, skrives data ikke i et af systemerne.
- Alle skrivninger er underlagt datastandardindstilling (hvis der opstår brugerdefinerede logik i Finans).
- Integrationsappen til dobbeltskrivning bruger integrationsnøgler til tilknytning mellem de to systemer. Sommetider kan det være vanskeligt at vælge den rigtige integrationsnøgle, især hvis der er flere integrationsnøgler, der opfylder kravene. Som en hjælp til dette valg vises de foreslåede integrationsnøgler til tilknytningerne i følgende tabel.
| Dataverse-tabel | Integrationsnøgler |
|---|---|
| Bankkontoudbetalinger | cdm_bankaccountid.cdm_accountidentification, cdm_bankaccountid.cdm_workerid.cdm_workernumber, cdm_companyid.cdm_companycode |
| Frekvens for personalegodeberegning | cdm_name |
| Frynsegoders Beregningsfrekvens, betalingsperiode | cdm_payperiodid.cdm_periodstartdate, cdm_payperiodid.cdm_paycycleid.cdm_name, cdm_benefitcalculationfrequencyid.cdm_name |
| Frynsegodeberegningssats | cdm_name |
| Oplysninger om frynsegodeberegningssats | cdm_workerdeduction, cdm_effective, cdm_calculationrateid.cdm_name |
| Frynsegodeindstilling | cdm_name |
| Human Resourcesgodetype | cdm_name |
| Forretningsproceskalender | cdm_name |
| Tildeling af forretningsprocesgruppe | cdm_name |
| Forretningsprocesoverskrift | cdm_processid |
| Opgavegruppe for forretningsprocesbibliotek | cdm_processtype, cdm_name |
| Forretningsprocesstadie | cdm_name, cdm_businessprocesstype, cdm_companyid.cdm_companycode |
| Forretningsprocesopgave | cdm_taskid |
| Virksomhedsenhed | |
| Kontrollisteskabelonhoved | cdm_businessprocesstype, cdm_name, cdm_genericsubtype |
| Tjeklisteskabelonopgave | cdm_taskid |
| Virksomhed | cdm_companycode |
| Fast lønstruktur | cdm_name, cdm_company.cdm_companycode |
| Kompensationsgitter | cdm_name, cdm_companyid.cdm_companycode |
| Kompensationsniveau | cdm_name |
| Kompensation - lønfrekvens | cdm_name, cdm_companyid.cdm_companycode |
| Opsætning af kompensationsreferencepunkt | cdm_name, cdm_companyid.cdm_companycode |
| Opsætningslinje for kompensationsreferencepunkt | cdm_name, cdm_referencepointsetupid.cdm_name, cdm_referencepointsetupid.cdm_companyid.cdm_companycode |
| Kompensationsområde | cdm_name |
| Kompensationsstruktur | cdm_compensationlevelid.cdm_name, cdm_referencepointid.cdm_name, cdm_referencepointid.cdm_referencepointsetupid.cdm_name, cdm_referencepointid.cdm_referencepointsetupid.cdm_companyid.cdm_companycode, cdm_companyid.cdm_companycode, cdm_compensationgridid.cdm_name, cdm_compensationgridid.cdm_companyid.cdm_companycode |
| Variabel kompensationsplan | cdm_name, cdm_companyid.cdm_companycode |
| Niveau i variabel kompensationsplan | cdm_companyid.cdm_companycode, cdm_compensationvariableplanid.cdm_name, cdm_compensationvariableplanid.cdm_companyid.cdm_companycode, cdm_compensationlevelid.cdm_name |
| Type af variabel kompensationsplan | cdm_name, cdm_companyid.cdm_companycode |
| Valuta | isocurrencycode |
| Afdeling | cdm_departmentnumber |
| Ansættelse | cdm_employmentstartdate, cdm_workerid.cdm_workernumber, cdm_companyid.cdm_companycode |
| Etnisk oprindelse | cdm_name |
| Hændelse for fast løn | cdm_name, cdm_companyid.cdm_companycode |
| Job | cdm_name |
| Jobfunktion | cdm_name |
| Stilling | cdm_jobpositionnumber |
| Stillingsdimension | cdm_jobpositionid.cdm_jobpositionnumber, cdm_companyid.cdm_companycode |
| Jobtype | cdm_name |
| Sprog | cdm_name |
| Orlovsbanktransaktion | cdm_transactiondate, cdm_transactiontype, cdm_transactionnumber, cdm_leavetypeid.cdm_type, cdm_leavetypeid.cdm_companyid.cdm_companycode, cdm_companyid.cdm_companycode, cdm_workerid.cdm_workernumber |
| Orlovstilmelding | cdm_startdate, cdm_leaveplanid.cdm_name, cdm_leaveplanid.cdm_companyid.cdm_companycode, cdm_companyid.cdm_companycode, cdm_workerid.cdm_workernumber |
| Orlovsplan | cdm_name, cdm_companyid.cdm_companycode |
| Orlovsanmodning | cdm_leaverequestnumber, cdm_companyid.cdm_companycode |
| Detaljer om orlovsanmodning | cdm_leavedate, cdm_leavetypeid.cdm_type, cdm_leavetypeid.cdm_companyid.cdm_companycode, cdm_leaverequestid.cdm_leaverequestnumber, cdm_leaverequestid.cdm_companyid.cdm_companycode |
| Orlovstype | cdm_type, cdm_companyid.cdm_companycode |
| Orlovstypens årsagskode | cdm_reasoncodeid.cdm_name, cdm_typeid.cdm_type, cdm_typeid.cdm_companyid.cdm_companycode |
| Overskrift for onboardproces | cdm_processheaderid.cdm_processid |
| Organisation | |
| Betalingscyklus | cdm_name |
| Lønperiode | cdm_periodstartdate, cdm_paycycleid.cdm_name, cdm_periodenddate |
| Lønkode | cdm_name |
| Lønpositionsdetalje | cdm_validfrom, cdm_validto, cdm_position.cdm_jobpositionnumber |
| Udstedende organ for personidentifikation | cdm_name |
| Stillingstype | cdm_name |
| Arbejdertildeling til stilling | cdm_validfrom, cdm_jobpositionid.cdm_jobpositionnumber |
| Årsagskode | cdm_name |
| Kompetencetype | cdm_name |
| Skatteområde | cdm_stateorprovince, cdm_name, cdm_countryorregion, cdm_county, cdm_city |
| Team | azureactivedirectoryobjectid, membershiptype |
| Stilling | cdm_name |
| User | azureactivedirectoryobjectid |
| Fordelingsregel | cdm_name, cdm_companyid.cdm_companycode |
| Veteranstatus | cdm_name |
| Arbejdskalender | cdm_name, cdm_companyid.cdm_companycode |
| Arbejdskalenderdag | cdm_calendardate, cdm_companyid.cdm_companycode, cdm_workcalendarid.cdm_name, cdm_workcalendarid.cdm_companyid.cdm_companycode |
| Arbejdskalendertilmelding | cdm_employmentid.cdm_employmentstartdate, cdm_employmentid.cdm_workerid.cdm_workernumber, cdm_employmentid.cdm_companyid.cdm_companycode |
| Arbejdskalenderfridag | cdm_name |
| Ferielinje i arbejdskalender | cdm_holidaydate, cdm_workcalendarholidayid.cdm_name |
| Tidsinterval i arbejdskalender | cdm_starttime, cdm_workcalendardayid.cdm_calendardate, cdm_workcalendardayid.cdm_companyid.cdm_companycode, cdm_workcalendardayid.cdm_workcalendarid.cdm_name, cdm_workcalendardayid.cdm_workcalendarid.cdm_companyid.cdm_companycode, cdm_companyid.cdm_companycode, cdm_workcalendarid.cdm_name, cdm_workcalendarid.cdm_companyid.cdm_companycode |
| Arbejdstråd | cdm_workernumber |
| Arbejderadresse | cdm_addressnumber, cdm_addresstype, cdm_workerid.cdm_workernumber |
| Arbejderbankkonto | cdm_accountidentification, cdm_workerid.cdm_workernumber |
| Arbejders faste løn | cdm_linenumber, cdm_effectivedate, cdm_companyid.cdm_companycode, cdm_positionid.cdm_jobpositionnumber, cdm_workerid.cdm_workernumber, cdm_eventid.cdm_name, cdm_eventid.cdm_companyid.cdm_companycode, cdm_planid.cdm_name, cdm_planid.cdm_company.cdm_companycode |
| Personidentifikationsnummeret for arbejder | cdm_identificationnumber, cdm_workerid.cdm_workernumber, cdm_identificationtypeid.cdm_name |
| Personidentifikationstype for arbejder | cdm_name |
| Arbejders personlige oplysninger | cdm_workerid.cdm_workernumber |