Ultmarc

Raw File Name Nitro Table STG Load Pattern ODS Load Pattern Primary Key Composite ID

dcf_inst_*.csv

ult_dcf_hco__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v dcf_hco_composite_id__v |dcf_hco_cd__v|mst_start_date__v|
hco_type.csv ult_hco_type__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v hco_type_composite_id__v |hco_type_cd__v|mst_start_date__v|

hco_class.csv

ult_hco_class__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v hco_class_composite_id__v |hco_class_cd__v|mst_start_date__v|
hco_management.csv ult_hco_management__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v hco_management_composite_id__v |hco_management_cd__v|mst_start_date__v|

medical_treatment.csv

ult_medical_treatment__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v medical_treatment_composite_id__v |medical_treatment_cd__v|mst_start_date__v|
dcf_hcp.csv ult_dcf_hcp__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v dcf_hcp_composite_id__v |dcf_hcp_cd__v|mst_start_date__v|

dcf_hcp_academic_society.csv

ult_dcf_hcp_academic_society__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v dcf_hcp_academic_society_composite_id__v |dcf_hcp_cd__v|academic_society_cd__v|mst_start_date__v|
academic_society.csv ult_academic_society__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v academic_society_composite_id__v |academic_society_cd__v|mst_start_date__v|

alma_master.csv

ult_alma_master__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v alma_master_composite_id__v |alma_master_cd__v|mst_start_date__v|
prefecture.csv ult_prefecture__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v prefecture_composite_id__v |prefecture_cd__v|mst_start_date__v|

dcf_parenthco.csv

ult_dcf_parenthco__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v dcf_parenthco_composite_id__v |dcf_hcp_cd__v|dcf_hco_cd__v|mst_start_date__v|
medical_department.csv ult_medical_department__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v medical_department_composite_id__v |medical_department_cd__v|mst_start_date__v|

position.csv

ult_position__v pt_ftp_stg_rawformulaload__v pt_ftp_ods_upsertload__v position_composite_id__v |position_cd__v|mst_start_date__v|

Nitro Table

ult_dcf_hco__v ult_hco_type__v ult_hco_class__v ult_hco_management__v ult_medical_treatment__v ult_dcf_hcp__v ult_dcf_hcp_academic_society__v ult_academic_society__v ult_alma_master__v ult_prefecture__v ult_dcf_parenthco__v ult_medical_department__v ult_position__v
dcf_hco_cd__v hco_type_cd__v hco_class_cd__v hco_management_cd__v medical_treatment_cd__v dcf_hcp_cd__v dcf_hcp_cd__v academic_society_cd__v alma_master_cd__v prefecture_cd__v dcf_hcp_cd__v medical_department_cd__v position_cd__v
mst_start_date__v mst_start_date__v mst_start_date__v mst_start_date__v mst_start_date__v mst_start_date__v academic_society_cd__v mst_start_date__v mst_start_date__v mst_start_date__v dcf_hco_cd__v mst_start_date__v mst_start_date__v
mst_end_date__v mst_end_date__v mst_end_date__v mst_end_date__v mst_end_date__v mst_end_date__v mst_start_date__v mst_end_date__v mst_end_date__v mst_end_date__v mst_start_date__v mst_end_date__v mst_end_date__v
delete_date__v delete_date__v delete_date__v delete_date__v delete_date__v delete_date__v mst_end_date__v delete_date__v delete_date__v delete_date__v mst_end_date__v delete_date__v delete_date__v
layout_type__v layout_type__v layout_type__v layout_type__v layout_type__v layout_type__v delete_date__v layout_type__v layout_type__v layout_type__v delete_date__v layout_type__v layout_type__v
modify_type__v modify_type__v modify_type__v modify_type__v modify_type__v modify_type__v layout_type__v modify_type__v modify_type__v modify_type__v layout_type__v modify_type__v modify_type__v
maintenance_date__v maintenance_date__v maintenance_date__v maintenance_date__v maintenance_date__v maintenance_date__v modify_type__v maintenance_date__v maintenance_date__v maintenance_date__v modify_type__v maintenance_date__v maintenance_date__v
reservation_date__v reservation_date__v reservation_date__v reservation_date__v reservation_date__v reservation_date__v maintenance_type__v reservation_date__v reservation_date__v reservation_date__v reservation_type__v reservation_date__v reservation_date__v
unconfirmed_flg__v hco_type_name__v hco_class_name__v hco_management_name__v medical_treatment_name__v delete_schedule_reason_cd__v maintenance_date__v academic_society_name__v alma_master_name__v prefecture_name__v maintenance_date__v medical_department_name__v position_name__v
delete_reason_cd__v created_date__v created_date__v created_date__v medical_treatment_long_name__v duplication_referenct_cd__v reservation_date__v created_date__v created_date__v jis_prefecture_cd__v reservation_date__v medical_department_kana__v created_date__v
duplication_reference_cd__v last_modified_date__v last_modified_date__v last_modified_date__v medical_treatment_kana__v hcp_name__v academic_society_year__v last_modified_date__v last_modified_date__v created_date__v position_cd__v hco_category__v last_modified_date__v
long_hco_name__v hco_type_composite_id__v hco_class_composite_id__v hco_management_composite_id__v created_date__v hcp_name_kana__v created_date__v academic_society_composite_id__v alma_master_composite_id__v last_modified_date__v identity_cd__v treatment_category__v position_composite_id__v
long_hco_name_kana__v

