Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
HDL load error - Date effective related - (WorkTerms) - Related Tables? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HDL load error - Date effective related - (WorkTerms) - Related Tables?

Received Response
21
Views
2
Comments
edited Jul 31, 2020 6:47PM in HCM Integrations 2 comments

Summary

HDL load error - Date effective related - (WorkTerms) - Related Tables?

Content

Hi Forum:

Ahead of Assignment in Worker BO hierarchy is WorkTerms (Employement Terms).   As I debug an HDL load issue, can anyone point the HCM table that may hold an “Effective Date”?    I was assuming PER_ALL_ASSIGNMENTS_M was the one and only.

 

METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|EffectiveEndDate|PersonId|SourceSystemId|SourceSystemOwner|ActionCode

MERGE|WorkTerms|300000082698623|100000033443985|Y|1|2020/07/31|4712/12/31|100000033414675|WTM852947010|PSFT|ASG_CHANGE                                                                                                                                                                               

METADATA|Assignment|FLEX:PER_ASG_DF|bidCode(PER_ASG_DF=Global Data Elements)|skillCode(PER_ASG_DF=Global Data Elements)|AssignmentId|WorkTermsAssignmentId|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|EffectiveEndDate|PersonId|SourceSystemId|SourceSystemOwner|ActionCode               

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!