Database update error. Aurelius

Zohair_Hussain · November 6, 2020, 3:31pm

Hello
I have 3 tables in my MSSQL database. A,B,C.
B has a foreign key to A, C has foreign key to B. (Both foreign keys contain 2 columns ).
I generated entities using Aurelius connection. I am updating tables B and C.
Apply works fine for B. But for C I get the error about property 'P_PID' , which is not even a part of the primary key for table C. It is a part of the primary key for table B.

Looks like it happens in this function ( XDATA source code):

function TXDataWebClient.GetPropValue(Entity: JSValue;
Prop: TXDataSimpleProperty): JSValue;
begin
Result := TJSObject(Entity)[Prop.Name];
end;

Can you advice please.

Thank you.

wlandgraf · November 9, 2020, 2:12pm

Can you please provide the source code of entity classes involved, and the client code you are using that is causing this issue?

Zohair_Hussain · November 9, 2020, 6:41pm

Thank you for the reply.
I was able to make it work using this query string in the request;

dm.xdsNurHistory.Close;
DM.xdsNurHistory.QueryString := '$expand=PROCEDURENUMBER,PROCEDURENUMBER/P_PID&$filter= (PROCEDURENUMBER eq ' + dm.xdsScheduleID.AsString +
' and PROCEDURENUMBER/P_PID/FACILITYID eq ' + dm.xdsSchedule.FieldByName('P_PID.FACILITYID').asstring + ')';
dm.xdsNurHistory.Load;

I noticed that aurelius doesn't define the primary key for the NURHISTORY table ( which is PROCEDURENUMBER and FACILITYID columns). So I expanded 1 level up - PROCEDURE_SURGERY table from where as i understand it can take the ID ( which is linked to NURHISTORY.PROCEDURENUMBER - foreign key)
Then from the aurelius code i saw that to get the FACILITYID value it needs an access to PATIENTS table.
So expanded one more level : PATIENTS.

It finally worked but i am still not sure if this heavy construction( 3 tabes expaned) i created is the right way of doing it.

Thank you.

This is Aurelius code generated:

unit Unit3;

interface

uses
SysUtils,
Generics.Collections,
Aurelius.Mapping.Attributes,
Aurelius.Types.Blob,
Aurelius.Types.DynamicProperties,
Aurelius.Types.Nullable,
Aurelius.Types.Proxy,
Aurelius.Criteria.Dictionary;

type
TNURHISTORY = class;
TPATIENTS = class;
TPROCEDURE_SURGERY = class;
TNURHISTORYTableDictionary = class;
TPATIENTSTableDictionary = class;
TPROCEDURE_SURGERYTableDictionary = class;

[Entity]
[Table('NURHISTORY')]
[Id('FPROCEDURENUMBER', TIdGenerator.None)]
TNURHISTORY = class
private
[Column('NURSE', [], 131)]
FNURSE: Nullable;

[Column('DATEOFHISTORY', [])]
FDATEOFHISTORY: Nullable<TDateTime>;

[Column('TIMEOFHISTORY', [], 7)]
FTIMEOFHISTORY: Nullable<TDateTime>;

[Column('CLINIC', [], 128)]
FCLINIC: Nullable<string>;

[Column('VITALS', [], 128)]
FVITALS: Nullable<string>;

[Column('PAT_HEIGHTFT', [], 3)]
FPAT_HEIGHTFT: Nullable<string>;

[Column('PAT_HEIGHTINC', [], 3)]
FPAT_HEIGHTINC: Nullable<string>;

[Column('PAT_HEIGHTMTS', [], 3)]
FPAT_HEIGHTMTS: Nullable<string>;

[Column('PAT_HEIGHTCM', [], 3)]
FPAT_HEIGHTCM: Nullable<string>;

[Column('PAT_WEIGHTLBS', [], 3)]
FPAT_WEIGHTLBS: Nullable<string>;

[Column('PAT_WEIGHTLOZ', [], 3)]
FPAT_WEIGHTLOZ: Nullable<string>;

[Column('PAT_WEIGHTKG', [], 3)]
FPAT_WEIGHTKG: Nullable<string>;

[Column('INFO_PROVIDEDBY', [], 131)]
FINFO_PROVIDEDBY: Nullable<string>;

[Column('HIS_EVAL_PERFORMED', [], 8)]
FHIS_EVAL_PERFORMED: Nullable<string>;

[Column('HIS_EVALPERFORM_DROPDOWN', [], 64)]
FHIS_EVALPERFORM_DROPDOWN: Nullable<string>;

[Column('RESPIRATORY', [], 3)]
FRESPIRATORY: Nullable<string>;

[Column('GIDISORDER', [], 3)]
FGIDISORDER: Nullable<string>;

[Column('NEUROMASCULAR', [], 3)]
FNEUROMASCULAR: Nullable<string>;

[Column('ONCOLOGY', [], 3)]
FONCOLOGY: Nullable<string>;

[Column('REPRODUCTIVE', [], 3)]
FREPRODUCTIVE: Nullable<string>;

[Column('POSTMENOPAUSAL', [], 3)]
FPOSTMENOPAUSAL: Nullable<string>;

[Column('LNP_DATE', [])]
FLNP_DATE: Nullable<TDateTime>;

[Column('ENT', [], 3)]
FENT: Nullable<string>;

[Column('GU', [], 3)]
FGU: Nullable<string>;

[Column('ENDOCRINE', [], 3)]
FENDOCRINE: Nullable<string>;

[Column('PSYCHOSOCIAL', [], 3)]
FPSYCHOSOCIAL: Nullable<string>;

[Column('CARDIOVASCULAR', [], 3)]
FCARDIOVASCULAR: Nullable<string>;

[Column('DISEASES', [], 3)]
FDISEASES: Nullable<string>;

[Column('HEMATOLOGICAL', [], 3)]
FHEMATOLOGICAL: Nullable<string>;

[Column('PEDIATRIC_PATIENT', [], 3)]
FPEDIATRIC_PATIENT: Nullable<string>;

[Column('TOBACCO', [], 3)]
FTOBACCO: Nullable<string>;

[Column('TOBACCO_HOWMUCH', [], 50)]
FTOBACCO_HOWMUCH: Nullable<string>;

[Column('TOBACCO_FREQUENCY', [], 50)]
FTOBACCO_FREQUENCY: Nullable<string>;

[Column('ETOH', [], 3)]
FETOH: Nullable<string>;

[Column('ETOH_HOWMUCH', [], 50)]
FETOH_HOWMUCH: Nullable<string>;

[Column('ETOH_FREQUENCY', [], 50)]
FETOH_FREQUENCY: Nullable<string>;

[Column('RECDRUGUSE', [], 3)]
FRECDRUGUSE: Nullable<string>;

[Column('RECDRUGUSE_HOWMUCH', [], 50)]
FRECDRUGUSE_HOWMUCH: Nullable<string>;

[Column('RECDRUGUSE_FREQUENCY', [], 50)]
FRECDRUGUSE_FREQUENCY: Nullable<string>;

[Column('CUSTOM_PH', [], 150)]
FCUSTOM_PH: Nullable<string>;

[Column('CUSTOM_OTHERPH', [], 3)]
FCUSTOM_OTHERPH: Nullable<string>;

[Column('TB_HEMOPTYSIS', [], 3)]
FTB_HEMOPTYSIS: Nullable<string>;

[Column('TB_ASTHMA', [], 3)]
FTB_ASTHMA: Nullable<string>;

[Column('TB_WEIGHTLOSS', [], 3)]
FTB_WEIGHTLOSS: Nullable<string>;

[Column('TB_NIGHTSWEATS', [], 3)]
FTB_NIGHTSWEATS: Nullable<string>;

[Column('TB_POSSKINTEST', [], 3)]
FTB_POSSKINTEST: Nullable<string>;

[Column('TBISOLATIONPRECINI', [], 3)]
FTBISOLATIONPRECINI: Nullable<string>;

[Column('HEALTHHIS_COMMENTS', [], 7500)]
FHEALTHHIS_COMMENTS: Nullable<string>;

[Column('PRIOR_ANAESTHESIA_COMP', [], 1024)]
FPRIOR_ANAESTHESIA_COMP: Nullable<string>;

[Column('PERTINENT_FAMHIST', [], 128)]
FPERTINENT_FAMHIST: Nullable<string>;

[Column('PATIENTS_INSTRUCTIONS', [], 7500)]
FPATIENTS_INSTRUCTIONS: Nullable<string>;

[Column('ENDTIMEOFEVAL', [], 7)]
FENDTIMEOFEVAL: Nullable<TDateTime>;

[Column('CUSTOM1', [], 1024)]
FCUSTOM1: Nullable<string>;

[Column('GI', [], 3)]
FGI: Nullable<string>;

[Column('FAMHIST', [], 7500)]
FFAMHIST: Nullable<string>;

[Column('HISTORYSTATUS', [], 12)]
FHISTORYSTATUS: Nullable<string>;

[Column('DATETIMEOFSIGNOFF', [])]
FDATETIMEOFSIGNOFF: Nullable<TDateTime>;

[Column('TB_FATIGUE', [], 3)]
FTB_FATIGUE: Nullable<string>;

[Column('PTHIST', [], 128)]
FPTHIST: Nullable<string>;

[Column('MEDHIST', [], 7500)]
FMEDHIST: Nullable<string>;

[Column('SURGHIST', [], 7500)]
FSURGHIST: Nullable<string>;

[Column('ALLERGIES_REACTION', [], 128)]
FALLERGIES_REACTION: Nullable<string>;

[Column('PASTPROC', [], 128)]
FPASTPROC: Nullable<string>;

[Column('PASTPROC_RESULTS', [], 128)]
FPASTPROC_RESULTS: Nullable<string>;

[Column('PASTPROC_CLINIC', [], 128)]
FPASTPROC_CLINIC: Nullable<string>;

[Column('PASTPROC_DATE', [])]
FPASTPROC_DATE: Nullable<TDateTime>;

[Column('SOCIALHIST', [], 7500)]
FSOCIALHIST: Nullable<string>;

[Column('LABRESULT', [], 128)]
FLABRESULT: Nullable<string>;

[Column('LABRESULT_COMMENT', [], 128)]
FLABRESULT_COMMENT: Nullable<string>;

[Column('DIABETES', [], 3)]
FDIABETES: Nullable<string>;

[Column('HEARTDISEASE', [], 3)]
FHEARTDISEASE: Nullable<string>;

[Column('IRREGULARHEARTBEAT', [], 3)]
FIRREGULARHEARTBEAT: Nullable<string>;

[Column('HEARTMURMUR', [], 3)]
FHEARTMURMUR: Nullable<string>;

[Column('HEARTMURMUR_TYPE', [], 50)]
FHEARTMURMUR_TYPE: Nullable<string>;

[Column('MITRALVALVEPROLAPSE', [], 3)]
FMITRALVALVEPROLAPSE: Nullable<string>;

[Column('VALVEREPLACEMENT', [], 3)]
FVALVEREPLACEMENT: Nullable<string>;

[Column('PACEMAKERICD', [], 3)]
FPACEMAKERICD: Nullable<string>;

[Column('HYPERTENSION', [], 3)]
FHYPERTENSION: Nullable<string>;

[Column('VASCULARGRAFTS', [], 3)]
FVASCULARGRAFTS: Nullable<string>;

[Column('HEPATITIS', [], 3)]
FHEPATITIS: Nullable<string>;

[Column('HIV', [], 3)]
FHIV: Nullable<string>;

[Column('KIDNEYDISEASE', [], 3)]
FKIDNEYDISEASE: Nullable<string>;

[Column('LUNG_BREATHINGPROBLEMS', [], 3)]
FLUNG_BREATHINGPROBLEMS: Nullable<string>;

[Column('ASTHMA', [], 3)]
FASTHMA: Nullable<string>;

[Column('EMPHYSEMA', [], 3)]
FEMPHYSEMA: Nullable<string>;

[Column('COPD', [], 3)]
FCOPD: Nullable<string>;

[Column('SLEEPAPNEA', [], 3)]
FSLEEPAPNEA: Nullable<string>;

[Column('NEUROLOGICALDISORDER', [], 3)]
FNEUROLOGICALDISORDER: Nullable<string>;

[Column('MUSCULOSKELETALDISORDER', [], 3)]
FMUSCULOSKELETALDISORDER: Nullable<string>;

[Column('BLEEDINGDISORDER', [], 3)]
FBLEEDINGDISORDER: Nullable<string>;

[Column('GLAUCOMA', [], 3)]
FGLAUCOMA: Nullable<string>;

[Column('PREGNANT', [], 3)]
FPREGNANT: Nullable<string>;

[Column('SEIZUREDISORDER', [], 3)]
FSEIZUREDISORDER: Nullable<string>;

[Column('PROSTHETICJOINTS', [], 3)]
FPROSTHETICJOINTS: Nullable<string>;

[Column('CANCER', [], 3)]
FCANCER: Nullable<string>;

[Column('EIOH', [], 3)]
FEIOH: Nullable<string>;

[Column('EIOH_HOWMUCH', [], 50)]
FEIOH_HOWMUCH: Nullable<string>;

[Column('OTHER', [], 3)]
FOTHER: Nullable<string>;

[Column('OTHER_VAL', [], 150)]
FOTHER_VAL: Nullable<string>;

[Column('VISION', [], 3)]
FVISION: Nullable<string>;

[Column('HEARINGLOSS', [], 3)]
FHEARINGLOSS: Nullable<string>;

[Column('PRESENTILLNESS', [], 128)]
FPRESENTILLNESS: Nullable<string>;

[Column('CMEDHIST', [], 128)]
FCMEDHIST: Nullable<string>;

[Column('ALLERGIES', [], 128)]
FALLERGIES: Nullable<string>;

[Column('VISION_HEARINGLOSS', [], 3)]
FVISION_HEARINGLOSS: Nullable<string>;

[Column('CHIEF_COMPLAINT', [], 128)]
FCHIEF_COMPLAINT: Nullable<string>;

[Column('MEDS', [], 7500)]
FMEDS: Nullable<string>;

[Column('ANTICOAGULANTS', [], 1024)]
FANTICOAGULANTS: Nullable<string>;

[Column('PAT_BMI', [], 7, 2)]
FPAT_BMI: Nullable<Double>;

[Column('HISTORYREPORT', [TColumnProp.Lazy])]
[DBTypeMemo]
FHISTORYREPORT: TBlob;

[Column('COMMENTS', [TColumnProp.Lazy])]
[DBTypeMemo]
FCOMMENTS: TBlob;

[Column('PAT_BSA', [], 7, 2)]
FPAT_BSA: Nullable<Double>;

[Column('PREOPCONTACTDATE', [])]
FPREOPCONTACTDATE: Nullable<TDateTime>;

[Column('PREOPCONTACTTIME', [], 7)]
FPREOPCONTACTTIME: Nullable<TDateTime>;

[Column('PREOPCONTACTPERSON', [], 128)]
FPREOPCONTACTPERSON: Nullable<string>;

[Column('PREOPCONTACTRELATIONSHIP', [], 128)]
FPREOPCONTACTRELATIONSHIP: Nullable<string>;

[Column('PREOPCONTACTINITIATOR', [], 128)]
FPREOPCONTACTINITIATOR: Nullable<string>;

[Column('PREOPCONTACTREASON', [], 128)]
FPREOPCONTACTREASON: Nullable<string>;

[Column('TIMEOFSIGNOFF', [], 7)]
FTIMEOFSIGNOFF: Nullable<TDateTime>;

[Association([TAssociationProp.Required], CascadeTypeAll - [TCascadeType.Remove])]
[JoinColumn('PROCEDURENUMBER', [TColumnProp.Required], 'ID')]
[JoinColumn('FACILITYID', [TColumnProp.Required], 'FACILITYID')]
FPROCEDURENUMBER: TPROCEDURE_SURGERY;

