stage active {
  # Oracle nests employment under a work relationship, and the assignments under that. The
  # assignment number, the location ids and the reporting line are Oracle's to mint, so the
  # policy writes the shape and lets the connector settle the rest.
  target oracle_fusion.worker {
    personNumber    = worker.employee_id
    firstName       = worker.legal_name.given
    lastName        = worker.legal_name.family
    legislationCode = "US"
    active          = true

    # The mailbox address is the one field genuinely mastered in Entra, so it is read back out
    # of the account this same policy provisions.
    emails = [
      { emailType = "W1", emailAddress = microsoft_entra.mail, primaryFlag = true },
    ]

    workRelationships = [
      {
        legalEmployerName = "Acme Logistics LLC"
        workerType        = "E"
        hireDate          = worker.hire_date

        assignments = each worker.assignments as assignment
          where assignment.status == "Active" {
          assignmentNumber      = assignment.source_id
          assignmentName        = assignment.job.name
          actionCode            = "HIRE"
          businessUnitName      = lookup(table.oracle_business_unit, assignment.business_unit.name)
          jobCode               = assignment.job.code
          locationCode          = assignment.location.code
          defaultExpenseAccount = script.default_expense_account
          primaryFlag           = assignment.is_primary
          effectiveFrom         = assignment.start_date
        }
      },
    ]

    roles = ["Employee"]
  }
}