Deila með


Skilgreina samþættingu við Dataverse töflur

Til að samþætta Microsoft Dynamics 365 Human Resources við Dataverse geturðu notað Data Integrator. Mannauður-til-sniðmátDataverse gerir gögnum fyrir störf, stöður, starfsmenn og aðra kleift að flæða frá mannauði inn Dataverse í og frá Dataverse inn í mannauð, þannig að skrif eru skrifuð í báðum kerfum.

Kerfiskröfur vegna Human Resources

Samþættingarlausnin krefst eftirfarandi útgáfu af mannauði og Dynamics 365 Finance:

  • Dynamics 365 Finance, útgáfa 7.2 og nýrri
  • Dynamics CRM umhverfi þar sem gagnagrunnur hefur verið búinn til og Dynamics 365-forrit eru leyfð

Sniðmát og verkefni

Fylgið þessum skrefum til að fá aðgang að sniðmátinu Mannauður–til-Fjármál.

  1. Opnaðu Power Apps admin center.
  2. Undir umhverfinu þínu skaltu velja Dynamics 365 Apps og veljasíðan Uppruni forrits á tækjastikunni.
  3. Til setja í embætti the sniðmát, leita að “Dual- skrifa Mannauður†eða fara beint til the hópur stuðningsmanna heimilisfang: https://appsource.microsoft.com/product/dynamics-365/mscrm.hcm_dualwrite.
  4. Eftir að uppsetningu er lokið skaltu opna Dynamics 365 Finance.
  5. Opnið vinnusvæðið Gagnastjórnun .
  6. Veldu Dual Write.
  7. Fylgið ferlinu til að tengja umhverfið fyrir að minnsta kosti eitt fyrirtæki í fyrirtækinu.
  8. Þegar þú hefur lokið við að setja upp tengil í umhverfið þitt Dataverse skaltu velja Nota lausn. Lausninni er beitt og kortlagningin er sett upp í samþættingarforritið.

Nóta

Það eru þrír lausnarpakkar sem þarf fyrir Dual-skrifa Human Resources. Frekari upplýsingar er að finna í Aðskilinn tvískriftarpakki forrita.

Varpanir sniðmáta

Í eftirfarandi sniðmátsvörpunartöflum gefur heiti verkefnisins til kynna einingarnar sem eru notaðar í hverju forriti. Fjármálaeftirlitið er til vinstri og Dataverse til hægri.

Útgreiðslur bankareiknings (Dual-write) til Útgreiðsla bankareiknings

Fjármálafyrirtæki Dataverse tafla
ACCOUNTIDENTIFICATIONID cdm_bankaccountid.cdm_accountidentification
UPPHÆÐ cdm_amount
FORGANGUR cdm_disbursementpriority
PERSONNELNUMBER cdm_bankaccountid.cdm_workerid.cdm_workernumber
AFGANGUR cdm_isremainder

Sundurliðun útreikningshlutfalls fríðinda (tvískrift) til Upplýsingar um útreikningshlutfall fríðinda

Fjármálafyrirtæki Dataverse tafla
FRAMLAG cdm_contributionmethod
SKILVIRKUR cdm_effective
FRAMLAG VINNUVEITANDA cdm_employercontribution
ENDIR cdm_expiration
FRÁDRÁTTUR STARFSMANNS cdm_workerdeduction
HEITI cdm_calculationrateid.cdm_name

Haus útreikningshlutfalls fríðinda í útreikningshlutfall fríðinda

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
HEITI cdm_name
TIERTYPE cdm_tiertype

Ávinningur valkostur til hagsbóta valkostur

Fjármálafyrirtæki Dataverse tafla
TILNEFNINGAR STYRKÞEGA cdm_allowbeneficiarydesignations
ALLOWDEPENDENTCOVERAGE cdm_allowdependentcoverage
BENEFITOPTIONID cdm_name
LÝSING cdm_description
UNDANÞÁGA cdm_iswaived

Gerð fríðinda til Gerð fríðinda

Fjármálafyrirtæki Dataverse tafla
BENEFITTYPEID cdm_name
SAMHLIÐA INNSKRÁNING cdm_concurrentenrollment
LÝSING cdm_description
LAUNAFLOKKUR cdm_payrollcategory

Viðskiptadagatal í viðskiptaferlidagatal

Fjármálafyrirtæki Dataverse tafla
CALENDARID cdm_name
HEITI cdm_calendarname
STARTDATE cdm_startdate
ENDDATE cdm_enddate
ISOPENMÁNUDAGUR cdm_ismondayopen
ISOPENTUESDAY cdm_istuesdayopen
ISOPENMIÐVIKUDAGUR cdm_iswednesdayopen
ISOPENFIMMTUDAGUR cdm_isthursdayopen
ISOPENFRIDAY cdm_isfridayopen
ISOPENLAUGARDAGUR cdm_issaturdayopen
ISOPENSUNNUDAGUR cdm_issundayopen

Viðskiptaferli í haus viðskiptaferlis

Fjármálafyrirtæki Dataverse tafla
PROCESSID cdm_processid
GERÐ FERLIS cdm_processtype
GENERICSUBTYPE cdm_genericsubtype
HEITI cdm_name
LÝSING cdm_description
STAÐA cdm_status
DAGSETNING MARKMIÐS 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