public
property NURSE: Nullable read FNURSE write FNURSE;
property DATEOFHISTORY: Nullable read FDATEOFHISTORY write FDATEOFHISTORY;
property TIMEOFHISTORY: Nullable read FTIMEOFHISTORY write FTIMEOFHISTORY;
property CLINIC: Nullable read FCLINIC write FCLINIC;
property VITALS: Nullable read FVITALS write FVITALS;
property PAT_HEIGHTFT: Nullable read FPAT_HEIGHTFT write FPAT_HEIGHTFT;
property PAT_HEIGHTINC: Nullable read FPAT_HEIGHTINC write FPAT_HEIGHTINC;
property PAT_HEIGHTMTS: Nullable read FPAT_HEIGHTMTS write FPAT_HEIGHTMTS;
property PAT_HEIGHTCM: Nullable read FPAT_HEIGHTCM write FPAT_HEIGHTCM;
property PAT_WEIGHTLBS: Nullable read FPAT_WEIGHTLBS write FPAT_WEIGHTLBS;
property PAT_WEIGHTLOZ: Nullable read FPAT_WEIGHTLOZ write FPAT_WEIGHTLOZ;
property PAT_WEIGHTKG: Nullable read FPAT_WEIGHTKG write FPAT_WEIGHTKG;
property INFO_PROVIDEDBY: Nullable read FINFO_PROVIDEDBY write FINFO_PROVIDEDBY;
property HIS_EVAL_PERFORMED: Nullable read FHIS_EVAL_PERFORMED write FHIS_EVAL_PERFORMED;
property HIS_EVALPERFORM_DROPDOWN: Nullable read FHIS_EVALPERFORM_DROPDOWN write FHIS_EVALPERFORM_DROPDOWN;
property RESPIRATORY: Nullable read FRESPIRATORY write FRESPIRATORY;
property GIDISORDER: Nullable read FGIDISORDER write FGIDISORDER;
property NEUROMASCULAR: Nullable read FNEUROMASCULAR write FNEUROMASCULAR;
property ONCOLOGY: Nullable read FONCOLOGY write FONCOLOGY;
property REPRODUCTIVE: Nullable read FREPRODUCTIVE write FREPRODUCTIVE;
property POSTMENOPAUSAL: Nullable read FPOSTMENOPAUSAL write FPOSTMENOPAUSAL;
property LNP_DATE: Nullable read FLNP_DATE write FLNP_DATE;
property ENT: Nullable read FENT write FENT;
property GU: Nullable read FGU write FGU;
property ENDOCRINE: Nullable read FENDOCRINE write FENDOCRINE;
property PSYCHOSOCIAL: Nullable read FPSYCHOSOCIAL write FPSYCHOSOCIAL;
property CARDIOVASCULAR: Nullable read FCARDIOVASCULAR write FCARDIOVASCULAR;
property DISEASES: Nullable read FDISEASES write FDISEASES;
property HEMATOLOGICAL: Nullable read FHEMATOLOGICAL write FHEMATOLOGICAL;
property PEDIATRIC_PATIENT: Nullable read FPEDIATRIC_PATIENT write FPEDIATRIC_PATIENT;
property TOBACCO: Nullable read FTOBACCO write FTOBACCO;
property TOBACCO_HOWMUCH: Nullable read FTOBACCO_HOWMUCH write FTOBACCO_HOWMUCH;
property TOBACCO_FREQUENCY: Nullable read FTOBACCO_FREQUENCY write FTOBACCO_FREQUENCY;
property ETOH: Nullable read FETOH write FETOH;
property ETOH_HOWMUCH: Nullable read FETOH_HOWMUCH write FETOH_HOWMUCH;
property ETOH_FREQUENCY: Nullable read FETOH_FREQUENCY write FETOH_FREQUENCY;
property RECDRUGUSE: Nullable read FRECDRUGUSE write FRECDRUGUSE;
property RECDRUGUSE_HOWMUCH: Nullable read FRECDRUGUSE_HOWMUCH write FRECDRUGUSE_HOWMUCH;
property RECDRUGUSE_FREQUENCY: Nullable read FRECDRUGUSE_FREQUENCY write FRECDRUGUSE_FREQUENCY;
property CUSTOM_PH: Nullable read FCUSTOM_PH write FCUSTOM_PH;
property CUSTOM_OTHERPH: Nullable read FCUSTOM_OTHERPH write FCUSTOM_OTHERPH;
property TB_HEMOPTYSIS: Nullable read FTB_HEMOPTYSIS write FTB_HEMOPTYSIS;
property TB_ASTHMA: Nullable read FTB_ASTHMA write FTB_ASTHMA;
property TB_WEIGHTLOSS: Nullable read FTB_WEIGHTLOSS write FTB_WEIGHTLOSS;
property TB_NIGHTSWEATS: Nullable read FTB_NIGHTSWEATS write FTB_NIGHTSWEATS;
property TB_POSSKINTEST: Nullable read FTB_POSSKINTEST write FTB_POSSKINTEST;
property TBISOLATIONPRECINI: Nullable read FTBISOLATIONPRECINI write FTBISOLATIONPRECINI;
property HEALTHHIS_COMMENTS: Nullable read FHEALTHHIS_COMMENTS write FHEALTHHIS_COMMENTS;
property PRIOR_ANAESTHESIA_COMP: Nullable read FPRIOR_ANAESTHESIA_COMP write FPRIOR_ANAESTHESIA_COMP;
property PERTINENT_FAMHIST: Nullable read FPERTINENT_FAMHIST write FPERTINENT_FAMHIST;
property PATIENTS_INSTRUCTIONS: Nullable read FPATIENTS_INSTRUCTIONS write FPATIENTS_INSTRUCTIONS;
property ENDTIMEOFEVAL: Nullable read FENDTIMEOFEVAL write FENDTIMEOFEVAL;
property CUSTOM1: Nullable read FCUSTOM1 write FCUSTOM1;
property GI: Nullable read FGI write FGI;
property FAMHIST: Nullable read FFAMHIST write FFAMHIST;
property HISTORYSTATUS: Nullable read FHISTORYSTATUS write FHISTORYSTATUS;
property DATETIMEOFSIGNOFF: Nullable read FDATETIMEOFSIGNOFF write FDATETIMEOFSIGNOFF;
property TB_FATIGUE: Nullable read FTB_FATIGUE write FTB_FATIGUE;
property PTHIST: Nullable read FPTHIST write FPTHIST;
property MEDHIST: Nullable read FMEDHIST write FMEDHIST;
property SURGHIST: Nullable read FSURGHIST write FSURGHIST;
property ALLERGIES_REACTION: Nullable read FALLERGIES_REACTION write FALLERGIES_REACTION;
property PASTPROC: Nullable read FPASTPROC write FPASTPROC;
property PASTPROC_RESULTS: Nullable read FPASTPROC_RESULTS write FPASTPROC_RESULTS;
property PASTPROC_CLINIC: Nullable read FPASTPROC_CLINIC write FPASTPROC_CLINIC;
property PASTPROC_DATE: Nullable read FPASTPROC_DATE write FPASTPROC_DATE;
property SOCIALHIST: Nullable read FSOCIALHIST write FSOCIALHIST;
property LABRESULT: Nullable read FLABRESULT write FLABRESULT;
property LABRESULT_COMMENT: Nullable read FLABRESULT_COMMENT write FLABRESULT_COMMENT;
property DIABETES: Nullable read FDIABETES write FDIABETES;
property HEARTDISEASE: Nullable read FHEARTDISEASE write FHEARTDISEASE;
property IRREGULARHEARTBEAT: Nullable read FIRREGULARHEARTBEAT write FIRREGULARHEARTBEAT;
property HEARTMURMUR: Nullable read FHEARTMURMUR write FHEARTMURMUR;
property HEARTMURMUR_TYPE: Nullable read FHEARTMURMUR_TYPE write FHEARTMURMUR_TYPE;
property MITRALVALVEPROLAPSE: Nullable read FMITRALVALVEPROLAPSE write FMITRALVALVEPROLAPSE;
property VALVEREPLACEMENT: Nullable read FVALVEREPLACEMENT write FVALVEREPLACEMENT;
property PACEMAKERICD: Nullable read FPACEMAKERICD write FPACEMAKERICD;
property HYPERTENSION: Nullable read FHYPERTENSION write FHYPERTENSION;
property VASCULARGRAFTS: Nullable read FVASCULARGRAFTS write FVASCULARGRAFTS;
property HEPATITIS: Nullable read FHEPATITIS write FHEPATITIS;
property HIV: Nullable read FHIV write FHIV;
property KIDNEYDISEASE: Nullable read FKIDNEYDISEASE write FKIDNEYDISEASE;
property LUNG_BREATHINGPROBLEMS: Nullable read FLUNG_BREATHINGPROBLEMS write FLUNG_BREATHINGPROBLEMS;
property ASTHMA: Nullable read FASTHMA write FASTHMA;
property EMPHYSEMA: Nullable read FEMPHYSEMA write FEMPHYSEMA;
property COPD: Nullable read FCOPD write FCOPD;
property SLEEPAPNEA: Nullable read FSLEEPAPNEA write FSLEEPAPNEA;
property NEUROLOGICALDISORDER: Nullable read FNEUROLOGICALDISORDER write FNEUROLOGICALDISORDER;
property MUSCULOSKELETALDISORDER: Nullable read FMUSCULOSKELETALDISORDER write FMUSCULOSKELETALDISORDER;
property BLEEDINGDISORDER: Nullable read FBLEEDINGDISORDER write FBLEEDINGDISORDER;
property GLAUCOMA: Nullable read FGLAUCOMA write FGLAUCOMA;
property PREGNANT: Nullable read FPREGNANT write FPREGNANT;
property SEIZUREDISORDER: Nullable read FSEIZUREDISORDER write FSEIZUREDISORDER;
property PROSTHETICJOINTS: Nullable read FPROSTHETICJOINTS write FPROSTHETICJOINTS;
property CANCER: Nullable read FCANCER write FCANCER;
property EIOH: Nullable read FEIOH write FEIOH;
property EIOH_HOWMUCH: Nullable read FEIOH_HOWMUCH write FEIOH_HOWMUCH;
property OTHER: Nullable read FOTHER write FOTHER;
property OTHER_VAL: Nullable read FOTHER_VAL write FOTHER_VAL;
property VISION: Nullable read FVISION write FVISION;
property HEARINGLOSS: Nullable read FHEARINGLOSS write FHEARINGLOSS;
property PRESENTILLNESS: Nullable read FPRESENTILLNESS write FPRESENTILLNESS;
property CMEDHIST: Nullable read FCMEDHIST write FCMEDHIST;
property ALLERGIES: Nullable read FALLERGIES write FALLERGIES;
property VISION_HEARINGLOSS: Nullable read FVISION_HEARINGLOSS write FVISION_HEARINGLOSS;
property CHIEF_COMPLAINT: Nullable read FCHIEF_COMPLAINT write FCHIEF_COMPLAINT;
property MEDS: Nullable read FMEDS write FMEDS;
property ANTICOAGULANTS: Nullable read FANTICOAGULANTS write FANTICOAGULANTS;
property PAT_BMI: Nullable read FPAT_BMI write FPAT_BMI;
property HISTORYREPORT: TBlob read FHISTORYREPORT write FHISTORYREPORT;
property COMMENTS: TBlob read FCOMMENTS write FCOMMENTS;
property PAT_BSA: Nullable read FPAT_BSA write FPAT_BSA;
property PREOPCONTACTDATE: Nullable read FPREOPCONTACTDATE write FPREOPCONTACTDATE;
property PREOPCONTACTTIME: Nullable read FPREOPCONTACTTIME write FPREOPCONTACTTIME;
property PREOPCONTACTPERSON: Nullable read FPREOPCONTACTPERSON write FPREOPCONTACTPERSON;
property PREOPCONTACTRELATIONSHIP: Nullable read FPREOPCONTACTRELATIONSHIP write FPREOPCONTACTRELATIONSHIP;
property PREOPCONTACTINITIATOR: Nullable read FPREOPCONTACTINITIATOR write FPREOPCONTACTINITIATOR;
property PREOPCONTACTREASON: Nullable read FPREOPCONTACTREASON write FPREOPCONTACTREASON;
property TIMEOFSIGNOFF: Nullable read FTIMEOFSIGNOFF write FTIMEOFSIGNOFF;
property PROCEDURENUMBER: TPROCEDURE_SURGERY read FPROCEDURENUMBER write FPROCEDURENUMBER;
end;

[Entity]
[Table('PATIENTS')]
[Id('FP_PID', TIdGenerator.None)]
[Id('FFACILITYID', TIdGenerator.None)]
TPATIENTS = class
private
[Column('P_PID', [TColumnProp.Required], 64)]
FP_PID: string;

[Column('LASTNAME', [], 1024)]
FLASTNAME: Nullable<string>;

[Column('FIRSTNAME', [], 1024)]
FFIRSTNAME: Nullable<string>;

[Column('P_ENAME', [], 1280)]
FP_ENAME: Nullable<string>;

[Column('MI', [], 1024)]
FMI: Nullable<string>;

[Column('TITLE', [], 16)]
FTITLE: Nullable<string>;

[Column('P_DOB', [])]
FP_DOB: Nullable<TDateTime>;

[Column('P_AGE', [])]
FP_AGE: Nullable<Integer>;

[Column('P_SEX', [], 1)]
FP_SEX: Nullable<string>;

[Column('RACE', [], 64)]
FRACE: Nullable<string>;

[Column('ADDRESS1', [], 1024)]
FADDRESS1: Nullable<string>;

[Column('ADDRESS2', [], 1024)]
FADDRESS2: Nullable<string>;

[Column('CITY', [], 1024)]
FCITY: Nullable<string>;

[Column('STATE', [], 1024)]
FSTATE: Nullable<string>;

[Column('ZIP', [], 1024)]
FZIP: Nullable<string>;

[Column('PHONE', [], 1024)]
FPHONE: Nullable<string>;

[Column('FAX', [], 1024)]
FFAX: Nullable<string>;

[Column('OTHERPHONE', [], 1024)]
FOTHERPHONE: Nullable<string>;

[Column('SSN', [], 1024)]
FSSN: Nullable<string>;

[Column('ACTNUM', [], 64)]
FACTNUM: Nullable<string>;

[Column('CUST1', [], 64)]
FCUST1: Nullable<string>;

[Column('CUST2', [], 64)]
FCUST2: Nullable<string>;

[Column('CUST3', [], 64)]
FCUST3: Nullable<string>;

[Column('CUST4', [], 64)]
FCUST4: Nullable<string>;

[Column('DATE_ENTERED', [])]
FDATE_ENTERED: Nullable<TDateTime>;

[Column('WORKPHONE', [], 1024)]
FWORKPHONE: Nullable<string>;

[Column('TIMEOFARRIVAL', [], 7)]
FTIMEOFARRIVAL: Nullable<TDateTime>;

[Column('DATEOFARRIVAL', [])]
FDATEOFARRIVAL: Nullable<TDateTime>;

[Column('OTHERNAME', [], 1024)]
FOTHERNAME: Nullable<string>;

[Column('EMAIL', [], 1024)]
FEMAIL: Nullable<string>;

[Column('SIGNATUREONFILE', [], 1)]
FSIGNATUREONFILE: Nullable<string>;

[Column('SIGNATUREDATE', [])]
FSIGNATUREDATE: Nullable<TDateTime>;

[Column('MARITALSTATUS', [], 20)]
FMARITALSTATUS: Nullable<string>;

[Column('DECEASED', [])]
FDECEASED: Nullable<Integer>;

[Column('DATE_OF_DEATH', [])]
FDATE_OF_DEATH: Nullable<TDateTime>;

[Column('LOCATION_OF_DEATH', [], 64)]
FLOCATION_OF_DEATH: Nullable<string>;

[Column('REASON_OF_DEATH', [], 128)]
FREASON_OF_DEATH: Nullable<string>;

[Column('EXEMPT', [])]
FEXEMPT: Nullable<Integer>;

[Column('PAST_MEDICALHIST', [], 1024)]
FPAST_MEDICALHIST: Nullable<string>;

[Column('PAST_SURGICALHIST', [], 1024)]
FPAST_SURGICALHIST: Nullable<string>;

[Column('ALLERGIES', [], 1024)]
FALLERGIES: Nullable<string>;

[Column('FAMILY_HIST', [], 1024)]
FFAMILY_HIST: Nullable<string>;

[Column('PREV_HOSPITALISATIONS', [], 1024)]
FPREV_HOSPITALISATIONS: Nullable<string>;

[Column('SOCIAL_HIST', [], 1024)]
FSOCIAL_HIST: Nullable<string>;

[Column('CUSTOM1', [], 1024)]
FCUSTOM1: Nullable<string>;

[Column('CUSTOM2', [], 1024)]
FCUSTOM2: Nullable<string>;

[Column('CUSTOM3', [], 1024)]
FCUSTOM3: Nullable<string>;

[Column('CELLPHONE', [], 1024)]
FCELLPHONE: Nullable<string>;

[Column('COUNTY', [], 32)]
FCOUNTY: Nullable<string>;

[Column('COUNTYCODE', [], 12)]
FCOUNTYCODE: Nullable<string>;

[Column('RELIGION', [], 16)]
FRELIGION: Nullable<string>;

[Column('PATIENT_PICTURE', [TColumnProp.Lazy])]
FPATIENT_PICTURE: TBlob;

[Column('MEDSALLERGIES', [])]
FMEDSALLERGIES: Nullable<Boolean>;

[Column('OTCALLERGIES', [])]
FOTCALLERGIES: Nullable<Boolean>;

[Column('PRIMARYLANGUAGE', [], 18)]
FPRIMARYLANGUAGE: Nullable<string>;

[Column('ALTADDRESS1', [], 1024)]
FALTADDRESS1: Nullable<string>;

[Column('ALTADDRESS2', [], 1024)]
FALTADDRESS2: Nullable<string>;

[Column('ALTADDRESSCITY', [], 1024)]
FALTADDRESSCITY: Nullable<string>;

[Column('ALTADDRESSSTATE', [], 1024)]
FALTADDRESSSTATE: Nullable<string>;

[Column('ALTADDRESSZIP', [], 1024)]
FALTADDRESSZIP: Nullable<string>;

[Column('ALTPHONE', [], 1024)]
FALTPHONE: Nullable<string>;

[Column('ALTCOUNTRY', [], 64)]
FALTCOUNTRY: Nullable<string>;

[Column('SMOKINGSTATUS', [], 64)]
FSMOKINGSTATUS: Nullable<string>;

[Column('SMOKINGCODE', [])]
FSMOKINGCODE: Nullable<Integer>;

[Column('ETHNICITY', [], 32)]
FETHNICITY: Nullable<string>;

[Column('COMMUNICATIONPREFERENCE', [], 12)]
FCOMMUNICATIONPREFERENCE: Nullable<string>;

[Column('PREGNANT', [])]
FPREGNANT: Nullable<Boolean>;

[Column('PREGNANCYWEEK', [])]
FPREGNANCYWEEK: Nullable<Integer>;

[Column('USERID', [], 64)]
FUSERID: Nullable<string>;

[Column('PWD', [], 64)]
FPWD: Nullable<string>;

[Column('PWDCHANGEDON', [])]
FPWDCHANGEDON: Nullable<TDateTime>;

[Column('FIRSTLOGINPWD', [])]
FFIRSTLOGINPWD: Nullable<Integer>;

[Column('PWDCHANGEFREQ', [])]
FPWDCHANGEFREQ: Nullable<Integer>;

[Column('PWDEXPIRES', [])]
FPWDEXPIRES: Nullable<Integer>;

[Column('TIMELYACCESS', [], 1)]
FTIMELYACCESS: Nullable<string>;

[Column('SCHEDULED', [], 1)]
FSCHEDULED: Nullable<string>;

[Column('PATBILLINGPID', [])]
FPATBILLINGPID: Nullable<Integer>;

[Column('TIME_OF_DEATH', [], 7)]
FTIME_OF_DEATH: Nullable<TDateTime>;

[Column('NH_STATUS', [], 1)]
FNH_STATUS: Nullable<string>;

[Column('NHS_STATUS', [], 1)]
FNHS_STATUS: Nullable<string>;

[Column('ELIG_CONSENT', [])]
FELIG_CONSENT: Nullable<Integer>;

[Column('es_code', [], 64)]
Fes_code: Nullable<string>;

[Column('CANCER_HIST', [], 7500)]
FCANCER_HIST: Nullable<string>;

[Column('FACILITYID', [TColumnProp.Required])]
FFACILITYID: Integer;

[Column('SUFFIX', [], 16)]
FSUFFIX: Nullable<string>;

[Column('ISOLATIONPRECAUTIONS', [], 128)]
FISOLATIONPRECAUTIONS: Nullable<string>;

[Column('COUNTRY', [], 128)]
FCOUNTRY: Nullable<string>;

[Column('PATIENTSTAGE', [], 64)]
FPATIENTSTAGE: Nullable<string>;

[Column('BSAFORMULA', [], 64)]
FBSAFORMULA: Nullable<string>;

[Column('ENABLEPORTALREGISTRATION', [], 1)]
FENABLEPORTALREGISTRATION: Nullable<string>;

[Column('LASTNAME_ENCRYPTED', [], 640)]
FLASTNAME_ENCRYPTED: Nullable<string>;

public
property P_PID: string read FP_PID write FP_PID;
property LASTNAME: Nullable read FLASTNAME write FLASTNAME;
property FIRSTNAME: Nullable read FFIRSTNAME write FFIRSTNAME;
property P_ENAME: Nullable read FP_ENAME write FP_ENAME;
property MI: Nullable read FMI write FMI;
property TITLE: Nullable read FTITLE write FTITLE;
property P_DOB: Nullable read FP_DOB write FP_DOB;
property P_AGE: Nullable read FP_AGE write FP_AGE;
property P_SEX: Nullable read FP_SEX write FP_SEX;
property RACE: Nullable read FRACE write FRACE;
property ADDRESS1: Nullable read FADDRESS1 write FADDRESS1;
property ADDRESS2: Nullable read FADDRESS2 write FADDRESS2;
property CITY: Nullable read FCITY write FCITY;
property STATE: Nullable read FSTATE write FSTATE;
property ZIP: Nullable read FZIP write FZIP;
property PHONE: Nullable read FPHONE write FPHONE;
property FAX: Nullable read FFAX write FFAX;
property OTHERPHONE: Nullable read FOTHERPHONE write FOTHERPHONE;
property SSN: Nullable read FSSN write FSSN;
property ACTNUM: Nullable read FACTNUM write FACTNUM;
property CUST1: Nullable read FCUST1 write FCUST1;
property CUST2: Nullable read FCUST2 write FCUST2;
property CUST3: Nullable read FCUST3 write FCUST3;
property CUST4: Nullable read FCUST4 write FCUST4;
property DATE_ENTERED: Nullable read FDATE_ENTERED write FDATE_ENTERED;
property WORKPHONE: Nullable read FWORKPHONE write FWORKPHONE;
property TIMEOFARRIVAL: Nullable read FTIMEOFARRIVAL write FTIMEOFARRIVAL;
property DATEOFARRIVAL: Nullable read FDATEOFARRIVAL write FDATEOFARRIVAL;
property OTHERNAME: Nullable read FOTHERNAME write FOTHERNAME;
property EMAIL: Nullable read FEMAIL write FEMAIL;
property SIGNATUREONFILE: Nullable read FSIGNATUREONFILE write FSIGNATUREONFILE;
property SIGNATUREDATE: Nullable read FSIGNATUREDATE write FSIGNATUREDATE;
property MARITALSTATUS: Nullable read FMARITALSTATUS write FMARITALSTATUS;
property DECEASED: Nullable read FDECEASED write FDECEASED;
property DATE_OF_DEATH: Nullable read FDATE_OF_DEATH write FDATE_OF_DEATH;
property LOCATION_OF_DEATH: Nullable read FLOCATION_OF_DEATH write FLOCATION_OF_DEATH;
property REASON_OF_DEATH: Nullable read FREASON_OF_DEATH write FREASON_OF_DEATH;
property EXEMPT: Nullable read FEXEMPT write FEXEMPT;
property PAST_MEDICALHIST: Nullable read FPAST_MEDICALHIST write FPAST_MEDICALHIST;
property PAST_SURGICALHIST: Nullable read FPAST_SURGICALHIST write FPAST_SURGICALHIST;
property ALLERGIES: Nullable read FALLERGIES write FALLERGIES;
property FAMILY_HIST: Nullable read FFAMILY_HIST write FFAMILY_HIST;
property PREV_HOSPITALISATIONS: Nullable read FPREV_HOSPITALISATIONS write FPREV_HOSPITALISATIONS;
property SOCIAL_HIST: Nullable read FSOCIAL_HIST write FSOCIAL_HIST;
property CUSTOM1: Nullable read FCUSTOM1 write FCUSTOM1;
property CUSTOM2: Nullable read FCUSTOM2 write FCUSTOM2;
property CUSTOM3: Nullable read FCUSTOM3 write FCUSTOM3;
property CELLPHONE: Nullable read FCELLPHONE write FCELLPHONE;
property COUNTY: Nullable read FCOUNTY write FCOUNTY;
property COUNTYCODE: Nullable read FCOUNTYCODE write FCOUNTYCODE;
property RELIGION: Nullable read FRELIGION write FRELIGION;
property PATIENT_PICTURE: TBlob read FPATIENT_PICTURE write FPATIENT_PICTURE;
property MEDSALLERGIES: Nullable read FMEDSALLERGIES write FMEDSALLERGIES;
property OTCALLERGIES: Nullable read FOTCALLERGIES write FOTCALLERGIES;
property PRIMARYLANGUAGE: Nullable read FPRIMARYLANGUAGE write FPRIMARYLANGUAGE;
property ALTADDRESS1: Nullable read FALTADDRESS1 write FALTADDRESS1;
property ALTADDRESS2: Nullable read FALTADDRESS2 write FALTADDRESS2;
property ALTADDRESSCITY: Nullable read FALTADDRESSCITY write FALTADDRESSCITY;
property ALTADDRESSSTATE: Nullable read FALTADDRESSSTATE write FALTADDRESSSTATE;
property ALTADDRESSZIP: Nullable read FALTADDRESSZIP write FALTADDRESSZIP;
property ALTPHONE: Nullable read FALTPHONE write FALTPHONE;
property ALTCOUNTRY: Nullable read FALTCOUNTRY write FALTCOUNTRY;
property SMOKINGSTATUS: Nullable read FSMOKINGSTATUS write FSMOKINGSTATUS;
property SMOKINGCODE: Nullable read FSMOKINGCODE write FSMOKINGCODE;
property ETHNICITY: Nullable read FETHNICITY write FETHNICITY;
property COMMUNICATIONPREFERENCE: Nullable read FCOMMUNICATIONPREFERENCE write FCOMMUNICATIONPREFERENCE;
property PREGNANT: Nullable read FPREGNANT write FPREGNANT;
property PREGNANCYWEEK: Nullable read FPREGNANCYWEEK write FPREGNANCYWEEK;
property USERID: Nullable read FUSERID write FUSERID;
property PWD: Nullable read FPWD write FPWD;
property PWDCHANGEDON: Nullable read FPWDCHANGEDON write FPWDCHANGEDON;
property FIRSTLOGINPWD: Nullable read FFIRSTLOGINPWD write FFIRSTLOGINPWD;
property PWDCHANGEFREQ: Nullable read FPWDCHANGEFREQ write FPWDCHANGEFREQ;
property PWDEXPIRES: Nullable read FPWDEXPIRES write FPWDEXPIRES;
property TIMELYACCESS: Nullable read FTIMELYACCESS write FTIMELYACCESS;
property SCHEDULED: Nullable read FSCHEDULED write FSCHEDULED;
property PATBILLINGPID: Nullable read FPATBILLINGPID write FPATBILLINGPID;
property TIME_OF_DEATH: Nullable read FTIME_OF_DEATH write FTIME_OF_DEATH;
property NH_STATUS: Nullable read FNH_STATUS write FNH_STATUS;
property NHS_STATUS: Nullable read FNHS_STATUS write FNHS_STATUS;
property ELIG_CONSENT: Nullable read FELIG_CONSENT write FELIG_CONSENT;
property es_code: Nullable read Fes_code write Fes_code;
property CANCER_HIST: Nullable read FCANCER_HIST write FCANCER_HIST;
property FACILITYID: Integer read FFACILITYID write FFACILITYID;
property SUFFIX: Nullable read FSUFFIX write FSUFFIX;
property ISOLATIONPRECAUTIONS: Nullable read FISOLATIONPRECAUTIONS write FISOLATIONPRECAUTIONS;
property COUNTRY: Nullable read FCOUNTRY write FCOUNTRY;
property PATIENTSTAGE: Nullable read FPATIENTSTAGE write FPATIENTSTAGE;
property BSAFORMULA: Nullable read FBSAFORMULA write FBSAFORMULA;
property ENABLEPORTALREGISTRATION: Nullable read FENABLEPORTALREGISTRATION write FENABLEPORTALREGISTRATION;
property LASTNAME_ENCRYPTED: Nullable read FLASTNAME_ENCRYPTED write FLASTNAME_ENCRYPTED;
end;