n/a

 

    last_modified_date__v gender_cd__v last_modified_date__v n/a   prefecture_composite_id__v medical_department_cd__v sort_cd__v n/a
hco_name__v       medical_treatment_composite_id__v birthday_era__v dcf_hcp_academic_society_composite_id__v n/a     medical_department_name__v created_date__v  
hco_name_kana__v       n/a birthday_year__v n/a       medical_department_kana__v last_modified_date__v  
address_unknown_reason_cd__v         birthday_month__v         no_dm_flg__v medical_department_composite_id__v  
prefecture_cd__v         birthday_day__v         created_date__v n/a  
city_cd__v         place_of_birth_prefecture_cd__v         last_modified_date__v    
twon_cd__v         medical_association_cd__v         dcf_parenthco_composite_id__v    
village_cd__v         graduation_era__v         n/a    
postal_cd__v         graduation_year__v              
hco_address__v         alma_mater_cd__v              
hco_address_kana__v         major_cd__v              
address_display_number__v         registration_era__v              
prefecture_length__v         registration_year__v              
city_length__v         medical_treatment_01__v              
twon_length__v         medical_treatment_02__v              
village_length__v         medical_treatment_03__v              
prefecture_kana_length__v         medical_treatment_04__v              
city_kana_length__v         medical_treatment_05__v              
twon_kana_length__v         address_unkown_flg__v              
village_kana_length__v         prefecture_cd__v              
no_phone_number_flg__v         city_cd__v              
hco_phone_number__v         twon_cd__v              
hco_management_cd__v         village_cd__v              
hco_type_cd__v         postal_cd__v              
hco_owner_cd__v         home_address__v              
hco_owner_name__v         home_address_kana__v              
hco_owner_kana__v         address_display_number__v              
establish_schedule_flg__v         prefecture_length__v              
establish_schedule_ym__v         city_length__v              
close_flg__v         twon_length__v              
close_date__v         village_length__v              
medical_treatment_01__v         prefecture_kana_length__v              
medical_treatment_02__v         city_kana_length__v              
medical_treatment_03__v         twon_kana_length__v              
medical_treatment_04__v         village_kana_length__v              
medical_treatment_05__v         home_phone_number__v              
medical_treatment_06__v         no_use_type__v              
medical_treatment_07__v         no_use_reason__v              
medical_treatment_08__v         no_use_registration_date__v              
medical_treatment_09__v         no_use_cancel_date__v              
medical_treatment_10__v         practitioner_type__v              
medical_treatment_11__v         practitioner_era__v              
medical_treatment_12__v         practitioner_year__v              
medical_treatment_13__v         registration_flg__v              
medical_treatment_14__v         home_address_prefecture__v              
medical_treatment_15__v         home_address_city__v              
medical_treatment_16__v         home_address_town__v              
medical_treatment_17__v         home_address_village__v              
medical_treatment_18__v         home_address_prefecture_kana__v              
medical_treatment_19__v         home_address_city_kana__v              
medical_treatment_20__v         home_address_town_kana__v              
medical_treatment_21__v         home_address_village_kana__v              
medical_treatment_22__v         created_date__v              
medical_treatment_23__v         last_modified_date__v              
medical_treatment_24__v         dcf_hcp_composite_id__v