HCHB_CLIENT_EPISODES

107936 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
epi_id int 4 null
epi_paid int 4 null
epi_mrnum varchar 14 √ null
epi_ssn varchar 11 √ null
epi_lastname varchar 50 null
epi_firstname varchar 50 null
epi_mi char 1 √ null
epi_nickname varchar 25 √ null
epi_wphone varchar 25 √ null
epi_aphone varchar 25 √ null
epi_email varchar 100 √ null
epi_gender varchar 6 √ null
epi_race int 4 √ null
epi_asid int 4 √ null
epi_dsid int 4 √ null
epi_status varchar 15 √ null
epi_dob datetime 16,3 √ null
epi_AdmitType varchar 25 null
epi_phid1 int 4 √ null
epi_poid1 int 4 √ null
epi_phid2 int 4 √ null
epi_poid2 int 4 √ null
epi_phid int 4 √ null
epi_poid int 4 √ null
epi_fakid int 4 √ null
epi_phkid int 4 √ null
epi_ReferralSource varchar 10 √ null
epi_ReferralTakenBy varchar 50 √ null
epi_ReferralContact varchar 50 √ null
epi_ReferralRelId int 4 √ null
epi_ReferralFaId int 4 √ null
epi_DateOfReferral datetime 16,3 √ null
epi_AdditionalProviders varchar 255 √ null
epi_RecertFlag varchar 50 √ null
epi_CurrentStageDate datetime 16,3 √ null
epi_branchcode char 3 √ null
epi_ReqDOE smalldatetime 16 √ null
epi_DOLastSeen smalldatetime 16 √ null
epi_DcCode char 2 √ null
epi_DischargeDate smalldatetime 16 √ null
epi_NonAdmitCode char 2 √ null
epi_NonAdmitDate smalldatetime 16 √ null
epi_StartOfEpisode datetime 16,3 √ null
epi_EndOfEpisode datetime 16,3 √ null
epi_SocDate datetime 16,3 √ null
epi_rrid int 4 √ null
epi_admitdiscipline varchar 4 null
epi_EvacuationLocation varchar 50 √ null
epi_teamid int 4 null
epi_mrccode char 1 √ null
epi_insertdate datetime 16,3 null
epi_lastupdate datetime 16,3 null
epi_modifiedby varchar 50 null
epi_ReqAddOnDOE smalldatetime 16 √ null
epi_AddOnDiscipline varchar 4 √ null
epi_SOCAddOnVisit char 1 null
epi_paperworkreceived char 1 null
epi_dcrid int 4 √ null
epi_dccid int 4 √ null
epi_agid int 4 √ null
epi_hccid int 4 √ null
epi_supplydeliveryonly char 1 null
epi_PhysInfo varchar 255 √ null
epi_medidsource int 4 √ null
epi_slid int 4 null
epi_locid int 4 √ null
epi_pregnant char 1 √ null
epi_weight float 8 √ null
epi_height float 8 √ null
epi_vsocdate datetime 16,3 √ null
epi_AddOnDiscipline2 varchar 4 √ null
epi_ReqAddOnDOE2 smalldatetime 16 √ null
epi_NumOfAddOn int 4 √ null
epi_timing int 4 null
epi_initiationvisit char 1 null
epi_numofinitiation int 4 √ null
epi_acid int 4 √ null
epi_acwkrid int 4 √ null
epi_referralotherworkphone varchar 25 √ null
epi_referralotherphoneext varchar 4 √ null
epi_overrideacid int 4 √ null
epi_maritalstatus int 4 √ null
epi_livingarrangments varchar 50 √ null
epi_prid int 4 √ null
epi_hrnid int 4 √ null
epi_religid int 4 √ null
AVA_insert_date datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_HCHB_CLIENT_EPISODES Primary key Asc epi_id

Diagram producer might be missing

No diagrams were produced please see application output for any errors