Summary Table
Categories |
Total Count |
PII |
0 |
URL |
0 |
DNS |
0 |
EKL |
0 |
IP |
0 |
PORT |
0 |
VsID |
0 |
CF |
0 |
AI |
0 |
VPD |
0 |
PL |
0 |
Other |
0 |
File Content
<?xml version="1.0" encoding="UTF-8"?>
<Export generator="Cache" version="25">
<Class name="CREPOS.CASES">
<Description>
Generated by the Link Table wizard on 2018-10-18 12:32:54. Note that you can access the data in this class only when the external database is accessible.</Description>
<ProcedureBlock>0</ProcedureBlock>
<SqlRowIdPrivate>1</SqlRowIdPrivate>
<SqlTableName>CASES</SqlTableName>
<Super>%Library.Persistent,%XML.Adaptor,CREPOS.DBCONFIG</Super>
<TimeCreated>64939,45173.789647</TimeCreated>
<Parameter name="EXTERNALTABLENAME">
<Description>
Specifies the external table to which this class refers</Description>
<Default>E_REPOS.CASES</Default>
</Parameter>
<Property name="CAS01CLMADJGRP">
<Type>%String</Type>
<SqlColumnNumber>12</SqlColumnNumber>
<SqlFieldName>CAS01CLM_ADJ_GRP</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS01CLM_ADJ_GRP"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="2"/>
</Property>
<Property name="CAS02CLMADJRSN1">
<Type>%String</Type>
<SqlColumnNumber>13</SqlColumnNumber>
<SqlFieldName>CAS02CLM_ADJ_RSN1</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS02CLM_ADJ_RSN1"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="5"/>
</Property>
<Property name="CAS03ADJAMT1">
<Type>%Numeric</Type>
<SqlColumnNumber>14</SqlColumnNumber>
<SqlFieldName>CAS03ADJ_AMT1</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS03ADJ_AMT1"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9999999999999999.99"/>
<Parameter name="MINVAL" value="-9999999999999999.99"/>
<Parameter name="SCALE" value="2"/>
</Property>
<Property name="CAS04ADJQTY1">
<Type>%Numeric</Type>
<SqlColumnNumber>15</SqlColumnNumber>
<SqlFieldName>CAS04ADJ_QTY1</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS04ADJ_QTY1"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="999999999999.999"/>
<Parameter name="MINVAL" value="-999999999999.999"/>
<Parameter name="SCALE" value="3"/>
</Property>
<Property name="CAS05CLMADJRSN2">
<Type>%String</Type>
<SqlColumnNumber>16</SqlColumnNumber>
<SqlFieldName>CAS05CLM_ADJ_RSN2</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS05CLM_ADJ_RSN2"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="5"/>
</Property>
<Property name="CAS06ADJAMT2">
<Type>%Numeric</Type>
<SqlColumnNumber>17</SqlColumnNumber>
<SqlFieldName>CAS06ADJ_AMT2</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS06ADJ_AMT2"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9999999999999999.99"/>
<Parameter name="MINVAL" value="-9999999999999999.99"/>
<Parameter name="SCALE" value="2"/>
</Property>
<Property name="CAS07ADJQTY2">
<Type>%Numeric</Type>
<SqlColumnNumber>18</SqlColumnNumber>
<SqlFieldName>CAS07ADJ_QTY2</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS07ADJ_QTY2"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="999999999999.999"/>
<Parameter name="MINVAL" value="-999999999999.999"/>
<Parameter name="SCALE" value="3"/>
</Property>
<Property name="CAS08CLMADJRSN3">
<Type>%String</Type>
<SqlColumnNumber>19</SqlColumnNumber>
<SqlFieldName>CAS08CLM_ADJ_RSN3</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS08CLM_ADJ_RSN3"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="5"/>
</Property>
<Property name="CAS09ADJAMT3">
<Type>%Numeric</Type>
<SqlColumnNumber>20</SqlColumnNumber>
<SqlFieldName>CAS09ADJ_AMT3</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS09ADJ_AMT3"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9999999999999999.99"/>
<Parameter name="MINVAL" value="-9999999999999999.99"/>
<Parameter name="SCALE" value="2"/>
</Property>
<Property name="CAS10ADJQTY3">
<Type>%Numeric</Type>
<SqlColumnNumber>21</SqlColumnNumber>
<SqlFieldName>CAS10ADJ_QTY3</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS10ADJ_QTY3"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="999999999999.999"/>
<Parameter name="MINVAL" value="-999999999999.999"/>
<Parameter name="SCALE" value="3"/>
</Property>
<Property name="CAS11CLMADJRSN4">
<Type>%String</Type>
<SqlColumnNumber>22</SqlColumnNumber>
<SqlFieldName>CAS11CLM_ADJ_RSN4</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS11CLM_ADJ_RSN4"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="5"/>
</Property>
<Property name="CAS12ADJAMT4">
<Type>%Numeric</Type>
<SqlColumnNumber>23</SqlColumnNumber>
<SqlFieldName>CAS12ADJ_AMT4</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS12ADJ_AMT4"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9999999999999999.99"/>
<Parameter name="MINVAL" value="-9999999999999999.99"/>
<Parameter name="SCALE" value="2"/>
</Property>
<Property name="CAS13ADJQTY4">
<Type>%Numeric</Type>
<SqlColumnNumber>24</SqlColumnNumber>
<SqlFieldName>CAS13ADJ_QTY4</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS13ADJ_QTY4"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="999999999999.999"/>
<Parameter name="MINVAL" value="-999999999999.999"/>
<Parameter name="SCALE" value="3"/>
</Property>
<Property name="CAS14CLMADJRSN5">
<Type>%String</Type>
<SqlColumnNumber>25</SqlColumnNumber>
<SqlFieldName>CAS14CLM_ADJ_RSN5</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS14CLM_ADJ_RSN5"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="5"/>
</Property>
<Property name="CAS15ADJAMT5">
<Type>%Numeric</Type>
<SqlColumnNumber>26</SqlColumnNumber>
<SqlFieldName>CAS15ADJ_AMT5</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS15ADJ_AMT5"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9999999999999999.99"/>
<Parameter name="MINVAL" value="-9999999999999999.99"/>
<Parameter name="SCALE" value="2"/>
</Property>
<Property name="CAS16ADJQTY5">
<Type>%Numeric</Type>
<SqlColumnNumber>27</SqlColumnNumber>
<SqlFieldName>CAS16ADJ_QTY5</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS16ADJ_QTY5"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="999999999999.999"/>
<Parameter name="MINVAL" value="-999999999999.999"/>
<Parameter name="SCALE" value="3"/>
</Property>
<Property name="CAS17CLMADJRSN6">
<Type>%String</Type>
<SqlColumnNumber>28</SqlColumnNumber>
<SqlFieldName>CAS17CLM_ADJ_RSN6</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS17CLM_ADJ_RSN6"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="5"/>
</Property>
<Property name="CAS18ADJAMT6">
<Type>%Numeric</Type>
<SqlColumnNumber>29</SqlColumnNumber>
<SqlFieldName>CAS18ADJ_AMT6</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS18ADJ_AMT6"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9999999999999999.99"/>
<Parameter name="MINVAL" value="-9999999999999999.99"/>
<Parameter name="SCALE" value="2"/>
</Property>
<Property name="CAS19ADJQTY6">
<Type>%Numeric</Type>
<SqlColumnNumber>30</SqlColumnNumber>
<SqlFieldName>CAS19ADJ_QTY6</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CAS19ADJ_QTY6"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="999999999999.999"/>
<Parameter name="MINVAL" value="-999999999999.999"/>
<Parameter name="SCALE" value="3"/>
</Property>
<Property name="CASESKEY">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>2</SqlColumnNumber>
<SqlFieldName>CASES_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CASES_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="CLAIMKEY">
<Type>%String</Type>
<SqlColumnNumber>3</SqlColumnNumber>
<SqlFieldName>CLAIM_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLAIM_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="CLAIMPYMTINFOKEY">
<Type>%String</Type>
<SqlColumnNumber>7</SqlColumnNumber>
<SqlFieldName>CLAIM_PYMT_INFO_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLAIM_PYMT_INFO_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="CREATEDBY">
<Type>%String</Type>
<SqlColumnNumber>31</SqlColumnNumber>
<SqlFieldName>CREATED_BY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CREATED_BY"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="20"/>
</Property>
<Property name="DATECREATED">
<Type>%Date</Type>
<SqlColumnNumber>32</SqlColumnNumber>
<SqlFieldName>DATE_CREATED</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="DATE_CREATED"/>
<Parameter name="EXTERNALSQLTYPE" value="91"/>
</Property>
<Property name="DATEMODIFIED">
<Type>%Date</Type>
<SqlColumnNumber>34</SqlColumnNumber>
<SqlFieldName>DATE_MODIFIED</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="DATE_MODIFIED"/>
<Parameter name="EXTERNALSQLTYPE" value="91"/>
</Property>
<Property name="DENTALSERVICEKEY">
<Type>%String</Type>
<SqlColumnNumber>6</SqlColumnNumber>
<SqlFieldName>DENTAL_SERVICE_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="DENTAL_SERVICE_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="INSTSERVICEKEY">
<Type>%String</Type>
<SqlColumnNumber>4</SqlColumnNumber>
<SqlFieldName>INST_SERVICE_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="INST_SERVICE_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="LOOPSEQNBR">
<Type>%Numeric</Type>
<Required>1</Required>
<SqlColumnNumber>10</SqlColumnNumber>
<SqlFieldName>LOOP_SEQ_NBR</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="LOOP_SEQ_NBR"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9223372036854775807"/>
<Parameter name="MINVAL" value="-9223372036854775808"/>
<Parameter name="SCALE" value="0"/>
</Property>
<Property name="MODIFIEDBY">
<Type>%String</Type>
<SqlColumnNumber>33</SqlColumnNumber>
<SqlFieldName>MODIFIED_BY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="MODIFIED_BY"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="20"/>
</Property>
<Property name="PRFSNSERVICEKEY">
<Type>%String</Type>
<SqlColumnNumber>5</SqlColumnNumber>
<SqlFieldName>PRFSN_SERVICE_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PRFSN_SERVICE_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="SEQNBR">
<Type>%Numeric</Type>
<Required>1</Required>
<SqlColumnNumber>11</SqlColumnNumber>
<SqlFieldName>SEQ_NBR</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SEQ_NBR"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9223372036854775807"/>
<Parameter name="MINVAL" value="-9223372036854775808"/>
<Parameter name="SCALE" value="0"/>
</Property>
<Property name="SUBSCRIBERINFOKEY">
<Type>%String</Type>
<SqlColumnNumber>35</SqlColumnNumber>
<SqlFieldName>SUBSCRIBER_INFO_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SUBSCRIBER_INFO_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="SVCPYMTINFOKEY">
<Type>%String</Type>
<SqlColumnNumber>8</SqlColumnNumber>
<SqlFieldName>SVC_PYMT_INFO_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SVC_PYMT_INFO_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="TXTYPE">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>9</SqlColumnNumber>
<SqlFieldName>TX_TYPE</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="TX_TYPE"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Index name="MainIndex">
<IdKey>1</IdKey>
<PrimaryKey>1</PrimaryKey>
<Properties>CASESKEY</Properties>
</Index>
<Storage name="GSQLStorage">
<Type>%CacheSQLStorage</Type>
<StreamLocation>^EREPOS.CASESS</StreamLocation>
</Storage>
<Storage name="Default">
<Type>%Library.CacheStorage</Type>
<DataLocation>^CREPOS.CASESD</DataLocation>
<DefaultData>CASESDefaultData</DefaultData>
<IdLocation>^CREPOS.CASESD</IdLocation>
<IndexLocation>^CREPOS.CASESI</IndexLocation>
<StreamLocation>^CREPOS.CASESS</StreamLocation>
<Data name="CASESDefaultData">
<Structure>listnode</Structure>
<Subscript/>
<Value name="1">
<Value>%%CLASSNAME</Value>
</Value>
<Value name="2">
<Value>CAS01CLMADJGRP</Value>
</Value>
<Value name="3">
<Value>CAS02CLMADJRSN1</Value>
</Value>
<Value name="4">
<Value>CAS03ADJAMT1</Value>
</Value>
<Value name="5">
<Value>CAS04ADJQTY1</Value>
</Value>
<Value name="6">
<Value>CAS05CLMADJRSN2</Value>
</Value>
<Value name="7">
<Value>CAS06ADJAMT2</Value>
</Value>
<Value name="8">
<Value>CAS07ADJQTY2</Value>
</Value>
<Value name="9">
<Value>CAS08CLMADJRSN3</Value>
</Value>
<Value name="10">
<Value>CAS09ADJAMT3</Value>
</Value>
<Value name="11">
<Value>CAS10ADJQTY3</Value>
</Value>
<Value name="12">
<Value>CAS11CLMADJRSN4</Value>
</Value>
<Value name="13">
<Value>CAS12ADJAMT4</Value>
</Value>
<Value name="14">
<Value>CAS13ADJQTY4</Value>
</Value>
<Value name="15">
<Value>CAS14CLMADJRSN5</Value>
</Value>
<Value name="16">
<Value>CAS15ADJAMT5</Value>
</Value>
<Value name="17">
<Value>CAS16ADJQTY5</Value>
</Value>
<Value name="18">
<Value>CAS17CLMADJRSN6</Value>
</Value>
<Value name="19">
<Value>CAS18ADJAMT6</Value>
</Value>
<Value name="20">
<Value>CAS19ADJQTY6</Value>
</Value>
<Value name="21">
<Value>CLAIMKEY</Value>
</Value>
<Value name="22">
<Value>CLAIMPYMTINFOKEY</Value>
</Value>
<Value name="23">
<Value>CREATEDBY</Value>
</Value>
<Value name="24">
<Value>DATECREATED</Value>
</Value>
<Value name="25">
<Value>DATEMODIFIED</Value>
</Value>
<Value name="26">
<Value>DENTALSERVICEKEY</Value>
</Value>
<Value name="27">
<Value>INSTSERVICEKEY</Value>
</Value>
<Value name="28">
<Value>LOOPSEQNBR</Value>
</Value>
<Value name="29">
<Value>MODIFIEDBY</Value>
</Value>
<Value name="30">
<Value>PRFSNSERVICEKEY</Value>
</Value>
<Value name="31">
<Value>SEQNBR</Value>
</Value>
<Value name="32">
<Value>SUBSCRIBERINFOKEY</Value>
</Value>
<Value name="33">
<Value>SVCPYMTINFOKEY</Value>
</Value>
<Value name="34">
<Value>TXTYPE</Value>
</Value>
</Data>
</Storage>
</Class>
</Export>