[Entity]
[Table('PROCEDURE_SURGERY')]
[Id('FID', TIdGenerator.None)]
[Id('FP_PID', TIdGenerator.None)]
TPROCEDURE_SURGERY = class
private
[Column('ID', [TColumnProp.Required])]
FID: Integer;

[Column('ENCOUNTERNUM', [])]
FENCOUNTERNUM: Nullable<Integer>;

[Column('FINISHDATE', [])]
FFINISHDATE: Nullable<TDateTime>;

[Column('FINISHTIME', [], 7)]
FFINISHTIME: Nullable<TDateTime>;

[Column('AUTHOR', [], 64)]
FAUTHOR: Nullable<string>;

[Column('FACILITY', [], 64)]
FFACILITY: Nullable<string>;

[Column('REPORTSTITLE', [], 128)]
FREPORTSTITLE: Nullable<string>;

[Column('STATUS', [], 16)]
FSTATUS: Nullable<string>;

[Column('DATEOFPROCEDURE', [])]
FDATEOFPROCEDURE: Nullable<TDateTime>;

[Column('PROCEDUREPERFORMED', [], 1024)]
FPROCEDUREPERFORMED: Nullable<string>;

[Column('CPTCODES', [], 1024)]
FCPTCODES: Nullable<string>;

[Column('TIMEOFPROCEDURE', [], 7)]
FTIMEOFPROCEDURE: Nullable<TDateTime>;

[Column('EXTENTOFEXAM', [], 512)]
FEXTENTOFEXAM: Nullable<string>;

[Column('RECOMMENDATIONS', [], 2048)]
FRECOMMENDATIONS: Nullable<string>;

[Column('LIMITATIONSOFEXAM', [], 128)]
FLIMITATIONSOFEXAM: Nullable<string>;

[Column('ICDCODES', [], 1024)]
FICDCODES: Nullable<string>;

[Column('COMMENTS', [], 1024)]
FCOMMENTS: Nullable<string>;

[Column('INDICATIONS', [], 1024)]
FINDICATIONS: Nullable<string>;

[Column('AGE', [])]
FAGE: Nullable<Integer>;

[Column('CUSTOM1', [], 1024)]
FCUSTOM1: Nullable<string>;

[Column('SIGNOFF', [], 1)]
FSIGNOFF: Nullable<string>;

[Column('PROCTYPE', [], 20)]
FPROCTYPE: Nullable<string>;

[Column('REVIEWPHYSICIAN', [], 128)]
FREVIEWPHYSICIAN: Nullable<string>;

[Column('REVIEWDATE', [])]
FREVIEWDATE: Nullable<TDateTime>;

[Column('ORDERINGPROVIDER', [], 131)]
FORDERINGPROVIDER: Nullable<string>;

[Column('TECHNICIAN', [], 131)]
FTECHNICIAN: Nullable<string>;

[Column('NURSE', [], 131)]
FNURSE: Nullable<string>;

[Column('REFERRINGPHYSICIAN', [], 131)]
FREFERRINGPHYSICIAN: Nullable<string>;

[Column('LOCATION', [], 80)]
FLOCATION: Nullable<string>;

[Column('CANCELREASON', [], 128)]
FCANCELREASON: Nullable<string>;

[Column('PROCEDUREREASON', [], 1024)]
FPROCEDUREREASON: Nullable<string>;

[Column('TRACTIMAGE', [TColumnProp.Lazy])]
FTRACTIMAGE: TBlob;

[Column('DIAGRAMIMAGE', [TColumnProp.Lazy])]
FDIAGRAMIMAGE: TBlob;

[Column('DIAGRAMANNOTATION', [TColumnProp.Lazy])]
FDIAGRAMANNOTATION: TBlob;

[Column('CUSTOM2', [], 1024)]
FCUSTOM2: Nullable<string>;

[Column('PROCNAME', [], 128)]
FPROCNAME: Nullable<string>;

[Column('VISUALIZATION', [], 8)]
FVISUALIZATION: Nullable<string>;

[Column('TOLERANCE', [], 8)]
FTOLERANCE: Nullable<string>;

[Column('COMPLICATIONS', [], 512)]
FCOMPLICATIONS: Nullable<string>;

[Column('DISCHARGEINS', [], 2048)]
FDISCHARGEINS: Nullable<string>;

[Column('DISCHARGEDTO', [], 128)]
FDISCHARGEDTO: Nullable<string>;

[Column('APPOINTMENTINFO', [], 1024)]
FAPPOINTMENTINFO: Nullable<string>;

[Column('ADDINSTR', [], 1024)]
FADDINSTR: Nullable<string>;

[Column('REFERRALS', [], 128)]
FREFERRALS: Nullable<string>;

[Column('DI_CUSTOM1', [], 1024)]
FDI_CUSTOM1: Nullable<string>;

[Column('ISOLATIONPRECAUTIONS', [], 128)]
FISOLATIONPRECAUTIONS: Nullable<string>;

[Column('ASSISTANT', [], 128)]
FASSISTANT: Nullable<string>;

[Column('MEDICATIONS', [], 256)]
FMEDICATIONS: Nullable<string>;

[Column('PPN_CONDITION', [], 1024)]
FPPN_CONDITION: Nullable<string>;

[Column('PPN_PROGRESS', [], 1024)]
FPPN_PROGRESS: Nullable<string>;

[Column('PPN_CUSTOM', [], 1024)]
FPPN_CUSTOM: Nullable<string>;

[Column('PPN_CUSTOM2', [], 1024)]
FPPN_CUSTOM2: Nullable<string>;

[Column('INSTRUMENTS', [], 128)]
FINSTRUMENTS: Nullable<string>;

[Column('SPECIALINSTRUCTIONS', [], 255)]
FSPECIALINSTRUCTIONS: Nullable<string>;

[Column('FELLOW', [], 128)]
FFELLOW: Nullable<string>;

[Column('ESTIMATEDBLOODLOSS', [], 8)]
FESTIMATEDBLOODLOSS: Nullable<string>;

[Column('BLOODLOSSUNIT', [], 3)]
FBLOODLOSSUNIT: Nullable<string>;

[Column('PROCEDUREPROPOSED', [], 512)]
FPROCEDUREPROPOSED: Nullable<string>;

[Column('ER_CONTRAINDICATIONS', [], 512)]
FER_CONTRAINDICATIONS: Nullable<string>;

[Column('TECH_DIFFICULT', [], 3)]
FTECH_DIFFICULT: Nullable<string>;

[Column('PAINSCALE', [], 255)]
FPAINSCALE: Nullable<string>;

[Column('INTENDEDEXTENT', [], 50)]
FINTENDEDEXTENT: Nullable<string>;

[Column('SITE', [], 255)]
FSITE: Nullable<string>;

[Column('NOOFPASSES', [], 50)]
FNOOFPASSES: Nullable<string>;

[Column('POSITIONS', [], 255)]
FPOSITIONS: Nullable<string>;

[Column('NEEDLESIZE', [], 255)]
FNEEDLESIZE: Nullable<string>;

[Column('PPN_ORDERS', [], 1024)]
FPPN_ORDERS: Nullable<string>;

[Column('DI_CUSTOM2', [], 1024)]
FDI_CUSTOM2: Nullable<string>;

[Column('PROC_CUSTOM1', [], 128)]
FPROC_CUSTOM1: Nullable<string>;

[Column('PROC_CUSTOM2', [], 128)]
FPROC_CUSTOM2: Nullable<string>;

[Column('VISITNUM', [], 16)]
FVISITNUM: Nullable<string>;

[Column('ORDERNUM', [], 16)]
FORDERNUM: Nullable<string>;

[Column('INOUTPATIENT', [], 12)]
FINOUTPATIENT: Nullable<string>;

[Column('INPATINFO', [], 131)]
FINPATINFO: Nullable<string>;

[Column('TIMEOFARRIVAL', [], 7)]
FTIMEOFARRIVAL: Nullable<TDateTime>;

[Column('SPECIALITY', [], 64)]
FSPECIALITY: Nullable<string>;

[Column('DIFFICULTYLEVEL', [], 12)]
FDIFFICULTYLEVEL: Nullable<string>;

[Column('ADDENDUM_COMPLICATIONS', [], 512)]
FADDENDUM_COMPLICATIONS: Nullable<string>;

[Column('ADDENDUM_ICD', [], 512)]
FADDENDUM_ICD: Nullable<string>;

[Column('ADDENDUM_CPT', [], 512)]
FADDENDUM_CPT: Nullable<string>;

[Column('HL7_SEND_STATUS', [], 1)]
FHL7_SEND_STATUS: Nullable<string>;

[Column('GROUPNAME', [], 64)]
FGROUPNAME: Nullable<string>;

[Column('NURSTATUS', [], 16)]
FNURSTATUS: Nullable<string>;

[Column('NURFINISHDATE', [])]
FNURFINISHDATE: Nullable<TDateTime>;

[Column('NURFINISHTIME', [], 7)]
FNURFINISHTIME: Nullable<TDateTime>;

[Column('NURSIGNOFFBY', [], 131)]
FNURSIGNOFFBY: Nullable<string>;

[Column('PROCEDURETECHNIQUE', [TColumnProp.Lazy])]
[DBTypeMemo]
FPROCEDURETECHNIQUE: TBlob;

[Column('FINDINGS', [TColumnProp.Lazy])]
[DBTypeMemo]
FFINDINGS: TBlob;

[Column('DIAGNOSIS', [TColumnProp.Lazy])]
[DBTypeMemo]
FDIAGNOSIS: TBlob;

[Column('ADDENDUMDATA', [TColumnProp.Lazy])]
[DBTypeMemo]
FADDENDUMDATA: TBlob;

[Column('MEDRECONCILIATION', [], 1024)]
FMEDRECONCILIATION: Nullable<string>;

[Column('DURATIONOFPROCEDURE', [])]
FDURATIONOFPROCEDURE: Nullable<Integer>;

[Column('DURATIONOFFLOROUSE', [])]
FDURATIONOFFLOROUSE: Nullable<Integer>;

[Column('ANESTHESIOLOGIST', [], 128)]
FANESTHESIOLOGIST: Nullable<string>;

[Column('FIRSTTIMESCREENING', [], 3)]
FFIRSTTIMESCREENING: Nullable<string>;

[Column('HL7_SEND_STATUS_ADDENDUM', [], 1)]
FHL7_SEND_STATUS_ADDENDUM: Nullable<string>;

[Column('NURSE2', [], 131)]
FNURSE2: Nullable<string>;

[Column('COMPLICATION_YES_NONE', [], 8)]
FCOMPLICATION_YES_NONE: Nullable<string>;

[Column('NURSEGROUPNAME', [], 8)]
FNURSEGROUPNAME: Nullable<string>;

[Column('HL7_SEND_STATUS_PROFCRG', [], 1)]
FHL7_SEND_STATUS_PROFCRG: Nullable<string>;

[Column('URINEVOLUME', [], 512)]
FURINEVOLUME: Nullable<string>;

[Column('HL7_SEND_STATUS_TEXT', [], 1)]
FHL7_SEND_STATUS_TEXT: Nullable<string>;

[Column('NUMBEROFSPECIMENS', [])]
FNUMBEROFSPECIMENS: Nullable<Integer>;

[Column('GROSS', [TColumnProp.Lazy])]
[DBTypeMemo]
FGROSS: TBlob;

[Column('IMPLANTS', [], 8)]
FIMPLANTS: Nullable<string>;

[Column('CLOTESTPOSITIVE', [], 1)]
FCLOTESTPOSITIVE: Nullable<string>;

[Column('CLOTESTTAKEN', [], 4)]
FCLOTESTTAKEN: Nullable<string>;

[Column('PREPAINLEVEL', [], 256)]
FPREPAINLEVEL: Nullable<string>;

[Column('PLANSTATUS', [], 16)]
FPLANSTATUS: Nullable<string>;

[Column('FELLOWPROCPERFORMED', [], 3)]
FFELLOWPROCPERFORMED: Nullable<string>;

[Column('DURATIONOFFLOROUSE_SEC', [])]
FDURATIONOFFLOROUSE_SEC: Nullable<Integer>;

[Column('SECONDEXTENT', [], 1024)]
FSECONDEXTENT: Nullable<string>;

[Column('ES_CODE', [], 64)]
FES_CODE: Nullable<string>;

[Column('COLONOSCOPYTYPE', [], 16)]
FCOLONOSCOPYTYPE: Nullable<string>;

[Column('CUSTOM3', [], 1024)]
FCUSTOM3: Nullable<string>;

[Column('CUSTOM4', [], 1024)]
FCUSTOM4: Nullable<string>;

[Column('CUSTOM5', [], 1024)]
FCUSTOM5: Nullable<string>;

[Column('CUSTOM6', [], 1024)]
FCUSTOM6: Nullable<string>;

[Column('SECONDPHYSICIAN', [], 131)]
FSECONDPHYSICIAN: Nullable<string>;

[Column('DATEOFPATHARRIVAL', [])]
FDATEOFPATHARRIVAL: Nullable<TDateTime>;

[Column('TIMEOFPATHARRIVAL', [], 7)]
FTIMEOFPATHARRIVAL: Nullable<TDateTime>;

[Column('SPECIMENCOLLECTIONDATE', [])]
FSPECIMENCOLLECTIONDATE: Nullable<TDateTime>;

[Column('TIMEFINISHEDBYFELLOW', [], 7)]
FTIMEFINISHEDBYFELLOW: Nullable<TDateTime>;

[Column('DATEFINISHEDBYFELLOW', [])]
FDATEFINISHEDBYFELLOW: Nullable<TDateTime>;

[Column('REFCODE', [], 16)]
FREFCODE: Nullable<string>;

[Column('ORDEREDBY', [], 64)]
FORDEREDBY: Nullable<string>;

[Column('IMAGECOUNT', [])]
FIMAGECOUNT: Nullable<Integer>;

[Column('PRESEDATIONCOMMETS', [], 128)]
FPRESEDATIONCOMMETS: Nullable<string>;

[Column('LASTCOLONOSCOPYPERFOMED', [], 16)]
FLASTCOLONOSCOPYPERFOMED: Nullable<string>;

[Column('USERCODE', [], 64)]
FUSERCODE: Nullable<string>;

[Column('AGEMONTH', [], 2)]
FAGEMONTH: Nullable<string>;

[Column('TISSUESUBMITTED', [TColumnProp.Lazy])]
[DBTypeMemo]
FTISSUESUBMITTED: TBlob;

[Column('VISITTYPE', [], 1)]
FVISITTYPE: Nullable<string>;

[Column('PATIENTTYPE', [], 12)]
FPATIENTTYPE: Nullable<string>;

[Column('PRIMARYCAREPHY', [], 128)]
FPRIMARYCAREPHY: Nullable<string>;

[Column('RECALLNUM', [])]
FRECALLNUM: Nullable<Integer>;

[Column('STATUSID', [])]
FSTATUSID: Nullable<Integer>;

[Column('PATIENTTEACHING_ALL', [TColumnProp.Lazy])]
[DBTypeMemo]
FPATIENTTEACHING_ALL: TBlob;

[Column('PATIENTTEACHING_PREV', [TColumnProp.Lazy])]
[DBTypeMemo]
FPATIENTTEACHING_PREV: TBlob;

[Column('CHAIRSTARTTIME', [], 7)]
FCHAIRSTARTTIME: Nullable<TDateTime>;

[Column('PROCEDURESTARTTIME', [], 7)]
FPROCEDURESTARTTIME: Nullable<TDateTime>;

[Column('TIMEOUTTIME', [], 7)]
FTIMEOUTTIME: Nullable<TDateTime>;

[Column('TIMEOUTQUESTIONS', [TColumnProp.Lazy])]
[DBTypeMemo]
FTIMEOUTQUESTIONS: TBlob;

[Column('O2STOP', [], 7)]
FO2STOP: Nullable<TDateTime>;

[Column('O2START', [], 7)]
FO2START: Nullable<TDateTime>;

[Column('O2RATE_ROUTE', [], 128)]
FO2RATE_ROUTE: Nullable<string>;

[Column('ROOMENDTIME', [], 7)]
FROOMENDTIME: Nullable<TDateTime>;

[Column('PROCENDTIME', [], 7)]
FPROCENDTIME: Nullable<TDateTime>;

[Column('REPORTGIVENTO', [], 128)]
FREPORTGIVENTO: Nullable<string>;

[Column('PATIENTTRANSTO', [], 64)]
FPATIENTTRANSTO: Nullable<string>;

[Column('INCOMPLETEREASON', [], 512)]
FINCOMPLETEREASON: Nullable<string>;

[Column('PROCEDURECOMPLETE', [])]
FPROCEDURECOMPLETE: Nullable<Boolean>;

[Column('CHAIRENDTIME', [], 7)]
FCHAIRENDTIME: Nullable<TDateTime>;

[Column('PAT_HEIGHTFT', [], 3)]
FPAT_HEIGHTFT: Nullable<string>;

[Column('PAT_HEIGHTINC', [], 3)]
FPAT_HEIGHTINC: Nullable<string>;

[Column('PAT_HEIGHTMTS', [], 3)]
FPAT_HEIGHTMTS: Nullable<string>;

[Column('PAT_HEIGHTCM', [], 3)]
FPAT_HEIGHTCM: Nullable<string>;

[Column('PAT_WEIGHTLBS', [], 3)]
FPAT_WEIGHTLBS: Nullable<string>;

[Column('PAT_WEIGHTKG', [], 3)]
FPAT_WEIGHTKG: Nullable<string>;

[Column('PAT_WEIGHTLOZ', [], 3)]
FPAT_WEIGHTLOZ: Nullable<string>;

[Column('HEIGHTMTSCM', [], 3)]
FHEIGHTMTSCM: Nullable<string>;

[Column('BMI', [])]
FBMI: Nullable<Double>;

[Column('BSA', [])]
FBSA: Nullable<Double>;

[Association([TAssociationProp.Required], CascadeTypeAll - [TCascadeType.Remove])]
[JoinColumn('P_PID', [TColumnProp.Required], 'P_PID')]
[JoinColumn('FACILITYID', [TColumnProp.Required], 'FACILITYID')]
FP_PID: TPATIENTS;