Verkefnaflokkur viðskiptaferlissafns fyrir verkefnahóp viðskiptaferlissafns

Fjármálafyrirtæki Dataverse tafla
GERÐ FERLIS cdm_processtype
HEITI cdm_name
LÝSING cdm_description

Stig viðskiptaferlis að stigi viðskiptaferlis

Fjármálafyrirtæki Dataverse tafla
GERÐ FERLIS cdm_businessprocesstype
HEITI cdm_name
LÝSING cdm_description
RAÐNÚMER cdm_sequencenumber

Verk viðskiptaferlis í verk viðskiptaferlis

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
DUEDATE cdm_duedate
KENNI VERKS cdm_taskid
FYRIRMÆLI cdm_instructions
COMPLETIONDATETIME cdm_completiondatetime
ASSIGNMENTTYPE cdm_assignmenttype
ISVALFRJÁLST cdm_isoptional
HEITI cdm_name
STAÐA 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

Sniðmát viðskiptaferlis í haus gátlistasniðmáts

Fjármálafyrirtæki Dataverse tafla
GERÐ FERLIS cdm_businessprocesstype
GENERICSUBTYPE cdm_genericsubtype
HEITI cdm_name
LÝSING cdm_description
CALENDARID cdm_businessprocesscalendarid.cdm_name
PERSONNELNUMBER cdm_processownerid.cdm_workernumber
ISACTIVE cdm_isactive

Sniðmátsverk viðskiptaferlis í gátlistasniðmátsverkefni

Fjármálafyrirtæki Dataverse tafla
KENNI VERKS cdm_taskid
HEITI cdm_name
TEMPLATEHEADER_PROCESSTYPE cdm_businessprocesstemplateheaderid.cdm_businessprocesstype
TEMPLATEHEADER_GENERICSUBTYPE cdm_businessprocesstemplateheaderid.cdm_genericsubtype
TEMPLATEHEADER_NAME cdm_businessprocesstemplateheaderid.cdm_name
LÝSING cdm_description
DUEDATEOFFSETDAYS cdm_duedateoffsetdays
MENUITEMTYPE cdm_tasklinktype
VALMYNDARATRIÐI 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
ISVALFRJÁLST cdm_isoptional
FYRIRMÆLI cdm_instructions

Útreikningstíðni til fríðindaútreikningstíðni

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
FREQUENCY cdm_name
TÍÐNISTJÓRNUN cdm_frequencycontrol
ÍSÓBREYTANLEGT cdm_isimmutable

Tíðni útreiknings launatímabils til Tíðni fríðindaútreikninga Launatímabil

Fjármálafyrirtæki Dataverse tafla
CALCULATIONFREQUENCYID cdm_benefitcalculationfrequencyid.cdm_name
DAGSETNING TÍMABILS cdm_payperiodid.cdm_periodstartdate
PAYCYCLEID cdm_payperiodid.cdm_paycycleid.cdm_name

Dagatal til vinnudagatals

Fjármálafyrirtæki Dataverse tafla
CALENDARID cdm_name
HEITI DAGATALS cdm_description
WORKCALENDARHOLIDAYID cdm_workcalendarholidayid.cdm_name

Launatafla fastra launa fyrir tilvik fastra launa

Fjármálafyrirtæki Dataverse tafla
AÐGERÐ cdm_name
VIRKUR cdm_isactive
LÝSING cdm_description
GERÐ cdm_eventtype

Launaáætlun föst í launaáætlun

Fjármálafyrirtæki Dataverse tafla
ÁÆTLUN cdm_name
LÝSING cdm_description
GERÐ cdm_type
GILDISTÖKUDAGUR cdm_effectivedate
GILDISTÍMI: cdm_expirationdate
GJALDMIÐILL cdm_transactioncurrencyid.isocurrencycode
GREIÐSLUTÍÐNI cdm_payfrequency.cdm_name
HIRERULE cdm_hirerule
OUTOFRANGETOLERANCE cdm_outofrangetolerance
TILMÆLI. cdm_recommendationallowed
UPPBYGGING LAUNA cdm_compensationgrid.cdm_name
REFPOINTSETUPID cdm_referencepointsetupline.cdm_referencepointsetupid.cdm_name
STÝRIPUNKTUR cdm_referencepointsetupline.cdm_name

Launanet í launanet

Fjármálafyrirtæki Dataverse tafla
GRÍDÓ cdm_name
LÝSING cdm_description
GILDISTÖKUDAGUR cdm_effectivedate
GILDISTÍMI: cdm_expirationdate
REFERENCESETUP cdm_referencepointsetupid.cdm_name
GERÐ cdm_type
GJALDMIÐILL cdm_transactioncurrencyid.isocurrencycode

Starfshlutverk launa í starfshlutverk

Fjármálafyrirtæki Dataverse tafla
JOBFUNCTIONID cdm_name
LÝSING cdm_description

Vinnslugerð uppbótar fyrir vinnslugerð vinnslu

Fjármálafyrirtæki Dataverse tafla
JOBTYPEID cdm_name
LÝSING cdm_description
EXEMPTSTATUS cdm_exemptstatus

Launatíðni launa til launatíðni launa

