Source code for q2_cores.Corelation.queries.mock_responses

from ... import data_helpers


[docs] def alert_details_response(): return """<?xml version="1.0"?> <query type="c" xmlns="http://www.corelationinc.com/queryLanguage/v1.0" sessionId="943430A3E5A9212538FBF07C29807586"> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>5</targetSerial> <rowDescription>Tester,John D Card Limit Change for 00002545725001 Rewards Visa</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>5</serial> <accessKey>AE:5/</accessKey> <rowDescription>Tester,John D Card Limit Change for 00002545725001 Rewards Visa</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_5</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>3</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>5</parentSerial> <accessKey>AE:5/C:3/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_5"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>5</targetSerial> <targetSerialResult>5</targetSerialResult> <targetAccessKeyResult>AE:5/</targetAccessKeyResult> <rowDescription>Tester,John D Card Limit Change for 00002545725001 Rewards Visa</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>5</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:5/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>58578</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>2</newContents> <newContentsDescription>Card Limit Change</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> <newContents>45313</newContents> <newContentsDescription>00002545725001 Rewards Visa</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_5/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-09</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>3</targetSerial> <targetSerialResult>3</targetSerialResult> <targetAccessKeyResult>AE:5/C:3/</targetAccessKeyResult> <targetParentSerialResult>5</targetParentSerialResult> <rowDescription>Tester,John D Card Limit Change for 00002545725001 Rewards Visa Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>3</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>5</newContents> <newContentsDescription>Tester,John D Card Limit Change for 00002545725001 Rewards Visa</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:5/C:3/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>3</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>57824</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-09</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>502</targetSerial> <rowDescription>Tester,John D Card Purchase Posted for 00002545725001 Rewards Visa</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>5</serial> <accessKey>AE:5/</accessKey> <rowDescription>Tester,John D Card Purchase Posted for 00002545725001 Rewards Visa</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_5</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>3</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>5</parentSerial> <accessKey>AE:5/C:3/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_502"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>502</targetSerial> <targetSerialResult>502</targetSerialResult> <targetAccessKeyResult>AE:5/</targetAccessKeyResult> <rowDescription>Tester,John D Card Purchase Posted for 00002545725001 Rewards Visa</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>5</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:5/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>58578</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>735</newContents> <newContentsDescription>Card Purchase Posted</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> <newContents>45313</newContents> <newContentsDescription>00002545725001 Rewards Visa</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> <newContents>50.00</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> <newContents>100.00</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_502/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-09</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>204</targetSerial> <targetSerialResult>204</targetSerialResult> <targetAccessKeyResult>AE:5/C:3/</targetAccessKeyResult> <targetParentSerialResult>5</targetParentSerialResult> <rowDescription>Tester,John D Card Purchase Posted for 00002545725001 Rewards Visa Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>3</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>502</newContents> <newContentsDescription>Tester,John D Card Purchase Posted for 00002545725001 Rewards Visa</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:5/C:3/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>3</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>57824</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_734/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-09</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>55</targetSerial> <rowDescription>Tester,John D Card Limit Expiration Due for 00002545725001 Rewards Visa</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>5</serial> <accessKey>AE:5/</accessKey> <rowDescription>Tester,John D Card Limit Expiration Due for 00002545725001 Rewards Visa</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_5</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>3</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>5</parentSerial> <accessKey>AE:5/C:3/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_55"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>55</targetSerial> <targetSerialResult>55</targetSerialResult> <targetAccessKeyResult>AE:5/</targetAccessKeyResult> <rowDescription>Tester,John D Card Limit Expiration Due for 00002545725001 Rewards Visa</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>5</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:5/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>58578</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>215</newContents> <newContentsDescription>Card Limit Expiration Due</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> <newContents>45313</newContents> <newContentsDescription>00002545725001 Rewards Visa</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> <newContents>1</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_55/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-09</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>204</targetSerial> <targetSerialResult>204</targetSerialResult> <targetAccessKeyResult>AE:5/C:3/</targetAccessKeyResult> <targetParentSerialResult>5</targetParentSerialResult> <rowDescription>Tester,John D Card Limit Expiration Due for 00002545725001 Rewards Visa Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>3</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>55</newContents> <newContentsDescription>Tester,John D Card Limit Expiration Due for 00002545725001 Rewards Visa</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:5/C:3/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>3</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>57824</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_214/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-09</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>6</targetSerial> <rowDescription>Tester,John D Login Locked for Internet Banking Without Passwords JDTester</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>6</serial> <accessKey>AE:6/</accessKey> <rowDescription>Tester,John D Login Locked for Internet Banking Without Passwords JDTester</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_6</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>4</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>6</parentSerial> <accessKey>AE:6/C:4/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_6"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>6</targetSerial> <targetSerialResult>6</targetSerialResult> <targetAccessKeyResult>AE:6/</targetAccessKeyResult> <rowDescription>Tester,John D Login Locked for Internet Banking Without Passwords JDTester</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>6</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:6/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>58578</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>3</newContents> <newContentsDescription>Login Locked</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> <newContents>48845</newContents> <newContentsDescription>Internet Banking Without Passwords JDTester</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_6/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-21</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>4</targetSerial> <targetSerialResult>4</targetSerialResult> <targetAccessKeyResult>AE:6/C:4/</targetAccessKeyResult> <targetParentSerialResult>6</targetParentSerialResult> <rowDescription>Tester,John D Login Locked for Internet Banking Without Passwords JDTester Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>4</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>6</newContents> <newContentsDescription>Tester,John D Login Locked for Internet Banking Without Passwords JDTester</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:6/C:4/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>4</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>57824</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_4/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-21</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>16</targetSerial> <rowDescription>Tester,John D Deposit Posted for 00002545720000 Savings</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>16</serial> <accessKey>AE:16/</accessKey> <rowDescription>Tester,John D Deposit Posted for 00002545720000 Savings</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_16</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>15</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>16</parentSerial> <accessKey>AE:16/C:15/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_16"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>16</targetSerial> <targetSerialResult>16</targetSerialResult> <targetAccessKeyResult>AE:16/</targetAccessKeyResult> <rowDescription>Tester,John D Deposit Posted for 00002545720000 Savings</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>16</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:16/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>2</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>5</newContents> <newContentsDescription>Deposit Posted</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> <newContents>60228</newContents> <newContentsDescription>00002545720000 Savings</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> <newContents>300.00</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_16/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-01-29</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>15</targetSerial> <targetSerialResult>15</targetSerialResult> <targetAccessKeyResult>AE:16/C:15/</targetAccessKeyResult> <targetParentSerialResult>16</targetParentSerialResult> <rowDescription>Tester,John D Deposit Posted for 00002545720000 Savings Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>15</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>16</newContents> <newContentsDescription>Tester,John D Deposit Posted for 00002545720000 Savings</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:16/C:15/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>15</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>55408</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_15/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-01-29</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>19</targetSerial> <rowDescription>Tester,John D Loan Balance Over Amount for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>19</serial> <accessKey>AE:19/</accessKey> <rowDescription>Tester,John D Loan Balance Over Amount for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_19</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>18</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>19</parentSerial> <accessKey>AE:19/C:18/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_19"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>19</targetSerial> <targetSerialResult>19</targetSerialResult> <targetAccessKeyResult>AE:19/</targetAccessKeyResult> <rowDescription>Tester,John D Loan Balance Over Amount for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>19</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:19/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>2</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>8</newContents> <newContentsDescription>Loan Balance Over Amount</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> <newContents>800</newContents> <newContentsDescription>00002545720020 RB Unsecured Fixed 48mo bw</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> <newContents>15.00</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_19/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-01-29</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>18</targetSerial> <targetSerialResult>18</targetSerialResult> <targetAccessKeyResult>AE:19/C:18/</targetAccessKeyResult> <targetParentSerialResult>19</targetParentSerialResult> <rowDescription>Tester,John D Loan Balance Over Amount for 00002545720020 RB Unsecured Fixed 48mo bw Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>18</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>19</newContents> <newContentsDescription>Tester,John D Loan Balance Over Amount for 00002545720020 RB Unsecured Fixed 48mo bw</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:19/C:18/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>18</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>55408</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_18/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-01-29</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>20</targetSerial> <rowDescription>Tester,John D Payment Posted for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>20</serial> <accessKey>AE:20/</accessKey> <rowDescription>Tester,John D Payment Posted for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_20</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>19</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>20</parentSerial> <accessKey>AE:20/C:19/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_20"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>20</targetSerial> <targetSerialResult>20</targetSerialResult> <targetAccessKeyResult>AE:20/</targetAccessKeyResult> <rowDescription>Tester,John D Payment Posted for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>20</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:20/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>2</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>7</newContents> <newContentsDescription>Payment Posted</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> <newContents>800</newContents> <newContentsDescription>00002545720020 RB Unsecured Fixed 48mo bw</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> <newContents>16.00</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> <newContents>500.00</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_20/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-01-29</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>19</targetSerial> <targetSerialResult>19</targetSerialResult> <targetAccessKeyResult>AE:20/C:19/</targetAccessKeyResult> <targetParentSerialResult>20</targetParentSerialResult> <rowDescription>Tester,John D Payment Posted for 00002545720020 RB Unsecured Fixed 48mo bw Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>19</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>20</newContents> <newContentsDescription>Tester,John D Payment Posted for 00002545720020 RB Unsecured Fixed 48mo bw</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:20/C:19/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>19</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>55408</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_19/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-01-29</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>401</targetSerial> <rowDescription>Tester,John D Loan payment pending for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>401</serial> <accessKey>AE:401/</accessKey> <rowDescription>Tester,John D Loan payment pending for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_401</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>399</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>401</parentSerial> <accessKey>AE:401/C:399/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_401"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>401</targetSerial> <targetSerialResult>401</targetSerialResult> <targetAccessKeyResult>AE:401/</targetAccessKeyResult> <rowDescription>Tester,John D Loan payment pending for 00002545720020 RB Unsecured Fixed 48mo bw</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>401</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:401/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>2</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>213</newContents> <newContentsDescription>Loan payment pending</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> <newContents>800</newContents> <newContentsDescription>00002545720020 RB Unsecured Fixed 48mo bw</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> <newContents>5</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_401/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-18</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>399</targetSerial> <targetSerialResult>399</targetSerialResult> <targetAccessKeyResult>AE:401/C:399/</targetAccessKeyResult> <targetParentSerialResult>401</targetParentSerialResult> <rowDescription>Tester,John D Loan payment pending for 00002545720020 RB Unsecured Fixed 48mo bw Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>399</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>401</newContents> <newContentsDescription>Tester,John D Loan payment pending for 00002545720020 RB Unsecured Fixed 48mo bw</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:401/C:399/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>399</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>55408</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_399/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-18</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>437</targetSerial> <rowDescription>Tester,John D Returned item fee for 00002545720021 2012 Nissan Altima 66mo bw</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>437</serial> <accessKey>AE:437/</accessKey> <rowDescription>Tester,John D Returned item fee for 00002545720021 2012 Nissan Altima 66mo bw</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_437</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>435</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>437</parentSerial> <accessKey>AE:437/C:435/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_437"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>437</targetSerial> <targetSerialResult>437</targetSerialResult> <targetAccessKeyResult>AE:437/</targetAccessKeyResult> <rowDescription>Tester,John D Returned item fee for 00002545720021 2012 Nissan Altima 66mo bw</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>437</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:437/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>2</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>199</newContents> <newContentsDescription>Returned item fee</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> <newContents>54897</newContents> <newContentsDescription>00002545720021 2012 Nissan Altima 66mo bw</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_437/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-18</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>435</targetSerial> <targetSerialResult>435</targetSerialResult> <targetAccessKeyResult>AE:437/C:435/</targetAccessKeyResult> <targetParentSerialResult>437</targetParentSerialResult> <rowDescription>Tester,John D Returned item fee for 00002545720021 2012 Nissan Altima 66mo bw Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>435</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>437</newContents> <newContentsDescription>Tester,John D Returned item fee for 00002545720021 2012 Nissan Altima 66mo bw</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:437/C:435/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>435</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>55408</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_435/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-18</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-07-27 13:02:02 PDT</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>3314</targetSerial> <rowDescription>Tester,John D Overdraft Transfer for 00000010200004 Primary Savings Account</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>3314</serial> <accessKey>AE:3314/</accessKey> <rowDescription>Tester,John D Overdraft Transfer for 00000010200004 Primary Savings Account</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_3314</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>3314</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>3314</parentSerial> <accessKey>AE:3314/C:3314/</accessKey> <rowDescription>Email tester@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_3314"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>3314</targetSerial> <targetSerialResult>3314</targetSerialResult> <targetAccessKeyResult>AE:3314/</targetAccessKeyResult> <rowDescription>Tester,John D Overdraft Transfer for 00000010200004 Primary Savings Account</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>3314</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:3314/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>2</newContents> <newContentsDescription>Tester,John D</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>733</newContents> <newContentsDescription>Overdraft Transfer</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> <newContents>61376</newContents> <newContentsDescription>00000010200004 Primary Savings Account</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_3314/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2020-01-08</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>3314</targetSerial> <targetSerialResult>3314</targetSerialResult> <targetAccessKeyResult>AE:3314/C:3314/</targetAccessKeyResult> <targetParentSerialResult>3314</targetParentSerialResult> <rowDescription>Tester,John D Overdraft Transfer for 00000010200004 Primary Savings Account Email tester@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>3314</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>3314</newContents> <newContentsDescription>Tester,John D Overdraft Transfer for 00000010200004 Primary Savings Account</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:3314/C:3314/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>3314</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>58405</newContents> <newContentsDescription>Tester,John D Personal email tester@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_3314/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2020-01-08</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-11-22</postingDate> <postingTime>2020-11-24 13:05:11 PST</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>346</targetSerial> <rowDescription>Smith,John Michael Bill payment created for 0000001020</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>346</serial> <accessKey>AE:346/</accessKey> <rowDescription>Smith,John Michael Bill payment created for 0000001020</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_346</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>344</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>346</parentSerial> <accessKey>AE:346/C:344/</accessKey> <rowDescription>Email banking@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_346"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>346</targetSerial> <targetSerialResult>346</targetSerialResult> <targetAccessKeyResult>AE:346/</targetAccessKeyResult> <rowDescription>Smith,John Michael Bill payment created for 0000001020</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>346</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:346/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>2</newContents> <newContentsDescription>Smith,John Michael</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>203</newContents> <newContentsDescription>Bill payment created</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> <newContents>2</newContents> <newContentsDescription>0000001020</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_346/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-18</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>344</targetSerial> <targetSerialResult>344</targetSerialResult> <targetAccessKeyResult>AE:346/C:344/</targetAccessKeyResult> <targetParentSerialResult>346</targetParentSerialResult> <rowDescription>Smith,John Michael Bill payment created for 0000001020 Email banking@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>344</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>346</newContents> <newContentsDescription>Smith,John Michael Bill payment created for 0000001020</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:346/C:344/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>344</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>55408</newContents> <newContentsDescription>Smith,John Michael Personal email banking@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_344/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-18</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-11-22</postingDate> <postingTime>2020-11-24 13:05:11 PST</postingTime> <step type="a"> <recordTree type="c" label="SYS_1"> <tableName>ALERT_ENROLLMENT</tableName> <targetSerial>350</targetSerial> <rowDescription>Smith,John Michael Bill payment due for 0000001020</rowDescription> <viewName>STANDARD</viewName> <viewDescription>Standard</viewDescription> <includeRecordDetail option="Y">Yes</includeRecordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT</tableName> </recordDetail> <recordDetail type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> </recordDetail> <metadataTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <newLocationSupport option="Y">Yes</newLocationSupport> </child> </metadataTree> <resultTree type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <serial>350</serial> <accessKey>AE:350/</accessKey> <rowDescription>Smith,John Michael Bill payment due for 0000001020</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_350</detailLabel> <child type="a"> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <serial>348</serial> <parentTableName>ALERT_ENROLLMENT</parentTableName> <parentSerial>350</parentSerial> <accessKey>AE:350/C:348/</accessKey> <rowDescription>Email banking@q2.com</rowDescription> <detailLabel>SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348</detailLabel> </child> </resultTree> </recordTree> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_350"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <targetSerial>350</targetSerial> <targetSerialResult>350</targetSerialResult> <targetAccessKeyResult>AE:350/</targetAccessKeyResult> <rowDescription>Smith,John Michael Bill payment due for 0000001020</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>350</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:350/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_PERSON_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_SERIAL</columnName> <columnDescription>Person</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON</referenceTableName> <newContents>2</newContents> <newContentsDescription>Smith,John Michael</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_TYPE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>TYPE_SERIAL</columnName> <columnDescription>Type</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_TYPE</referenceTableName> <newContents>214</newContents> <newContentsDescription>Bill payment due</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_ACCOUNT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_SERIAL</columnName> <columnDescription>Account</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ACCOUNT</referenceTableName> <newContents>2</newContents> <newContentsDescription>0000001020</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_SHARE_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_SERIAL</columnName> <columnDescription>Share</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>SHARE</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_LOAN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_SERIAL</columnName> <columnDescription>Loan</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOAN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_CARD_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_SERIAL</columnName> <columnDescription>Card</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>CARD</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_LOGIN_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_SERIAL</columnName> <columnDescription>Login</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>LOGIN</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_MINIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT</columnName> <columnDescription>Minimum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_MAXIMUM_AMOUNT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT</columnName> <columnDescription>Maximum Amount</columnDescription> <dataType option="M">Money</dataType> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_DAYS_BEFORE_EVENT"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT</columnName> <columnDescription>Days Before Event</columnDescription> <dataType option="C">Count</dataType> <newContents>5</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Insert Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Insert Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_350/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-18</newContents> </field> </record> </step> <step type="a"> <record type="c" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348"> <systemGenerated option="g">Privilege required</systemGenerated> <operation option="V">View</operation> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_ENROLLMENT_CONTACT</tableName> <tableDescription>Alert Enrollment Contact</tableDescription> <parentTableName>ALERT_ENROLLMENT</parentTableName> <targetSerial>348</targetSerial> <targetSerialResult>348</targetSerialResult> <targetAccessKeyResult>AE:350/C:348/</targetAccessKeyResult> <targetParentSerialResult>350</targetParentSerialResult> <rowDescription>Smith,John Michael Bill payment due for 0000001020 Email banking@q2.com</rowDescription> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>348</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348/_PARENT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PARENT_SERIAL</columnName> <columnDescription>Parent Serial</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_ENROLLMENT</referenceTableName> <newContents>350</newContents> <newContentsDescription>Smith,John Michael Mahalo Bill payment due for 0000001020</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>AE:350/C:348/</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348/_ORDINAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ORDINAL</columnName> <columnDescription>Ordinal</columnDescription> <dataType option="C">Count</dataType> <newContents>348</newContents> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348/_CONTACT_METHOD"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CONTACT_METHOD</columnName> <columnDescription>Contact Method</columnDescription> <dataType option="O">Option</dataType> <newContents>E</newContents> <newContentsDescription>Email</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348/_PERSON_CONTACT_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>PERSON_CONTACT_SERIAL</columnName> <columnDescription>Person Contact</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>PERSON_CONTACT</referenceTableName> <newContents>55408</newContents> <newContentsDescription>Smith,John Michael Personal email banking@q2.com</newContentsDescription> </field> <field type="a" label="SYS_1/TBL_ALERT_ENROLLMENT_CONTACT_348/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-18</newContents> </field> </record> </step> </transaction> </sequence> </query>"""
[docs] def alert_type_details_response(): return """<query xmlns="http://www.corelationinc.com/queryLanguage/v1.0" sessionId="943430A3E5A9212538FBF07C29807586"> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-05 13:31:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>2</targetSerial> <targetSerialResult>2</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:2/</targetAccessKeyResult> <rowDescription>Card Limit Change</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>2</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:2/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Card Limit Change</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>CLC</newContents> <newContentsDescription>Card limit changed</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>Your Card Number %%CARD_NUMBER%% has had a limit change. Contact your credit union for details.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>2</newContents> <newContentsDescription>Alert Server Alert Channel 1</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-09</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-05 13:31:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>3</targetSerial> <targetSerialResult>3</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:3/</targetAccessKeyResult> <rowDescription>Login Locked</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>3</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:3/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Login Locked</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>LGL</newContents> <newContentsDescription>Login locked</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>Your home banking or audio login record has been locked. Please contact your credit union to address the problem.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>2</newContents> <newContentsDescription>Alert Server Alert Channel 1</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-21</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-05 13:31:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>5</targetSerial> <targetSerialResult>5</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:5/</targetAccessKeyResult> <rowDescription>Deposit Posted</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>5</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:5/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Deposit Posted</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>DEP</newContents> <newContentsDescription>Deposit posted (exclude same account transfer)</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>A deposit was posted!</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>2</newContents> <newContentsDescription>Alert Server Alert Channel 1</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2018-10-21</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-05 13:31:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>8</targetSerial> <targetSerialResult>8</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:8/</targetAccessKeyResult> <rowDescription>Loan Balance Over Amount</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>8</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:8/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Loan Balance Over Amount</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>LBO</newContents> <newContentsDescription>Loan balance over amount</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>Your loan %%ACCOUNT_NUMBER%%-%%ID%% balance of %%NEW_BALANCE%% exceeds the amount of %%MONETARY_AMOUNT%%.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>2</newContents> <newContentsDescription>Alert Server Alert Channel 1</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-01-29</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-05 13:31:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>7</targetSerial> <targetSerialResult>7</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:7/</targetAccessKeyResult> <rowDescription>Payment Posted</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>7</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:7/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Payment Posted</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>PMT</newContents> <newContentsDescription>Payment posted</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>A payment of %%MONETARY_AMOUNT%% has been posted to %%ACCOUNT_NUMBER%%-%%ID%%.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>2</newContents> <newContentsDescription>Alert Server Alert Channel 1</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-01-29</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-05 13:31:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>213</targetSerial> <targetSerialResult>213</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:213/</targetAccessKeyResult> <rowDescription>Loan payment pending</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>213</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:213/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Loan payment pending</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>PMP</newContents> <newContentsDescription>Loan payment pending</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>Your loan payment is will be made in %%DAYS_BEFORE_EVENT%%.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>5</newContents> <newContentsDescription>Alert Server Alert Channel</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-13</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-08-16</postingDate> <postingTime>2020-08-17 14:21:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>215</targetSerial> <targetSerialResult>215</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:215/</targetAccessKeyResult> <rowDescription>Test Card limit expiration due</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>215</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:215/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Test Card limit expiration due</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>CLE</newContents> <newContentsDescription>Card limit expiration due</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>Your card limit will expired in %%DAYS_BEFORE_EVENT%% days.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>5</newContents> <newContentsDescription>Alert Server Test Alert Channel</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-13</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-05 13:31:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>199</targetSerial> <targetSerialResult>199</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:199/</targetAccessKeyResult> <rowDescription>Returned item fee</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>199</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:199/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Returned item fee</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>RTN</newContents> <newContentsDescription>Returned item fee</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>An item has been returned</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>5</newContents> <newContentsDescription>Alert Server Alert Channel</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-13</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-05 13:31:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>733</targetSerial> <targetSerialResult>733</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:733/</targetAccessKeyResult> <rowDescription>Overdraft Transfer</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>733</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:733/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Overdraft Transfer</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>ODT</newContents> <newContentsDescription>Overdraft transfer</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>An overdraft transfer has occured.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>5</newContents> <newContentsDescription>Alert Server Alert Channel</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-12-22</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-08-16</postingDate> <postingTime>2020-08-17 14:21:35 PDT</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>735</targetSerial> <targetSerialResult>735</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:735/</targetAccessKeyResult> <rowDescription>Qtwo Card purchase posted</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>735</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:735/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Qtwo Card purchase posted</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>PUR</newContents> <newContentsDescription>Card purchase posted</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>A purchase of %%MONETARY_AMOUNT%% occurred on card %%CARD_NUMBER%%.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>502</newContents> <newContentsDescription>Alert Server Qtwo</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2020-02-18</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-11-22</postingDate> <postingTime>2020-11-24 13:24:55 PST</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>203</targetSerial> <targetSerialResult>203</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:203/</targetAccessKeyResult> <rowDescription>Bill payment created</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>203</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:203/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Bill payment created</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>BPI</newContents> <newContentsDescription>Bill payment created</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>Your %%ACCOUNT_NUMBER%% has a new bill payment created.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>5</newContents> <newContentsDescription>Alert Server Alert Channel</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-13</newContents> </field> </record> </step> </transaction> </sequence> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-11-22</postingDate> <postingTime>2020-11-24 13:24:56 PST</postingTime> <step type="a"> <record type="c" label="SYS_1"> <operation option="V">View</operation> <includeRowDescriptions option="Y">Yes</includeRowDescriptions> <includeAllColumns option="Y">Yes</includeAllColumns> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <targetSerial>214</targetSerial> <targetSerialResult>214</targetSerialResult> <targetAccessKeyResult>ALERT_TYPE:214/</targetAccessKeyResult> <rowDescription>Bill payment due</rowDescription> <field type="a" label="SYS_1/_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SERIAL</columnName> <columnDescription>Serial</columnDescription> <dataType option="E">Serial</dataType> <newContents>214</newContents> </field> <field type="a" label="SYS_1/_ACCESS_KEY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCESS_KEY</columnName> <columnDescription>Access Key</columnDescription> <dataType option="S">Text</dataType> <newContents>ALERT_TYPE:214/</newContents> </field> <field type="a" label="SYS_1/_DESCRIPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> <newContents>Bill payment due</newContents> </field> <field type="a" label="SYS_1/_STATUS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>STATUS</columnName> <columnDescription>Status</columnDescription> <dataType option="O">Option</dataType> <newContents>O</newContents> <newContentsDescription>Open</newContentsDescription> </field> <field type="a" label="SYS_1/_CODE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CODE</columnName> <columnDescription>Code</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CATEGORY"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CATEGORY</columnName> <columnDescription>Category</columnDescription> <dataType option="O">Option</dataType> <newContents>BPD</newContents> <newContentsDescription>Bill payment due</newContentsDescription> </field> <field type="a" label="SYS_1/_ACCOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>ACCOUNT_OPTION</columnName> <columnDescription>Account Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_SHARE_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>SHARE_OPTION</columnName> <columnDescription>Share Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOAN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOAN_OPTION</columnName> <columnDescription>Loan Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_CARD_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CARD_OPTION</columnName> <columnDescription>Card Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_LOGIN_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LOGIN_OPTION</columnName> <columnDescription>Login Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MINIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MINIMUM_AMOUNT_OPTION</columnName> <columnDescription>Minimum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_MAXIMUM_AMOUNT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MAXIMUM_AMOUNT_OPTION</columnName> <columnDescription>Maximum Amount Option</columnDescription> <dataType option="O">Option</dataType> <newContents>N</newContents> <newContentsDescription>No</newContentsDescription> </field> <field type="a" label="SYS_1/_DAYS_BEFORE_EVENT_OPTION"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DAYS_BEFORE_EVENT_OPTION</columnName> <columnDescription>Days Before Event Option</columnDescription> <dataType option="O">Option</dataType> <newContents>Y</newContents> <newContentsDescription>Yes</newContentsDescription> </field> <field type="a" label="SYS_1/_EXCLUSIONS"> <systemGenerated option="G">Yes</systemGenerated> <columnName>EXCLUSIONS</columnName> <columnDescription>Exclusions</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>MESSAGE</columnName> <columnDescription>Message</columnDescription> <dataType option="S">Text</dataType> <newContents>A bill payment is due in %%DAYS_BEFORE_EVENT%% days.</newContents> </field> <field type="a" label="SYS_1/_INSERT_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>INSERT_MESSAGE</columnName> <columnDescription>Insert Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_DELETE_MESSAGE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>DELETE_MESSAGE</columnName> <columnDescription>Delete Message</columnDescription> <dataType option="S">Text</dataType> </field> <field type="a" label="SYS_1/_CHANNEL_SERIAL"> <systemGenerated option="G">Yes</systemGenerated> <columnName>CHANNEL_SERIAL</columnName> <columnDescription>Channel</columnDescription> <dataType option="E">Serial</dataType> <referenceTableName>ALERT_CHANNEL</referenceTableName> <newContents>5</newContents> <newContentsDescription>Alert Server Alert Channel</newContentsDescription> </field> <field type="a" label="SYS_1/_LAST_FM_DATE"> <systemGenerated option="G">Yes</systemGenerated> <columnName>LAST_FM_DATE</columnName> <columnDescription>Last FM Date</columnDescription> <dataType option="D">Date</dataType> <newContents>2019-02-13</newContents> </field> </record> </step> </transaction> </sequence> </query>"""
[docs] def alert_types_response(): return """<query xmlns="http://www.corelationinc.com/queryLanguage/v1.0" sessionId="943430A3E5A9212538FBF07C29807586"> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-30</postingDate> <postingTime>2020-08-04 09:20:09 PDT</postingTime> <step type="a"> <search type="c"> <tableName>ALERT_TYPE</tableName> <tableDescription>Alert Type</tableDescription> <filterName>BY_DESCRIPTION</filterName> <filterDescription>By Description</filterDescription> <includeSelectColumns option="Y">Yes</includeSelectColumns> <includeTotalHitCount option="Y">Yes</includeTotalHitCount> <returnLimit>1000</returnLimit> <returnLimitMaximum>1000</returnLimitMaximum> <parameter type="a"> <columnName>DESCRIPTION</columnName> </parameter> <selectColumn type="a"> <tableName>ALERT_TYPE</tableName> <columnName>ROW_DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> </selectColumn> <resultRow type="a"> <serial>2</serial> <selectColumn type="a"> <contents>Card Limit Change</contents> </selectColumn> </resultRow> <resultRow type="a"> <serial>5</serial> <selectColumn type="a"> <contents>Deposit Posted</contents> </selectColumn> </resultRow> <resultRow type="a"> <serial>902</serial> <selectColumn type="a"> <contents>Deposit Posted Test</contents> </selectColumn> </resultRow> <totalHitCount>3</totalHitCount> </search> </step> </transaction> </sequence> </query>"""
[docs] def alerts_by_person_serial_response(): return """<?xml version="1.0"?> <query type="c" xmlns="http://www.corelationinc.com/queryLanguage/v1.0" sessionId="943430A3E5A9212538FBF07C29807586"> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>2</branchSerial> <postingDate>2020-06-03</postingDate> <postingTime>2020-06-05 13:13:29 PDT</postingTime> <step type="a"> <search type="c"> <tableName>ALERT_ENROLLMENT</tableName> <tableDescription>Alert Enrollment</tableDescription> <filterName>BY_PERSON_SERIAL</filterName> <filterDescription>By Person</filterDescription> <includeSelectColumns option="Y">Yes</includeSelectColumns> <includeTotalHitCount option="Y">Yes</includeTotalHitCount> <returnLimit>500</returnLimit> <returnLimitMaximum>1000</returnLimitMaximum> <parameter type="a"> <columnName>PERSON_SERIAL</columnName> <contents>58578</contents> </parameter> <selectColumn type="a"> <tableName>ALERT_ENROLLMENT</tableName> <columnName>ROW_DESCRIPTION</columnName> <columnDescription>Description</columnDescription> <dataType option="S">Text</dataType> </selectColumn> <resultRow type="a"> <serial>5</serial> <selectColumn type="a"> <contents>Tester,John D Card Limit Change for 00002545725001 Rewards Visa</contents> </selectColumn> </resultRow> <resultRow type="a"> <serial>6</serial> <selectColumn type="a"> <contents>Tester,John D Login Locked for Internet Banking Without Passwords JDTester</contents> </selectColumn> </resultRow> <totalHitCount>2</totalHitCount> </search> </step> </transaction> </sequence> </query>"""
[docs] def demographic_info_response(): return """<query type="c" sessionId="8D59CFDC84085FBE8D798CE9A469864B"> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>203</branchSerial> <postingDate>2019-01-18</postingDate> <postingTime>2019-01-30 19:50:17 UTC</postingTime> <step type="a"> <search type="c"> <tableName>PERSON</tableName> <tableDescription>Person</tableDescription> <filterName>BY_SERIAL</filterName> <filterDescription>By Serial</filterDescription> <filterUserInterfaceCategory option="S">Suppress</filterUserInterfaceCategory> <formatName>VERIFICATION</formatName> <formatDescription>Verification</formatDescription> <includeTotalHitCount option="Y">Yes</includeTotalHitCount> <returnLimit>10</returnLimit> <returnLimitMaximum>1000</returnLimitMaximum> <parameter type="a"> <columnName>SERIAL</columnName> <contents>36323</contents> </parameter> <resultRow type="a"> <serial>36323</serial> <person type="c"> <serial>36323</serial> <rowDescription>Tester,Jane E.</rowDescription> <firstName>Jane</firstName> <middleName>E.</middleName> <lastName>Tester</lastName> <tinSuffix>6509</tinSuffix> <birthDate>1981-07-26</birthDate> <taxStateSerial>1</taxStateSerial> <alertEligibilityDate>2019-01-18</alertEligibilityDate> <alert type="a"> <serial>37836</serial> <typeSerial>11</typeSerial> <typeDescription>Conversion Note Type EMPLOYEE_FLAG</typeDescription> <explanation>E</explanation> </alert> <contact type="a"> <serial>84363</serial> <category option="HP">Home phone</category> <value>(555)632-7643</value> </contact> <contact type="a"> <serial>84364</serial> <category option="BP">Business phone</category> <value>(555)455-9400</value> </contact> <contact type="a"> <serial>84365</serial> <category option="PE">Personal email</category> <value>noreply@q2.com</value> </contact> <contact type="a"> <serial>84374</serial> <category option="PC">Personal cell</category> <description>Cell</description> <value>(555)626-4013</value> </contact> <identification type="a"> <serial>100634</serial> <category option="DL">Driver license</category> <value>C123-456-78-900-0</value> <issuer>TX</issuer> </identification> <identification type="a"> <serial>100635</serial> <category option="MM">Mother's maiden name</category> <value>SOMENAME</value> </identification> <identification type="a"> <serial>100651</serial> <category option="CU">Custom</category> <description>DL</description> <value>C123-456-78-900-0</value> <issueDate>1907-07-26</issueDate> </identification> <identification type="a"> <serial>100652</serial> <category option="CU">Custom</category> <description>Mother's maiden name</description> <value>SOMENAME</value> </identification> <identification type="a"> <serial>100721</serial> <category option="CU">Custom</category> <description>DL</description> <value>G613-105-81-766-0</value> <expirationDate>2019-07-26</expirationDate> </identification> <addressEligibilityDate>2019-01-18</addressEligibilityDate> <address type="a"> <serial>45731</serial> <addressSerial>31021</addressSerial> <category option="R">Residence</category> <street>123 Rose Rd</street> <city>Austin</city> <state>TX</state> <postalCode>78750</postalCode> </address> <address type="a"> <serial>45741</serial> <addressSerial>31026</addressSerial> <category option="R">Residence</category> <street>789 Some Rd</street> <city>Somewhere</city> <state>TX</state> <postalCode>65432</postalCode> </address> <address type="a"> <serial>45801</serial> <addressSerial>31062</addressSerial> <category option="R">Residence</category> <street>789 Some Rd</street> <city>Nowhere</city> <state>TX</state> <postalCode>65432</postalCode> </address> </person> </resultRow> <totalHitCount>1</totalHitCount> </search> </step> </transaction> </sequence> </query>"""
[docs] def login_verify_response(): return """<query type="c" sessionId="08A85C56C39DB1086C86373F9C2AAFB9"> <sequence type="a"> <transaction type="a" result="posted"> <serial>67954191</serial> <branchSerial>203</branchSerial> <postingDate>2019-01-18</postingDate> <postingTime>2019-01-31 20:00:17 UTC</postingTime> <step type="a"> <loginVerify type="c" label="SYS_1"> <channelSerial>2</channelSerial> <channelSerialResult>2</channelSerialResult> <loginId>123456509</loginId> <loginIdResult>123456509</loginIdResult> <loginSerialResult>161559</loginSerialResult> <personSerialResult>36323</personSerialResult> <oldLastLoginTime>2019-01-31 02:20:30 UTC</oldLastLoginTime> <newLastLoginTime>2019-01-31 20:00:17 UTC</newLastLoginTime> <success option="Y">Yes</success> </loginVerify> </step> <step type="a"> <record type="c" label="SYS_1/LOGIN"> <serial>67954192</serial> <systemGenerated option="A">No reversing</systemGenerated> <tableName>LOGIN</tableName> <tableDescription>Login</tableDescription> <targetSerial>161559</targetSerial> <targetSerialResult>161559</targetSerialResult> <targetAccessKeyResult>LG:161559/</targetAccessKeyResult> <oldLastFMDate>2019-01-18</oldLastFMDate> <newLastFMDate>2019-01-18</newLastFMDate> <rowDescription>Q2 xxx-xx-6509</rowDescription> <field type="a" label="SYS_1/LOGIN/_LAST_LOGIN_TIME"> <serial>67954193</serial> <systemGenerated option="A">No reversing</systemGenerated> <columnName>LAST_LOGIN_TIME</columnName> <columnDescription>Last Login Time</columnDescription> <dataType option="T">Time</dataType> <operation option="S">Set</operation> <oldContents>2019-01-31 02:20:30 UTC</oldContents> <newContents>2019-01-31 20:00:17 UTC</newContents> </field> </record> </step> </transaction> </sequence> </query>"""
[docs] def mock_person_verification_response(): return f"""<?xml version="1.0"?><query type="c" sessionId="40FCF345B801E78322F2438E3B1B1946"> <sequence type="a"> <transaction type="a" result="posted"> <branchSerial>1</branchSerial> <postingDate>2019-06-13</postingDate> <postingTime>2019-06-18 16:14:42 CDT</postingTime> <step type="a"> <search type="c"> <tableName>PERSON</tableName> <tableDescription>Person</tableDescription> <filterName>BY_TIN</filterName> <filterDescription>By TIN</filterDescription> <formatName>VERIFICATION</formatName> <formatDescription>Verification</formatDescription> <includeTotalHitCount option="Y">Yes</includeTotalHitCount> <returnLimit>50</returnLimit> <returnLimitMaximum>1000</returnLimitMaximum> <parameter type="a"> <columnName>TIN</columnName> <contents>{data_helpers.SOCIALSECURITY}</contents> </parameter> <resultRow type="a"> <serial>579</serial> <person type="c"> <serial>579</serial> <rowDescription>{data_helpers.LASTNAME},{data_helpers.FIRSTNAME} {data_helpers.MIDDLENAME}</rowDescription> <firstName>{data_helpers.FIRSTNAME}</firstName> <middleName>{data_helpers.MIDDLENAME}</middleName> <lastName>{data_helpers.LASTNAME}</lastName> <tinSuffix>6871</tinSuffix> <birthDate>{data_helpers.DOB}</birthDate> <taxStateSerial>1</taxStateSerial> <alertEligibilityDate>2019-06-13</alertEligibilityDate> <contact type="a"> <serial>778</serial> <category option="HP">Home phone</category> <description>Home Land Line1</description> <value>{data_helpers.PHONENUMBER}</value> </contact> <contact type="a"> <serial>779</serial> <category option="PC">Personal cell</category> <description>Home Mobile1</description> <value>{data_helpers.PHONENUMBER}</value> </contact> <contact type="a"> <serial>780</serial> <category option="BP">Business phone</category> <description>Work Land Line1</description> <value>{data_helpers.PHONENUMBER}</value> </contact> <contact type="a"> <serial>781</serial> <category option="PE">Personal email</category> <description>{data_helpers.EMAIL}</description> <value>{data_helpers.EMAIL}</value> </contact> <identification type="a"> <serial>256</serial> <category option="DL">Driver license</category> <value>{data_helpers.DRIVERSLICENSENUM}</value> <issuer>{data_helpers.DRIVERSLICENSESTATEABBREV}</issuer> <issueDate>2014-03-10</issueDate> <expirationDate>2017-12-10</expirationDate> <imageFormat option="pdf">pdf</imageFormat> </identification> <identification type="a"> <serial>76286</serial> <category option="CU">Custom</category> <description>Signature</description> <value>10907.jpeg</value> <imageFormat option="jpeg">jpeg</imageFormat> </identification> <identification type="a"> <serial>118356</serial> <category option="CU">Custom</category> <description>Drivers License</description> <value>83340.pdf</value> <imageFormat option="pdf">pdf</imageFormat> </identification> <addressEligibilityDate>2019-06-13</addressEligibilityDate> <address type="a"> <serial>617</serial> <addressSerial>412</addressSerial> <category option="R">Residence</category> <effectiveDate>1994-08-12</effectiveDate> <street>{data_helpers.ADDRESS1}</street> <city>{data_helpers.CITY}</city> <state>{data_helpers.STATEABBRV}</state> <postalCode>{data_helpers.ZIP}-{data_helpers.ZIPCODELAST4}</postalCode> </address> <address type="a"> <serial>617</serial> <addressSerial>412</addressSerial> <category option="M">Mailing</category> <effectiveDate>1994-08-12</effectiveDate> <street>Mailing_Address</street> <city>{data_helpers.CITY}</city> <state>{data_helpers.STATEABBRV}</state> <postalCode>{data_helpers.ZIP}-{data_helpers.ZIPCODELAST4}</postalCode> </address> </person> </resultRow> <totalHitCount>1</totalHitCount> </search> </step> </transaction> </sequence> </query>"""
[docs] def mock_invalid_account_number_response(): return """<query type="c" sessionId="BC63CCC4A01FA40AB9ADFDEC45D19950"> <sequence type="a"> <transaction type="a" result="failed"> <branchSerial>1</branchSerial> <postingDate>2022-10-04</postingDate> <postingTime>2023-01-25 07:10:25 CST</postingTime> <step type="a"> <search type="c" label="SYS_1"> <tableName>PERSON</tableName> <tableDescription>Person</tableDescription> <filterName>BY_ACCOUNT_NUMBER</filterName> <filterDescription>By Account Number</filterDescription> <formatName>VERIFICATION</formatName> <formatDescription>Verification</formatDescription> <includeTotalHitCount option="Y">Yes</includeTotalHitCount> <returnLimit>50</returnLimit> <returnLimitMaximum>1000</returnLimitMaximum> <parameter type="a"> <columnName>ACCOUNT_NUMBER</columnName> <contents>999999999324</contents> </parameter> <exception type="a"> <message>Invalid Account Number</message> </exception> </search> </step> <step type="a"> <tranResult type="c" label="SYS_1/SYS_2"> <systemGenerated option="G">Yes</systemGenerated> <category option="E">Exception</category> <description>Invalid Account Number</description> <approvedTransactionOnly option="Y">Yes</approvedTransactionOnly> <sourceLabel>SYS_1</sourceLabel> </tranResult> </step> <exception type="a"> <message>Invalid Account Number</message> </exception> </transaction> </sequence> </query> """