public
property ID: Integer read FID write FID;
property ENCOUNTERNUM: Nullable read FENCOUNTERNUM write FENCOUNTERNUM;
property FINISHDATE: Nullable read FFINISHDATE write FFINISHDATE;
property FINISHTIME: Nullable read FFINISHTIME write FFINISHTIME;
property AUTHOR: Nullable read FAUTHOR write FAUTHOR;
property FACILITY: Nullable read FFACILITY write FFACILITY;
property REPORTSTITLE: Nullable read FREPORTSTITLE write FREPORTSTITLE;
property STATUS: Nullable read FSTATUS write FSTATUS;
property DATEOFPROCEDURE: Nullable read FDATEOFPROCEDURE write FDATEOFPROCEDURE;
property PROCEDUREPERFORMED: Nullable read FPROCEDUREPERFORMED write FPROCEDUREPERFORMED;
property CPTCODES: Nullable read FCPTCODES write FCPTCODES;
property TIMEOFPROCEDURE: Nullable read FTIMEOFPROCEDURE write FTIMEOFPROCEDURE;
property EXTENTOFEXAM: Nullable read FEXTENTOFEXAM write FEXTENTOFEXAM;
property RECOMMENDATIONS: Nullable read FRECOMMENDATIONS write FRECOMMENDATIONS;
property LIMITATIONSOFEXAM: Nullable read FLIMITATIONSOFEXAM write FLIMITATIONSOFEXAM;
property ICDCODES: Nullable read FICDCODES write FICDCODES;
property COMMENTS: Nullable read FCOMMENTS write FCOMMENTS;
property INDICATIONS: Nullable read FINDICATIONS write FINDICATIONS;
property AGE: Nullable read FAGE write FAGE;
property CUSTOM1: Nullable read FCUSTOM1 write FCUSTOM1;
property SIGNOFF: Nullable read FSIGNOFF write FSIGNOFF;
property PROCTYPE: Nullable read FPROCTYPE write FPROCTYPE;
property REVIEWPHYSICIAN: Nullable read FREVIEWPHYSICIAN write FREVIEWPHYSICIAN;
property REVIEWDATE: Nullable read FREVIEWDATE write FREVIEWDATE;
property ORDERINGPROVIDER: Nullable read FORDERINGPROVIDER write FORDERINGPROVIDER;
property TECHNICIAN: Nullable read FTECHNICIAN write FTECHNICIAN;
property NURSE: Nullable read FNURSE write FNURSE;
property REFERRINGPHYSICIAN: Nullable read FREFERRINGPHYSICIAN write FREFERRINGPHYSICIAN;
property LOCATION: Nullable read FLOCATION write FLOCATION;
property CANCELREASON: Nullable read FCANCELREASON write FCANCELREASON;
property PROCEDUREREASON: Nullable read FPROCEDUREREASON write FPROCEDUREREASON;
property TRACTIMAGE: TBlob read FTRACTIMAGE write FTRACTIMAGE;
property DIAGRAMIMAGE: TBlob read FDIAGRAMIMAGE write FDIAGRAMIMAGE;
property DIAGRAMANNOTATION: TBlob read FDIAGRAMANNOTATION write FDIAGRAMANNOTATION;
property CUSTOM2: Nullable read FCUSTOM2 write FCUSTOM2;
property PROCNAME: Nullable read FPROCNAME write FPROCNAME;
property VISUALIZATION: Nullable read FVISUALIZATION write FVISUALIZATION;
property TOLERANCE: Nullable read FTOLERANCE write FTOLERANCE;
property COMPLICATIONS: Nullable read FCOMPLICATIONS write FCOMPLICATIONS;
property DISCHARGEINS: Nullable read FDISCHARGEINS write FDISCHARGEINS;
property DISCHARGEDTO: Nullable read FDISCHARGEDTO write FDISCHARGEDTO;
property APPOINTMENTINFO: Nullable read FAPPOINTMENTINFO write FAPPOINTMENTINFO;
property ADDINSTR: Nullable read FADDINSTR write FADDINSTR;
property REFERRALS: Nullable read FREFERRALS write FREFERRALS;
property DI_CUSTOM1: Nullable read FDI_CUSTOM1 write FDI_CUSTOM1;
property ISOLATIONPRECAUTIONS: Nullable read FISOLATIONPRECAUTIONS write FISOLATIONPRECAUTIONS;
property ASSISTANT: Nullable read FASSISTANT write FASSISTANT;
property MEDICATIONS: Nullable read FMEDICATIONS write FMEDICATIONS;
property PPN_CONDITION: Nullable read FPPN_CONDITION write FPPN_CONDITION;
property PPN_PROGRESS: Nullable read FPPN_PROGRESS write FPPN_PROGRESS;
property PPN_CUSTOM: Nullable read FPPN_CUSTOM write FPPN_CUSTOM;
property PPN_CUSTOM2: Nullable read FPPN_CUSTOM2 write FPPN_CUSTOM2;
property INSTRUMENTS: Nullable read FINSTRUMENTS write FINSTRUMENTS;
property SPECIALINSTRUCTIONS: Nullable read FSPECIALINSTRUCTIONS write FSPECIALINSTRUCTIONS;
property FELLOW: Nullable read FFELLOW write FFELLOW;
property ESTIMATEDBLOODLOSS: Nullable read FESTIMATEDBLOODLOSS write FESTIMATEDBLOODLOSS;
property BLOODLOSSUNIT: Nullable read FBLOODLOSSUNIT write FBLOODLOSSUNIT;
property PROCEDUREPROPOSED: Nullable read FPROCEDUREPROPOSED write FPROCEDUREPROPOSED;
property ER_CONTRAINDICATIONS: Nullable read FER_CONTRAINDICATIONS write FER_CONTRAINDICATIONS;
property TECH_DIFFICULT: Nullable read FTECH_DIFFICULT write FTECH_DIFFICULT;
property PAINSCALE: Nullable read FPAINSCALE write FPAINSCALE;
property INTENDEDEXTENT: Nullable read FINTENDEDEXTENT write FINTENDEDEXTENT;
property SITE: Nullable read FSITE write FSITE;
property NOOFPASSES: Nullable read FNOOFPASSES write FNOOFPASSES;
property POSITIONS: Nullable read FPOSITIONS write FPOSITIONS;
property NEEDLESIZE: Nullable read FNEEDLESIZE write FNEEDLESIZE;
property PPN_ORDERS: Nullable read FPPN_ORDERS write FPPN_ORDERS;
property DI_CUSTOM2: Nullable read FDI_CUSTOM2 write FDI_CUSTOM2;
property PROC_CUSTOM1: Nullable read FPROC_CUSTOM1 write FPROC_CUSTOM1;
property PROC_CUSTOM2: Nullable read FPROC_CUSTOM2 write FPROC_CUSTOM2;
property VISITNUM: Nullable read FVISITNUM write FVISITNUM;
property ORDERNUM: Nullable read FORDERNUM write FORDERNUM;
property INOUTPATIENT: Nullable read FINOUTPATIENT write FINOUTPATIENT;
property INPATINFO: Nullable read FINPATINFO write FINPATINFO;
property TIMEOFARRIVAL: Nullable read FTIMEOFARRIVAL write FTIMEOFARRIVAL;
property SPECIALITY: Nullable read FSPECIALITY write FSPECIALITY;
property DIFFICULTYLEVEL: Nullable read FDIFFICULTYLEVEL write FDIFFICULTYLEVEL;
property ADDENDUM_COMPLICATIONS: Nullable read FADDENDUM_COMPLICATIONS write FADDENDUM_COMPLICATIONS;
property ADDENDUM_ICD: Nullable read FADDENDUM_ICD write FADDENDUM_ICD;
property ADDENDUM_CPT: Nullable read FADDENDUM_CPT write FADDENDUM_CPT;
property HL7_SEND_STATUS: Nullable read FHL7_SEND_STATUS write FHL7_SEND_STATUS;
property GROUPNAME: Nullable read FGROUPNAME write FGROUPNAME;
property NURSTATUS: Nullable read FNURSTATUS write FNURSTATUS;
property NURFINISHDATE: Nullable read FNURFINISHDATE write FNURFINISHDATE;
property NURFINISHTIME: Nullable read FNURFINISHTIME write FNURFINISHTIME;
property NURSIGNOFFBY: Nullable read FNURSIGNOFFBY write FNURSIGNOFFBY;
property PROCEDURETECHNIQUE: TBlob read FPROCEDURETECHNIQUE write FPROCEDURETECHNIQUE;
property FINDINGS: TBlob read FFINDINGS write FFINDINGS;
property DIAGNOSIS: TBlob read FDIAGNOSIS write FDIAGNOSIS;
property ADDENDUMDATA: TBlob read FADDENDUMDATA write FADDENDUMDATA;
property MEDRECONCILIATION: Nullable read FMEDRECONCILIATION write FMEDRECONCILIATION;
property DURATIONOFPROCEDURE: Nullable read FDURATIONOFPROCEDURE write FDURATIONOFPROCEDURE;
property DURATIONOFFLOROUSE: Nullable read FDURATIONOFFLOROUSE write FDURATIONOFFLOROUSE;
property ANESTHESIOLOGIST: Nullable read FANESTHESIOLOGIST write FANESTHESIOLOGIST;
property FIRSTTIMESCREENING: Nullable read FFIRSTTIMESCREENING write FFIRSTTIMESCREENING;
property HL7_SEND_STATUS_ADDENDUM: Nullable read FHL7_SEND_STATUS_ADDENDUM write FHL7_SEND_STATUS_ADDENDUM;
property NURSE2: Nullable read FNURSE2 write FNURSE2;
property COMPLICATION_YES_NONE: Nullable read FCOMPLICATION_YES_NONE write FCOMPLICATION_YES_NONE;
property NURSEGROUPNAME: Nullable read FNURSEGROUPNAME write FNURSEGROUPNAME;
property HL7_SEND_STATUS_PROFCRG: Nullable read FHL7_SEND_STATUS_PROFCRG write FHL7_SEND_STATUS_PROFCRG;
property URINEVOLUME: Nullable read FURINEVOLUME write FURINEVOLUME;
property HL7_SEND_STATUS_TEXT: Nullable read FHL7_SEND_STATUS_TEXT write FHL7_SEND_STATUS_TEXT;
property NUMBEROFSPECIMENS: Nullable read FNUMBEROFSPECIMENS write FNUMBEROFSPECIMENS;
property GROSS: TBlob read FGROSS write FGROSS;
property IMPLANTS: Nullable read FIMPLANTS write FIMPLANTS;
property CLOTESTPOSITIVE: Nullable read FCLOTESTPOSITIVE write FCLOTESTPOSITIVE;
property CLOTESTTAKEN: Nullable read FCLOTESTTAKEN write FCLOTESTTAKEN;
property PREPAINLEVEL: Nullable read FPREPAINLEVEL write FPREPAINLEVEL;
property PLANSTATUS: Nullable read FPLANSTATUS write FPLANSTATUS;
property FELLOWPROCPERFORMED: Nullable read FFELLOWPROCPERFORMED write FFELLOWPROCPERFORMED;
property DURATIONOFFLOROUSE_SEC: Nullable read FDURATIONOFFLOROUSE_SEC write FDURATIONOFFLOROUSE_SEC;
property SECONDEXTENT: Nullable read FSECONDEXTENT write FSECONDEXTENT;
property ES_CODE: Nullable read FES_CODE write FES_CODE;
property COLONOSCOPYTYPE: Nullable read FCOLONOSCOPYTYPE write FCOLONOSCOPYTYPE;
property CUSTOM3: Nullable read FCUSTOM3 write FCUSTOM3;
property CUSTOM4: Nullable read FCUSTOM4 write FCUSTOM4;
property CUSTOM5: Nullable read FCUSTOM5 write FCUSTOM5;
property CUSTOM6: Nullable read FCUSTOM6 write FCUSTOM6;
property SECONDPHYSICIAN: Nullable read FSECONDPHYSICIAN write FSECONDPHYSICIAN;
property DATEOFPATHARRIVAL: Nullable read FDATEOFPATHARRIVAL write FDATEOFPATHARRIVAL;
property TIMEOFPATHARRIVAL: Nullable read FTIMEOFPATHARRIVAL write FTIMEOFPATHARRIVAL;
property SPECIMENCOLLECTIONDATE: Nullable read FSPECIMENCOLLECTIONDATE write FSPECIMENCOLLECTIONDATE;
property TIMEFINISHEDBYFELLOW: Nullable read FTIMEFINISHEDBYFELLOW write FTIMEFINISHEDBYFELLOW;
property DATEFINISHEDBYFELLOW: Nullable read FDATEFINISHEDBYFELLOW write FDATEFINISHEDBYFELLOW;
property REFCODE: Nullable read FREFCODE write FREFCODE;
property ORDEREDBY: Nullable read FORDEREDBY write FORDEREDBY;
property IMAGECOUNT: Nullable read FIMAGECOUNT write FIMAGECOUNT;
property PRESEDATIONCOMMETS: Nullable read FPRESEDATIONCOMMETS write FPRESEDATIONCOMMETS;
property LASTCOLONOSCOPYPERFOMED: Nullable read FLASTCOLONOSCOPYPERFOMED write FLASTCOLONOSCOPYPERFOMED;
property USERCODE: Nullable read FUSERCODE write FUSERCODE;
property AGEMONTH: Nullable read FAGEMONTH write FAGEMONTH;
property TISSUESUBMITTED: TBlob read FTISSUESUBMITTED write FTISSUESUBMITTED;
property VISITTYPE: Nullable read FVISITTYPE write FVISITTYPE;
property PATIENTTYPE: Nullable read FPATIENTTYPE write FPATIENTTYPE;
property PRIMARYCAREPHY: Nullable read FPRIMARYCAREPHY write FPRIMARYCAREPHY;
property RECALLNUM: Nullable read FRECALLNUM write FRECALLNUM;
property STATUSID: Nullable read FSTATUSID write FSTATUSID;
property PATIENTTEACHING_ALL: TBlob read FPATIENTTEACHING_ALL write FPATIENTTEACHING_ALL;
property PATIENTTEACHING_PREV: TBlob read FPATIENTTEACHING_PREV write FPATIENTTEACHING_PREV;
property CHAIRSTARTTIME: Nullable read FCHAIRSTARTTIME write FCHAIRSTARTTIME;
property PROCEDURESTARTTIME: Nullable read FPROCEDURESTARTTIME write FPROCEDURESTARTTIME;
property TIMEOUTTIME: Nullable read FTIMEOUTTIME write FTIMEOUTTIME;
property TIMEOUTQUESTIONS: TBlob read FTIMEOUTQUESTIONS write FTIMEOUTQUESTIONS;
property O2STOP: Nullable read FO2STOP write FO2STOP;
property O2START: Nullable read FO2START write FO2START;
property O2RATE_ROUTE: Nullable read FO2RATE_ROUTE write FO2RATE_ROUTE;
property ROOMENDTIME: Nullable read FROOMENDTIME write FROOMENDTIME;
property PROCENDTIME: Nullable read FPROCENDTIME write FPROCENDTIME;
property REPORTGIVENTO: Nullable read FREPORTGIVENTO write FREPORTGIVENTO;
property PATIENTTRANSTO: Nullable read FPATIENTTRANSTO write FPATIENTTRANSTO;
property INCOMPLETEREASON: Nullable read FINCOMPLETEREASON write FINCOMPLETEREASON;
property PROCEDURECOMPLETE: Nullable read FPROCEDURECOMPLETE write FPROCEDURECOMPLETE;
property CHAIRENDTIME: Nullable read FCHAIRENDTIME write FCHAIRENDTIME;
property PAT_HEIGHTFT: Nullable read FPAT_HEIGHTFT write FPAT_HEIGHTFT;
property PAT_HEIGHTINC: Nullable read FPAT_HEIGHTINC write FPAT_HEIGHTINC;
property PAT_HEIGHTMTS: Nullable read FPAT_HEIGHTMTS write FPAT_HEIGHTMTS;
property PAT_HEIGHTCM: Nullable read FPAT_HEIGHTCM write FPAT_HEIGHTCM;
property PAT_WEIGHTLBS: Nullable read FPAT_WEIGHTLBS write FPAT_WEIGHTLBS;
property PAT_WEIGHTKG: Nullable read FPAT_WEIGHTKG write FPAT_WEIGHTKG;
property PAT_WEIGHTLOZ: Nullable read FPAT_WEIGHTLOZ write FPAT_WEIGHTLOZ;
property HEIGHTMTSCM: Nullable read FHEIGHTMTSCM write FHEIGHTMTSCM;
property BMI: Nullable read FBMI write FBMI;
property BSA: Nullable read FBSA write FBSA;
property P_PID: TPATIENTS read FP_PID write FP_PID;
end;

TDicDictionary = class
private
FNURHISTORY: TNURHISTORYTableDictionary;
FPATIENTS: TPATIENTSTableDictionary;
FPROCEDURE_SURGERY: TPROCEDURE_SURGERYTableDictionary;
function GetNURHISTORY: TNURHISTORYTableDictionary;
function GetPATIENTS: TPATIENTSTableDictionary;
function GetPROCEDURE_SURGERY: TPROCEDURE_SURGERYTableDictionary;
public
destructor Destroy; override;
property NURHISTORY: TNURHISTORYTableDictionary read GetNURHISTORY;
property PATIENTS: TPATIENTSTableDictionary read GetPATIENTS;
property PROCEDURE_SURGERY: TPROCEDURE_SURGERYTableDictionary read GetPROCEDURE_SURGERY;
end;