Fjármálafyrirtæki Dataverse tafla
PAYRATECONVERSION cdm_name
TÍMABIL cdm_period
LÝSING cdm_description
ÁRLEGUR BREYTISTUÐULL cdm_annualconversionfactor
HOURLYCONVERSIONFACTOR cdm_hourlyconversionfactor
MONTHLYCONVERSIONFACTOR cdm_monthlyconversionfactor
WEEKLYCONVERSIONFACTOR cdm_weeklyconversionfactor

Bótasvæði til bótasvæðis

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
STAÐSETNING cdm_name

Launabreytuáætlun V2 í launabreytuáætlun

Fjármálafyrirtæki Dataverse tafla
BREYTILEGUR GRUNDVÖLLUR cdm_awardbasis
ÚTREIKNINGUR VERÐLAUNA cdm_awardbasiscalculation
GERÐ ÚTREIKNINGS cdm_calculationtype
LÝSING cdm_description
ENABLEENROLLMENT cdm_enableenrollment
VIRKJAR STIG cdm_enablelevels
ENABLERECOMMENDATION cdm_enablerecommendation
HIRERULE cdm_hirerule
LEVERAGE100PERCENT cdm_leverage100percent
MIKIL ÁVÖXTUN cdm_leveragemaximum
LÁGMARK VOGUN cdm_leverageminimum
LEVERAGEOVEROBJECTIVE cdm_leverageoverobjective
LVERAGEUNDEROBJECTIVE cdm_leverageunderobjective
PRÓSENTUGRUNNUR cdm_percentofbasis
SVIF cdm_name
VARIABLECOMPENSATIONTYPE cdm_variablecompensationtypeid.cdm_name
UNITCURRENCYCODE transactioncurrencyid.isocurrencycode
UNITRELATIONSHIP cdm_unitrelationship
UNITVALUE cdm_unitvalue
NUMBEROFUNITSREAL cdm_numberofunits
GILDISTÖKUDAGUR cdm_effectivedate
GILDISTÍMI: cdm_expirationdate
VESTINGRULE cdm_vestingruleid.cdm_name
LVERAGETOLERANCEMAX cdm_leveragetolerancemax
LVERAGETOLERANCEMIN cdm_leveragetolerancemin

Gerð launabreytu í áætlunargerð uppbótarbreytu

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
GERÐ cdm_awardtype
VARIABLECOMPENSATIONTYPE cdm_name

Reglur um ávinnslu launa samkvæmt ávinnslureglu

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
ATHUGASEMD cdm_notes
VESTINGRULE cdm_name

Deild V2 til deildar

Fjármálafyrirtæki Dataverse tafla
REKSTRAREININGNÚMER cdm_departmentnumber
HEITI cdm_name
LEITARHEITI cdm_description
PARTYTYPE cdm_partytype

Tvöfalt skattsvæði á skattsvæði

Fjármálafyrirtæki Dataverse tafla
BORG cdm_city
COUNTRYORREGION cdm_countryorregion
SÝSLA cdm_county
RÍKI cdm_stateorprovince
TAXREGIONNAME cdm_name

Tvískiptur skrifari Kennitala starfsmanns á kennitölu starfsmanns

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
TEGUND FÆRSLU cdm_entrytype
GILDISTÍMI: cdm_expirationdate
IDENTIFICATIONNUMBER cdm_identificationnumber
IDENTIFICATIONTYPEID cdm_identificationtypeid.cdm_name
ÍSLAND cdm_isprimary
ÚTGÁFUDAGUR cdm_issuedate
ÚTGÁFUSTOFNUNIN cdm_issuingagencyid.cdm_name
NÚMER STARFSMANNS cdm_workerid.cdm_workernumber

Launaskipulag til launakerfis

Fjármálafyrirtæki Dataverse tafla
UPPHÆÐ cdm_amount
RIST cdm_compensationgridid.cdm_name
LEVELID cdm_compensationlevelid.cdm_name
REFERENCEPOINTLINENUMBER cdm_referencepointid.cdm_linenumber
REFERENCESETUP cdm_referencepointid.cdm_referencepointsetupid.cdm_name
VIÐMIÐUNARPUNKTUR cdm_referencepointid.cdm_name

Að vinna sér inn kóða í launatekjukóða

Fjármálafyrirtæki Dataverse tafla
EARNINGCODE cdm_name
LÝSING cdm_description
INCLUDEINPAYMENTTYPE cdm_includeinpaymenttype
MAGNEINING cdm_quantityunit
TRACKFMLAHOURS cdm_trackfmlahours
ER AFKASTAMIKILL cdm_isproductive

Föst laun starfsmanns í föst laun starfsmanns

Fjármálafyrirtæki Dataverse tafla
COMPENSATIONLEVELID cdm_compensationlevelid.cdm_name
GERÐ cdm_compensationtype
GILDISTÖKUDAGUR cdm_effectivedate
GILDISTÍMI: cdm_expirationdate
LINENUMBER cdm_linenumber
GREIÐSLUTÍÐNI cdm_payfrequencyid.cdm_name
LAUNATAXTI cdm_payrate
ÁÆTLUN cdm_planid.cdm_name
KENNI STÖÐU cdm_positionid.cdm_jobpositionnumber
GERÐ FERLIS cdm_processtype
PERSONNELNUMBER cdm_workerid.cdm_workernumber
AÐGERÐ cdm_eventid.cdm_name
ÞREP cdm_referencepointsetuplineid.cdm_name
REFPOINTSETUPID cdm_referencepointsetuplineid.cdm_referencepointsetupid.cdm_name

