nfi_torfqs_note.txt

1. Schedule
AT 1745 PRIORITY HI              IDN pickup: 23:00 (updated from 19:00 on BS5 to process the peak time for German)
runtime: around 10 minutes

2. File format
dtr-ai001c:abinitio $ echo $NFI_FQS_FILENAME
CORAX_EMEA.26DEC2008
dtr-ai001c:abinitio $ echo $NFI_AQS_FILENAME
EXTEL_AQS.26DEC2008
cat link_archive/CORAX_EMEA.23DEC2008_001|TORfileChk>tidyfile
"tidyfile" [Read only] 98 lines, 6860 characters
JAI.L          ! 15FEB2008  ! 09JAN2008 ! 023 ! 00000130 ! 023 ! -00008169
IKBEUR.PZ   !   BLANK      !   BLANK      ! 999 ! 00000000 ! 220 !  00122700
IBM.S         ! 22DEC2008  ! 29DEC2008 ! 092 ! 00001443 ! 092 !  00000132

RIC	RIC name
DIVPD1/ DIVPD2	Dividend Payment Date corresponding to parent PILC. (split by <EOL> div_pay_date  Format: CYYMMDD where C=Century –19
DivEX	Dividend ex-date corresponding to RIC
DivCur	EXTEL number corresponding to currency of dividend, or ‘999’ if no dividend amount.
DivAmt	Dividend amount, scaled, or zero-filled if no dividend amount.
Ecurr	EXTEL number corresponding to currency of earnings amount, or ‘999’ if no earnings amount.
Eamnt	Earnings amount, scaled, or zero-filled if no earnings amount. Each currency has its own scaling factor
sign	Sign indicator of earnings amount: ‘A’, ‘Z’ or blank. ‘A’ for negative value, ‘Z’ for positive value, blank for zero value.
EOL	Carriage return./linefeed

Input:
CRX_COR.LATEST_ANNUALISED_DPS_ISSUE
CRX_COR.LATEST_ANNUALISED_EPS_ISSUE
LATEST_ANNUALISED_DPS_QUOTE
LATEST_ANNUALISED_EPS_QUOTE, PRODUCTS_EPS_RANKING

3.TORAQS/FQS Configuration Utility
The utility can be invoked as follows:

➢▪▪▪▪▪▪ cd /opt/appl/abinitio/sand/feeds_out/feeds_out_main/run

➢▪▪▪▪▪▪ set_env feeds_out

➢▪▪▪▪▪▪ torfqs_config [insert | update | delete]  [exchange | divmarks | epmarks | netgross]

4.Network
The TORFQS/AQS feed requires connectivity between the system it runs on and the Feeds Staging Server system (FSS). In addition, it requires connectivity between the FDS/FSS and the target Quote Head-end systems.
The FQS files (TORONTO.ddMMMyyyy) are sent to the FSS, where they will be retrieved by the appropriate FQS system via FTP-PULL. The username/password, directory, plus IP address for the FDS, which the client should use to connect to must be communicated to David Harris (DTC Technical Support).  The head-end development  contact is Martin Attwood (RAQ development project manager)

5.
Last FQSAQS runtime: $AI_SERIAL_LOOKUP/nfi_fqsaqs_runtime.dat  --FQS 20081225:17:45
$AI_SERIAL_OUTPUT/nfi_torfqs_hist_load_rics.dat                         --Blank
$AI_SERIAL_LOOKUP/torfqs_issue_market_lookup.dat                     --issue market
$AI_SERIAL_LOOKUP/torfqs_issue_market_lookup_old.dat                --issue market lookup - old    
$AI_SERIAL_LOOKUP/nfi_fqs_exchange_info.dat                        --exchange,ric_suffix,currency,extel_code,scale_factor       
MAU MZ, ,MUR,XXX, ,256 10000

6.
SubGraph:
1). get MKT_FOR_NDA_ID by invoking NFI_TSO_PKG_ddl.sql
select nfi_tso_pkg_stone.get_market_nda_id('600030.SS') market_nda_id from dual
2). get dps and eps
a. for normal
SELECT cma.erd_cma_type_value_d,
decode(cma.erd_cma_type_value_d,'DIV ANNUALISATION TYPE','mkt_dps_ann','DIV NET GROSS INDICATOR','mkt_dps_net_gro',
'EPS ANNUALISATION TYPE','mkt_eps_ann','ACCOUNTING STANDARD','mkt_eps_acc_stds') type,
cla.value value
FROM classifier_map cma,classifier cla
WHERE cma.end_date IS NULL--'DIV NET GROSS INDICATOR'
  AND cma.erd_cma_type_value_d in ('DIV ANNUALISATION TYPE','EPS ANNUALISATION TYPE',
'DIV NET GROSS INDICATOR','ACCOUNTING STANDARD')
AND cma.MKT_FOR_NDA_ID = &MKT_FOR_NDA_ID --51
AND cma.cla_against_nda_id = cla.nda_id
b. for Generate Non-Exchange Defaults

--GetAnnType
SELECT ned.ast_for_nda_id issue_nda_id,
decode(eps_div,'EPS',cla_default_ann_type_nda_id) mkt_eps_ann_id,
decode(eps_div,'EPS',cla.value) mkt_eps_ann,
decode(eps_div,'DIV',cla_default_ann_type_nda_id) mkt_dps_ann_id,
decode(eps_div,'DIV',cla.value) mkt_dps_ann
FROM non_exchange_default ned,classifier cla
WHERE ned.end_date IS NULL
AND ned.cla_accstd_nda_id = cla.nda_id
AND cla.eit_name_d IN('ANNUALISATION TYPE',   'ACCOUNTING STANDARDS',   'NET GROSS')
--GetAccStd
SELECT ned.ast_for_nda_id issue_nda_id,cla.nda_id mkt_eps_acc_stds_id,cla.value mkt_eps_acc_stds
FROM non_exchange_default ned,classifier cla
WHERE ned.end_date IS NULL
AND ned.cla_accstd_nda_id = cla.nda_id
AND cla.eit_name_d IN('ANNUALISATION TYPE',   'ACCOUNTING STANDARDS',   'NET GROSS')
--GetTaxStatus
SELECT ned.ast_for_nda_id issue_nda_id,cla.nda_id mkt_dps_net_gro_id,cla.value mkt_dps_net_gro
FROM non_exchange_default ned,classifier cla
WHERE ned.end_date IS NULL
AND ned.cla_tax_status_nda_id = cla.nda_id
AND cla.eit_name_d IN('ANNUALISATION TYPE',   'ACCOUNTING STANDARDS',   'NET GROSS')