ข้อมูล s_alien_ipd

Update Delete

ID770
Parent ID1
Table Names_alien_ipd
Titleข้อมูล s_alien_ipd
Description
Script#SQL_OPTIONS#
PROVIDERS=1
PROVIDER1=43STD
PROVIDER1_VALIDATE_TABLES=accident,admission,anc,appointment
SCRIPT_FLOW=SQL
#SQL_OPTIONS#

#PROVIDER1_SQL#
SELECT
s_alien_ipd.id,
s_alien_ipd.hospcode,
s_alien_ipd.areacode,
s_alien_ipd.flag_sent,
s_alien_ipd.date_com,
s_alien_ipd.b_year,
s_alien_ipd.nation,
s_alien_ipd.labor_group,
s_alien_ipd.visit10,
s_alien_ipd.price10,
s_alien_ipd.actualpay10,
s_alien_ipd.fee10,
s_alien_ipd.visit11,
s_alien_ipd.price11,
s_alien_ipd.actualpay11,
s_alien_ipd.fee11,
s_alien_ipd.visit12,
s_alien_ipd.price12,
s_alien_ipd.actualpay12,
s_alien_ipd.fee12,
s_alien_ipd.visit01,
s_alien_ipd.price01,
s_alien_ipd.actualpay01,
s_alien_ipd.fee01,
s_alien_ipd.visit02,
s_alien_ipd.price02,
s_alien_ipd.actualpay02,
s_alien_ipd.fee02,
s_alien_ipd.visit03,
s_alien_ipd.price03,
s_alien_ipd.actualpay03,
s_alien_ipd.fee03,
s_alien_ipd.visit04,
s_alien_ipd.price04,
s_alien_ipd.actualpay04,
s_alien_ipd.fee04,
s_alien_ipd.visit05,
s_alien_ipd.price05,
s_alien_ipd.actualpay05,
s_alien_ipd.fee05,
s_alien_ipd.visit06,
s_alien_ipd.price06,
s_alien_ipd.actualpay06,
s_alien_ipd.fee06,
s_alien_ipd.visit07,
s_alien_ipd.price07,
s_alien_ipd.actualpay07,
s_alien_ipd.fee07,
s_alien_ipd.visit08,
s_alien_ipd.price08,
s_alien_ipd.actualpay08,
s_alien_ipd.fee08,
s_alien_ipd.visit09,
s_alien_ipd.price09,
s_alien_ipd.actualpay09,
s_alien_ipd.fee09,
s_alien_ipd.nation_group
FROM
s_alien_ipd
#PROVIDER1_SQL#
Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2017-08-28 09:58:58
Last Update2017-08-28 09:58:58