Atvinna á hvert fyrirtæki til Atvinna

Fjármálafyrirtæki Dataverse tafla
DAGSETNING RÁÐNINGAR cdm_employmentenddate
PERSONNELNUMBER cdm_workerid.cdm_workernumber
STARFSBYRJUNARDAGSETNING cdm_employmentstartdate
GERÐ STARFSMANNS cdm_workertype
DIMENSIONDISPLAYVALUE cdm_dimensiondisplayvalue
ADJUSTEDWORKERSTARTDATE cdm_adjustedworkerstartdate
TILKYNNING VINNUVEITANDA cdm_employernoticeamount
VINNUVEITANDI TILKYNNING cdm_employerunitofnotice
WORKERUNITOFNOTICE cdm_workerunitofnotice
WORKERNOTICEAMOUNT cdm_workernoticeamount
LASTDATEWORKED cdm_lastdateworked
PROBATIONENDDATE cdm_probationenddate
AÐLÖGUNARDAGUR cdm_transitiondate
TRANSITIONREASONCODENAME cdm_transitionreasoncode.cdm_name
WORKERSTARTDATE cdm_workerstartdate
VALIDTO cdm_validto
VALIDFROM cdm_validfrom

Þjóðernislegur uppruni til þjóðernis

Fjármálafyrirtæki Dataverse tafla
ETHNICORIGINID cdm_name
LÝSING cdm_description

Hópúthlutun í flokksverkefni viðskiptaferlis

Fjármálafyrirtæki Dataverse tafla
HEITI cdm_name
LÝSING cdm_description
ISACTIVE cdm_isactive

Auðkennisgerð fyrir auðkennisgerð starfsmanns

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
IDENTIFICATIONTYPEID cdm_name
ALLOWEDVALUES cdm_allowedvalues
FÖST LENGD cdm_fixedlength
IDENTIFICATIONNUMBERFORMAT cdm_identificationnumberformat

Umboðsskrifstofa sem gefur út auðkenni einstaklinga

Fjármálafyrirtæki Dataverse tafla
NETFANG cdm_email
FRAMLENGING cdm_extension
SÍMBRÉF cdm_fax
ÚTGÁFUSTOFNUN cdm_name
FARSÍMI cdm_mobilephone
VEFFANG cdm_websiteurl
HEITI cdm_description
PAGER cdm_pager
SMS cdm_sms
SÍMI cdm_telephone
TELEXNÚMER cdm_telex
ADDRESSCITY cdm_city
ADDRESSCOUNTY cdm_county
ADDRESSDESCRIPTION cdm_addressdescription
ADDRESSSTATE cdm_stateorprovince
ADDRESSSTREET cdm_street
ADDRESSZIPCODE cdm_postalcode
ADDRESSCOUNTRYREGIONISOCODE cdm_countryregion

Starfsstöður Tvöfalt Skrifa í starfsstöðu

Fjármálafyrirtæki Dataverse tafla
KENNI STÖÐU cdm_jobpositionnumber
VIRKJUN cdm_activation
AVAILABLEFORASSIGNMENT cdm_availableforassignment
COMPENSATIONREGIONID cdm_compensationregionid.cdm_name
DEILDARKENNI cdm_departmentid.cdm_deildarnúmer
LÝSING cdm_description
FULLT STARF cdm_fulltimeequivalent
JOBID cdm_jobid.cdm_name
PARENTPOSITIONID cdm_parentjobpositionid.cdm_jobpositionnumber
POSITIONTYPEID cdm_positiontypeid.cdm_name
STARFSLOK SÖKUM ALDURS cdm_retirement
TITLEID cdm_titleid.cdm_name
VALIDFROM cdm_validfrom
VALIDTO cdm_validto

Verk Tvískrifað í Verk

Fjármálafyrirtæki Dataverse tafla
JOBID cdm_name
LÝSING cdm_description
STARFSLÝSING 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

Tungumálakóðar á tungumál

Fjármálafyrirtæki Dataverse tafla
LANGUAGECODEID cdm_name
LÝSING cdm_description

Leyfi og fjarvistir bankafærslu V2 til að yfirgefa bankafærslu

Fjármálafyrirtæki Dataverse tafla
UPPHÆÐ cdm_amount
LEAVETYPEID cdm_leavetypeid.cdm_type
LEAVEPLANID cdm_leaveplanid.cdm_name
DAGSETNING VIÐSKIPTA cdm_transactiondate
FÆRSLUNÚMER cdm_transactionnumber
PERSONNELNUMBER cdm_workerid.cdm_workernumber
TRANSACTIONTYPE cdm_transactiontype

Skráning í leyfi og fjarvistir V2 til að yfirgefa innritun

