Ressources Humaines Core HR et Service Commun de Données CDS

    Core HR and Common Data Service par @Microsoft

    Core HR utilise Common Data Service pour permettre des scénarios d’extensibilité et d’intégration.

    @Thierry : Comme je le dis souvent, l’intégration avec les autres solutions de Microsoft comme Flow, PSA, FS, FO, BC, Forms, PowerApps,… ou externes est devenu quasi quotidienne, et il est important de se tenir informé des possibilités existantes dans cet écosystème.

    Pour plus d’informations sur le service de données commun CDS, voir Qu’est-ce qu’un service de données commun CDS .

    Important

    La version précédente du Service commun de données (1.0) est en cours d’abandon. Le 15 avril 2019, l’intégration entre les RH de base et le Service commun de données (1.0) sera désactivée. Pour plus d’informations sur la mise à niveau, voir Mise à niveau vers le service de données commun.

    Les entités RH de base suivantes sont disponibles dans le Service commun de données :

    Benefit entities

    Benefit calculation frequency

    FieldsData typeRequiredSearchable
    DescriptionTextX
    Frequency ControlOption setXX
    Is ImmutableTwo optionsX
    NameTextXX

    Benefit calculation rate

    FieldsData typeRequiredSearchable
    DescriptionTextX
    NameTextXX
    TierTypeOption setXX

    Benefit calculation rate detail

    FieldsData typeRequiredSearchable
    Benefit Calculation Rate Detail NumberTextXX
    Calculation Rate IDLookupXX
    Contribution MethodOption SetXX
    EffectiveDate OnlyXX
    Employer ContributionDecimal numberX
    ExpirationDate OnlyXX
    WorkerDeductionDecimal numberX

    Benefit type

    FieldsData typeRequiredSearchable
    ConcurrentEnrollmentOption setX
    DescriptionTextX
    NameTextXX
    PayrollCategoryOption setX

    Benefit plan

    FieldsData typeRequiredSearchable
    Arrear Limit MethodOption setX
    Benefit TypeLookupXX
    Contribution Limit MethodOption setX
    Contribution MethodOption setX
    CurrencyLookupX
    Deduction PriorityWhole NumberX
    Default Contribution Limit AmountCurrencyX
    Default Contribution Limit Amount (Base)CurrencyX
    Default Contribution Limit PeriodOption setX
    Default Deduction Limit AmountCurrencyX
    Default Deduction Limit Amount (Base)CurrencyX
    Default Deduction Limit PeriodOption setX
    DescriptionTextX
    Exchange RateDecimal NumberX
    Is Additional Payroll RunTwo OptionsX
    Is Affordable Care Act ReportableTwo OptionsX
    Is Arrear GeneratedTwo OptionsX
    Is Gross UpTwo OptionsX
    Is PrimaryTwo OptionsX
    NameTextXX
    Payroll ImpactOption setX
    Retirement TypeOption setX

    Employment entity

    FieldsData typeRequiredSearchable
    Adjusted worker start dateDate and TimeX
    CompanyLookupXX
    Employer Unit of Notice AmountDecimal NumberX
    Employer Unit of NoticeOption SetX
    Employment End DateDate and TimeX
    Employment NumberTextXX
    Employment Start DateDate and TimeX
    Last Date WorkedDate and TimeX
    Transition DateDate and TimeX
    Valid FromDate and TimeXX
    Valid ToDate and TimeX
    WorkerLookupXX
    Worker Notice AmountDecimal NumberX
    Workers Start DateDate and TimeX
    Worker TypeOption SetXX
    Worker Unit of NoticeOption SetX

    Worker entities

    Ethnic origin

    FieldsData typeRequiredSearchable
    DescriptionTextX
    Ethnic Origin NameTextXX

    Language

    FieldsData typeRequiredSearchable
    DescriptionTextX
    Language NameTextXX

    Veteran status

    FieldsData typeRequiredSearchable
    DescriptionTextX
    Is Protected VeteranTwo OptionX
    Language NameTextXX

    Worker

    FieldsData typeRequiredSearchable
    BirthdateDate OnlyX
    DescriptionTextX
    Email Address 1EmailX
    Email Address 2EmailX
    Facebook IdentityTextX
    First NameTextX
    Full NameTextX
    GenderOption SetX
    GenerationTextX
    Is Email Contact AllowedTwo OptionsX
    Is Phone Contact AllowedTwo OptionsX
    Last NameTextX
    LinkedIn IdentityTextX
    ManagerLookupX
    Middle NameTextX
    Mobile PhonePhoneX
    Office Graph IdentifierTextX
    Primary Email AddressEmailX
    Primary TelephonePhoneX
    ProfessionTextX
    Social Network 1Option SetX
    Social Network 2Option SetX
    Social Network Identity 1TextX
    Social Network Identity 2TextX
    SourceOption SetXX
    StatusOption SetXX
    Telephone 1PhoneX
    Telephone 2PhoneX
    Telephone 3PhoneX
    Twitter IdentityTextX
    UserLookupX
    Website URLURLX
    Worker NumberTextXX
    Worker TypeOption SetXX
    Yomi First NameTextX
    Yomi Full NameTextX
    Yomi Last NameTextX
    Yomi Middle NameTextX

    Worker address

    FieldsData typeRequiredSearchable
    Address NumberTextXX
    Address TypeOption SetXX
    CityTextX
    Country or RegionTextX
    CountyTextX
    FaxPhoneX
    Is PreferredTwo OptionsX
    LatitudeDecimal NumberX
    Line 1TextX
    Line 2TextX
    Line 3TextX
    LongitudeDecimal NumberX
    Postal CodeTextX
    Post Office BoxTextX
    Shipping Method CodeWhole NumberX
    State or ProvinceTextX
    Telephone 1PhoneX
    Telephone 2PhoneX
    Telephone 3PhoneX
    UPS ZoneTextX
    UTC OffsetWhole NumberX
    WorkerLookupXX

    Worker personal detail

    FieldsData typeRequiredSearchable
    Birth CityTextX
    Birth Country or RegionOption SetX
    BirthdateDate OnlyX
    Citizenship Country or RegionOption SetX
    Deceased DateDate OnlyX
    Disabled Veteran Verification DateDate OnlyX
    EducationTextX
    Ethnic OriginLookupX
    ExpatriateEndDateDate OnlyX
    ExpatriateStartDateDate OnlyX
    Father Birth Country or RegionOption SetX
    GenderOption SetX
    Is DisabledTwo OptionsX
    Is Disabled VeteranTwo OptionsX
    Is Expatriate Ruling ApplicableTwo OptionsX
    Is Full-Time StudentTwo OptionsX
    Marital StatusOption SetX
    Military Service End DateDate OnlyX
    Military Service Start DateDate OnlyX
    Mother Birth Country or RegionOption SetX
    Nationality Country or RegionOption SetX
    Native LanguageLookupX
    Number of DependentsWhole Number
    Veteran StatusLookupX
    WorkerLookupXX
    Worker Personal Detail NumberTextXX

    Worker bank account

    FieldsData typeRequiredSearchable
    Account HolderTextX
    Account IdentificationTextX
    Address DescriptionTextX
    Bank Account TypeOption SetX
    Bank Location CodeTextX
    Branch NameTextX
    Branch NumberTextX
    CityTextX
    Country or RegionTextX
    CountyTextX
    DescriptionTextX
    District NameTextX
    EmailTextX
    ExtensionTextX
    FaxTextX
    IBANTextX
    Line 1TextX
    Line 2TextX
    Line 3TextX
    Mobile PhoneTextX
    Name of PersonTextX
    Postal CodeTextX
    Post Office BoxText
    Routing NumberTextX
    Routing Number TypeOption SetX
    State or ProvinceTextX
    SWIFT CodeTextX
    TelephoneTextX
    Telex NumberTextX
    Website URLTextX
    WorkerLookupXX
    Worker Bank Account NumberTextX
    Worker Bank Account NumberTextXX

    Worker fixed compensation

    FieldsData typeRequiredSearchable
    CompanyLookupXX
    Compensation TypeOption SetX
    CurrencyLookupX
    Effective DateDate OnlyX
    EventLookupXX
    Exchange RateDecimal NumberX
    Expiration DateDate OnlyX
    Line NumberDecimal NumberX
    Pay FrequencyLookupXX
    Pay RateCurrencyX
    Pay Rate (Base)CurrencyX
    PlanLookupXX
    PositionLookupXX
    Process TypeOption SetXX
    Reference Point Setup LineLookupX
    WorkerLookupXX
    Worker Fixed Compensation NumberTextXX

    Worker person identification number

    FieldsData typeRequiredSearchable
    DescriptionTextX
    Entry TypeTextX
    Expiration DateDate OnlyX
    Identification NumberTextXX
    Identification TypeLookupXX
    Is PrimaryTwo OptionsX
    Issue DateDate OnlyX
    Issuing AgencyLookupXX
    WorkerLookupXX

    Position entities

    Job position

    FieldsData typeRequiredSearchable
    ActivationDate and TimeX
    Available for AssignmentDate and TimeX
    DepartmentLookupX
    DescriptionTextX
    Full Time EquivalentDecimal NumberX
    JobLookupXX
    Job Position NumberTextXX
    Parent Job PositionLookupX
    Position TypeLookupX
    RetirementDate and TimeX
    TitleOption SetX
    Valid FromDate and TimeXX
    Valid ToDate and TimeX

    Position type

    FieldsData typeRequiredSearchable
    ClassificationOption SetX
    DescriptionTextX
    Position Type NameTextXX

    Position worker assignment

    FieldsData typeRequiredSearchable
    Job PositionLookupXX
    Position Worker Assignment NumberTextXX
    Valid FromTextXX
    Valid ToX
    WorkerXX

    Job entities

    Job

    FieldsData typeRequiredSearchable
    Allow unlimited positionsTwo OptionsX
    Default Full Time EquivalentDecimal NumberX
    DescriptionTextX
    Job DescriptionTextX
    Job FunctionLookupX
    Job TypeLookupX
    Maximum Number of PositionsWhole NumberX
    NameTextXX
    TitleOption SetX
    Valid FromDate and TimeXX
    Valid ToDate and TimeX

    Job function

    FieldsData typeRequiredSearchable
    DescriptionTextXX
    Job Function NameTextXX

    Job type

    FieldsData typeRequiredSearchable
    DescriptionTextXX
    Exempt StatusOption SetXX
    Job Type NameTextXX

    Leave and absence entities

    Leave enrollment

    FieldsData typeRequiredSearchable
    Accrual Date BasisDate OnlyXX
    Accrual Start DateDate OnlyXX
    Custom DateDate OnlyXX
    Is Accrual SuspendedTwo OptionsX
    LeaveEnrollmentNumberTextXX
    Leave PlanLookupXX
    Start DateDate OnlyXX
    Tier BasisOption SetXX
    WorkerLookupXX

    Leave bank transaction

    FieldsData typeRequiredSearchable
    AmountDecimal NumberXX
    CompanyLookupXX
    Leave Bank Transaction NumberTextXX
    Leave PlanLookupX
    Leave TypeLookupXX
    Transaction DateDate OnlyXX
    Transaction NumberDecimal NumberXX
    Transaction TypeOption SetXX
    WorkerLookupXX

    Leave plan

    FieldsData typeRequiredSearchable
    Accrual FrequencyOption SetXX
    CompanyLookupXX
    DescriptionTextX
    Leave TypeLookupXX
    NameTextXX
    Start DateDate OnlyXX

    Leave request

    FieldsData typeRequiredSearchable
    CommentTextXX
    CompanyLookupXX
    Leave Request NumberTextX
    Request DateDate and TimeXX
    StatusOption SetXX
    WorkerLookupXX

    Leave request detail

    FieldsData typeRequiredSearchable
    AmountDecimal NumberXX
    Leave DateDate and TimeXX
    Leave RequestLookupXX
    Leave Request Detail NumberTextXX
    Leave TypeLookupXX

    Leave type

    FieldsData typeRequiredSearchable
    CompanyLookupXX
    DescriptionTextX
    Earning CodeLookupX
    Leave Type NameTextXX

    Work calendar

    FieldsData typeRequiredSearchable
    CompanyLookupXX
    DescriptionTextX
    NameTextXX

    Work calendar day

    FieldsData typeRequiredSearchable
    Calendar DateDate OnlyXX
    CompanyLookupX
    StatusTextX
    Work CalendarLookupXX
    Work Calendar Day NumberTextXX

    Work calendar holiday

    FieldsData typeRequiredSearchable
    NameTextX
    DescriptionTextXX

    Work calendar holiday line

    FieldsData typeRequiredSearchable
    Holiday DateDate OnlyXX
    NameTextX
    Work Calendar HolidayLookupXX
    Work Calendar Holiday Line NumberTextXX

    Work calendar time interval

    FieldsData typeRequiredSearchable
    CompanyLookupX
    End TimeWhole NumberX
    Start TimeWhole NumberX
    Work CalendarLookupXX
    Work Calendar DayLookupXX
    Work Calendar Time Interval NumberTextXX

    Organization entities

    Company

    FieldsData typeRequiredSearchable
    Company codeTextXX
    NameTextXX

    Department

    FieldsData typeRequiredSearchable
    Department NumberTextXX
    DescriptionTextX
    NameTextXX
    Parent DepartmentLookupX

    Currency

    FieldsData typeRequiredSearchable
    Currency CodeTextXX
    Currency NameTextXX
    Currency PrecisionWhole NumberXX
    Currency SymbolTextXX
    Entity ImageImage
    Exchange RateDecimal NumberXX
    OrganizationLookupXX
    StatusOption SetX

    Payroll entities

    Pay cycle

    FieldsData typeRequiredSearchable
    DescriptionTextXX
    FrequencyOption SetXX
    NameTextXX

    Pay period

    FieldsData typeRequiredSearchable
    Default Payment DateDate OnlyX
    DescriptionTextX
    Pay CycleLookXX
    Pay Period NumberTextXX
    Period End DateDate OnlyXX
    Period Start DateDate OnlyXX
    StatusOption SetX

    Payroll earning code

    FieldsData typeRequiredSearchable
    DescriptionTextXX
    Include in Payment TypeOption SetXX
    Is ProductiveTwo OptionsXX
    NameTextX
    Quantity UnitOption SetX
    Track FMLA HoursTwo OptionsX

    Tax region

    FieldsData typeRequiredSearchable
    CityTextX
    Country or RegionTextX
    CountyTextX
    NameTextXX
    State or ProvinceTextX

    Benefit calculation frequency pay period

    FieldsData typeRequiredSearchable
    Benefit Calculation FrequencyLookupXX
    Benefit Calculation Frequency Pay Period NumberTextXX
    Pay PeriodLookupXX

    Bank account disbursement

    FieldsData typeRequiredSearchable
    AmountCurrencyX
    Amount (Base)CurrencyX
    Bank AccountLookupXX
    Bank Account Disbursement NumberTextXX
    CompanyLookupXX
    CurrencyLookupX
    Exchange RateDecimal NumberX
    Is RemainderTwo OptionsX
    PriorityWhole NumberX

    Person identification issuing agency

    FieldsData typeRequiredSearchable
    Address DescriptionTextX
    Address Line 1TextX
    Address Line 2TextX
    Address Line 3TextX
    CityTextX
    Country or RegionOption SetX
    CountyTextX
    DescriptionTextX
    EmailTextX
    ExtensionTextX
    FaxTextX
    Issuing Agency NameTextXX
    Mobile PhoneTextX
    PageTextX
    Postal CodeTextX
    Post Office BoxTextX
    SMSTextX
    State or ProvinceTextX
    TelephoneTextX
    TelexTextX
    Website URLTextX

    Worker person identification type

    FieldsData typeRequiredSearchable
    Allowed ValuesOption SetX
    Country or RegionTextX
    DescriptionTextX
    Fixed LengthWhole NumberX
    Identification Number FormatTextX
    TypeOption SetX
    Worker Person Identification TypeTextXX

    Fixed compensation entities

    Compensation fixed plan

    FieldsData typeRequiredSearchable
    CompanyLookupXX
    Compensation GridLookupX
    CurrencyLookupXX
    DescriptionTextXX
    Effective DateDate OnlyXX
    Expiration DateDate OnlyXX
    Hire RuleOption SetXX
    NameTextXX
    Out of Range ToleranceOption SetXX
    Pay FrequencyLookupXX
    Recommendation AllowedTwo OptionsXX
    Reference Point Line SetupLookupX
    TypeOption SetXX

    Compensation grid

    FieldsData typeRequiredSearchable
    CompanyLookupXX
    CurrencyLookupX
    DescriptionTextXX
    Effective DateDate OnlyX
    Expiration DateDate OnlyX
    NameTextXX
    Reference Point SetupLookupXX
    TypeOption SetXX

    Compensation level

    FieldsData typeRequiredSearchable
    DescriptionTextX
    NameTextXX
    TypeOption SetXX

    Compensation pay frequency

    FieldsData typeRequiredSearchable
    Annual Conversion FactorDecimal NumberX
    CompanyLookupXX
    DescriptionTextX
    Hourly Conversion FactorDecimal NumberX
    Monthly Conversion FactorDecimal NumberX
    NameTextXX
    PeriodOption SetX
    Weekly Conversion FactorOption SetX

    Compensation reference point setup

    FieldsData typeRequiredSearchable
    CompanyLookupXX
    Compensation TypeOption SetXX
    DescriptionTextXX
    NameTextXX

    Compensation reference point setup line

    FieldsData typeRequiredSearchable
    CompanyLookupXX
    DescriptionTextXX
    Line NumberDecimal NumberXX
    NameTextXX
    Reference Point SetupLookupXX

    Compensation region

    FieldsData typeRequiredSearchable
    DescriptionTextXX
    NameTextXX

    Compensation structure

    FieldsData typeRequiredSearchable
    AmountCurrencyX
    Amount BaseCurrencyX
    CompanyLookupXX
    Compensation Structure NumberTextXX
    CurrencyLookupX
    Exchange RateDecimal NumberX
    GridLookupXX
    LevelLookupXX
    Reference PointLookupXX
    Reference Point Line SetupLookupXX

    Fixed compensation event

    FieldsData typeRequiredSearchable
    CompanyLookupXX
    DescriptionTextXX
    Event TypeOption SetXX
    Is ActiveTwo OptionsX
    NameTextXX

    @Thierry, ma partie préférée de cette article « Modèles de relations entre entités » , très rare de trouver ce type d’informations….

    Worker

    Worker

    Job and Job Position

    Job and Job Position

    Benefits

    Benefits

    Compensation

    Compensation

    Leave

    Leave

    Work Calendar

    Work Calendar

      Leave a Reply

      Ce site utilise Akismet pour réduire les indésirables. En savoir plus sur comment les données de vos commentaires sont utilisées.

      error: