Is there a data dictionary for the e-RS AG01 extract?

e-Referral Service (e-RS)
1

Hi all,

As per the title, really. Specifically, what I’m interested in is:

  • Is it correct to say that you can identify that an A&G request has concluded by looking for ADVICE_AND_GUIDANCE_CLOSED in the Activity Type field?
  • Is it correct to say that, for the Activity Type ADVICE_AND_GUIDANCE_CLOSED, the only possible Outcome values are ADVICE_CONVERTED_BY_PROVIDER or ADVICE_ENDED?
  • Is Activity ID an auto-incrementing number that can be relied upon to only ever increase with each new record that gets added?

Many thanks,

Chris

2

Hi @chris.pursey -

No data dictionary but if you access the e-RS help from the professional web app, on INT, we have a page which includes field definitions.

Thanks,
Z.

1 Like
3

Hi @chris.pursey,

We would advice not making any assumptions about how the Activity ID is generated.

If you can detail how you plan to use it then we may be able to provide further guidance.

Thanks.

4

Thanks @zubeir.tai and @adam.oldfield.

I would like to identify any A&G cases that have been closed since the last time I looked at the AG01 extract.

I had considered doing this by finding any new rows where both conditions are met:

  • Activity Type = ADVICE_AND_GUIDANCE_CLOSED
  • Activity ID > {highestActivityIdPreviouslyProcessed}

However based on Adam’s feedback, I think perhaps I should use the Activity Date and Activity Time instead of Activity ID to identify new rows?

5

Hi @chris.pursey,

Yes using the Activity Date/Time seems sensible.

Note that the Activity ID is safe to use as a unique key for the activity. But as it is feasibly possible we may change how it is generated in the future it is best not to make any assumptions about it that aren’t specifically documented.

Regards,

Adam.

1 Like