BRGVersion:6
revision:$Revision$
UUID:fd30cd4e-2ea0-4b33-8584-f330d7322cbd
timestamp:1614884142
baselib:core
baselib:inFlow
baselib:lal1

begin:graphprops
end:graphprops

node:Failed
bretype:core::DB Execute
editor:Label=Failed
editor:handle=604129d4102d55b0
editor:sortkey=50bf7e4c13c434cc
input:50be667741db2312/=Static_Data.40fe6c55598828e5
output:50be68b035467013/out1=
prop:CommitFrequency=10
prop:DbInterface=cli
prop:Script=<<EOX
sqlSelect(1,
		"{{^query^}}",
		BAN.str().trim())

EOX
prop:SqlDateType=datetime
prop:query=<<EOX
select
acct_nbr,
curr_crdt_sts_cd,
curr_crdt_sts_rsn_cd,
crdt_sts_rsn_desc
from 
ECDW_EDWCCDVIEWS.CRDT_APP
where
acct_nbr = :1
EOX
editor:XY=390,450
editor:propdef=query|sql|1||None
end:Failed

node:Succesful
bretype:core::DB Execute
editor:Label=Succesful
editor:handle=60412428429f4cd7
editor:sortkey=50bf7e4c13c434cc_3
input:50be667741db2312/=Static_Data_3.40fe6c55598828e5
output:50be68b035467013/out1=
prop:CommitFrequency=10
prop:DbInterface=oci
prop:Script=<<EOX
sqlSelect(1,
		"{{^query^}}",
		BAN.str().trim())

EOX
prop:SqlDateType=datetime
prop:query=<<EOX
select
customer_id,
sub_status,
sub_status_date,
sub_sts_issue_date,
effective_date
from lspappo.subscriber
where 
subscriber_type = 'VD' and
customer_id = :1 
EOX
editor:XY=400,250
editor:propdef=query|sql|1||None
end:Succesful

node:Static_Data
bretype:core::Static Data
editor:handle=60412ad425771fc9
editor:sortkey=60412ad425771fc9
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
BAN
980035609
980044597
980051278
980059516
EOX
editor:XY=210,450
end:Static_Data

node:Static_Data_3
bretype:core::Static Data
editor:handle=60412b4617a743c0
editor:sortkey=60412ad425771fc9_2
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
BAN
252662346
298563539
298414540
298485191
298168109
298256620
298786778
298761408
298363917
298710023
EOX
editor:XY=210,250
end:Static_Data_3