nhsd_mhs101referral_table - isaric4c/wiki GitHub Wiki

[1] Database Table Field Name	[2] Field Data Type	[3] Variable Availability Date Range	[4] Field Length or Format	[5] Range of Values	[6] Completeness	[7] Constraints	[8] Representation of Missing Data	[9] Field Description	[10] Field Group	[11] Notes
MONTH_ID	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
FILE_TYPE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
IC_USE_SUBMISSION_FLAG	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PSERVICEREQUESTID	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ORGIDCOMM	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
REFERRALREQUESTRECEIVEDDATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
REFERRALREQUESTRECEIVEDTIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SPECIALISEDMHSERVICECODE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SOURCEOFREFERRALMH	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ORGIDREFERRING	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
REFERRINGCAREPROFESSIONALSTAFFGROUP	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
CLINRESPPRIORITYTYPE	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PRIMREASONREFERRALMH	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SERVDISCHDATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHLETTERISSDATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
RECORDNUMBER	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
MHS101UNIQID	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ORGIDPROV	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
UNIQMHSDSPERSID	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
BSPUNIQID	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
PUNIQSERVREQID	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
LOCAREATEAMORGCODECOMM	NULL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
NHSENGREGORGCODECOMM	NULL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
AGESERVREFERRECDATE	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
AGESERVREFERDISCHDATE	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
INACTIVE_TIMESTAMP	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
MONTH_IDENTIFIER	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
MONTH_NAME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
FINANCIALYEAR_IDENTIFIER	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
REASONOAT	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHPLANCREATIONDATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHPLANCREATIONTIME	NULL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHPLANLASTUPDATEDDATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
DISCHPLANLASTUPDATEDTIME	NULL	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
SERVDISCHTIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]