TNURHISTORYTableDictionary = class
private
FNURSE: TDictionaryAttribute;
FDATEOFHISTORY: TDictionaryAttribute;
FTIMEOFHISTORY: TDictionaryAttribute;
FCLINIC: TDictionaryAttribute;
FVITALS: TDictionaryAttribute;
FPAT_HEIGHTFT: TDictionaryAttribute;
FPAT_HEIGHTINC: TDictionaryAttribute;
FPAT_HEIGHTMTS: TDictionaryAttribute;
FPAT_HEIGHTCM: TDictionaryAttribute;
FPAT_WEIGHTLBS: TDictionaryAttribute;
FPAT_WEIGHTLOZ: TDictionaryAttribute;
FPAT_WEIGHTKG: TDictionaryAttribute;
FINFO_PROVIDEDBY: TDictionaryAttribute;
FHIS_EVAL_PERFORMED: TDictionaryAttribute;
FHIS_EVALPERFORM_DROPDOWN: TDictionaryAttribute;
FRESPIRATORY: TDictionaryAttribute;
FGIDISORDER: TDictionaryAttribute;
FNEUROMASCULAR: TDictionaryAttribute;
FONCOLOGY: TDictionaryAttribute;
FREPRODUCTIVE: TDictionaryAttribute;
FPOSTMENOPAUSAL: TDictionaryAttribute;
FLNP_DATE: TDictionaryAttribute;
FENT: TDictionaryAttribute;
FGU: TDictionaryAttribute;
FENDOCRINE: TDictionaryAttribute;
FPSYCHOSOCIAL: TDictionaryAttribute;
FCARDIOVASCULAR: TDictionaryAttribute;
FDISEASES: TDictionaryAttribute;
FHEMATOLOGICAL: TDictionaryAttribute;
FPEDIATRIC_PATIENT: TDictionaryAttribute;
FTOBACCO: TDictionaryAttribute;
FTOBACCO_HOWMUCH: TDictionaryAttribute;
FTOBACCO_FREQUENCY: TDictionaryAttribute;
FETOH: TDictionaryAttribute;
FETOH_HOWMUCH: TDictionaryAttribute;
FETOH_FREQUENCY: TDictionaryAttribute;
FRECDRUGUSE: TDictionaryAttribute;
FRECDRUGUSE_HOWMUCH: TDictionaryAttribute;
FRECDRUGUSE_FREQUENCY: TDictionaryAttribute;
FCUSTOM_PH: TDictionaryAttribute;
FCUSTOM_OTHERPH: TDictionaryAttribute;
FTB_HEMOPTYSIS: TDictionaryAttribute;
FTB_ASTHMA: TDictionaryAttribute;
FTB_WEIGHTLOSS: TDictionaryAttribute;
FTB_NIGHTSWEATS: TDictionaryAttribute;
FTB_POSSKINTEST: TDictionaryAttribute;
FTBISOLATIONPRECINI: TDictionaryAttribute;
FHEALTHHIS_COMMENTS: TDictionaryAttribute;
FPRIOR_ANAESTHESIA_COMP: TDictionaryAttribute;
FPERTINENT_FAMHIST: TDictionaryAttribute;
FPATIENTS_INSTRUCTIONS: TDictionaryAttribute;
FENDTIMEOFEVAL: TDictionaryAttribute;
FCUSTOM1: TDictionaryAttribute;
FGI: TDictionaryAttribute;
FFAMHIST: TDictionaryAttribute;
FHISTORYSTATUS: TDictionaryAttribute;
FDATETIMEOFSIGNOFF: TDictionaryAttribute;
FTB_FATIGUE: TDictionaryAttribute;
FPTHIST: TDictionaryAttribute;
FMEDHIST: TDictionaryAttribute;
FSURGHIST: TDictionaryAttribute;
FALLERGIES_REACTION: TDictionaryAttribute;
FPASTPROC: TDictionaryAttribute;
FPASTPROC_RESULTS: TDictionaryAttribute;
FPASTPROC_CLINIC: TDictionaryAttribute;
FPASTPROC_DATE: TDictionaryAttribute;
FSOCIALHIST: TDictionaryAttribute;
FLABRESULT: TDictionaryAttribute;
FLABRESULT_COMMENT: TDictionaryAttribute;
FDIABETES: TDictionaryAttribute;
FHEARTDISEASE: TDictionaryAttribute;
FIRREGULARHEARTBEAT: TDictionaryAttribute;
FHEARTMURMUR: TDictionaryAttribute;
FHEARTMURMUR_TYPE: TDictionaryAttribute;
FMITRALVALVEPROLAPSE: TDictionaryAttribute;
FVALVEREPLACEMENT: TDictionaryAttribute;
FPACEMAKERICD: TDictionaryAttribute;
FHYPERTENSION: TDictionaryAttribute;
FVASCULARGRAFTS: TDictionaryAttribute;
FHEPATITIS: TDictionaryAttribute;
FHIV: TDictionaryAttribute;
FKIDNEYDISEASE: TDictionaryAttribute;
FLUNG_BREATHINGPROBLEMS: TDictionaryAttribute;
FASTHMA: TDictionaryAttribute;
FEMPHYSEMA: TDictionaryAttribute;
FCOPD: TDictionaryAttribute;
FSLEEPAPNEA: TDictionaryAttribute;
FNEUROLOGICALDISORDER: TDictionaryAttribute;
FMUSCULOSKELETALDISORDER: TDictionaryAttribute;
FBLEEDINGDISORDER: TDictionaryAttribute;
FGLAUCOMA: TDictionaryAttribute;
FPREGNANT: TDictionaryAttribute;
FSEIZUREDISORDER: TDictionaryAttribute;
FPROSTHETICJOINTS: TDictionaryAttribute;
FCANCER: TDictionaryAttribute;
FEIOH: TDictionaryAttribute;
FEIOH_HOWMUCH: TDictionaryAttribute;
FOTHER: TDictionaryAttribute;
FOTHER_VAL: TDictionaryAttribute;
FVISION: TDictionaryAttribute;
FHEARINGLOSS: TDictionaryAttribute;
FPRESENTILLNESS: TDictionaryAttribute;
FCMEDHIST: TDictionaryAttribute;
FALLERGIES: TDictionaryAttribute;
FVISION_HEARINGLOSS: TDictionaryAttribute;
FCHIEF_COMPLAINT: TDictionaryAttribute;
FMEDS: TDictionaryAttribute;
FANTICOAGULANTS: TDictionaryAttribute;
FPAT_BMI: TDictionaryAttribute;
FHISTORYREPORT: TDictionaryAttribute;
FCOMMENTS: TDictionaryAttribute;
FPAT_BSA: TDictionaryAttribute;
FPREOPCONTACTDATE: TDictionaryAttribute;
FPREOPCONTACTTIME: TDictionaryAttribute;
FPREOPCONTACTPERSON: TDictionaryAttribute;
FPREOPCONTACTRELATIONSHIP: TDictionaryAttribute;
FPREOPCONTACTINITIATOR: TDictionaryAttribute;
FPREOPCONTACTREASON: TDictionaryAttribute;
FTIMEOFSIGNOFF: TDictionaryAttribute;
FPROCEDURENUMBER: TDictionaryAssociation;
public
constructor Create;
property NURSE: TDictionaryAttribute read FNURSE;
property DATEOFHISTORY: TDictionaryAttribute read FDATEOFHISTORY;
property TIMEOFHISTORY: TDictionaryAttribute read FTIMEOFHISTORY;
property CLINIC: TDictionaryAttribute read FCLINIC;
property VITALS: TDictionaryAttribute read FVITALS;
property PAT_HEIGHTFT: TDictionaryAttribute read FPAT_HEIGHTFT;
property PAT_HEIGHTINC: TDictionaryAttribute read FPAT_HEIGHTINC;
property PAT_HEIGHTMTS: TDictionaryAttribute read FPAT_HEIGHTMTS;
property PAT_HEIGHTCM: TDictionaryAttribute read FPAT_HEIGHTCM;
property PAT_WEIGHTLBS: TDictionaryAttribute read FPAT_WEIGHTLBS;
property PAT_WEIGHTLOZ: TDictionaryAttribute read FPAT_WEIGHTLOZ;
property PAT_WEIGHTKG: TDictionaryAttribute read FPAT_WEIGHTKG;
property INFO_PROVIDEDBY: TDictionaryAttribute read FINFO_PROVIDEDBY;
property HIS_EVAL_PERFORMED: TDictionaryAttribute read FHIS_EVAL_PERFORMED;
property HIS_EVALPERFORM_DROPDOWN: TDictionaryAttribute read FHIS_EVALPERFORM_DROPDOWN;
property RESPIRATORY: TDictionaryAttribute read FRESPIRATORY;
property GIDISORDER: TDictionaryAttribute read FGIDISORDER;
property NEUROMASCULAR: TDictionaryAttribute read FNEUROMASCULAR;
property ONCOLOGY: TDictionaryAttribute read FONCOLOGY;
property REPRODUCTIVE: TDictionaryAttribute read FREPRODUCTIVE;
property POSTMENOPAUSAL: TDictionaryAttribute read FPOSTMENOPAUSAL;
property LNP_DATE: TDictionaryAttribute read FLNP_DATE;
property ENT: TDictionaryAttribute read FENT;
property GU: TDictionaryAttribute read FGU;
property ENDOCRINE: TDictionaryAttribute read FENDOCRINE;
property PSYCHOSOCIAL: TDictionaryAttribute read FPSYCHOSOCIAL;
property CARDIOVASCULAR: TDictionaryAttribute read FCARDIOVASCULAR;
property DISEASES: TDictionaryAttribute read FDISEASES;
property HEMATOLOGICAL: TDictionaryAttribute read FHEMATOLOGICAL;
property PEDIATRIC_PATIENT: TDictionaryAttribute read FPEDIATRIC_PATIENT;
property TOBACCO: TDictionaryAttribute read FTOBACCO;
property TOBACCO_HOWMUCH: TDictionaryAttribute read FTOBACCO_HOWMUCH;
property TOBACCO_FREQUENCY: TDictionaryAttribute read FTOBACCO_FREQUENCY;
property ETOH: TDictionaryAttribute read FETOH;
property ETOH_HOWMUCH: TDictionaryAttribute read FETOH_HOWMUCH;
property ETOH_FREQUENCY: TDictionaryAttribute read FETOH_FREQUENCY;
property RECDRUGUSE: TDictionaryAttribute read FRECDRUGUSE;
property RECDRUGUSE_HOWMUCH: TDictionaryAttribute read FRECDRUGUSE_HOWMUCH;
property RECDRUGUSE_FREQUENCY: TDictionaryAttribute read FRECDRUGUSE_FREQUENCY;
property CUSTOM_PH: TDictionaryAttribute read FCUSTOM_PH;
property CUSTOM_OTHERPH: TDictionaryAttribute read FCUSTOM_OTHERPH;
property TB_HEMOPTYSIS: TDictionaryAttribute read FTB_HEMOPTYSIS;
property TB_ASTHMA: TDictionaryAttribute read FTB_ASTHMA;
property TB_WEIGHTLOSS: TDictionaryAttribute read FTB_WEIGHTLOSS;
property TB_NIGHTSWEATS: TDictionaryAttribute read FTB_NIGHTSWEATS;
property TB_POSSKINTEST: TDictionaryAttribute read FTB_POSSKINTEST;
property TBISOLATIONPRECINI: TDictionaryAttribute read FTBISOLATIONPRECINI;
property HEALTHHIS_COMMENTS: TDictionaryAttribute read FHEALTHHIS_COMMENTS;
property PRIOR_ANAESTHESIA_COMP: TDictionaryAttribute read FPRIOR_ANAESTHESIA_COMP;
property PERTINENT_FAMHIST: TDictionaryAttribute read FPERTINENT_FAMHIST;
property PATIENTS_INSTRUCTIONS: TDictionaryAttribute read FPATIENTS_INSTRUCTIONS;
property ENDTIMEOFEVAL: TDictionaryAttribute read FENDTIMEOFEVAL;
property CUSTOM1: TDictionaryAttribute read FCUSTOM1;
property GI: TDictionaryAttribute read FGI;
property FAMHIST: TDictionaryAttribute read FFAMHIST;
property HISTORYSTATUS: TDictionaryAttribute read FHISTORYSTATUS;
property DATETIMEOFSIGNOFF: TDictionaryAttribute read FDATETIMEOFSIGNOFF;
property TB_FATIGUE: TDictionaryAttribute read FTB_FATIGUE;
property PTHIST: TDictionaryAttribute read FPTHIST;
property MEDHIST: TDictionaryAttribute read FMEDHIST;
property SURGHIST: TDictionaryAttribute read FSURGHIST;
property ALLERGIES_REACTION: TDictionaryAttribute read FALLERGIES_REACTION;
property PASTPROC: TDictionaryAttribute read FPASTPROC;
property PASTPROC_RESULTS: TDictionaryAttribute read FPASTPROC_RESULTS;
property PASTPROC_CLINIC: TDictionaryAttribute read FPASTPROC_CLINIC;
property PASTPROC_DATE: TDictionaryAttribute read FPASTPROC_DATE;
property SOCIALHIST: TDictionaryAttribute read FSOCIALHIST;
property LABRESULT: TDictionaryAttribute read FLABRESULT;
property LABRESULT_COMMENT: TDictionaryAttribute read FLABRESULT_COMMENT;
property DIABETES: TDictionaryAttribute read FDIABETES;
property HEARTDISEASE: TDictionaryAttribute read FHEARTDISEASE;
property IRREGULARHEARTBEAT: TDictionaryAttribute read FIRREGULARHEARTBEAT;
property HEARTMURMUR: TDictionaryAttribute read FHEARTMURMUR;
property HEARTMURMUR_TYPE: TDictionaryAttribute read FHEARTMURMUR_TYPE;
property MITRALVALVEPROLAPSE: TDictionaryAttribute read FMITRALVALVEPROLAPSE;
property VALVEREPLACEMENT: TDictionaryAttribute read FVALVEREPLACEMENT;
property PACEMAKERICD: TDictionaryAttribute read FPACEMAKERICD;
property HYPERTENSION: TDictionaryAttribute read FHYPERTENSION;
property VASCULARGRAFTS: TDictionaryAttribute read FVASCULARGRAFTS;
property HEPATITIS: TDictionaryAttribute read FHEPATITIS;
property HIV: TDictionaryAttribute read FHIV;
property KIDNEYDISEASE: TDictionaryAttribute read FKIDNEYDISEASE;
property LUNG_BREATHINGPROBLEMS: TDictionaryAttribute read FLUNG_BREATHINGPROBLEMS;
property ASTHMA: TDictionaryAttribute read FASTHMA;
property EMPHYSEMA: TDictionaryAttribute read FEMPHYSEMA;
property COPD: TDictionaryAttribute read FCOPD;
property SLEEPAPNEA: TDictionaryAttribute read FSLEEPAPNEA;
property NEUROLOGICALDISORDER: TDictionaryAttribute read FNEUROLOGICALDISORDER;
property MUSCULOSKELETALDISORDER: TDictionaryAttribute read FMUSCULOSKELETALDISORDER;
property BLEEDINGDISORDER: TDictionaryAttribute read FBLEEDINGDISORDER;
property GLAUCOMA: TDictionaryAttribute read FGLAUCOMA;
property PREGNANT: TDictionaryAttribute read FPREGNANT;
property SEIZUREDISORDER: TDictionaryAttribute read FSEIZUREDISORDER;
property PROSTHETICJOINTS: TDictionaryAttribute read FPROSTHETICJOINTS;
property CANCER: TDictionaryAttribute read FCANCER;
property EIOH: TDictionaryAttribute read FEIOH;
property EIOH_HOWMUCH: TDictionaryAttribute read FEIOH_HOWMUCH;
property OTHER: TDictionaryAttribute read FOTHER;
property OTHER_VAL: TDictionaryAttribute read FOTHER_VAL;
property VISION: TDictionaryAttribute read FVISION;
property HEARINGLOSS: TDictionaryAttribute read FHEARINGLOSS;
property PRESENTILLNESS: TDictionaryAttribute read FPRESENTILLNESS;
property CMEDHIST: TDictionaryAttribute read FCMEDHIST;
property ALLERGIES: TDictionaryAttribute read FALLERGIES;
property VISION_HEARINGLOSS: TDictionaryAttribute read FVISION_HEARINGLOSS;
property CHIEF_COMPLAINT: TDictionaryAttribute read FCHIEF_COMPLAINT;
property MEDS: TDictionaryAttribute read FMEDS;
property ANTICOAGULANTS: TDictionaryAttribute read FANTICOAGULANTS;
property PAT_BMI: TDictionaryAttribute read FPAT_BMI;
property HISTORYREPORT: TDictionaryAttribute read FHISTORYREPORT;
property COMMENTS: TDictionaryAttribute read FCOMMENTS;
property PAT_BSA: TDictionaryAttribute read FPAT_BSA;
property PREOPCONTACTDATE: TDictionaryAttribute read FPREOPCONTACTDATE;
property PREOPCONTACTTIME: TDictionaryAttribute read FPREOPCONTACTTIME;
property PREOPCONTACTPERSON: TDictionaryAttribute read FPREOPCONTACTPERSON;
property PREOPCONTACTRELATIONSHIP: TDictionaryAttribute read FPREOPCONTACTRELATIONSHIP;
property PREOPCONTACTINITIATOR: TDictionaryAttribute read FPREOPCONTACTINITIATOR;
property PREOPCONTACTREASON: TDictionaryAttribute read FPREOPCONTACTREASON;
property TIMEOFSIGNOFF: TDictionaryAttribute read FTIMEOFSIGNOFF;
property PROCEDURENUMBER: TDictionaryAssociation read FPROCEDURENUMBER;
end;

TPATIENTSTableDictionary = class
private
FP_PID: TDictionaryAttribute;
FLASTNAME: TDictionaryAttribute;
FFIRSTNAME: TDictionaryAttribute;
FP_ENAME: TDictionaryAttribute;
FMI: TDictionaryAttribute;
FTITLE: TDictionaryAttribute;
FP_DOB: TDictionaryAttribute;
FP_AGE: TDictionaryAttribute;
FP_SEX: TDictionaryAttribute;
FRACE: TDictionaryAttribute;
FADDRESS1: TDictionaryAttribute;
FADDRESS2: TDictionaryAttribute;
FCITY: TDictionaryAttribute;
FSTATE: TDictionaryAttribute;
FZIP: TDictionaryAttribute;
FPHONE: TDictionaryAttribute;
FFAX: TDictionaryAttribute;
FOTHERPHONE: TDictionaryAttribute;
FSSN: TDictionaryAttribute;
FACTNUM: TDictionaryAttribute;
FCUST1: TDictionaryAttribute;
FCUST2: TDictionaryAttribute;
FCUST3: TDictionaryAttribute;
FCUST4: TDictionaryAttribute;
FDATE_ENTERED: TDictionaryAttribute;
FWORKPHONE: TDictionaryAttribute;
FTIMEOFARRIVAL: TDictionaryAttribute;
FDATEOFARRIVAL: TDictionaryAttribute;
FOTHERNAME: TDictionaryAttribute;
FEMAIL: TDictionaryAttribute;
FSIGNATUREONFILE: TDictionaryAttribute;
FSIGNATUREDATE: TDictionaryAttribute;
FMARITALSTATUS: TDictionaryAttribute;
FDECEASED: TDictionaryAttribute;
FDATE_OF_DEATH: TDictionaryAttribute;
FLOCATION_OF_DEATH: TDictionaryAttribute;
FREASON_OF_DEATH: TDictionaryAttribute;
FEXEMPT: TDictionaryAttribute;
FPAST_MEDICALHIST: TDictionaryAttribute;
FPAST_SURGICALHIST: TDictionaryAttribute;
FALLERGIES: TDictionaryAttribute;
FFAMILY_HIST: TDictionaryAttribute;
FPREV_HOSPITALISATIONS: TDictionaryAttribute;
FSOCIAL_HIST: TDictionaryAttribute;
FCUSTOM1: TDictionaryAttribute;
FCUSTOM2: TDictionaryAttribute;
FCUSTOM3: TDictionaryAttribute;
FCELLPHONE: TDictionaryAttribute;
FCOUNTY: TDictionaryAttribute;
FCOUNTYCODE: TDictionaryAttribute;
FRELIGION: TDictionaryAttribute;
FPATIENT_PICTURE: TDictionaryAttribute;
FMEDSALLERGIES: TDictionaryAttribute;
FOTCALLERGIES: TDictionaryAttribute;
FPRIMARYLANGUAGE: TDictionaryAttribute;
FALTADDRESS1: TDictionaryAttribute;
FALTADDRESS2: TDictionaryAttribute;
FALTADDRESSCITY: TDictionaryAttribute;
FALTADDRESSSTATE: TDictionaryAttribute;
FALTADDRESSZIP: TDictionaryAttribute;
FALTPHONE: TDictionaryAttribute;
FALTCOUNTRY: TDictionaryAttribute;
FSMOKINGSTATUS: TDictionaryAttribute;
FSMOKINGCODE: TDictionaryAttribute;
FETHNICITY: TDictionaryAttribute;
FCOMMUNICATIONPREFERENCE: TDictionaryAttribute;
FPREGNANT: TDictionaryAttribute;
FPREGNANCYWEEK: TDictionaryAttribute;
FUSERID: TDictionaryAttribute;
FPWD: TDictionaryAttribute;
FPWDCHANGEDON: TDictionaryAttribute;
FFIRSTLOGINPWD: TDictionaryAttribute;
FPWDCHANGEFREQ: TDictionaryAttribute;
FPWDEXPIRES: TDictionaryAttribute;
FTIMELYACCESS: TDictionaryAttribute;
FSCHEDULED: TDictionaryAttribute;
FPATBILLINGPID: TDictionaryAttribute;
FTIME_OF_DEATH: TDictionaryAttribute;
FNH_STATUS: TDictionaryAttribute;
FNHS_STATUS: TDictionaryAttribute;
FELIG_CONSENT: TDictionaryAttribute;
Fes_code: TDictionaryAttribute;
FCANCER_HIST: TDictionaryAttribute;
FFACILITYID: TDictionaryAttribute;
FSUFFIX: TDictionaryAttribute;
FISOLATIONPRECAUTIONS: TDictionaryAttribute;
FCOUNTRY: TDictionaryAttribute;
FPATIENTSTAGE: TDictionaryAttribute;
FBSAFORMULA: TDictionaryAttribute;
FENABLEPORTALREGISTRATION: TDictionaryAttribute;
FLASTNAME_ENCRYPTED: TDictionaryAttribute;
public
constructor Create;
property P_PID: TDictionaryAttribute read FP_PID;
property LASTNAME: TDictionaryAttribute read FLASTNAME;
property FIRSTNAME: TDictionaryAttribute read FFIRSTNAME;
property P_ENAME: TDictionaryAttribute read FP_ENAME;
property MI: TDictionaryAttribute read FMI;
property TITLE: TDictionaryAttribute read FTITLE;
property P_DOB: TDictionaryAttribute read FP_DOB;
property P_AGE: TDictionaryAttribute read FP_AGE;
property P_SEX: TDictionaryAttribute read FP_SEX;
property RACE: TDictionaryAttribute read FRACE;
property ADDRESS1: TDictionaryAttribute read FADDRESS1;
property ADDRESS2: TDictionaryAttribute read FADDRESS2;
property CITY: TDictionaryAttribute read FCITY;
property STATE: TDictionaryAttribute read FSTATE;
property ZIP: TDictionaryAttribute read FZIP;
property PHONE: TDictionaryAttribute read FPHONE;
property FAX: TDictionaryAttribute read FFAX;
property OTHERPHONE: TDictionaryAttribute read FOTHERPHONE;
property SSN: TDictionaryAttribute read FSSN;
property ACTNUM: TDictionaryAttribute read FACTNUM;
property CUST1: TDictionaryAttribute read FCUST1;
property CUST2: TDictionaryAttribute read FCUST2;
property CUST3: TDictionaryAttribute read FCUST3;
property CUST4: TDictionaryAttribute read FCUST4;
property DATE_ENTERED: TDictionaryAttribute read FDATE_ENTERED;
property WORKPHONE: TDictionaryAttribute read FWORKPHONE;
property TIMEOFARRIVAL: TDictionaryAttribute read FTIMEOFARRIVAL;
property DATEOFARRIVAL: TDictionaryAttribute read FDATEOFARRIVAL;
property OTHERNAME: TDictionaryAttribute read FOTHERNAME;
property EMAIL: TDictionaryAttribute read FEMAIL;
property SIGNATUREONFILE: TDictionaryAttribute read FSIGNATUREONFILE;
property SIGNATUREDATE: TDictionaryAttribute read FSIGNATUREDATE;
property MARITALSTATUS: TDictionaryAttribute read FMARITALSTATUS;
property DECEASED: TDictionaryAttribute read FDECEASED;
property DATE_OF_DEATH: TDictionaryAttribute read FDATE_OF_DEATH;
property LOCATION_OF_DEATH: TDictionaryAttribute read FLOCATION_OF_DEATH;
property REASON_OF_DEATH: TDictionaryAttribute read FREASON_OF_DEATH;
property EXEMPT: TDictionaryAttribute read FEXEMPT;
property PAST_MEDICALHIST: TDictionaryAttribute read FPAST_MEDICALHIST;
property PAST_SURGICALHIST: TDictionaryAttribute read FPAST_SURGICALHIST;
property ALLERGIES: TDictionaryAttribute read FALLERGIES;
property FAMILY_HIST: TDictionaryAttribute read FFAMILY_HIST;
property PREV_HOSPITALISATIONS: TDictionaryAttribute read FPREV_HOSPITALISATIONS;
property SOCIAL_HIST: TDictionaryAttribute read FSOCIAL_HIST;
property CUSTOM1: TDictionaryAttribute read FCUSTOM1;
property CUSTOM2: TDictionaryAttribute read FCUSTOM2;
property CUSTOM3: TDictionaryAttribute read FCUSTOM3;
property CELLPHONE: TDictionaryAttribute read FCELLPHONE;
property COUNTY: TDictionaryAttribute read FCOUNTY;
property COUNTYCODE: TDictionaryAttribute read FCOUNTYCODE;
property RELIGION: TDictionaryAttribute read FRELIGION;
property PATIENT_PICTURE: TDictionaryAttribute read FPATIENT_PICTURE;
property MEDSALLERGIES: TDictionaryAttribute read FMEDSALLERGIES;
property OTCALLERGIES: TDictionaryAttribute read FOTCALLERGIES;
property PRIMARYLANGUAGE: TDictionaryAttribute read FPRIMARYLANGUAGE;
property ALTADDRESS1: TDictionaryAttribute read FALTADDRESS1;
property ALTADDRESS2: TDictionaryAttribute read FALTADDRESS2;
property ALTADDRESSCITY: TDictionaryAttribute read FALTADDRESSCITY;
property ALTADDRESSSTATE: TDictionaryAttribute read FALTADDRESSSTATE;
property ALTADDRESSZIP: TDictionaryAttribute read FALTADDRESSZIP;
property ALTPHONE: TDictionaryAttribute read FALTPHONE;
property ALTCOUNTRY: TDictionaryAttribute read FALTCOUNTRY;
property SMOKINGSTATUS: TDictionaryAttribute read FSMOKINGSTATUS;
property SMOKINGCODE: TDictionaryAttribute read FSMOKINGCODE;
property ETHNICITY: TDictionaryAttribute read FETHNICITY;
property COMMUNICATIONPREFERENCE: TDictionaryAttribute read FCOMMUNICATIONPREFERENCE;
property PREGNANT: TDictionaryAttribute read FPREGNANT;
property PREGNANCYWEEK: TDictionaryAttribute read FPREGNANCYWEEK;
property USERID: TDictionaryAttribute read FUSERID;
property PWD: TDictionaryAttribute read FPWD;
property PWDCHANGEDON: TDictionaryAttribute read FPWDCHANGEDON;
property FIRSTLOGINPWD: TDictionaryAttribute read FFIRSTLOGINPWD;
property PWDCHANGEFREQ: TDictionaryAttribute read FPWDCHANGEFREQ;
property PWDEXPIRES: TDictionaryAttribute read FPWDEXPIRES;
property TIMELYACCESS: TDictionaryAttribute read FTIMELYACCESS;
property SCHEDULED: TDictionaryAttribute read FSCHEDULED;
property PATBILLINGPID: TDictionaryAttribute read FPATBILLINGPID;
property TIME_OF_DEATH: TDictionaryAttribute read FTIME_OF_DEATH;
property NH_STATUS: TDictionaryAttribute read FNH_STATUS;
property NHS_STATUS: TDictionaryAttribute read FNHS_STATUS;
property ELIG_CONSENT: TDictionaryAttribute read FELIG_CONSENT;
property es_code: TDictionaryAttribute read Fes_code;
property CANCER_HIST: TDictionaryAttribute read FCANCER_HIST;
property FACILITYID: TDictionaryAttribute read FFACILITYID;
property SUFFIX: TDictionaryAttribute read FSUFFIX;
property ISOLATIONPRECAUTIONS: TDictionaryAttribute read FISOLATIONPRECAUTIONS;
property COUNTRY: TDictionaryAttribute read FCOUNTRY;
property PATIENTSTAGE: TDictionaryAttribute read FPATIENTSTAGE;
property BSAFORMULA: TDictionaryAttribute read FBSAFORMULA;
property ENABLEPORTALREGISTRATION: TDictionaryAttribute read FENABLEPORTALREGISTRATION;
property LASTNAME_ENCRYPTED: TDictionaryAttribute read FLASTNAME_ENCRYPTED;
end;