Fjármálafyrirtæki Dataverse tafla
STARTDATE cdm_startdate
ENDDATE cdm_enddate
CUSTOMDATE cdm_customdate
ACCRUALSTARTDATE cdm_accrualstartdate
ACCRUALDATEBASIS cdm_accrualdatebasis
ÍSASÖFNUN í bið cdm_isaccrualsuspended
LEAVEPLANID cdm_leaveplanid.cdm_name
ÞREP cdm_tierbasis
PERSONNELNUMBER cdm_workerid.cdm_workernumber

Orlofs- og fjarvistaráætlun V2 til að yfirgefa áætlun

Fjármálafyrirtæki Dataverse tafla
ACCRUALFREQUENCY cdm_accrualfrequency
HEITI cdm_name
LÝSING cdm_description
STARTDATE cdm_startdate
LEAVETYPEID cdm_leavetypeid.cdm_type

Gerð leyfis og fjarvistar til að fara frá

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
GERÐ cdm_type
EARNINGCODEID cdm_earningcodeid.cdm_name

Ástæðukóti orlofs- og fjarvistargerðar til að skilja tegund eftir Ástæðukóti

Fjármálafyrirtæki Dataverse tafla
TEGUND LAUFS cdm_typeid.cdm_type
REASONCODEID cdm_reasoncodeid.cdm_name

Skilja upplýsingar um tímafrestsbeiðni eftir til að skilja eftir upplýsingar um beiðni

Fjármálafyrirtæki Dataverse tafla
UPPHÆÐ cdm_amount
DAGSETNING LEYFIS cdm_leavedate
REQUESTID cdm_leaverequestid.cdm_leaverequestnumber
GERÐ cdm_leavetypeid.cdm_type

Skilja eftir haus beiðni um tímalokun til að skilja beiðni eftir

Fjármálafyrirtæki Dataverse tafla
REQUESTID cdm_leaverequestnumber
DAGSETNING BEIÐNI cdm_requestdate
STAÐA cdm_status
ATHUGASEMD cdm_comment
PERSONNELNUMBER cdm_workerid.cdm_workernumber

Stig að launastigi

Fjármálafyrirtæki Dataverse tafla
GERÐ cdm_type
LÝSING cdm_description
STIG cdm_name

Haus inngönguferlis í haus Onboard Process

Fjármálafyrirtæki Dataverse tafla
PROCESSID cdm_processheaderid.cdm_processid
ONBOARDEDEMPLOYEEPERSONNELNUMBER cdm_onboardedemployeeid.cdm_workernumber
STARFSMENN: cdm_employmentid.cdm_workerid.cdm_workernumber
LEGALENTITYID cdm_employmentid.cdm_companyid.cdm_companycode
STARFSBYRJUNARDAGSETNING cdm_employmentid.cdm_employmentstartdate

Launaferli í launalotu

Fjármálafyrirtæki Dataverse tafla
PAYCYCLEID cdm_name
LÝSING cdm_description
PAYCYCLEFREQUENCY cdm_frequency

Launatímabil til launatímabils

Fjármálafyrirtæki Dataverse tafla
COMMENTS cdm_description
DEFAULTPAYMENTDATE cdm_defaultpaymentdate
PAYCYCLEID cdm_paycycleid.cdm_name
DAGSETNING TÍMABILS cdm_periodenddate
DAGSETNING TÍMABILS cdm_periodstartdate
STAÐA cdm_status

Launaupplýsingar fyrir stöður til Upplýsingar um launastöðu

Fjármálafyrirtæki Dataverse tafla
PAYCYCLEID cdm_paycycle.cdm_name
KENNI STÖÐU cdm_position.cdm_jobpositionnumber
VALIDFROM cdm_validfrom
VALIDTO cdm_validto
ÁRLEGIR REGLULEGIR tímar cdm_annualregularhours
PAIDBYLEGALENTITY cdm_paidby.cdm_companycode

Staðsetning Sjálfgefnar víddir Tvískipt skrifa í vinnslustöðu Vídd stöðu

Fjármálafyrirtæki Dataverse tafla
DIMENSIONDISPLAYVALUE cdm_dimensiondisplayvalue
KENNI STÖÐU cdm_jobpositionid.cdm_jobpositionnumber

Gerð stöðu til Gerð stöðu

Fjármálafyrirtæki Dataverse tafla
POSITIONTYPEID cdm_name
LÝSING cdm_description
FLOKKUN cdm_classification

Verkefni stöðustarfsmanns V2 til Verkefni stöðustarfsmanns

Fjármálafyrirtæki Dataverse tafla
PERSONNELNUMBER cdm_workerid.cdm_workernumber
KENNI STÖÐU cdm_jobpositionid.cdm_jobpositionnumber
VALIDFROM cdm_validfrom
VALIDTO cdm_validto
IsPrimaryPosition cdm_isprimaryposition

Ástæðukóðar fyrir ástæðukóða

Fjármálafyrirtæki Dataverse tafla
REASONCODEID cdm_name
LÝSING cdm_description
ISABSENCE. cdm_isabsenceapplicable
ISUMSÓKN cdm_isapplicationapplicable
SKAÐABÆTUR. cdm_iscompensationapplicable
ISCREATENEWPOSITIONAPPLICABLE cdm_iscreatenewpositionapplicable
ISEDITPOSITIONAPPLICABLE cdm_iseditpositionapplicable
ÍSLAND cdm_ishireapplicable
ISSKILLMAPPINGAPPLICABLE cdm_isskillmappingapplicable
UPPSÖGN. cdm_isterminationapplicable
ISTRANSFERAPPLICABLE cdm_istransferapplicable

