ReferralReport

Field Type Length Allow Null Natural Key Description
1 Record Type ID String

Indicates the record type. For this record it will always be “ReferralReport”.

2 ID ID

Surrogate Key

3 Title String 100
4 Report ID REF

Surrogate Key to a ReportCorresponds to a (Report line in the same file set)’s ID value

5 Referral ID REF

Surrogate Key to a ReferralCorresponds to a (Referral line in the same file set)’s ID value

6 Referral Patient ID REF

Surrogate key to a patientCorresponds to a (Patient line in the same file set)’s ID value

7 Referral Identifier String 50

Referral identifier

8 Referral Patient Identifier String 128

Used to look up existing patient. Part of Natural Key Identifier. Typically, the source’s or practice’s key Identifier for a patient

9 Referral Patient Record Authority ID REF

Surrogate Key to a Record Authority.

10 Inserted Audit Data Audit

Audit data for when the record was inserted/created

11 Last Modified Audit Data Audit

Audit data for when the record was last modified