TPROCEDURE_SURGERYTableDictionary = class
private
FID: TDictionaryAttribute;
FENCOUNTERNUM: TDictionaryAttribute;
FFINISHDATE: TDictionaryAttribute;
FFINISHTIME: TDictionaryAttribute;
FAUTHOR: TDictionaryAttribute;
FFACILITY: TDictionaryAttribute;
FREPORTSTITLE: TDictionaryAttribute;
FSTATUS: TDictionaryAttribute;
FDATEOFPROCEDURE: TDictionaryAttribute;
FPROCEDUREPERFORMED: TDictionaryAttribute;
FCPTCODES: TDictionaryAttribute;
FTIMEOFPROCEDURE: TDictionaryAttribute;
FEXTENTOFEXAM: TDictionaryAttribute;
FRECOMMENDATIONS: TDictionaryAttribute;
FLIMITATIONSOFEXAM: TDictionaryAttribute;
FICDCODES: TDictionaryAttribute;
FCOMMENTS: TDictionaryAttribute;
FINDICATIONS: TDictionaryAttribute;
FAGE: TDictionaryAttribute;
FCUSTOM1: TDictionaryAttribute;
FSIGNOFF: TDictionaryAttribute;
FPROCTYPE: TDictionaryAttribute;
FREVIEWPHYSICIAN: TDictionaryAttribute;
FREVIEWDATE: TDictionaryAttribute;
FORDERINGPROVIDER: TDictionaryAttribute;
FTECHNICIAN: TDictionaryAttribute;
FNURSE: TDictionaryAttribute;
FREFERRINGPHYSICIAN: TDictionaryAttribute;
FLOCATION: TDictionaryAttribute;
FCANCELREASON: TDictionaryAttribute;
FPROCEDUREREASON: TDictionaryAttribute;
FTRACTIMAGE: TDictionaryAttribute;
FDIAGRAMIMAGE: TDictionaryAttribute;
FDIAGRAMANNOTATION: TDictionaryAttribute;
FCUSTOM2: TDictionaryAttribute;
FPROCNAME: TDictionaryAttribute;
FVISUALIZATION: TDictionaryAttribute;
FTOLERANCE: TDictionaryAttribute;
FCOMPLICATIONS: TDictionaryAttribute;
FDISCHARGEINS: TDictionaryAttribute;
FDISCHARGEDTO: TDictionaryAttribute;
FAPPOINTMENTINFO: TDictionaryAttribute;
FADDINSTR: TDictionaryAttribute;
FREFERRALS: TDictionaryAttribute;
FDI_CUSTOM1: TDictionaryAttribute;
FISOLATIONPRECAUTIONS: TDictionaryAttribute;
FASSISTANT: TDictionaryAttribute;
FMEDICATIONS: TDictionaryAttribute;
FPPN_CONDITION: TDictionaryAttribute;
FPPN_PROGRESS: TDictionaryAttribute;
FPPN_CUSTOM: TDictionaryAttribute;
FPPN_CUSTOM2: TDictionaryAttribute;
FINSTRUMENTS: TDictionaryAttribute;
FSPECIALINSTRUCTIONS: TDictionaryAttribute;
FFELLOW: TDictionaryAttribute;
FESTIMATEDBLOODLOSS: TDictionaryAttribute;
FBLOODLOSSUNIT: TDictionaryAttribute;
FPROCEDUREPROPOSED: TDictionaryAttribute;
FER_CONTRAINDICATIONS: TDictionaryAttribute;
FTECH_DIFFICULT: TDictionaryAttribute;
FPAINSCALE: TDictionaryAttribute;
FINTENDEDEXTENT: TDictionaryAttribute;
FSITE: TDictionaryAttribute;
FNOOFPASSES: TDictionaryAttribute;
FPOSITIONS: TDictionaryAttribute;
FNEEDLESIZE: TDictionaryAttribute;
FPPN_ORDERS: TDictionaryAttribute;
FDI_CUSTOM2: TDictionaryAttribute;
FPROC_CUSTOM1: TDictionaryAttribute;
FPROC_CUSTOM2: TDictionaryAttribute;
FVISITNUM: TDictionaryAttribute;
FORDERNUM: TDictionaryAttribute;
FINOUTPATIENT: TDictionaryAttribute;
FINPATINFO: TDictionaryAttribute;
FTIMEOFARRIVAL: TDictionaryAttribute;
FSPECIALITY: TDictionaryAttribute;
FDIFFICULTYLEVEL: TDictionaryAttribute;
FADDENDUM_COMPLICATIONS: TDictionaryAttribute;
FADDENDUM_ICD: TDictionaryAttribute;
FADDENDUM_CPT: TDictionaryAttribute;
FHL7_SEND_STATUS: TDictionaryAttribute;
FGROUPNAME: TDictionaryAttribute;
FNURSTATUS: TDictionaryAttribute;
FNURFINISHDATE: TDictionaryAttribute;
FNURFINISHTIME: TDictionaryAttribute;
FNURSIGNOFFBY: TDictionaryAttribute;
FPROCEDURETECHNIQUE: TDictionaryAttribute;
FFINDINGS: TDictionaryAttribute;
FDIAGNOSIS: TDictionaryAttribute;
FADDENDUMDATA: TDictionaryAttribute;
FMEDRECONCILIATION: TDictionaryAttribute;
FDURATIONOFPROCEDURE: TDictionaryAttribute;
FDURATIONOFFLOROUSE: TDictionaryAttribute;
FANESTHESIOLOGIST: TDictionaryAttribute;
FFIRSTTIMESCREENING: TDictionaryAttribute;
FHL7_SEND_STATUS_ADDENDUM: TDictionaryAttribute;
FNURSE2: TDictionaryAttribute;
FCOMPLICATION_YES_NONE: TDictionaryAttribute;
FNURSEGROUPNAME: TDictionaryAttribute;
FHL7_SEND_STATUS_PROFCRG: TDictionaryAttribute;
FURINEVOLUME: TDictionaryAttribute;
FHL7_SEND_STATUS_TEXT: TDictionaryAttribute;
FNUMBEROFSPECIMENS: TDictionaryAttribute;
FGROSS: TDictionaryAttribute;
FIMPLANTS: TDictionaryAttribute;
FCLOTESTPOSITIVE: TDictionaryAttribute;
FCLOTESTTAKEN: TDictionaryAttribute;
FPREPAINLEVEL: TDictionaryAttribute;
FPLANSTATUS: TDictionaryAttribute;
FFELLOWPROCPERFORMED: TDictionaryAttribute;
FDURATIONOFFLOROUSE_SEC: TDictionaryAttribute;
FSECONDEXTENT: TDictionaryAttribute;
FES_CODE: TDictionaryAttribute;
FCOLONOSCOPYTYPE: TDictionaryAttribute;
FCUSTOM3: TDictionaryAttribute;
FCUSTOM4: TDictionaryAttribute;
FCUSTOM5: TDictionaryAttribute;
FCUSTOM6: TDictionaryAttribute;
FSECONDPHYSICIAN: TDictionaryAttribute;
FDATEOFPATHARRIVAL: TDictionaryAttribute;
FTIMEOFPATHARRIVAL: TDictionaryAttribute;
FSPECIMENCOLLECTIONDATE: TDictionaryAttribute;
FTIMEFINISHEDBYFELLOW: TDictionaryAttribute;
FDATEFINISHEDBYFELLOW: TDictionaryAttribute;
FREFCODE: TDictionaryAttribute;
FORDEREDBY: TDictionaryAttribute;
FIMAGECOUNT: TDictionaryAttribute;
FPRESEDATIONCOMMETS: TDictionaryAttribute;
FLASTCOLONOSCOPYPERFOMED: TDictionaryAttribute;
FUSERCODE: TDictionaryAttribute;
FAGEMONTH: TDictionaryAttribute;
FTISSUESUBMITTED: TDictionaryAttribute;
FVISITTYPE: TDictionaryAttribute;
FPATIENTTYPE: TDictionaryAttribute;
FPRIMARYCAREPHY: TDictionaryAttribute;
FRECALLNUM: TDictionaryAttribute;
FSTATUSID: TDictionaryAttribute;
FPATIENTTEACHING_ALL: TDictionaryAttribute;
FPATIENTTEACHING_PREV: TDictionaryAttribute;
FCHAIRSTARTTIME: TDictionaryAttribute;
FPROCEDURESTARTTIME: TDictionaryAttribute;
FTIMEOUTTIME: TDictionaryAttribute;
FTIMEOUTQUESTIONS: TDictionaryAttribute;
FO2STOP: TDictionaryAttribute;
FO2START: TDictionaryAttribute;
FO2RATE_ROUTE: TDictionaryAttribute;
FROOMENDTIME: TDictionaryAttribute;
FPROCENDTIME: TDictionaryAttribute;
FREPORTGIVENTO: TDictionaryAttribute;
FPATIENTTRANSTO: TDictionaryAttribute;
FINCOMPLETEREASON: TDictionaryAttribute;
FPROCEDURECOMPLETE: TDictionaryAttribute;
FCHAIRENDTIME: TDictionaryAttribute;
FPAT_HEIGHTFT: TDictionaryAttribute;
FPAT_HEIGHTINC: TDictionaryAttribute;
FPAT_HEIGHTMTS: TDictionaryAttribute;
FPAT_HEIGHTCM: TDictionaryAttribute;
FPAT_WEIGHTLBS: TDictionaryAttribute;
FPAT_WEIGHTKG: TDictionaryAttribute;
FPAT_WEIGHTLOZ: TDictionaryAttribute;
FHEIGHTMTSCM: TDictionaryAttribute;
FBMI: TDictionaryAttribute;
FBSA: TDictionaryAttribute;
FP_PID: TDictionaryAssociation;
public
constructor Create;
property ID: TDictionaryAttribute read FID;
property ENCOUNTERNUM: TDictionaryAttribute read FENCOUNTERNUM;
property FINISHDATE: TDictionaryAttribute read FFINISHDATE;
property FINISHTIME: TDictionaryAttribute read FFINISHTIME;
property AUTHOR: TDictionaryAttribute read FAUTHOR;
property FACILITY: TDictionaryAttribute read FFACILITY;
property REPORTSTITLE: TDictionaryAttribute read FREPORTSTITLE;
property STATUS: TDictionaryAttribute read FSTATUS;
property DATEOFPROCEDURE: TDictionaryAttribute read FDATEOFPROCEDURE;
property PROCEDUREPERFORMED: TDictionaryAttribute read FPROCEDUREPERFORMED;
property CPTCODES: TDictionaryAttribute read FCPTCODES;
property TIMEOFPROCEDURE: TDictionaryAttribute read FTIMEOFPROCEDURE;
property EXTENTOFEXAM: TDictionaryAttribute read FEXTENTOFEXAM;
property RECOMMENDATIONS: TDictionaryAttribute read FRECOMMENDATIONS;
property LIMITATIONSOFEXAM: TDictionaryAttribute read FLIMITATIONSOFEXAM;
property ICDCODES: TDictionaryAttribute read FICDCODES;
property COMMENTS: TDictionaryAttribute read FCOMMENTS;
property INDICATIONS: TDictionaryAttribute read FINDICATIONS;
property AGE: TDictionaryAttribute read FAGE;
property CUSTOM1: TDictionaryAttribute read FCUSTOM1;
property SIGNOFF: TDictionaryAttribute read FSIGNOFF;
property PROCTYPE: TDictionaryAttribute read FPROCTYPE;
property REVIEWPHYSICIAN: TDictionaryAttribute read FREVIEWPHYSICIAN;
property REVIEWDATE: TDictionaryAttribute read FREVIEWDATE;
property ORDERINGPROVIDER: TDictionaryAttribute read FORDERINGPROVIDER;
property TECHNICIAN: TDictionaryAttribute read FTECHNICIAN;
property NURSE: TDictionaryAttribute read FNURSE;
property REFERRINGPHYSICIAN: TDictionaryAttribute read FREFERRINGPHYSICIAN;
property LOCATION: TDictionaryAttribute read FLOCATION;
property CANCELREASON: TDictionaryAttribute read FCANCELREASON;
property PROCEDUREREASON: TDictionaryAttribute read FPROCEDUREREASON;
property TRACTIMAGE: TDictionaryAttribute read FTRACTIMAGE;
property DIAGRAMIMAGE: TDictionaryAttribute read FDIAGRAMIMAGE;
property DIAGRAMANNOTATION: TDictionaryAttribute read FDIAGRAMANNOTATION;
property CUSTOM2: TDictionaryAttribute read FCUSTOM2;
property PROCNAME: TDictionaryAttribute read FPROCNAME;
property VISUALIZATION: TDictionaryAttribute read FVISUALIZATION;
property TOLERANCE: TDictionaryAttribute read FTOLERANCE;
property COMPLICATIONS: TDictionaryAttribute read FCOMPLICATIONS;
property DISCHARGEINS: TDictionaryAttribute read FDISCHARGEINS;
property DISCHARGEDTO: TDictionaryAttribute read FDISCHARGEDTO;
property APPOINTMENTINFO: TDictionaryAttribute read FAPPOINTMENTINFO;
property ADDINSTR: TDictionaryAttribute read FADDINSTR;
property REFERRALS: TDictionaryAttribute read FREFERRALS;
property DI_CUSTOM1: TDictionaryAttribute read FDI_CUSTOM1;
property ISOLATIONPRECAUTIONS: TDictionaryAttribute read FISOLATIONPRECAUTIONS;
property ASSISTANT: TDictionaryAttribute read FASSISTANT;
property MEDICATIONS: TDictionaryAttribute read FMEDICATIONS;
property PPN_CONDITION: TDictionaryAttribute read FPPN_CONDITION;
property PPN_PROGRESS: TDictionaryAttribute read FPPN_PROGRESS;
property PPN_CUSTOM: TDictionaryAttribute read FPPN_CUSTOM;
property PPN_CUSTOM2: TDictionaryAttribute read FPPN_CUSTOM2;
property INSTRUMENTS: TDictionaryAttribute read FINSTRUMENTS;
property SPECIALINSTRUCTIONS: TDictionaryAttribute read FSPECIALINSTRUCTIONS;
property FELLOW: TDictionaryAttribute read FFELLOW;
property ESTIMATEDBLOODLOSS: TDictionaryAttribute read FESTIMATEDBLOODLOSS;
property BLOODLOSSUNIT: TDictionaryAttribute read FBLOODLOSSUNIT;
property PROCEDUREPROPOSED: TDictionaryAttribute read FPROCEDUREPROPOSED;
property ER_CONTRAINDICATIONS: TDictionaryAttribute read FER_CONTRAINDICATIONS;
property TECH_DIFFICULT: TDictionaryAttribute read FTECH_DIFFICULT;
property PAINSCALE: TDictionaryAttribute read FPAINSCALE;
property INTENDEDEXTENT: TDictionaryAttribute read FINTENDEDEXTENT;
property SITE: TDictionaryAttribute read FSITE;
property NOOFPASSES: TDictionaryAttribute read FNOOFPASSES;
property POSITIONS: TDictionaryAttribute read FPOSITIONS;
property NEEDLESIZE: TDictionaryAttribute read FNEEDLESIZE;
property PPN_ORDERS: TDictionaryAttribute read FPPN_ORDERS;
property DI_CUSTOM2: TDictionaryAttribute read FDI_CUSTOM2;
property PROC_CUSTOM1: TDictionaryAttribute read FPROC_CUSTOM1;
property PROC_CUSTOM2: TDictionaryAttribute read FPROC_CUSTOM2;
property VISITNUM: TDictionaryAttribute read FVISITNUM;
property ORDERNUM: TDictionaryAttribute read FORDERNUM;
property INOUTPATIENT: TDictionaryAttribute read FINOUTPATIENT;
property INPATINFO: TDictionaryAttribute read FINPATINFO;
property TIMEOFARRIVAL: TDictionaryAttribute read FTIMEOFARRIVAL;
property SPECIALITY: TDictionaryAttribute read FSPECIALITY;
property DIFFICULTYLEVEL: TDictionaryAttribute read FDIFFICULTYLEVEL;
property ADDENDUM_COMPLICATIONS: TDictionaryAttribute read FADDENDUM_COMPLICATIONS;
property ADDENDUM_ICD: TDictionaryAttribute read FADDENDUM_ICD;
property ADDENDUM_CPT: TDictionaryAttribute read FADDENDUM_CPT;
property HL7_SEND_STATUS: TDictionaryAttribute read FHL7_SEND_STATUS;
property GROUPNAME: TDictionaryAttribute read FGROUPNAME;
property NURSTATUS: TDictionaryAttribute read FNURSTATUS;
property NURFINISHDATE: TDictionaryAttribute read FNURFINISHDATE;
property NURFINISHTIME: TDictionaryAttribute read FNURFINISHTIME;
property NURSIGNOFFBY: TDictionaryAttribute read FNURSIGNOFFBY;
property PROCEDURETECHNIQUE: TDictionaryAttribute read FPROCEDURETECHNIQUE;
property FINDINGS: TDictionaryAttribute read FFINDINGS;
property DIAGNOSIS: TDictionaryAttribute read FDIAGNOSIS;
property ADDENDUMDATA: TDictionaryAttribute read FADDENDUMDATA;
property MEDRECONCILIATION: TDictionaryAttribute read FMEDRECONCILIATION;
property DURATIONOFPROCEDURE: TDictionaryAttribute read FDURATIONOFPROCEDURE;
property DURATIONOFFLOROUSE: TDictionaryAttribute read FDURATIONOFFLOROUSE;
property ANESTHESIOLOGIST: TDictionaryAttribute read FANESTHESIOLOGIST;
property FIRSTTIMESCREENING: TDictionaryAttribute read FFIRSTTIMESCREENING;
property HL7_SEND_STATUS_ADDENDUM: TDictionaryAttribute read FHL7_SEND_STATUS_ADDENDUM;
property NURSE2: TDictionaryAttribute read FNURSE2;
property COMPLICATION_YES_NONE: TDictionaryAttribute read FCOMPLICATION_YES_NONE;
property NURSEGROUPNAME: TDictionaryAttribute read FNURSEGROUPNAME;
property HL7_SEND_STATUS_PROFCRG: TDictionaryAttribute read FHL7_SEND_STATUS_PROFCRG;
property URINEVOLUME: TDictionaryAttribute read FURINEVOLUME;
property HL7_SEND_STATUS_TEXT: TDictionaryAttribute read FHL7_SEND_STATUS_TEXT;
property NUMBEROFSPECIMENS: TDictionaryAttribute read FNUMBEROFSPECIMENS;
property GROSS: TDictionaryAttribute read FGROSS;
property IMPLANTS: TDictionaryAttribute read FIMPLANTS;
property CLOTESTPOSITIVE: TDictionaryAttribute read FCLOTESTPOSITIVE;
property CLOTESTTAKEN: TDictionaryAttribute read FCLOTESTTAKEN;
property PREPAINLEVEL: TDictionaryAttribute read FPREPAINLEVEL;
property PLANSTATUS: TDictionaryAttribute read FPLANSTATUS;
property FELLOWPROCPERFORMED: TDictionaryAttribute read FFELLOWPROCPERFORMED;
property DURATIONOFFLOROUSE_SEC: TDictionaryAttribute read FDURATIONOFFLOROUSE_SEC;
property SECONDEXTENT: TDictionaryAttribute read FSECONDEXTENT;
property ES_CODE: TDictionaryAttribute read FES_CODE;
property COLONOSCOPYTYPE: TDictionaryAttribute read FCOLONOSCOPYTYPE;
property CUSTOM3: TDictionaryAttribute read FCUSTOM3;
property CUSTOM4: TDictionaryAttribute read FCUSTOM4;
property CUSTOM5: TDictionaryAttribute read FCUSTOM5;
property CUSTOM6: TDictionaryAttribute read FCUSTOM6;
property SECONDPHYSICIAN: TDictionaryAttribute read FSECONDPHYSICIAN;
property DATEOFPATHARRIVAL: TDictionaryAttribute read FDATEOFPATHARRIVAL;
property TIMEOFPATHARRIVAL: TDictionaryAttribute read FTIMEOFPATHARRIVAL;
property SPECIMENCOLLECTIONDATE: TDictionaryAttribute read FSPECIMENCOLLECTIONDATE;
property TIMEFINISHEDBYFELLOW: TDictionaryAttribute read FTIMEFINISHEDBYFELLOW;
property DATEFINISHEDBYFELLOW: TDictionaryAttribute read FDATEFINISHEDBYFELLOW;
property REFCODE: TDictionaryAttribute read FREFCODE;
property ORDEREDBY: TDictionaryAttribute read FORDEREDBY;
property IMAGECOUNT: TDictionaryAttribute read FIMAGECOUNT;
property PRESEDATIONCOMMETS: TDictionaryAttribute read FPRESEDATIONCOMMETS;
property LASTCOLONOSCOPYPERFOMED: TDictionaryAttribute read FLASTCOLONOSCOPYPERFOMED;
property USERCODE: TDictionaryAttribute read FUSERCODE;
property AGEMONTH: TDictionaryAttribute read FAGEMONTH;
property TISSUESUBMITTED: TDictionaryAttribute read FTISSUESUBMITTED;
property VISITTYPE: TDictionaryAttribute read FVISITTYPE;
property PATIENTTYPE: TDictionaryAttribute read FPATIENTTYPE;
property PRIMARYCAREPHY: TDictionaryAttribute read FPRIMARYCAREPHY;
property RECALLNUM: TDictionaryAttribute read FRECALLNUM;
property STATUSID: TDictionaryAttribute read FSTATUSID;
property PATIENTTEACHING_ALL: TDictionaryAttribute read FPATIENTTEACHING_ALL;
property PATIENTTEACHING_PREV: TDictionaryAttribute read FPATIENTTEACHING_PREV;
property CHAIRSTARTTIME: TDictionaryAttribute read FCHAIRSTARTTIME;
property PROCEDURESTARTTIME: TDictionaryAttribute read FPROCEDURESTARTTIME;
property TIMEOUTTIME: TDictionaryAttribute read FTIMEOUTTIME;
property TIMEOUTQUESTIONS: TDictionaryAttribute read FTIMEOUTQUESTIONS;
property O2STOP: TDictionaryAttribute read FO2STOP;
property O2START: TDictionaryAttribute read FO2START;
property O2RATE_ROUTE: TDictionaryAttribute read FO2RATE_ROUTE;
property ROOMENDTIME: TDictionaryAttribute read FROOMENDTIME;
property PROCENDTIME: TDictionaryAttribute read FPROCENDTIME;
property REPORTGIVENTO: TDictionaryAttribute read FREPORTGIVENTO;
property PATIENTTRANSTO: TDictionaryAttribute read FPATIENTTRANSTO;
property INCOMPLETEREASON: TDictionaryAttribute read FINCOMPLETEREASON;
property PROCEDURECOMPLETE: TDictionaryAttribute read FPROCEDURECOMPLETE;
property CHAIRENDTIME: TDictionaryAttribute read FCHAIRENDTIME;
property PAT_HEIGHTFT: TDictionaryAttribute read FPAT_HEIGHTFT;
property PAT_HEIGHTINC: TDictionaryAttribute read FPAT_HEIGHTINC;
property PAT_HEIGHTMTS: TDictionaryAttribute read FPAT_HEIGHTMTS;
property PAT_HEIGHTCM: TDictionaryAttribute read FPAT_HEIGHTCM;
property PAT_WEIGHTLBS: TDictionaryAttribute read FPAT_WEIGHTLBS;
property PAT_WEIGHTKG: TDictionaryAttribute read FPAT_WEIGHTKG;
property PAT_WEIGHTLOZ: TDictionaryAttribute read FPAT_WEIGHTLOZ;
property HEIGHTMTSCM: TDictionaryAttribute read FHEIGHTMTSCM;
property BMI: TDictionaryAttribute read FBMI;
property BSA: TDictionaryAttribute read FBSA;
property P_PID: TDictionaryAssociation read FP_PID;
end;