Uppsetningarlína tilvísunarpunkts (tvískrift) í uppsetningarlínu tilvísunarpunkts launa

Fjármálafyrirtæki Dataverse tafla
LÝSING cdm_description
LÍN cdm_linenumber
REFPOINTID cdm_name
REFPOINTSETUPID cdm_referencepointsetupid.cdm_name

Uppsetning tilvísunarpunkta í uppsetningu tilvísunarpunkts launa

Fjármálafyrirtæki Dataverse tafla
REFERENCESETUP cdm_name
LÝSING cdm_description
GERÐ cdm_compensationtype

Hæfnisgerðir til hæfnisgerðar

Fjármálafyrirtæki Dataverse tafla
HÆFNI cdm_name
LÝSING cdm_description

Titlar á titil

Fjármálafyrirtæki Dataverse tafla
TITLEID cdm_name

Breytilegt uppbótarstig V2 í uppbótarbreytilegt áætlunarstig

Fjármálafyrirtæki Dataverse tafla
VERÐLAUNAUPPHÆÐ cdm_awardamount
VERÐLAUN cdm_awardpercent
AWARDUNITSREAL cdm_awardunits
COMPENSATIONLEVELID cdm_compensationlevelid.cdm_name
SVIF cdm_compensationvariableplanid.cdm_name

Veteran stöðu til Veteran Status

Fjármálafyrirtæki Dataverse tafla
VETERANSTATUSID cdm_name
LÝSING cdm_description
ISPROTECTEDVETERAN cdm_isprotectedveteran

Innskráningar á vinnudagatal í vinnudagatal

Fjármálafyrirtæki Dataverse tafla
STARTDATE cdm_employmentid.cdm_employmentstartdate
PERSONNELNUMBER cdm_employmentid.cdm_workerid.cdm_workernumber
CALENDARID cdm_workcalendarid.cdm_name
KENNI FYRIRTÆKIS cdm_employmentid.cdm_companyid.cdm_companycode

Vinnudagatal frí til vinnudagatals Holiday

Fjármálafyrirtæki Dataverse tafla
KENNI cdm_name
LÝSING cdm_description

Frílína vinnudagatals í frílínu vinnudagatals

Fjármálafyrirtæki Dataverse tafla
FRÍDAGUR cdm_workcalendarholidayid.cdm_name
HEITI cdm_name
FRÍDAGUR cdm_holidaydate

Starfsmaður til starfsmanns

Fjármálafyrirtæki Dataverse tafla
PERSONNELNUMBER cdm_workernumber
FIRSTNAME cdm_firstname
MIDDLENAME cdm_middlename
EFTIRNAFN cdm_lastname
GERÐ STARFSMANNS cdm_type
STAÐA STARFSMANNS cdm_status
PRIMARYCONTACTEMAIL cdm_primaryemailaddress
PRIMARYCONTACTPHONE cdm_primarytelephone
PRIMARYCONTACTFACEBOOK cdm_facebookidentity
PRIMARYCONTACTTWITTER cdm_twitteridentity
PRIMARYCONTACTLINKEDIN cdm_linkedinidentity
PRIMARYCONTACTURL cdm_websiteurl
GENDER cdm_gender
FÆÐINGARDAGUR cdm_birthdate
HEITI cdm_fullname

Bankareikningar starfsmanns á bankareikning starfsmanns

Fjármálafyrirtæki Dataverse tafla
AUÐKENNING REIKNINGS 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
NÚMER BANKAREIKNINGS cdm_bankaccountnumber
GERÐ BANKAREIKNINGS cdm_bankaccounttype
NETFANG cdm_email
FRAMLENGING cdm_extension
SÍMBRÉF cdm_fax
VEFFANG cdm_websiteurl
FARSÍMI cdm_mobilephone
LEIÐARNÚMER cdm_routingnumber
SÍMI cdm_telephone
TELEXNÚMER cdm_telexnumber
BANKI cdm_iban
SWIFTNO cdm_swiftcode
BANKLOCATIONCODE cdm_banklocationcode
HEITI ÚTIBÚS cdm_branchname
NÚMER ÚTIBÚS cdm_branchnumber
ROUTINGNUMBERTYPE cdm_routingnumbertype
REIKNINGSHAFI cdm_accountholder
NAFN EINSTAKLINGS cdm_nameofperson
HEITI cdm_description
ADDRESSSTREET cdm_line1
ADDRESSSTREETNUMBER cdm_line2

Persónulegar upplýsingar starfsmanns til starfsmanns Persónulegar upplýsingar

