Document Actions
Approval Form With Hidden and Cascading Report Parameters
last modified
2008-06-30 11:25
Accompanying file for the Building the Approval Form in BIRT presentation. Note, it can only be run within Mifos, not in BIRT/eclipse.
Size 95.0 kB - File type text/xml
Click here to get the file
File contents
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.1.2.v20070205-1728 Build <20070205-1728></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name here>></property>
<parameters>
<cascading-parameter-group name="Personnel-Center-Member-LoanCP" id="337">
<property name="dataSetMode">multiple</property>
<parameters>
<scalar-parameter name="RPCenterID" id="338">
<property name="valueType">dynamic</property>
<property name="allowNull">false</property>
<property name="controlType">list-box</property>
<property name="dataSetName">Personnel-to-Center RP Data Set</property>
<expression name="valueExpr">row["CUSTOMER_ID"]</expression>
<expression name="labelExpr">row["DISPLAY_NAME"]</expression>
<property name="mustMatch">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="RPMemberID" id="339">
<property name="valueType">dynamic</property>
<property name="allowNull">false</property>
<property name="controlType">list-box</property>
<property name="dataSetName">Center-to-Member RP Data Set</property>
<expression name="valueExpr">row["CUSTOMER_ID"]</expression>
<expression name="labelExpr">row["DISPLAY_NAME"]</expression>
<property name="mustMatch">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="RPLoanAccountID" id="340">
<property name="valueType">dynamic</property>
<property name="allowNull">false</property>
<property name="controlType">list-box</property>
<property name="dataSetName">Member-to-Loans RP Data Set</property>
<expression name="valueExpr">row["ACCOUNT_ID"]</expression>
<expression name="labelExpr">row["DISBURSEMENT_DATE"]</expression>
<property name="mustMatch">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
</cascading-parameter-group>
<scalar-parameter name="userId" id="341">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Mifos JDBC Data Source" id="4">
<property name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://localhost:3306/mifos</property>
<property name="odaUser">root</property>
<encrypted-property name="odaPassword">bXlzcWw=</encrypted-property>
</oda-data-source>
<script-data-source name="Mifos Scripted Data Source" id="153">
<method name="open"><![CDATA[Packages.java.util.logging.Logger.getLogger("").info("DS-OPEN");
var userId = reportContext.getParameterValue("userId");
reportsDataService = new Packages.org.mifos.application.reports.business.service.ReportsDataService();
reportsDataService.initialize(userId);
Packages.org.mifos.application.productdefinition.persistence.LoanPrdPersistence.enableThreadCacheForReports();]]></method>
<method name="close"><![CDATA[reportsDataService = null;
Packages.org.mifos.application.productdefinition.persistence.LoanPrdPersistence.disableThreadCacheForReports();]]></method>
</script-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Approval Form Data Set" id="5">
<list-property name="columnHints">
<structure>
<property name="columnName">DISPLAY_NAME</property>
<property name="alias">branch_name</property>
</structure>
<structure>
<property name="columnName">LOOKUP_NAME_10</property>
<property name="alias">gender_name</property>
</structure>
<structure>
<property name="columnName">FIELD_VALUE</property>
<property name="alias">financial_name</property>
</structure>
<structure>
<property name="columnName">ACTION_DATE</property>
<property name="alias">previous_loan_amount</property>
</structure>
<structure>
<property name="columnName">LOOKUP_VALUE</property>
<property name="alias">education_name</property>
</structure>
<structure>
<property name="columnName">LOOKUP_VALUE_12</property>
<property name="alias">marital_name</property>
</structure>
<structure>
<property name="columnName">LOOKUP_VALUE_23</property>
<property name="alias">business_name</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMER_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">GOVERNMENT_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">branch_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">FIRST_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">LAST_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">DATE_OF_BIRTH</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">EDUCATION_LEVEL</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">education_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">GENDER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">gender_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">MARITAL_STATUS</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">marital_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">NUM_CHILDREN</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">LINE_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">LINE_2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">GLOBAL_ACCOUNT_NUM</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">LOAN_AMOUNT</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">NO_OF_INSTALLMENTS</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">DISBURSEMENT_DATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">PRD_OFFERING_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">BUSINESS_ACTIVITIES_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">business_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">financial_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">previous_loan_amount</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">LOAN_COUNTER</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">PREVIOUS_LOAN_AMOUNT</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Mifos JDBC Data Source</property>
<property name="cachedRowCount">-1</property>
<list-property name="parameters">
<structure>
<property name="name">DSLoanAccountID</property>
<property name="paramName">RPLoanAccountID</property>
<property name="dataType">any</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMER_ID</property>
<property name="nativeName">CUSTOMER_ID</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">GOVERNMENT_ID</property>
<property name="nativeName">GOVERNMENT_ID</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DISPLAY_NAME</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">FIRST_NAME</property>
<property name="nativeName">FIRST_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">LAST_NAME</property>
<property name="nativeName">LAST_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">DATE_OF_BIRTH</property>
<property name="nativeName">DATE_OF_BIRTH</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">EDUCATION_LEVEL</property>
<property name="nativeName">EDUCATION_LEVEL</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">LOOKUP_VALUE</property>
<property name="nativeName">LOOKUP_VALUE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">GENDER</property>
<property name="nativeName">GENDER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">LOOKUP_NAME_10</property>
<property name="nativeName">LOOKUP_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">MARITAL_STATUS</property>
<property name="nativeName">MARITAL_STATUS</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">LOOKUP_VALUE_12</property>
<property name="nativeName">LOOKUP_VALUE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">NUM_CHILDREN</property>
<property name="nativeName">NUM_CHILDREN</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">LINE_1</property>
<property name="nativeName">LINE_1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">LINE_2</property>
<property name="nativeName">LINE_2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">CITY</property>
<property name="nativeName">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">GLOBAL_ACCOUNT_NUM</property>
<property name="nativeName">GLOBAL_ACCOUNT_NUM</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">LOAN_AMOUNT</property>
<property name="nativeName">LOAN_AMOUNT</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">NO_OF_INSTALLMENTS</property>
<property name="nativeName">NO_OF_INSTALLMENTS</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">DISBURSEMENT_DATE</property>
<property name="nativeName">DISBURSEMENT_DATE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">PRD_OFFERING_NAME</property>
<property name="nativeName">PRD_OFFERING_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">BUSINESS_ACTIVITIES_ID</property>
<property name="nativeName">BUSINESS_ACTIVITIES_ID</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">LOOKUP_VALUE_23</property>
<property name="nativeName">LOOKUP_VALUE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">FIELD_VALUE</property>
<property name="nativeName">FIELD_VALUE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">ACTION_DATE</property>
<property name="nativeName">ACTION_DATE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">LOAN_COUNTER</property>
<property name="nativeName">LOAN_COUNTER</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">PREVIOUS_LOAN_AMOUNT</property>
<property name="nativeName">PREVIOUS_LOAN_AMOUNT</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
</list-property>
<property name="queryText">SELECT
C.CUSTOMER_ID, C.GOVERNMENT_ID, O.DISPLAY_NAME,
C.FIRST_NAME, C.LAST_NAME, C.DATE_OF_BIRTH,
CD.EDUCATION_LEVEL, LVL1.LOOKUP_VALUE, CD.GENDER, LV2.LOOKUP_NAME,
CD.MARITAL_STATUS, LVL3.LOOKUP_VALUE,
CD.NUM_CHILDREN,
CAD.LINE_1, CAD.LINE_2, CAD.CITY,
A.GLOBAL_ACCOUNT_NUM, LA.LOAN_AMOUNT,
LA.NO_OF_INSTALLMENTS, LA.DISBURSEMENT_DATE,
PO.PRD_OFFERING_NAME, LA.BUSINESS_ACTIVITIES_ID, LVL4.LOOKUP_VALUE,
ACF.FIELD_VALUE,
LS.ACTION_DATE,
(SELECT SUM(LOAN_CYCLE_COUNTER)
FROM
LOAN_COUNTER LC
JOIN CLIENT_PERF_HISTORY CPH
ON LC.CLIENT_PERF_ID = CPH.ID
WHERE CPH.CUSTOMER_ID = C.CUSTOMER_ID
GROUP BY CLIENT_PERF_ID) AS LOAN_COUNTER,
(SELECT
LA3.LOAN_AMOUNT
FROM
LOAN_ACCOUNT LA3
JOIN ACCOUNT A3
ON LA3.ACCOUNT_ID = A3.ACCOUNT_ID
WHERE
A3.CUSTOMER_ID = C.CUSTOMER_ID
AND
LA3.DISBURSEMENT_DATE =
(SELECT
MAX(LA2.DISBURSEMENT_DATE)
FROM
ACCOUNT A2
JOIN LOAN_ACCOUNT LA2
ON A2.ACCOUNT_ID = LA2.ACCOUNT_ID
WHERE
LA2.DISBURSEMENT_DATE < LA.DISBURSEMENT_DATE
AND
A2.CUSTOMER_ID = C.CUSTOMER_ID)) AS PREVIOUS_LOAN_AMOUNT
FROM
CUSTOMER C
LEFT JOIN OFFICE O
ON C.BRANCH_ID = O.OFFICE_ID
LEFT JOIN CUSTOMER_DETAIL CD
ON C.CUSTOMER_ID = CD.CUSTOMER_ID
LEFT JOIN CUSTOMER_ADDRESS_DETAIL CAD
ON C.CUSTOMER_ID = CAD.CUSTOMER_ID
LEFT JOIN LOOKUP_VALUE_LOCALE LVL1
ON CD.EDUCATION_LEVEL = LVL1.LOOKUP_ID
LEFT JOIN LOOKUP_VALUE LV2
ON CD.GENDER = LV2.LOOKUP_ID
LEFT JOIN LOOKUP_VALUE_LOCALE LVL3
ON CD.MARITAL_STATUS = LVL3.LOOKUP_ID
LEFT JOIN ACCOUNT A
ON C.CUSTOMER_ID = A.CUSTOMER_ID
LEFT JOIN LOAN_ACCOUNT LA
ON A.ACCOUNT_ID = LA.ACCOUNT_ID
LEFT JOIN LOOKUP_VALUE_LOCALE LVL4
ON LA.BUSINESS_ACTIVITIES_ID = LVL4.LOOKUP_ID
LEFT JOIN PRD_OFFERING PO
ON LA.PRD_OFFERING_ID = PO.PRD_OFFERING_ID
JOIN LOAN_SCHEDULE LS
ON A.ACCOUNT_ID = LS.ACCOUNT_ID
JOIN ACCOUNT_CUSTOM_FIELD ACF
ON A.ACCOUNT_ID = ACF.ACCOUNT_ID
WHERE
LS.INSTALLMENT_ID = 1
AND
ACF.FIELD_ID = 15
AND
A.ACCOUNT_ID = ?</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMER_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMER_ID</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>GOVERNMENT_ID</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>GOVERNMENT_ID</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DISPLAY_NAME</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>FIRST_NAME</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>FIRST_NAME</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LAST_NAME</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LAST_NAME</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DATE_OF_BIRTH</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DATE_OF_BIRTH</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>EDUCATION_LEVEL</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>EDUCATION_LEVEL</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOOKUP_NAME</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LOOKUP_NAME</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>GENDER</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>6</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>GENDER</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOOKUP_NAME</design:name>
<design:position>10</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LOOKUP_NAME</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>MARITAL_STATUS</design:name>
<design:position>11</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>MARITAL_STATUS</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOOKUP_NAME</design:name>
<design:position>12</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LOOKUP_NAME</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>NUM_CHILDREN</design:name>
<design:position>13</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>6</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>NUM_CHILDREN</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LINE_1</design:name>
<design:position>14</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LINE_1</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LINE_2</design:name>
<design:position>15</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LINE_2</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CITY</design:name>
<design:position>16</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>CITY</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>GLOBAL_ACCOUNT_NUM</design:name>
<design:position>17</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>GLOBAL_ACCOUNT_NUM</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOAN_AMOUNT</design:name>
<design:position>18</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LOAN_AMOUNT</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>NO_OF_INSTALLMENTS</design:name>
<design:position>19</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>6</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>NO_OF_INSTALLMENTS</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISBURSEMENT_DATE</design:name>
<design:position>20</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DISBURSEMENT_DATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRD_OFFERING_NAME</design:name>
<design:position>21</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>PRD_OFFERING_NAME</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>BUSINESS_ACTIVITIES_ID</design:name>
<design:position>22</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>BUSINESS_ACTIVITIES_ID</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOOKUP_NAME</design:name>
<design:position>23</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LOOKUP_NAME</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>FIELD_VALUE</design:name>
<design:position>24</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>FIELD_VALUE</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ACTION_DATE</design:name>
<design:position>25</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>ACTION_DATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOAN_COUNTER</design:name>
<design:position>26</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>27</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LOAN_COUNTER</design:label>
<design:formattingHints>
<design:displaySize>28</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PREVIOUS_LOAN_AMOUNT</design:name>
<design:position>27</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>PREVIOUS_LOAN_AMOUNT</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Personnel-to-Center RP Data Set" id="334">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMER_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Mifos JDBC Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">DSPuserId</property>
<property name="paramName">userId</property>
<property name="dataType">any</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMER_ID</property>
<property name="nativeName">CUSTOMER_ID</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT
CUSTOMER_ID, DISPLAY_NAME
FROM
CUSTOMER
WHERE
DISCRIMINATOR = 'CENTER'
AND
STATUS_ID = '13' /* active */
AND
IF((SELECT LEVEL_ID
FROM PERSONNEL
WHERE PERSONNEL_ID = (SELECT @PersonnelID := ?)) = 1,
LOAN_OFFICER_ID = @PersonnelID,
1)</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMER_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMER_ID</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DISPLAY_NAME</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Center-to-Member RP Data Set" id="335">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMER_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Mifos JDBC Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">DSPCenterID</property>
<property name="paramName">RPCenterID</property>
<property name="dataType">any</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMER_ID</property>
<property name="nativeName">CUSTOMER_ID</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT
CMEM.CUSTOMER_ID, CMEM.DISPLAY_NAME
FROM
CUSTOMER CMEM
JOIN CUSTOMER CGRP
ON CMEM.PARENT_CUSTOMER_ID = CGRP.CUSTOMER_ID
JOIN CUSTOMER CCNTR
ON CGRP.PARENT_CUSTOMER_ID = CCNTR.CUSTOMER_ID
LEFT JOIN ACCOUNT A
ON CMEM.CUSTOMER_ID = A.CUSTOMER_ID
WHERE
A.ACCOUNT_TYPE_ID = 1
AND
CCNTR.CUSTOMER_ID = ?</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMER_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMER_ID</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DISPLAY_NAME</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Member-to-Loans RP Data Set" id="336">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ACCOUNT_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">GLOBAL_ACCOUNT_NUM</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">LOAN_AMOUNT</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">DISBURSEMENT_DATE</property>
<property name="dataType">date-time</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Mifos JDBC Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">DSPMemberID</property>
<property name="paramName">RPMemberID</property>
<property name="dataType">any</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ACCOUNT_ID</property>
<property name="nativeName">ACCOUNT_ID</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">GLOBAL_ACCOUNT_NUM</property>
<property name="nativeName">GLOBAL_ACCOUNT_NUM</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">LOAN_AMOUNT</property>
<property name="nativeName">LOAN_AMOUNT</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">DISBURSEMENT_DATE</property>
<property name="nativeName">DISBURSEMENT_DATE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
</list-property>
<property name="queryText">SELECT
A.ACCOUNT_ID, A.GLOBAL_ACCOUNT_NUM,
LA.LOAN_AMOUNT, LA.DISBURSEMENT_DATE
FROM ACCOUNT A
JOIN LOAN_ACCOUNT LA
ON A.ACCOUNT_ID = LA.ACCOUNT_ID
WHERE
A.ACCOUNT_TYPE_ID = 1 /* LOAN */
AND
A.CUSTOMER_ID = ?</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ACCOUNT_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>ACCOUNT_ID</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>GLOBAL_ACCOUNT_NUM</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>GLOBAL_ACCOUNT_NUM</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOAN_AMOUNT</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>LOAN_AMOUNT</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISBURSEMENT_DATE</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DISBURSEMENT_DATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="type">a4</property>
<property name="orientation">landscape</property>
<page-header>
<label id="77">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">large</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Approval Form</text-property>
</label>
</page-header>
<page-footer>
<text id="3">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<grid id="177">
<property name="fontFamily">"Arial"</property>
<property name="fontWeight">bold</property>
<property name="color">#408080</property>
<property name="width">100%</property>
<column id="178"/>
<column id="179"/>
<column id="180"/>
<row id="181">
<cell id="182"/>
<cell id="183">
<grid id="200">
<property name="width">100%</property>
<column id="201"/>
<column id="202"/>
<row id="203">
<cell id="204">
<label id="206">
<text-property name="text">Disbursed Date</text-property>
</label>
</cell>
<cell id="205">
<data id="194">
<property name="fontFamily">"Arial"</property>
<structure name="dateTimeFormat">
<property name="category">Short Date</property>
<property name="pattern">Short Date</property>
</structure>
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">DISBURSEMENT_DATE</property>
<expression name="expression">dataSetRow["DISBURSEMENT_DATE"]</expression>
<property name="dataType">date-time</property>
</structure>
</list-property>
<property name="resultSetColumn">DISBURSEMENT_DATE</property>
</data>
</cell>
</row>
</grid>
</cell>
<cell id="184">
<data id="197">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">GLOBAL_ACCOUNT_NUM</property>
<expression name="expression">"Loan id:"+dataSetRow["GLOBAL_ACCOUNT_NUM"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">GLOBAL_ACCOUNT_NUM</property>
</data>
</cell>
</row>
<row id="185">
<cell id="186">
<data id="193">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Branch_Name</property>
<expression name="expression">"Branch : " + dataSetRow["branch_name"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">Branch_Name</property>
</data>
</cell>
<cell id="187">
<data id="199">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">NO_OF_INSTALLMENTS</property>
<expression name="expression">"Number of payments :"+dataSetRow["NO_OF_INSTALLMENTS"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">NO_OF_INSTALLMENTS</property>
</data>
</cell>
<cell id="188">
<data id="198">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">PRD_OFFERING_NAME</property>
<expression name="expression">"Product:"+dataSetRow["PRD_OFFERING_NAME"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">PRD_OFFERING_NAME</property>
</data>
</cell>
</row>
<row id="189">
<cell id="190"/>
<cell id="191">
<grid id="207">
<property name="width">100%</property>
<column id="208"/>
<column id="209"/>
<row id="210">
<cell id="211">
<label id="213">
<text-property name="text">First payment Date</text-property>
</label>
</cell>
<cell id="212">
<data id="196">
<property name="fontFamily">"Arial"</property>
<property name="fontWeight">bold</property>
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">dd MMM yyyy</property>
</structure>
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ACTION_DATE</property>
<expression name="expression">dataSetRow["ACTION_DATE"]</expression>
<property name="dataType">date-time</property>
</structure>
</list-property>
<property name="resultSetColumn">ACTION_DATE</property>
</data>
</cell>
</row>
</grid>
</cell>
<cell id="192"/>
</row>
</grid>
<grid id="214">
<property name="fontFamily">"Arial"</property>
<property name="width">100%</property>
<column id="215">
<property name="width">12%</property>
<property name="fontWeight">bold</property>
</column>
<column id="216">
<property name="width">13%</property>
</column>
<column id="217">
<property name="width">12%</property>
<property name="fontWeight">bold</property>
</column>
<column id="218">
<property name="width">13%</property>
</column>
<column id="219">
<property name="width">12%</property>
<property name="fontWeight">bold</property>
</column>
<column id="220">
<property name="width">13%</property>
</column>
<column id="221">
<property name="width">12%</property>
<property name="fontWeight">bold</property>
</column>
<column id="222"/>
<row id="223">
<cell id="224">
<label id="277">
<property name="color">#408080</property>
<text-property name="text">Government ID</text-property>
</label>
</cell>
<cell id="225">
<data id="295">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">GOVERNMENT_ID</property>
<expression name="expression">dataSetRow["GOVERNMENT_ID"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">GOVERNMENT_ID</property>
</data>
</cell>
<cell id="226">
<label id="278">
<property name="color">#408080</property>
<text-property name="text">Name</text-property>
</label>
</cell>
<cell id="227">
<data id="296">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">FIRST_NAME</property>
<expression name="expression">dataSetRow["FIRST_NAME"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">FIRST_NAME</property>
</data>
</cell>
<cell id="228"/>
<cell id="229"/>
<cell id="230">
<label id="291">
<property name="color">#408080</property>
<text-property name="text">Last Name</text-property>
</label>
</cell>
<cell id="231">
<data id="297">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">LAST_NAME</property>
<expression name="expression">dataSetRow["LAST_NAME"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">LAST_NAME</property>
</data>
</cell>
</row>
<row id="232">
<cell id="233">
<label id="280">
<property name="color">#408080</property>
<text-property name="text">Sex</text-property>
</label>
</cell>
<cell id="234">
<data id="313">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">gender_name</property>
<expression name="expression">dataSetRow["gender_name"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">gender_name</property>
</data>
</cell>
<cell id="235">
<label id="287">
<property name="color">#408080</property>
<text-property name="text">Marital Status</text-property>
</label>
</cell>
<cell id="236">
<data id="300">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">MARITAL_STATUS</property>
<expression name="expression">dataSetRow["MARITAL_STATUS"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<property name="resultSetColumn">MARITAL_STATUS</property>
</data>
</cell>
<cell id="237">
<label id="288">
<property name="color">#408080</property>
<text-property name="text">Number of Children</text-property>
</label>
</cell>
<cell id="238">
<data id="299">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">NUM_CHILDREN</property>
<expression name="expression">dataSetRow["NUM_CHILDREN"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<property name="resultSetColumn">NUM_CHILDREN</property>
</data>
</cell>
<cell id="239">
<label id="292">
<property name="color">#408080</property>
<text-property name="text">Level of instru</text-property>
</label>
</cell>
<cell id="240">
<data id="312">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">education_name</property>
<expression name="expression">dataSetRow["education_name"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">education_name</property>
</data>
</cell>
</row>
<row id="241">
<cell id="242">
<label id="281">
<property name="color">#408080</property>
<text-property name="text">Birth Date</text-property>
</label>
</cell>
<cell id="243">
<data id="298">
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">MMM dd, yyyy</property>
</structure>
<structure name="numberFormat">
<property name="category">Custom</property>
</structure>
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">DATE_OF_BIRTH</property>
<expression name="expression">dataSetRow["DATE_OF_BIRTH"]</expression>
<property name="dataType">date-time</property>
</structure>
</list-property>
<property name="resultSetColumn">DATE_OF_BIRTH</property>
</data>
</cell>
<cell id="244"/>
<cell id="245"/>
<cell id="246">
<label id="289">
<property name="color">#408080</property>
<text-property name="text">Promotion</text-property>
</label>
</cell>
<cell id="247"/>
<cell id="248">
<label id="293">
<property name="color">#408080</property>
<text-property name="text">Licence</text-property>
</label>
</cell>
<cell id="249"/>
</row>
<row id="250">
<cell id="251">
<label id="282">
<property name="color">#408080</property>
<text-property name="text">Activity</text-property>
</label>
</cell>
<cell id="252">
<data id="310">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">business_name</property>
<expression name="expression">dataSetRow["business_name"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">business_name</property>
</data>
</cell>
<cell id="253"/>
<cell id="254"/>
<cell id="255">
<label id="290">
<property name="color">#408080</property>
<text-property name="text">Loan purpose</text-property>
</label>
</cell>
<cell id="256">
<data id="311">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">financial_name</property>
<expression name="expression">dataSetRow["financial_name"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">financial_name</property>
</data>
</cell>
<cell id="257">
<label id="294">
<property name="color">#408080</property>
<text-property name="text">Status</text-property>
</label>
</cell>
<cell id="258"/>
</row>
<row id="259">
<cell id="260">
<label id="283">
<property name="color">#408080</property>
<text-property name="text">Prevesious Loan Amount</text-property>
</label>
</cell>
<cell id="261">
<data id="301">
<property name="paddingRight">10pt</property>
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$#,##0.000</property>
</structure>
<property name="textAlign">right</property>
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">PREVIOUS_LOAN_AMOUNT</property>
<expression name="expression">dataSetRow["PREVIOUS_LOAN_AMOUNT"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="resultSetColumn">PREVIOUS_LOAN_AMOUNT</property>
</data>
</cell>
<cell id="262">
<label id="286">
<property name="color">#408080</property>
<text-property name="text">Client House Adress</text-property>
</label>
</cell>
<cell id="263">
<data id="302">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">LINE_1</property>
<expression name="expression">dataSetRow["LINE_1"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">LINE_1</property>
</data>
</cell>
<cell id="264"/>
<cell id="265"/>
<cell id="266"/>
<cell id="267"/>
</row>
<row id="268">
<cell id="269">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
<label id="284">
<property name="color">#408080</property>
<text-property name="text">Amount</text-property>
</label>
</cell>
<cell id="270">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
<data id="305">
<property name="paddingRight">10pt</property>
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$#,##0.000</property>
</structure>
<property name="textAlign">right</property>
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">LOAN_AMOUNT</property>
<expression name="expression">dataSetRow["LOAN_AMOUNT"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="resultSetColumn">LOAN_AMOUNT</property>
</data>
</cell>
<cell id="271">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
<label id="285">
<property name="color">#408080</property>
<text-property name="text">Loan Cycle</text-property>
</label>
</cell>
<cell id="272">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
<data id="306">
<property name="dataSet">Approval Form Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">LOAN_COUNTER</property>
<expression name="expression">dataSetRow["LOAN_COUNTER"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="resultSetColumn">LOAN_COUNTER</property>
</data>
</cell>
<cell id="273">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="274">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="275">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="276">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
</row>
<row id="314">
<cell id="315">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
<label id="323">
<text-property name="text">Signature</text-property>
</label>
</cell>
<cell id="317">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="318">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="319">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
<label id="333">
<text-property name="text">Signature</text-property>
</label>
</cell>
<cell id="321">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="322">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
</row>
<row id="324">
<cell id="325">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="326">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="329">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="330">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="331">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
<cell id="332">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
</cell>
</row>
</grid>
</body>
</report>