function Dic: TDicDictionary;

implementation

var
__Dic: TDicDictionary;

function Dic: TDicDictionary;
begin
if __Dic = nil then __Dic := TDicDictionary.Create;
result := __Dic
end;

{ TDicDictionary }

destructor TDicDictionary.Destroy;
begin
if FPROCEDURE_SURGERY <> nil then FPROCEDURE_SURGERY.Free;
if FPATIENTS <> nil then FPATIENTS.Free;
if FNURHISTORY <> nil then FNURHISTORY.Free;
inherited;
end;

function TDicDictionary.GetNURHISTORY: TNURHISTORYTableDictionary;
begin
if FNURHISTORY = nil then FNURHISTORY := TNURHISTORYTableDictionary.Create;
result := FNURHISTORY;
end;

function TDicDictionary.GetPATIENTS: TPATIENTSTableDictionary;
begin
if FPATIENTS = nil then FPATIENTS := TPATIENTSTableDictionary.Create;
result := FPATIENTS;
end;

function TDicDictionary.GetPROCEDURE_SURGERY: TPROCEDURE_SURGERYTableDictionary;
begin
if FPROCEDURE_SURGERY = nil then FPROCEDURE_SURGERY := TPROCEDURE_SURGERYTableDictionary.Create;
result := FPROCEDURE_SURGERY;
end;

{ TNURHISTORYTableDictionary }

constructor TNURHISTORYTableDictionary.Create;
begin
inherited;
FNURSE := TDictionaryAttribute.Create('NURSE');
FDATEOFHISTORY := TDictionaryAttribute.Create('DATEOFHISTORY');
FTIMEOFHISTORY := TDictionaryAttribute.Create('TIMEOFHISTORY');
FCLINIC := TDictionaryAttribute.Create('CLINIC');
FVITALS := TDictionaryAttribute.Create('VITALS');
FPAT_HEIGHTFT := TDictionaryAttribute.Create('PAT_HEIGHTFT');
FPAT_HEIGHTINC := TDictionaryAttribute.Create('PAT_HEIGHTINC');
FPAT_HEIGHTMTS := TDictionaryAttribute.Create('PAT_HEIGHTMTS');
FPAT_HEIGHTCM := TDictionaryAttribute.Create('PAT_HEIGHTCM');
FPAT_WEIGHTLBS := TDictionaryAttribute.Create('PAT_WEIGHTLBS');
FPAT_WEIGHTLOZ := TDictionaryAttribute.Create('PAT_WEIGHTLOZ');
FPAT_WEIGHTKG := TDictionaryAttribute.Create('PAT_WEIGHTKG');
FINFO_PROVIDEDBY := TDictionaryAttribute.Create('INFO_PROVIDEDBY');
FHIS_EVAL_PERFORMED := TDictionaryAttribute.Create('HIS_EVAL_PERFORMED');
FHIS_EVALPERFORM_DROPDOWN := TDictionaryAttribute.Create('HIS_EVALPERFORM_DROPDOWN');
FRESPIRATORY := TDictionaryAttribute.Create('RESPIRATORY');
FGIDISORDER := TDictionaryAttribute.Create('GIDISORDER');
FNEUROMASCULAR := TDictionaryAttribute.Create('NEUROMASCULAR');
FONCOLOGY := TDictionaryAttribute.Create('ONCOLOGY');
FREPRODUCTIVE := TDictionaryAttribute.Create('REPRODUCTIVE');
FPOSTMENOPAUSAL := TDictionaryAttribute.Create('POSTMENOPAUSAL');
FLNP_DATE := TDictionaryAttribute.Create('LNP_DATE');
FENT := TDictionaryAttribute.Create('ENT');
FGU := TDictionaryAttribute.Create('GU');
FENDOCRINE := TDictionaryAttribute.Create('ENDOCRINE');
FPSYCHOSOCIAL := TDictionaryAttribute.Create('PSYCHOSOCIAL');
FCARDIOVASCULAR := TDictionaryAttribute.Create('CARDIOVASCULAR');
FDISEASES := TDictionaryAttribute.Create('DISEASES');
FHEMATOLOGICAL := TDictionaryAttribute.Create('HEMATOLOGICAL');
FPEDIATRIC_PATIENT := TDictionaryAttribute.Create('PEDIATRIC_PATIENT');
FTOBACCO := TDictionaryAttribute.Create('TOBACCO');
FTOBACCO_HOWMUCH := TDictionaryAttribute.Create('TOBACCO_HOWMUCH');
FTOBACCO_FREQUENCY := TDictionaryAttribute.Create('TOBACCO_FREQUENCY');
FETOH := TDictionaryAttribute.Create('ETOH');
FETOH_HOWMUCH := TDictionaryAttribute.Create('ETOH_HOWMUCH');
FETOH_FREQUENCY := TDictionaryAttribute.Create('ETOH_FREQUENCY');
FRECDRUGUSE := TDictionaryAttribute.Create('RECDRUGUSE');
FRECDRUGUSE_HOWMUCH := TDictionaryAttribute.Create('RECDRUGUSE_HOWMUCH');
FRECDRUGUSE_FREQUENCY := TDictionaryAttribute.Create('RECDRUGUSE_FREQUENCY');
FCUSTOM_PH := TDictionaryAttribute.Create('CUSTOM_PH');
FCUSTOM_OTHERPH := TDictionaryAttribute.Create('CUSTOM_OTHERPH');
FTB_HEMOPTYSIS := TDictionaryAttribute.Create('TB_HEMOPTYSIS');
FTB_ASTHMA := TDictionaryAttribute.Create('TB_ASTHMA');
FTB_WEIGHTLOSS := TDictionaryAttribute.Create('TB_WEIGHTLOSS');
FTB_NIGHTSWEATS := TDictionaryAttribute.Create('TB_NIGHTSWEATS');
FTB_POSSKINTEST := TDictionaryAttribute.Create('TB_POSSKINTEST');
FTBISOLATIONPRECINI := TDictionaryAttribute.Create('TBISOLATIONPRECINI');
FHEALTHHIS_COMMENTS := TDictionaryAttribute.Create('HEALTHHIS_COMMENTS');
FPRIOR_ANAESTHESIA_COMP := TDictionaryAttribute.Create('PRIOR_ANAESTHESIA_COMP');
FPERTINENT_FAMHIST := TDictionaryAttribute.Create('PERTINENT_FAMHIST');
FPATIENTS_INSTRUCTIONS := TDictionaryAttribute.Create('PATIENTS_INSTRUCTIONS');
FENDTIMEOFEVAL := TDictionaryAttribute.Create('ENDTIMEOFEVAL');
FCUSTOM1 := TDictionaryAttribute.Create('CUSTOM1');
FGI := TDictionaryAttribute.Create('GI');
FFAMHIST := TDictionaryAttribute.Create('FAMHIST');
FHISTORYSTATUS := TDictionaryAttribute.Create('HISTORYSTATUS');
FDATETIMEOFSIGNOFF := TDictionaryAttribute.Create('DATETIMEOFSIGNOFF');
FTB_FATIGUE := TDictionaryAttribute.Create('TB_FATIGUE');
FPTHIST := TDictionaryAttribute.Create('PTHIST');
FMEDHIST := TDictionaryAttribute.Create('MEDHIST');
FSURGHIST := TDictionaryAttribute.Create('SURGHIST');
FALLERGIES_REACTION := TDictionaryAttribute.Create('ALLERGIES_REACTION');
FPASTPROC := TDictionaryAttribute.Create('PASTPROC');
FPASTPROC_RESULTS := TDictionaryAttribute.Create('PASTPROC_RESULTS');
FPASTPROC_CLINIC := TDictionaryAttribute.Create('PASTPROC_CLINIC');
FPASTPROC_DATE := TDictionaryAttribute.Create('PASTPROC_DATE');
FSOCIALHIST := TDictionaryAttribute.Create('SOCIALHIST');
FLABRESULT := TDictionaryAttribute.Create('LABRESULT');
FLABRESULT_COMMENT := TDictionaryAttribute.Create('LABRESULT_COMMENT');
FDIABETES := TDictionaryAttribute.Create('DIABETES');
FHEARTDISEASE := TDictionaryAttribute.Create('HEARTDISEASE');
FIRREGULARHEARTBEAT := TDictionaryAttribute.Create('IRREGULARHEARTBEAT');
FHEARTMURMUR := TDictionaryAttribute.Create('HEARTMURMUR');
FHEARTMURMUR_TYPE := TDictionaryAttribute.Create('HEARTMURMUR_TYPE');
FMITRALVALVEPROLAPSE := TDictionaryAttribute.Create('MITRALVALVEPROLAPSE');
FVALVEREPLACEMENT := TDictionaryAttribute.Create('VALVEREPLACEMENT');
FPACEMAKERICD := TDictionaryAttribute.Create('PACEMAKERICD');
FHYPERTENSION := TDictionaryAttribute.Create('HYPERTENSION');
FVASCULARGRAFTS := TDictionaryAttribute.Create('VASCULARGRAFTS');
FHEPATITIS := TDictionaryAttribute.Create('HEPATITIS');
FHIV := TDictionaryAttribute.Create('HIV');
FKIDNEYDISEASE := TDictionaryAttribute.Create('KIDNEYDISEASE');
FLUNG_BREATHINGPROBLEMS := TDictionaryAttribute.Create('LUNG_BREATHINGPROBLEMS');
FASTHMA := TDictionaryAttribute.Create('ASTHMA');
FEMPHYSEMA := TDictionaryAttribute.Create('EMPHYSEMA');
FCOPD := TDictionaryAttribute.Create('COPD');
FSLEEPAPNEA := TDictionaryAttribute.Create('SLEEPAPNEA');
FNEUROLOGICALDISORDER := TDictionaryAttribute.Create('NEUROLOGICALDISORDER');
FMUSCULOSKELETALDISORDER := TDictionaryAttribute.Create('MUSCULOSKELETALDISORDER');
FBLEEDINGDISORDER := TDictionaryAttribute.Create('BLEEDINGDISORDER');
FGLAUCOMA := TDictionaryAttribute.Create('GLAUCOMA');
FPREGNANT := TDictionaryAttribute.Create('PREGNANT');
FSEIZUREDISORDER := TDictionaryAttribute.Create('SEIZUREDISORDER');
FPROSTHETICJOINTS := TDictionaryAttribute.Create('PROSTHETICJOINTS');
FCANCER := TDictionaryAttribute.Create('CANCER');
FEIOH := TDictionaryAttribute.Create('EIOH');
FEIOH_HOWMUCH := TDictionaryAttribute.Create('EIOH_HOWMUCH');
FOTHER := TDictionaryAttribute.Create('OTHER');
FOTHER_VAL := TDictionaryAttribute.Create('OTHER_VAL');
FVISION := TDictionaryAttribute.Create('VISION');
FHEARINGLOSS := TDictionaryAttribute.Create('HEARINGLOSS');
FPRESENTILLNESS := TDictionaryAttribute.Create('PRESENTILLNESS');
FCMEDHIST := TDictionaryAttribute.Create('CMEDHIST');
FALLERGIES := TDictionaryAttribute.Create('ALLERGIES');
FVISION_HEARINGLOSS := TDictionaryAttribute.Create('VISION_HEARINGLOSS');
FCHIEF_COMPLAINT := TDictionaryAttribute.Create('CHIEF_COMPLAINT');
FMEDS := TDictionaryAttribute.Create('MEDS');
FANTICOAGULANTS := TDictionaryAttribute.Create('ANTICOAGULANTS');
FPAT_BMI := TDictionaryAttribute.Create('PAT_BMI');
FHISTORYREPORT := TDictionaryAttribute.Create('HISTORYREPORT');
FCOMMENTS := TDictionaryAttribute.Create('COMMENTS');
FPAT_BSA := TDictionaryAttribute.Create('PAT_BSA');
FPREOPCONTACTDATE := TDictionaryAttribute.Create('PREOPCONTACTDATE');
FPREOPCONTACTTIME := TDictionaryAttribute.Create('PREOPCONTACTTIME');
FPREOPCONTACTPERSON := TDictionaryAttribute.Create('PREOPCONTACTPERSON');
FPREOPCONTACTRELATIONSHIP := TDictionaryAttribute.Create('PREOPCONTACTRELATIONSHIP');
FPREOPCONTACTINITIATOR := TDictionaryAttribute.Create('PREOPCONTACTINITIATOR');
FPREOPCONTACTREASON := TDictionaryAttribute.Create('PREOPCONTACTREASON');
FTIMEOFSIGNOFF := TDictionaryAttribute.Create('TIMEOFSIGNOFF');
FPROCEDURENUMBER := TDictionaryAssociation.Create('PROCEDURENUMBER');
end;

{ TPATIENTSTableDictionary }

