# CTI_ParseTransactionQuery()

This subprocedure is used to parse a previously downloaded transaction query response. This subprocedure requires that you provide the fully-qualified filepath of the downloaded query response file in the IFS. If this query was performed using [CTI_QueryTransaction()](https://isupport.katointegrations.com/cti/cti_querytransaction.md), the report file will be found in the default download directory specified in your [CTICFGMCH](https://isupport.katointegrations.com/cti/configuration.md) record.

Parsed data will be written to the output tables described below. This data can then be retrieved from the tables and stored in a more permanent manner; the output tables should be treated as temporary, transactional tables and not used for long-term storage.

If an error occurs, this subprocedure will return *OFF, and information about the error will be present in the pErrorDS parameter which contains a CTI_ErrorDS_t data structure.

## Subprocedure Prototype

| Field | Description |
|---|---|
| `     D CTI_ParseTransactionQuery...      D                 PR              N   Extproc('CTI_ParseTransactionQuery')` | Returns *OFF if an error occurs during processing, *ON otherwise. |
| `     D  pUniqueId                          Const Like(CTI_UniqueId_t)` | Unique ID, generated with CTI_NextUniqueID(), that will be used to identify the parsed records from this file **Required** |
| `     D  pQueryFile                         Const Like(CTI_FilePath_t)` | The fully-qualified filepath of the file in the IFS that will be parsed. If this query was performed using CTI_QueryTransaction(), the file will be in the default download directory specified in your CTICFGMCH record |
| `     D  pErrorDS                           LikeDS(CTI_ErrorDS_t)` | Error data structure used to capture subprocedure and CyberSource errors **Required** |


## Data Structures

### CTI_ErrorDS_t

| Field | Description |
|---|---|
| `     D CTI_ErrorDS_t   DS                  Qualified Template Inz` |  |
| `     D  Subproc                     132A   Varying` | Name of subprocedure returning error |
| `     D  MessageId                     7A` | Message ID of error message |
| `     D  Message                    1024A   Varying` | Error message text |
| `     D  Source                       10A` | Error message source |
| `     D  LogFile                            Like(CTI_FilePath_t)` | IFS filepath of generated log file |


## Output Table Files

### CTIQTD

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `UID` | `UID` | `DECIMAL(15:0)` | Query Unique ID |  |
| `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID |  |
| `REQUESTID` | `REQUESTID` | `VARCHAR(26)` | Payment Request ID |  |
| `RECONID` | `RECONCILIATIONID` | `VARCHAR(60)` | Transaction Reconciliation ID |  |
| `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID |  |
| `TRANSTS` | `TRANSACTIONSTATUS` | `VARCHAR(30)` | Transaction Status |  |
| `SUBMITTS` | `SUBMITTIMESTAMP` | `TIMESTAMP` | Submission Timestamp |  |
| `APPINFSTS` | `APPSSTATUS` | `VARCHAR(30)` | Application Status |  |
| `APPINFRNCD` | `APPSREASONCODE` | `VARCHAR(5)` | Application Reason Code |  |
| `APPINFRCD` | `APPSRCODE` | `VARCHAR(15)` | Application RCode |  |
| `APPINFRFLG` | `APPSRFLAG` | `VARCHAR(50)` | Application RFlag |  |
| `MCHCSTID` | `MERCHANTCUSTOMERID` | `VARCHAR(100)` | Merchant Customer ID |  |
| `HASHPASSWD` | `HASHEDPASSWORD` | `VARCHAR(100)` | Buyer Hashed Password |  |
| `CLTCD` | `CLIENTREFERENCECODE` | `VARCHAR(50)` | Client Reference Code |  |
| `CLTAPPVER` | `CLIENTAPPVERSION` | `VARCHAR(50)` | Application Version |  |
| `CLTAPPNAME` | `CLIENTAPPNAME` | `VARCHAR(50)` | Application Name |  |
| `CLTAPPUSR` | `CLIENTAPPUSER` | `VARCHAR(30)` | Application User |  |
| `CLTAPPCOMM` | `CLIENTAPPCOMMENTS` | `VARCHAR(255)` | Comments |  |
| `CATHECIRAW` | `CONSUMERAUTHECIRAW` | `VARCHAR(2)` | Consumer ECI Raw |  |
| `CATHCAVV` | `CONSUMERAUTHCVV` | `VARCHAR(40)` | Consumer CVV |  |
| `CATHXID` | `CONSUMERXID` | `VARCHAR(40)` | Consumer XID |  |
| `CATHTRNSID` | `CONSUMERTRANSID` | `VARCHAR(60)` | Consumer Transaction ID |  |
| `DVCIPADDR` | `DEVICEIPADDRESS` | `VARCHAR(15)` | Customer Device IP Address |  |
| `DVCHSTNAME` | `DEVICEHOSTNAME` | `VARCHAR(60)` | Customer Device Host Name |  |
| `DVCCKSACP` | `DEVICECOOKIESACCEPTED` | `VARCHAR(5)` | Consumer Device Cookies Accepted |  |
| `ERRINFRSN` | `ERRORINFOREASON` | `VARCHAR(50)` | Error Information Reason |  |
| `ERRINFMSG` | `ERRORINFOMESSAGE` | `VARCHAR(255)` | Error Information Message |  |
| `NBRINSTLMT` | `NUMBEROFINSTALLMENTS` | `VARCHAR(3)` | Number of Installments |  |
| `FRDMRKRSN` | `FRAUDMARKREASON` | `VARCHAR(100)` | Fraud Marking Reason |  |
| `MCHDESCNAM` | `MERCHANTDESCRIPTORNAME` | `VARCHAR(23)` | Merchant Descriptor Name |  |
| `BTFNAME` | `BILLTOFIRSTNAME` | `VARCHAR(60)` | Bill To Customer First Name |  |
| `BTLNAME` | `BILLTOLASTNAME` | `VARCHAR(60)` | Bill To Customer Last Name |  |
| `BTMNAME` | `BILLTOMIDDLENAME` | `VARCHAR(60)` | Bill To Customer Middle Name |  |
| `BTSUFFIX` | `BILLTONAMESUFFIX` | `VARCHAR(60)` | Bill To Customer Name Suffix |  |
| `BTADDR1` | `BILLTOADDRESS1` | `VARCHAR(60)` | Bill To Address Line 1 |  |
| `BTADDR2` | `BILLTOADDRESS2` | `VARCHAR(60)` | Bill To Address Line 2 |  |
| `BTCITY` | `BILLTOCITY` | `VARCHAR(50)` | Bill To City |  |
| `BTSTATE` | `BILLTOSTATE` | `VARCHAR(2)` | Bill To State |  |
| `BTZIP` | `BILLTOZIP` | `VARCHAR(10)` | Bill To Zip |  |
| `BTCMPNAME` | `BILLTOCOMPANYNAME` | `VARCHAR(60)` | Bill To Company Name |  |
| `BTCMPADDR1` | `BILLTOCOMPANYADDR1` | `VARCHAR(40)` | Bill To Company Address Line 1 |  |
| `BTCMPADDR2` | `BILLTOCOMPANYADDR2` | `VARCHAR(40)` | Bill To Company Address Line 2 |  |
| `BTCMPCITY` | `BILLTOCOMPANYCITY` | `VARCHAR(30)` | Bill To Company City |  |
| `BTCMPSTATE` | `BILLTOCOMPANYSTATE` | `VARCHAR(2)` | Bill To Company State |  |
| `BTCMPZIP` | `BILLTOCOMPANYZIP` | `VARCHAR(10)` | Bill To Company Zip |  |
| `BTCMPCNTRY` | `BILLTOCOMPANYCOUNTRY` | `VARCHAR(2)` | Bill To Company Country |  |
| `BTEMAIL` | `BILLTOEMAIL` | `VARCHAR(255)` | Bill To Email Address |  |
| `BTCNTRY` | `BILLTOCOUNTRY` | `VARCHAR(2)` | Bill To Country |  |
| `BTCSTITLE` | `BILLTOTITLE` | `VARCHAR(60)` | Bill To Customer Title |  |
| `BTPHONE` | `BILLTOPHONE` | `VARCHAR(15)` | Bill To Phone Number |  |
| `STFNAME` | `SHIPTOFIRSTNAME` | `VARCHAR(60)` | Ship To Customer First Name |  |
| `STLNAME` | `SHIPTOLASTNAME` | `VARCHAR(60)` | Ship To Customer Last Name |  |
| `STADDR1` | `SHIPTOADDRESS1` | `VARCHAR(60)` | Ship To Address Line 1 |  |
| `STADDR2` | `SHIPTOADDRESS2` | `VARCHAR(60)` | Ship To Address Line 2 |  |
| `STCITY` | `SHIPTOCITY` | `VARCHAR(50)` | Ship To City |  |
| `STSTATE` | `SHIPTOSTATE` | `VARCHAR(2)` | Ship To State |  |
| `STZIP` | `SHIPTOZIP` | `VARCHAR(10)` | Ship To Zip |  |
| `STCMPNAME` | `SHIPTOCOMPANYNAME` | `VARCHAR(60)` | Ship To Company Name |  |
| `STCNTRY` | `SHIPTOCOUNTRY` | `VARCHAR(2)` | Ship To Country |  |
| `STPHONE` | `SHIPTOPHONE` | `VARCHAR(15)` | Ship To Phone Number |  |
| `AMTTOT` | `TOTALAMOUNT` | `VARCHAR(19)` | Total Amount |  |
| `AMTCUR` | `AMOUNTCURRENCY` | `VARCHAR(3)` | Amount Currency |  |
| `AMTTAX` | `TAXAMOUNT` | `VARCHAR(12)` | Tax Amount |  |
| `AMTATH` | `AUTHORIZEDAMOUNT` | `VARCHAR(15)` | Authorized Amount |  |
| `AMTSETTLE` | `SETTLEMENTAMOUNT` | `VARCHAR(12)` | Settlement Amount |  |
| `AMTSETLCUR` | `SETTLEMENTAMOUNTCURRENCY` | `VARCHAR(3)` | Settlement Amount Currency |  |
| `GIFTWRAP` | `GIFTWRAP` | `VARCHAR(1)` | Gift Wrapping |  |
| `SHIPMTH` | `SHIPPINGMETHOD` | `VARCHAR(10)` | Shipping Method |  |
| `PAYTYPNAME` | `PAYMENTTYPENAME` | `VARCHAR(50)` | Payment Type Name |  |
| `PAYTYP` | `PAYMENTTYPE` | `VARCHAR(20)` | Payment Type |  |
| `PAYTYPMTH` | `PAYMENTTYPEMETHOD` | `VARCHAR(50)` | Payment Type Method |  |
| `FUNDSRC` | `PAYMENTTYPEFUNDSOURCE` | `VARCHAR(50)` | Payment Type Funding Source |  |
| `FUNDSRCAFL` | `PAYMENTTYPEFUNDAFFILIATION` | `VARCHAR(50)` | Payment Type Funding Source Affiliation |  |
| `PAYTYPCRED` | `PAYMENTTYPECREDENTIAL` | `VARCHAR(50)` | Payment Type Credential |  |
| `PAYCSTID` | `PAYMENTCUSTOMERID` | `VARCHAR(26)` | Payment Customer ID |  |
| `CRDSUFFIX` | `CARDSUFFIX` | `VARCHAR(4)` | Card Suffix |  |
| `CRDPREFIX` | `CARDPREFIX` | `VARCHAR(6)` | Card Prefix |  |
| `CRDEXPMON` | `CARDEXPIRATIONMONTH` | `VARCHAR(2)` | Card Expiration Month |  |
| `CRDEXPYR` | `CARDEXPIRATIONYEAR` | `VARCHAR(4)` | Card Expiration Year |  |
| `CRDSTRMON` | `CARDSTARTMONTH` | `VARCHAR(2)` | Card Start Month |  |
| `CRDSTRYR` | `CARDSTARTYEAR` | `VARCHAR(4)` | Card Start Year |  |
| `CRDISSNBR` | `CARDISSUENUMBER` | `VARCHAR(5)` | Card Issue Number |  |
| `CRDTYP` | `CARDTYPE` | `VARCHAR(3)` | Card Type |  |
| `CRDENCID` | `CARDACCOUNTENCODERID` | `VARCHAR(3)` | Card Account Encoder ID |  |
| `CRDUSEAS` | `CRDUSEAS` | `VARCHAR(20)` | Card Use-As |  |
| `INVNBR` | `INVOICENUMBER` | `VARCHAR(50)` | Invoice Number |  |
| `INVBARCD` | `INVOICEBARCODENUMBER` | `VARCHAR(50)` | Invoice Barcode Number |  |
| `INVEXPDT` | `INVOICEEXPIRATIONDATE` | `VARCHAR(50)` | Invoice Expiration Date |  |
| `BKRTNBR` | `BANKROUTINGNUMBER` | `VARCHAR(9)` | Bank Routing Number |  |
| `BKBRANCHCD` | `BANKBRANCHCODE` | `VARCHAR(50)` | Branch Code |  |
| `BKSWIFTCD` | `BANKSWIFTCODE` | `VARCHAR(50)` | Bank Swift Code |  |
| `BKBANKCD` | `BANKCODE` | `VARCHAR(50)` | Bank Code |  |
| `BKIBAN` | `BANKIBAN` | `VARCHAR(50)` | Bank IBAN |  |
| `BKACTSFFIX` | `BANKACCOUNTSUFFIX` | `VARCHAR(50)` | Bank Account Suffix |  |
| `BKACTPRFIX` | `BANKACCOUNTPREFIX` | `VARCHAR(50)` | Bank Account Prefix |  |
| `BKCHKNBR` | `BANKCHECKNUMBER` | `VARCHAR(8)` | Bank Check Number |  |
| `BKACTTYP` | `BANKACCOUNTTYPE` | `VARCHAR(1)` | Bank Account Type |  |
| `BKACTNAME` | `BANKACCOUNTNAME` | `VARCHAR(60)` | Bank Account Name |  |
| `BKACTCHKDG` | `BANKACCOUNTCHECKDIGIT` | `VARCHAR(50)` | Bank Account Check Digit |  |
| `BKACTENCID` | `BANKACCOUNTENCODERID` | `VARCHAR(3)` | Bank Account Encoder ID |  |
| `BKMDREFNBR` | `BANKMANDATEREFERENCENUMBER` | `VARCHAR(50)` | Bank Mandate Reference Number |  |
| `BKMDRCRTYP` | `BANKMANDATERECURRINGTYPE` | `VARCHAR(50)` | Bank Mandate Recurring Type |  |
| `BKMDID` | `BANKMANDATEID` | `VARCHAR(50)` | Bank Mandate ID |  |
| `ACTBALAMT` | `ACCOUNTBALANCEAMOUNT` | `VARCHAR(12)` | Account Balance |  |
| `ACTPRVBAL` | `ACCOUNTPREVIOUSBALANCE` | `VARCHAR(12)` | Account Previous Balance |  |
| `ACTCUR` | `ACCOUNTCURRENCY` | `VARCHAR(5)` | Account Currency |  |
| `PMTSOLN` | `PAYMENTSOLUTION` | `VARCHAR(12)` | Payment Solution |  |
| `PMTCMCIND` | `PROCESSINGCOMMERCEINDICATOR` | `VARCHAR(20)` | Processing Commerce Indicator |  |
| `PMTBSAPPID` | `PROCESSINGAPPLICATIONID` | `VARCHAR(50)` | Processing Application ID |  |
| `ATHTYP` | `AUTHORIZATIONTYPE` | `VARCHAR(15)` | Authorization Type |  |
| `BKTRNSECCD` | `BANKTRANSFERSECCODE` | `VARCHAR(50)` | Bank Transfer Sec Code |  |
| `PRCNAME` | `PROCESSORNAME` | `VARCHAR(30)` | Processor Name |  |
| `PRCTRANID` | `PROCESSORTRANSACTIONID` | `VARCHAR(50)` | Processor Transaction ID |  |
| `PRCNTTRNID` | `PROCESSORNETWORKTRANSACTIONID` | `VARCHAR(50)` | Processor Network Transaction ID |  |
| `PRCRSPID` | `PROCESSORRESPONSEID` | `VARCHAR(50)` | Processor Response ID |  |
| `PRCPVTRNID` | `PROVIDERTRANSACTIONID` | `VARCHAR(50)` | Processor Provider Transaction ID |  |
| `PRCAPRCD` | `PROCESSORAPPROVALCODE` | `VARCHAR(50)` | Processor Approval Code |  |
| `PRCRSPCD` | `PROCESSORRESPONSECODE` | `VARCHAR(10)` | Processor Response Code |  |
| `PRCAVSCD` | `AVSCODE` | `VARCHAR(1)` | AVS Code |  |
| `PRCAVSCDRW` | `AVSCODERAW` | `VARCHAR(10)` | AVS Code Raw |  |
| `PRCCVRSTCD` | `CARDVERIFICATIONRESULTCODE` | `VARCHAR(1)` | CVN Result Code |  |
| `PRCACHRSCD` | `ACHVERIFICATIONRESULTCODE` | `VARCHAR(2)` | ACH Verification Result Code |  |
| `PRCACHCDRW` | `ACHVERIFICATIONCODERAW` | `VARCHAR(10)` | ACH Verification Result Code Raw |  |
| `EVEMAIL` | `EVEMAILRESULT` | `VARCHAR(1)` | EV Email Result |  |
| `EVEMAILRAW` | `EVEMAILRESULTRAW` | `VARCHAR(1)` | EV Email Result Raw |  |
| `EVNAME` | `EVNAMERESULT` | `VARCHAR(30)` | EV Name Result |  |
| `EVNAMERAW` | `EVNAMERESULTRAW` | `VARCHAR(30)` | EV Name Result Raw |  |
| `EVPHONE` | `EVPHONERESULT` | `VARCHAR(1)` | EV Phone Result |  |
| `EVPHONERAW` | `EVPHONERESULTRAW` | `VARCHAR(1)` | EV Phone Result Raw |  |
| `EVSTREET` | `EVSTREETRESULT` | `VARCHAR(1)` | EV Street Result |  |
| `EVSTREETRW` | `EVSTREETRESULTRAW` | `VARCHAR(1)` | EV Street Result Raw |  |
| `EVZIP` | `EVZIPRESULT` | `VARCHAR(1)` | EV Zip Result |  |
| `EVZIPRAW` | `EVZIPRESULTRAW` | `VARCHAR(1)` | EV Zip Result Raw |  |
| `SYSTRADNBR` | `SYSTEMTRACEAUDITNUMBER` | `VARCHAR(6)` | System Trace Audit Number |  |
| `RSPCDSRC` | `RESPONSECODESOURCE` | `VARCHAR(1)` | Response Code Source |  |
| `POSENTRYMD` | `POSENTRYMODE` | `VARCHAR(11)` | POS Entry Mode |  |
| `POSTERMCAP` | `POSTERMINALCAPABILITY` | `VARCHAR(1)` | POS Termianl Capability |  |
| `PRFNAME` | `PROFILENAME` | `VARCHAR(50)` | Profile Name |  |
| `PRFDCSN` | `PROFILEDECISION` | `VARCHAR(255)` | Decision Returned by the Profile |  |
| `PASPRFNAME` | `PASSIVEPROFILENAME` | `VARCHAR(50)` | Passive Profile Name |  |
| `PASPRFDSCN` | `PASSIVEPROFILEDECISION` | `VARCHAR(255)` | Passive Profile Decision |  |
| `FACTORCDS` | `SCOREFACTORCODES` | `VARCHAR(100)` | Score Factor Codes |  |
| `SCORERSLT` | `SCORERESULT` | `VARCHAR(50)` | Score Result |  |
| `RISKLOCTS` | `RISKLOCALTIME` | `CHAR(30)` | Risk Information Local Time |  |
| `SNDREFNBR` | `SENDERREFERENCENUMBER` | `VARCHAR(19)` | Sender Reference Number |  |


### CTIQTDAPP

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id |  |
| `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID |  |
| `UID` | `UID` | `DECIMAL(15:0)` | Application Unique ID |  |
| `APPNAME` | `APPLICATIONNAME` | `VARCHAR(30)` | Application Name |  |
| `APPSTS` | `APPLICATIONSTATUS` | `VARCHAR(30)` | Application Status |  |
| `APPRSNCD` | `APPLICATIONREASONCODE` | `VARCHAR(5)` | Application Reason Code |  |
| `APPRCD` | `APPLICATIONRCODE` | `VARCHAR(15)` | Application RCode |  |
| `APPRFLAG` | `APPLICATIONRFLAG` | `VARCHAR(50)` | Application RFlag |  |
| `APPRECONID` | `APPLICATIONRECONCILIATIONID` | `VARCHAR(60)` | Application Reconciliation ID |  |
| `APPRMSG` | `APPLICATIONRMESSAGE` | `VARCHAR(255)` | Application rMessage |  |
| `APPRTNCD` | `APPLICATIONRETURNCODE` | `VARCHAR(50)` | Application Return Code |  |


### CTIQTDERR

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id |  |
| `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID |  |
| `UID` | `UID` | `DECIMAL(15:0)` | Error Unique ID |  |
| `ERRFIELD` | `ERRORFIELD` | `VARCHAR(1024)` | JSON Field in Error |  |
| `ERRREASON` | `ERRORREASON` | `VARCHAR(15)` | Error Reason |  |


### CTIQTDLIN

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id |  |
| `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID |  |
| `UID` | `UID` | `DECIMAL(15:0)` | Line Item Unique ID |  |
| `PRODUCTCD` | `PRODUCTCODE` | `VARCHAR(255)` | Product Code |  |
| `PRODUCTNAM` | `PRODUCTNAME` | `VARCHAR(255)` | Product Name |  |
| `PRODUCTSKU` | `PRODUCTSKU` | `VARCHAR(255)` | Product SKU |  |
| `TAXAMT` | `TAXAMOUNT` | `VARCHAR(15)` | Tax Amount |  |
| `QUANTITY` | `QUANTITY` | `VARCHAR(15)` | Quantity of Product |  |
| `UNITPRICE` | `UNITPRICE` | `VARCHAR(15)` | Unit Price |  |
| `FULFILTYP` | `FULFILLMENTTYPE` | `VARCHAR(2)` | Fulfillment Type |  |


### CTIQTDMDI

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id |  |
| `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID |  |
| `UID` | `UID` | `DECIMAL(15:0)` | Merchant-Defined Unique ID |  |
| `MDIKEY` | `MERCHDEFINEDINFOKEY` | `VARCHAR(50)` | Merchant-Defined Information Key |  |
| `MDIVALUE` | `MERCHDEFINEDINFOVALUE` | `VARCHAR(255)` | Merchant-Defined Information Value |  |


### CTIQTDPAS

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id |  |
| `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID |  |
| `UID` | `UID` | `DECIMAL(15:0)` | Passive Rule Unique ID |  |
| `PASRULNAME` | `PASSIVERULENAME` | `VARCHAR(50)` | Passive Rule Name |  |
| `PASRULDSCN` | `PASSIVERULEDECISION` | `VARCHAR(255)` | Passive Rule Decision |  |


### CTIQTDRUL

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id |  |
| `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID |  |
| `UID` | `UID` | `DECIMAL(15:0)` | Rule Unique ID |  |
| `RULNAME` | `RULENAME` | `VARCHAR(50)` | Rule Name |  |
| `RULDSCN` | `RULEDECISION` | `VARCHAR(255)` | Rule Decision |  |