Fjármálafyrirtæki Dataverse tafla
PERSONNELNUMBER cdm_workerid.cdm_workernumber
FÆÐINGARDAGUR cdm_birthdate
PERSONBIRTHCITY cdm_birthcity
GENDER cdm_gender
EXPATRIATEENDDATE cdm_expatriateenddate
EXPATRIATESTARTDATE cdm_expatriatestartdate
FATLAÐUR ÖLDUNGUR cdm_isdisabledveteran
LÁTINNDAGS cdm_deceaseddate
DISABLEDVERIFICATIONDATE cdm_disabledveteranverificationdate
MENNTUN cdm_education
ETHNICORIGINID cdm_ethnicoriginid.cdm_name
ÓVIRKT 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
FÆÐINGARLANDIÐ cdm_fatherbirthcountryregion
FÆÐINGARLAND cdm_motherbirthcountryregion
RÍKISFANGCOUNTRYREGION cdm_citizenshipcountryregion
VETERANSTATUSID cdm_veteranstatusid.cdm_name

Póstföng starfsmanns tvískrifuð í aðsetur starfsmanns

Fjármálafyrirtæki Dataverse tafla
PERSONNELNUMBER cdm_workerid.cdm_workernumber
ADDRESSLOCATIONID cdm_addressnumber
ADDRESSLOCATIONROLES cdm_addresstype
SKILVIRKUR cdm_effectivedate
ENDIR 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
ÍSLAND cdm_ispreferred

Tímabil vinnutíma í vinnudagatal

Fjármálafyrirtæki Dataverse tafla
LOKATÍMI cdm_endtime
UPPHAFSTÍMI cdm_starttime
VINNUDAGATALDAGSETNING cdm_workcalendardayid.cdm_calendardate
WORKCALENDARID cdm_workcalendarid.cdm_name
WORKCALENDARID cdm_workcalendardayid.cdm_workcalendarid.cdm_name

Vinnutími að vinnudagatali Dagur

Fjármálafyrirtæki Dataverse tafla
DAGATAL cdm_calendardate
WORKCALENDARID cdm_workcalendarid.cdm_name
VINNUDAGURSKILGREINING cdm_status

Hvað skal hafa í huga við samþættingu

  • Allar breytingar sem gerðar eru á gögnum í öðru hvoru kerfinu verða háðar staðfestingu hins kerfisins. Ef bilun kemur upp verða gögn ekki skrifuð í hvorugu kerfinu.
  • Öll skrif eru háð sjálfgefnum gögnum (ef sérsniðin rökfræði á sér stað í fjármálum).
  • Tvískriftarsamþættingarforritið notar samþættingarlykla til að kortleggja á milli kerfanna tveggja. Stundum er erfitt að velja réttan samþættingarlykil, sérstaklega ef margir samþættingarlyklar uppfylla kröfurnar. Til að hjálpa við þetta val er eftirfarandi tafla listi yfir tillögur að samþættingarlykla fyrir kortanir þínar.
