For more information, please refer to this announcement explaining best practices for getting answers to questions.
HDL load error - Date effective related - (WorkTerms) - Related Tables?
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