wiki:i2b2 - UHL clinical informatics system integration PATS EPS_EPSINIVW

back

Start Date Field: DateOfAdmission

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
DateOfEntry3dateIgnored For Datatype
!TimeofEPSRFA4timeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
DateOfAdmission8dateIgnored For Datatype
DateOfDischarge9dateIgnored For Datatype
DateAddedToWaitingList10dateIgnored For Datatype
HospitalIdentifier11varchar
PatientGender12varchar
AgeAtOperation13int
PatientEthnicGroup14varchar
PatientAdminStatus15varchar
IsThisARe_Do16varchar
Preeps_ablationAetiology217varchar
Preeps_ablationEcg18varchar
Prepacing_eps_ablationPresentingSymptom19varcharIgnored For No Enum
GeneratorPacingMode20varchar
Preeps_ablationPreviousIntervention21varchar
Preeps_ablationArrhythmia22varchar
Eps_ablationIndicationForIntervention23varchar
Preicd_ablationQrsDuration24int
Date_timeOfProcedure25varcharIgnored For No Enum
ProcedureUrgency26varchar
OperativeUrgency27varchar
PrimaryOperator28varcharIgnored For No Enum
FirstOperatorStatus29varchar
SecondOperator30varcharIgnored For No Enum
SecondOperatorStatus31varchar
ThirdOperator32varchar
ThirdOperatorStatus33varchar
Ccso34varcharIgnored For No Enum
AblationProcedure_s35varcharIgnored For No Enum
AccessoryPathway36varcharIgnored For No Enum
NumberOfElectrodeCatheters37int
MappingTechnique38varchar
TransseptalApproach39varchar
Anticoagulation40varchar
HeparinDose_iu41int
TotalFluoroscopyTime42float
ProcedureStartTime43varcharIgnored For No Enum
ProcedureEndTime44varcharIgnored For No Enum
ProcedureDuration45int
AblationAttempted46varchar
WaitingTime47int
WhyAblationNotAttempted48varchar
NumberOfEnergyApplications49int
TotalTimeOfEnergyApplication50int
AblationEnergySource51varchar
Catheter52varcharIgnored For No Enum
CatheterReach53varcharIgnored For No Enum
Ga54varchar
WhichPulmonaryVeinsAblated55varchar
Success56varchar
TransientHeartBlock57varchar
AblationComplications58varchar
AvBlock59varchar
DeviceImplanted60varchar
IntraopDrugs261varcharIgnored For No Enum
ProcedureReport_comment62varcharIgnored For No Enum
Early_24hrs_Recurrence63varchar
ChestDrain64varchar
PericardialTap65varchar
ArterialRepair66varchar
DeathOnSameAdmission67varchar
LateRecurrenceOfArrhythmia68varchar
TimeToRecurrence_months69int
DateLastFollow_Up70dateIgnored For Datatype
PreOpStay71int
PostOpStay72int
TotalHospitalStay73int
TotalTimeOnWaitingList74int
ReferringGpOrDentist75varcharIgnored For No Enum
NameOfReferringGpOrDentist76varcharIgnored For No Enum
GpPracticeCode77varcharIgnored For No Enum
Pct78varcharIgnored For No Enum
MedicalRecordNumberAtTimeOfEntry79varcharIgnored For No Enum
AuditTrail80varchar
CatheterCcad81varcharIgnored For No Enum
CatheterReachCcad82varchar
AfAblationStrategies83varcharIgnored For No Enum
Score84int
Tvac_pvac85varchar
Height86float
Weight87float
Bmi88float
ScreeningDose89float
ExceededDrl90varchar
Radiographer91varchar
ReasonForExceedingDrl92varchar
DateOfCurrentStatus93dateIgnored For Datatype
DateOfEndStatus94dateIgnored For Datatype
DateTimeRecordCreated95varcharIgnored For No Enum
DateTimeRecordLastChanged96varcharIgnored For No Enum
EnteredByTag97varchar
EntryCurrentStatus98varchar
EntryEndStatus99varchar
HospitalTag100varchar
ImportLinkId101int
Last modified 11 years ago Last modified on 03/15/13 08:55:48
Note: See TracWiki for help on using the wiki.