Dataverse tafla Samþættingarlyklar
Bankareikningsgreiðslur cdm_bankaccountid.cdm_accountidentification, cdm_bankaccountid.cdm_workerid.cdm_workernumber, cdm_companyid.cdm_companycode
Útreikningstíðni fríðinda cdm_name
Útreikningsíðni fríðinda á launatímabili cdm_payperiodid.cdm_periodstartdate, cdm_payperiodid.cdm_paycycleid.cdm_name, cdm_benefitcalculationfrequencyid.cdm_name
Hlutfall útreikninga fyrir fríðindi cdm_name
Upplýsingar um hlutfall útreikninga fyrir fríðindi cdm_workerdeduction, cdm_effective, cdm_calculationrateid.cdm_name
Fríðindavalkostur cdm_name
Gerð fríðinda cdm_name
Dagatal viðskiptaferlis cdm_name
Hópverkefni viðskiptaferlis cdm_name
Viðskiptaferlishaus cdm_processid
Verkhópur viðskiptaferlissafns cdm_processtype, cdm_name
Stig viðskiptaferlis cdm_name, cdm_businessprocesstype, cdm_companyid.cdm_companycode
Viðskiptaferli verkefni cdm_taskid
Fyrirtækiseining
Haus gátlistasniðmáts cdm_businessprocesstype, cdm_name, cdm_genericsubtype
Verkefni gátlistasniðmáts cdm_taskid
Fyrirt. cdm_companycode
Fyrirkomulag fastra launa cdm_name, cdm_company.cdm_companycode
Launanet cdm_name, cdm_companyid.cdm_companycode
Launastig cdm_name
Greiðslutíðni launa cdm_name, cdm_companyid.cdm_companycode
Uppsetning á tilvísunarpunkti launa cdm_name, cdm_companyid.cdm_companycode
Setja upp línu tilvísunarpunkts launa cdm_name, cdm_referencepointsetupid.cdm_name, cdm_referencepointsetupid.cdm_companyid.cdm_companycode
Launasvæði cdm_name
Launaskipulag cdm_compensationlevelid.cdm_name, cdm_referencepointid.cdm_name, cdm_referencepointid.cdm_referencepointsetupid.cdm_name, cdm_referencepointid.cdm_referencepointsetupid.cdm_companyid.cdm_company_company.comy d.cdm_name, cdm_compensationgridid.cdm_companyid.cdm_companycode
Fyrirkomulag breytilegra uppbóta cdm_name, cdm_companyid.cdm_companycode
Fyrirkomulagsstig breytilegra uppbóta cdm_companyid.cdm_companycode, cdm_compensationvariableplanid.cdm_name, cdm_compensationvariableplanid.cdm_companyid.cdm_companycode, cdm_compensationlevelid.cdm_name
Fyrirkomulagsgerð breytilegra uppbóta cdm_name, cdm_companyid.cdm_companycode
Gjaldmiðill isocurrencycode
Deild cdm_departmentnumber
Ráðning cdm_employmentstartdate, cdm_workerid.cdm_workernumber, cdm_companyid.cdm_companycode
Þjóðernisuppruni cdm_name
Fast launatilvik cdm_name, cdm_companyid.cdm_companycode
Vinnsla cdm_name
Starfshlutverk cdm_name
Staða starfs cdm_jobpositionnumber
Vídd stöðu starfs cdm_jobpositionid.cdm_jobpositionnumber, cdm_companyid.cdm_companycode
Starfsgerð cdm_name
Tungumál cdm_name
Orlofsbankafærsla cdm_transactiondate, cdm_transactiontype, cdm_transactionnumber, cdm_leavetypeid.cdm_type, cdm_leavetypeid.cdm_companyid.cdm_companycode, cdm_companyid.cdm_companycode, cdm_workerid.cdm_
Orlofsskráning cdm_upphafsdagur, cdm_leaveplanid.cdm_name, cdm_leaveplanid.cdm_companyid.cdm_companycode, cdm_companyid.cdm_companycode, cdm_workerid.cdm_workernumber
Leyfisáætlun cdm_name, cdm_companyid.cdm_companycode
Orlofsbeiðni cdm_leaverequestnumber, cdm_companyid.cdm_companycode
Upplýsingar um orlofsbeiðni cdm_leavedate, cdm_leavetypeid.cdm_type, cdm_leavetypeid.cdm_companyid.cdm_companycode, cdm_leaverequestid.cdm_leaverequestnumber, cdm_leaverequestid.cdm_companyid.cdm_company
Gerð leyfis cdm_type, cdm_companyid.cdm_companycode
Ástæðukóði orlofsgerðar cdm_reasoncodeid.cdm_name, cdm_typeid.cdm_type, cdm_typeid.cdm_companyid.cdm_companycode
Innbyggður ferlihaus cdm_processheaderid.cdm_processid
Stofnun/fyrirtæki
Greiðsluferli cdm_name
Launatímabil cdm_periodstartdate, cdm_paycycleid.cdm_name, cdm_periodenddate
Tekjukóði launa cdm_name
Upplýsingar um launastöðu cdm_validfrom, cdm_validto, cdm_position.cdm_jobpositionnumber
Útgáfustofnun persónuskilríkja cdm_name
Gerð stöðu cdm_name
Stöðuúthlutun starfskrafts cdm_validfrom, cdm_jobpositionid.cdm_jobpositionnumber
Ástæðukóði cdm_name
Gerð hæfni cdm_name
Skattumdæmi cdm_stateorprovince, cdm_name, cdm_countryorregion, cdm_county, cdm_city
Teymi Azureactivedirectoryobjectid, aðildargerð
Titill cdm_name
Notandi azureactivedirectoryobjectid
Veitiregla cdm_name, cdm_companyid.cdm_companycode
Uppgjafahermaður cdm_name
Vinnudagatal cdm_name, cdm_companyid.cdm_companycode
Dagur í vinnudagatali cdm_calendardate, cdm_companyid.cdm_companycode, cdm_workcalendarid.cdm_name, cdm_workcalendarid.cdm_companyid.cdm_companycode
Skráning vinnudagatals cdm_employmentid.cdm_employmentstartdate, cdm_employmentid.cdm_workerid.cdm_workernumber, cdm_employmentid.cdm_companyid.cdm_companycode
Frídagur í vinnudagatali cdm_name
Frídagslína í vinnudagatali cdm_holidaydate, cdm_workcalendarholidayid.cdm_name
Tímabil vinnudagatals cdm_starttime, cdm_workcalendardayid.cdm_calendardate, cdm_workcalendardayid.cdm_companyid.cdm_companycode, cdm_workcalendardayid.cdm_workcalendarid.cdm_name, cdm_workcalendardayid.comrid.comrid_work _fyrirtækjanúmer.cdm_fyrirtækjakóði, cdm_vinnudagatal.cdm_nafn, cdm_vinnudagatal.cdm_fyrirtækisnúmer.cdm_fyrirtækiskóði
Vinna cdm_workernumber
Aðsetur starfskrafts cdm_addressnumber, cdm_addresstype, cdm_workerid.cdm_workernumber
Bankareikningur starfskrafts cdm_accountidentification, cdm_workerid.cdm_workernumber
Föst laun starfskrafts cdm_linenumber, cdm_effectivedate, cdm_companyid.cdm_companycode, cdm_positionid.cdm_jobpositionnumber, cdm_workerid.cdm_workernumber, cdm_eventid.cdm_name, cdm_eventid.cdm_eventid.cdm_company_company.cdm_company. planid.cdm_company.cdm_companycode
Kennitala starfskrafts cdm_auðkennisnúmer, cdm_workerid.cdm_workernumber, cdm_identificationtypeid.cdm_name
Persónukennisgerð starfskrafts cdm_name
Persónuupplýsingar starfskrafts cdm_workerid.cdm_workernumber