CL_Clinical_Log

47801 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
snf_admit int 4 null
hha_admit int 4 null
cbc_admit int 4 null
admit_# int 4 null
referral_# int 4 null
referred_to char 66 √ null
referral_destination_cl varchar 66 √ null
orginal_referral char 3 √ null
referral_quarter_nbr varchar 11 √ null
referral_day_of_week varchar 3 √ null
week_ending datetime 16,3 √ null
month_ varchar 6 √ null
referral_date_month varchar 3 √ null
referral_date_week int 4 √ null
referral_date_year char 4 √ null
payor_type varchar 16 null
Source_State varchar 100 √ null
source_market varchar 1 null
patient_name varchar 68 √ null
rowid int 4 null
clinical_liaison char 33 null
referral_source varchar 100 √ null
hospital_name varchar 100 √ null
referral_date datetime 16,3 √ null
dc_planner char 66 √ null
first_name char 33 null
last_name char 33 null
primary_payor_type char 16 √ null
payor_name char 66 √ null
secondary_payor char 66 √ null
orginal varchar 3 null
diagnosis char 100 √ null
snf char 66 √ null
home_health char 66 √ null
cbc char 66 √ null
attempts int 4 √ null
status char 16 √ null
comments char 255 √ null
userid char 33 √ null
insert_date datetime 16,3 √ null
change_date datetime 16,3 √ null
other_diagnosis varchar 500 √ null
readmit_flag varchar 1 √ null
homecare varchar 100 √ null
denied_flag varchar 1 √ null
lost_flag varchar 1 √ null
lost_reason varchar 500 √ null
denial_type varchar 30 √ null
denial_description varchar 500 √ null
discharge_flag varchar 25 √ null
referral_quarter_number int 4 √ null
location_type varchar 100 null
destination_market varchar 100 null
destination_state varchar 100 null
region varchar 100 null
location_name varchar 100 null

Diagram producer might be missing

No diagrams were produced please see application output for any errors