constructor TPATIENTSTableDictionary.Create;
begin
inherited;
FP_PID := TDictionaryAttribute.Create('P_PID');
FLASTNAME := TDictionaryAttribute.Create('LASTNAME');
FFIRSTNAME := TDictionaryAttribute.Create('FIRSTNAME');
FP_ENAME := TDictionaryAttribute.Create('P_ENAME');
FMI := TDictionaryAttribute.Create('MI');
FTITLE := TDictionaryAttribute.Create('TITLE');
FP_DOB := TDictionaryAttribute.Create('P_DOB');
FP_AGE := TDictionaryAttribute.Create('P_AGE');
FP_SEX := TDictionaryAttribute.Create('P_SEX');
FRACE := TDictionaryAttribute.Create('RACE');
FADDRESS1 := TDictionaryAttribute.Create('ADDRESS1');
FADDRESS2 := TDictionaryAttribute.Create('ADDRESS2');
FCITY := TDictionaryAttribute.Create('CITY');
FSTATE := TDictionaryAttribute.Create('STATE');
FZIP := TDictionaryAttribute.Create('ZIP');
FPHONE := TDictionaryAttribute.Create('PHONE');
FFAX := TDictionaryAttribute.Create('FAX');
FOTHERPHONE := TDictionaryAttribute.Create('OTHERPHONE');
FSSN := TDictionaryAttribute.Create('SSN');
FACTNUM := TDictionaryAttribute.Create('ACTNUM');
FCUST1 := TDictionaryAttribute.Create('CUST1');
FCUST2 := TDictionaryAttribute.Create('CUST2');
FCUST3 := TDictionaryAttribute.Create('CUST3');
FCUST4 := TDictionaryAttribute.Create('CUST4');
FDATE_ENTERED := TDictionaryAttribute.Create('DATE_ENTERED');
FWORKPHONE := TDictionaryAttribute.Create('WORKPHONE');
FTIMEOFARRIVAL := TDictionaryAttribute.Create('TIMEOFARRIVAL');
FDATEOFARRIVAL := TDictionaryAttribute.Create('DATEOFARRIVAL');
FOTHERNAME := TDictionaryAttribute.Create('OTHERNAME');
FEMAIL := TDictionaryAttribute.Create('EMAIL');
FSIGNATUREONFILE := TDictionaryAttribute.Create('SIGNATUREONFILE');
FSIGNATUREDATE := TDictionaryAttribute.Create('SIGNATUREDATE');
FMARITALSTATUS := TDictionaryAttribute.Create('MARITALSTATUS');
FDECEASED := TDictionaryAttribute.Create('DECEASED');
FDATE_OF_DEATH := TDictionaryAttribute.Create('DATE_OF_DEATH');
FLOCATION_OF_DEATH := TDictionaryAttribute.Create('LOCATION_OF_DEATH');
FREASON_OF_DEATH := TDictionaryAttribute.Create('REASON_OF_DEATH');
FEXEMPT := TDictionaryAttribute.Create('EXEMPT');
FPAST_MEDICALHIST := TDictionaryAttribute.Create('PAST_MEDICALHIST');
FPAST_SURGICALHIST := TDictionaryAttribute.Create('PAST_SURGICALHIST');
FALLERGIES := TDictionaryAttribute.Create('ALLERGIES');
FFAMILY_HIST := TDictionaryAttribute.Create('FAMILY_HIST');
FPREV_HOSPITALISATIONS := TDictionaryAttribute.Create('PREV_HOSPITALISATIONS');
FSOCIAL_HIST := TDictionaryAttribute.Create('SOCIAL_HIST');
FCUSTOM1 := TDictionaryAttribute.Create('CUSTOM1');
FCUSTOM2 := TDictionaryAttribute.Create('CUSTOM2');
FCUSTOM3 := TDictionaryAttribute.Create('CUSTOM3');
FCELLPHONE := TDictionaryAttribute.Create('CELLPHONE');
FCOUNTY := TDictionaryAttribute.Create('COUNTY');
FCOUNTYCODE := TDictionaryAttribute.Create('COUNTYCODE');
FRELIGION := TDictionaryAttribute.Create('RELIGION');
FPATIENT_PICTURE := TDictionaryAttribute.Create('PATIENT_PICTURE');
FMEDSALLERGIES := TDictionaryAttribute.Create('MEDSALLERGIES');
FOTCALLERGIES := TDictionaryAttribute.Create('OTCALLERGIES');
FPRIMARYLANGUAGE := TDictionaryAttribute.Create('PRIMARYLANGUAGE');
FALTADDRESS1 := TDictionaryAttribute.Create('ALTADDRESS1');
FALTADDRESS2 := TDictionaryAttribute.Create('ALTADDRESS2');
FALTADDRESSCITY := TDictionaryAttribute.Create('ALTADDRESSCITY');
FALTADDRESSSTATE := TDictionaryAttribute.Create('ALTADDRESSSTATE');
FALTADDRESSZIP := TDictionaryAttribute.Create('ALTADDRESSZIP');
FALTPHONE := TDictionaryAttribute.Create('ALTPHONE');
FALTCOUNTRY := TDictionaryAttribute.Create('ALTCOUNTRY');
FSMOKINGSTATUS := TDictionaryAttribute.Create('SMOKINGSTATUS');
FSMOKINGCODE := TDictionaryAttribute.Create('SMOKINGCODE');
FETHNICITY := TDictionaryAttribute.Create('ETHNICITY');
FCOMMUNICATIONPREFERENCE := TDictionaryAttribute.Create('COMMUNICATIONPREFERENCE');
FPREGNANT := TDictionaryAttribute.Create('PREGNANT');
FPREGNANCYWEEK := TDictionaryAttribute.Create('PREGNANCYWEEK');
FUSERID := TDictionaryAttribute.Create('USERID');
FPWD := TDictionaryAttribute.Create('PWD');
FPWDCHANGEDON := TDictionaryAttribute.Create('PWDCHANGEDON');
FFIRSTLOGINPWD := TDictionaryAttribute.Create('FIRSTLOGINPWD');
FPWDCHANGEFREQ := TDictionaryAttribute.Create('PWDCHANGEFREQ');
FPWDEXPIRES := TDictionaryAttribute.Create('PWDEXPIRES');
FTIMELYACCESS := TDictionaryAttribute.Create('TIMELYACCESS');
FSCHEDULED := TDictionaryAttribute.Create('SCHEDULED');
FPATBILLINGPID := TDictionaryAttribute.Create('PATBILLINGPID');
FTIME_OF_DEATH := TDictionaryAttribute.Create('TIME_OF_DEATH');
FNH_STATUS := TDictionaryAttribute.Create('NH_STATUS');
FNHS_STATUS := TDictionaryAttribute.Create('NHS_STATUS');
FELIG_CONSENT := TDictionaryAttribute.Create('ELIG_CONSENT');
Fes_code := TDictionaryAttribute.Create('es_code');
FCANCER_HIST := TDictionaryAttribute.Create('CANCER_HIST');
FFACILITYID := TDictionaryAttribute.Create('FACILITYID');
FSUFFIX := TDictionaryAttribute.Create('SUFFIX');
FISOLATIONPRECAUTIONS := TDictionaryAttribute.Create('ISOLATIONPRECAUTIONS');
FCOUNTRY := TDictionaryAttribute.Create('COUNTRY');
FPATIENTSTAGE := TDictionaryAttribute.Create('PATIENTSTAGE');
FBSAFORMULA := TDictionaryAttribute.Create('BSAFORMULA');
FENABLEPORTALREGISTRATION := TDictionaryAttribute.Create('ENABLEPORTALREGISTRATION');
FLASTNAME_ENCRYPTED := TDictionaryAttribute.Create('LASTNAME_ENCRYPTED');
end;

{ TPROCEDURE_SURGERYTableDictionary }

constructor TPROCEDURE_SURGERYTableDictionary.Create;
begin
inherited;
FID := TDictionaryAttribute.Create('ID');
FENCOUNTERNUM := TDictionaryAttribute.Create('ENCOUNTERNUM');
FFINISHDATE := TDictionaryAttribute.Create('FINISHDATE');
FFINISHTIME := TDictionaryAttribute.Create('FINISHTIME');
FAUTHOR := TDictionaryAttribute.Create('AUTHOR');
FFACILITY := TDictionaryAttribute.Create('FACILITY');
FREPORTSTITLE := TDictionaryAttribute.Create('REPORTSTITLE');
FSTATUS := TDictionaryAttribute.Create('STATUS');
FDATEOFPROCEDURE := TDictionaryAttribute.Create('DATEOFPROCEDURE');
FPROCEDUREPERFORMED := TDictionaryAttribute.Create('PROCEDUREPERFORMED');
FCPTCODES := TDictionaryAttribute.Create('CPTCODES');
FTIMEOFPROCEDURE := TDictionaryAttribute.Create('TIMEOFPROCEDURE');
FEXTENTOFEXAM := TDictionaryAttribute.Create('EXTENTOFEXAM');
FRECOMMENDATIONS := TDictionaryAttribute.Create('RECOMMENDATIONS');
FLIMITATIONSOFEXAM := TDictionaryAttribute.Create('LIMITATIONSOFEXAM');
FICDCODES := TDictionaryAttribute.Create('ICDCODES');
FCOMMENTS := TDictionaryAttribute.Create('COMMENTS');
FINDICATIONS := TDictionaryAttribute.Create('INDICATIONS');
FAGE := TDictionaryAttribute.Create('AGE');
FCUSTOM1 := TDictionaryAttribute.Create('CUSTOM1');
FSIGNOFF := TDictionaryAttribute.Create('SIGNOFF');
FPROCTYPE := TDictionaryAttribute.Create('PROCTYPE');
FREVIEWPHYSICIAN := TDictionaryAttribute.Create('REVIEWPHYSICIAN');
FREVIEWDATE := TDictionaryAttribute.Create('REVIEWDATE');
FORDERINGPROVIDER := TDictionaryAttribute.Create('ORDERINGPROVIDER');
FTECHNICIAN := TDictionaryAttribute.Create('TECHNICIAN');
FNURSE := TDictionaryAttribute.Create('NURSE');
FREFERRINGPHYSICIAN := TDictionaryAttribute.Create('REFERRINGPHYSICIAN');
FLOCATION := TDictionaryAttribute.Create('LOCATION');
FCANCELREASON := TDictionaryAttribute.Create('CANCELREASON');
FPROCEDUREREASON := TDictionaryAttribute.Create('PROCEDUREREASON');
FTRACTIMAGE := TDictionaryAttribute.Create('TRACTIMAGE');
FDIAGRAMIMAGE := TDictionaryAttribute.Create('DIAGRAMIMAGE');
FDIAGRAMANNOTATION := TDictionaryAttribute.Create('DIAGRAMANNOTATION');
FCUSTOM2 := TDictionaryAttribute.Create('CUSTOM2');
FPROCNAME := TDictionaryAttribute.Create('PROCNAME');
FVISUALIZATION := TDictionaryAttribute.Create('VISUALIZATION');
FTOLERANCE := TDictionaryAttribute.Create('TOLERANCE');
FCOMPLICATIONS := TDictionaryAttribute.Create('COMPLICATIONS');
FDISCHARGEINS := TDictionaryAttribute.Create('DISCHARGEINS');
FDISCHARGEDTO := TDictionaryAttribute.Create('DISCHARGEDTO');
FAPPOINTMENTINFO := TDictionaryAttribute.Create('APPOINTMENTINFO');
FADDINSTR := TDictionaryAttribute.Create('ADDINSTR');
FREFERRALS := TDictionaryAttribute.Create('REFERRALS');
FDI_CUSTOM1 := TDictionaryAttribute.Create('DI_CUSTOM1');
FISOLATIONPRECAUTIONS := TDictionaryAttribute.Create('ISOLATIONPRECAUTIONS');
FASSISTANT := TDictionaryAttribute.Create('ASSISTANT');
FMEDICATIONS := TDictionaryAttribute.Create('MEDICATIONS');
FPPN_CONDITION := TDictionaryAttribute.Create('PPN_CONDITION');
FPPN_PROGRESS := TDictionaryAttribute.Create('PPN_PROGRESS');
FPPN_CUSTOM := TDictionaryAttribute.Create('PPN_CUSTOM');
FPPN_CUSTOM2 := TDictionaryAttribute.Create('PPN_CUSTOM2');
FINSTRUMENTS := TDictionaryAttribute.Create('INSTRUMENTS');
FSPECIALINSTRUCTIONS := TDictionaryAttribute.Create('SPECIALINSTRUCTIONS');
FFELLOW := TDictionaryAttribute.Create('FELLOW');
FESTIMATEDBLOODLOSS := TDictionaryAttribute.Create('ESTIMATEDBLOODLOSS');
FBLOODLOSSUNIT := TDictionaryAttribute.Create('BLOODLOSSUNIT');
FPROCEDUREPROPOSED := TDictionaryAttribute.Create('PROCEDUREPROPOSED');
FER_CONTRAINDICATIONS := TDictionaryAttribute.Create('ER_CONTRAINDICATIONS');
FTECH_DIFFICULT := TDictionaryAttribute.Create('TECH_DIFFICULT');
FPAINSCALE := TDictionaryAttribute.Create('PAINSCALE');
FINTENDEDEXTENT := TDictionaryAttribute.Create('INTENDEDEXTENT');
FSITE := TDictionaryAttribute.Create('SITE');
FNOOFPASSES := TDictionaryAttribute.Create('NOOFPASSES');
FPOSITIONS := TDictionaryAttribute.Create('POSITIONS');
FNEEDLESIZE := TDictionaryAttribute.Create('NEEDLESIZE');
FPPN_ORDERS := TDictionaryAttribute.Create('PPN_ORDERS');
FDI_CUSTOM2 := TDictionaryAttribute.Create('DI_CUSTOM2');
FPROC_CUSTOM1 := TDictionaryAttribute.Create('PROC_CUSTOM1');
FPROC_CUSTOM2 := TDictionaryAttribute.Create('PROC_CUSTOM2');
FVISITNUM := TDictionaryAttribute.Create('VISITNUM');
FORDERNUM := TDictionaryAttribute.Create('ORDERNUM');
FINOUTPATIENT := TDictionaryAttribute.Create('INOUTPATIENT');
FINPATINFO := TDictionaryAttribute.Create('INPATINFO');
FTIMEOFARRIVAL := TDictionaryAttribute.Create('TIMEOFARRIVAL');
FSPECIALITY := TDictionaryAttribute.Create('SPECIALITY');
FDIFFICULTYLEVEL := TDictionaryAttribute.Create('DIFFICULTYLEVEL');
FADDENDUM_COMPLICATIONS := TDictionaryAttribute.Create('ADDENDUM_COMPLICATIONS');
FADDENDUM_ICD := TDictionaryAttribute.Create('ADDENDUM_ICD');
FADDENDUM_CPT := TDictionaryAttribute.Create('ADDENDUM_CPT');
FHL7_SEND_STATUS := TDictionaryAttribute.Create('HL7_SEND_STATUS');
FGROUPNAME := TDictionaryAttribute.Create('GROUPNAME');
FNURSTATUS := TDictionaryAttribute.Create('NURSTATUS');
FNURFINISHDATE := TDictionaryAttribute.Create('NURFINISHDATE');
FNURFINISHTIME := TDictionaryAttribute.Create('NURFINISHTIME');
FNURSIGNOFFBY := TDictionaryAttribute.Create('NURSIGNOFFBY');
FPROCEDURETECHNIQUE := TDictionaryAttribute.Create('PROCEDURETECHNIQUE');
FFINDINGS := TDictionaryAttribute.Create('FINDINGS');
FDIAGNOSIS := TDictionaryAttribute.Create('DIAGNOSIS');
FADDENDUMDATA := TDictionaryAttribute.Create('ADDENDUMDATA');
FMEDRECONCILIATION := TDictionaryAttribute.Create('MEDRECONCILIATION');
FDURATIONOFPROCEDURE := TDictionaryAttribute.Create('DURATIONOFPROCEDURE');
FDURATIONOFFLOROUSE := TDictionaryAttribute.Create('DURATIONOFFLOROUSE');
FANESTHESIOLOGIST := TDictionaryAttribute.Create('ANESTHESIOLOGIST');
FFIRSTTIMESCREENING := TDictionaryAttribute.Create('FIRSTTIMESCREENING');
FHL7_SEND_STATUS_ADDENDUM := TDictionaryAttribute.Create('HL7_SEND_STATUS_ADDENDUM');
FNURSE2 := TDictionaryAttribute.Create('NURSE2');
FCOMPLICATION_YES_NONE := TDictionaryAttribute.Create('COMPLICATION_YES_NONE');
FNURSEGROUPNAME := TDictionaryAttribute.Create('NURSEGROUPNAME');
FHL7_SEND_STATUS_PROFCRG := TDictionaryAttribute.Create('HL7_SEND_STATUS_PROFCRG');
FURINEVOLUME := TDictionaryAttribute.Create('URINEVOLUME');
FHL7_SEND_STATUS_TEXT := TDictionaryAttribute.Create('HL7_SEND_STATUS_TEXT');
FNUMBEROFSPECIMENS := TDictionaryAttribute.Create('NUMBEROFSPECIMENS');
FGROSS := TDictionaryAttribute.Create('GROSS');
FIMPLANTS := TDictionaryAttribute.Create('IMPLANTS');
FCLOTESTPOSITIVE := TDictionaryAttribute.Create('CLOTESTPOSITIVE');
FCLOTESTTAKEN := TDictionaryAttribute.Create('CLOTESTTAKEN');
FPREPAINLEVEL := TDictionaryAttribute.Create('PREPAINLEVEL');
FPLANSTATUS := TDictionaryAttribute.Create('PLANSTATUS');
FFELLOWPROCPERFORMED := TDictionaryAttribute.Create('FELLOWPROCPERFORMED');
FDURATIONOFFLOROUSE_SEC := TDictionaryAttribute.Create('DURATIONOFFLOROUSE_SEC');
FSECONDEXTENT := TDictionaryAttribute.Create('SECONDEXTENT');
FES_CODE := TDictionaryAttribute.Create('ES_CODE');
FCOLONOSCOPYTYPE := TDictionaryAttribute.Create('COLONOSCOPYTYPE');
FCUSTOM3 := TDictionaryAttribute.Create('CUSTOM3');
FCUSTOM4 := TDictionaryAttribute.Create('CUSTOM4');
FCUSTOM5 := TDictionaryAttribute.Create('CUSTOM5');
FCUSTOM6 := TDictionaryAttribute.Create('CUSTOM6');
FSECONDPHYSICIAN := TDictionaryAttribute.Create('SECONDPHYSICIAN');
FDATEOFPATHARRIVAL := TDictionaryAttribute.Create('DATEOFPATHARRIVAL');
FTIMEOFPATHARRIVAL := TDictionaryAttribute.Create('TIMEOFPATHARRIVAL');
FSPECIMENCOLLECTIONDATE := TDictionaryAttribute.Create('SPECIMENCOLLECTIONDATE');
FTIMEFINISHEDBYFELLOW := TDictionaryAttribute.Create('TIMEFINISHEDBYFELLOW');
FDATEFINISHEDBYFELLOW := TDictionaryAttribute.Create('DATEFINISHEDBYFELLOW');
FREFCODE := TDictionaryAttribute.Create('REFCODE');
FORDEREDBY := TDictionaryAttribute.Create('ORDEREDBY');
FIMAGECOUNT := TDictionaryAttribute.Create('IMAGECOUNT');
FPRESEDATIONCOMMETS := TDictionaryAttribute.Create('PRESEDATIONCOMMETS');
FLASTCOLONOSCOPYPERFOMED := TDictionaryAttribute.Create('LASTCOLONOSCOPYPERFOMED');
FUSERCODE := TDictionaryAttribute.Create('USERCODE');
FAGEMONTH := TDictionaryAttribute.Create('AGEMONTH');
FTISSUESUBMITTED := TDictionaryAttribute.Create('TISSUESUBMITTED');
FVISITTYPE := TDictionaryAttribute.Create('VISITTYPE');
FPATIENTTYPE := TDictionaryAttribute.Create('PATIENTTYPE');
FPRIMARYCAREPHY := TDictionaryAttribute.Create('PRIMARYCAREPHY');
FRECALLNUM := TDictionaryAttribute.Create('RECALLNUM');
FSTATUSID := TDictionaryAttribute.Create('STATUSID');
FPATIENTTEACHING_ALL := TDictionaryAttribute.Create('PATIENTTEACHING_ALL');
FPATIENTTEACHING_PREV := TDictionaryAttribute.Create('PATIENTTEACHING_PREV');
FCHAIRSTARTTIME := TDictionaryAttribute.Create('CHAIRSTARTTIME');
FPROCEDURESTARTTIME := TDictionaryAttribute.Create('PROCEDURESTARTTIME');
FTIMEOUTTIME := TDictionaryAttribute.Create('TIMEOUTTIME');
FTIMEOUTQUESTIONS := TDictionaryAttribute.Create('TIMEOUTQUESTIONS');
FO2STOP := TDictionaryAttribute.Create('O2STOP');
FO2START := TDictionaryAttribute.Create('O2START');
FO2RATE_ROUTE := TDictionaryAttribute.Create('O2RATE_ROUTE');
FROOMENDTIME := TDictionaryAttribute.Create('ROOMENDTIME');
FPROCENDTIME := TDictionaryAttribute.Create('PROCENDTIME');
FREPORTGIVENTO := TDictionaryAttribute.Create('REPORTGIVENTO');
FPATIENTTRANSTO := TDictionaryAttribute.Create('PATIENTTRANSTO');
FINCOMPLETEREASON := TDictionaryAttribute.Create('INCOMPLETEREASON');
FPROCEDURECOMPLETE := TDictionaryAttribute.Create('PROCEDURECOMPLETE');
FCHAIRENDTIME := TDictionaryAttribute.Create('CHAIRENDTIME');
FPAT_HEIGHTFT := TDictionaryAttribute.Create('PAT_HEIGHTFT');
FPAT_HEIGHTINC := TDictionaryAttribute.Create('PAT_HEIGHTINC');
FPAT_HEIGHTMTS := TDictionaryAttribute.Create('PAT_HEIGHTMTS');
FPAT_HEIGHTCM := TDictionaryAttribute.Create('PAT_HEIGHTCM');
FPAT_WEIGHTLBS := TDictionaryAttribute.Create('PAT_WEIGHTLBS');
FPAT_WEIGHTKG := TDictionaryAttribute.Create('PAT_WEIGHTKG');
FPAT_WEIGHTLOZ := TDictionaryAttribute.Create('PAT_WEIGHTLOZ');
FHEIGHTMTSCM := TDictionaryAttribute.Create('HEIGHTMTSCM');
FBMI := TDictionaryAttribute.Create('BMI');
FBSA := TDictionaryAttribute.Create('BSA');
FP_PID := TDictionaryAssociation.Create('P_PID');
end;

initialization
RegisterEntity(TNURHISTORY);
RegisterEntity(TPATIENTS);
RegisterEntity(TPROCEDURE_SURGERY);

finalization
if __Dic <> nil then __Dic.Free

end.

wlandgraf · November 10, 2020, 11:15am

Looks like the code you provided is not complete as it's missing some fields. In the case of such big file, you can attach it to the message, if you will.

In any case, yes, if you want the dataset to have access to sub properties of associated objects, you need to use $expand, otherwise the JSON will only come with a proxy/reference value and the sub properties will be absent (and thus null).

Zohair_Hussain · November 10, 2020, 12:49pm

Thank you very much.
So it means i did it right.

system · November 10, 2020, 2:00pm

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.