MediaWiki API result

{
    "batchcomplete": "",
    "continue": {
        "gapcontinue": "Regular_Expression_Pattern_Matching_Using_!Match",
        "continue": "gapcontinue||"
    },
    "query": {
        "pages": {
            "206": {
                "pageid": 206,
                "ns": 0,
                "title": "Reading Spectrum Data Change Records",
                "revisions": [
                    {
                        "contentformat": "text/x-wiki",
                        "contentmodel": "wikitext",
                        "*": "== Reading Spectrum Data Change Records ==\n===Overview===\nThe SH-HISTORY and LN-HISTORY datasets (HISTRY database) contain data change records that are stored in a binary format.  AskPlus provides two special functions designed to read and interpret these records.  To use these functions the datachng.sl (or .so Itanium) must be installed in the /ASKPLUS directory.  An AskPlus/SUPRTOOL job is available that extracts specific data change records based on their ENTRY-DATE and creates an SD file that can be used for reporting with AskPlus or Visimage3.\n\n===Installing the Data Change Files===\n\nThe data change library file and the extract job are provided in a single gz download.  Choose the pa32 file for PARISC and the it64 file for Itanium.  Transfer the gz file to the /ASKPLUS directory on UNIX and execute the following commands to unzip the gzip file and extract the files from the tar file.  You should be logged on as the ask plus user while installing these files.\n \n:gunzip datachange_pa32.tar.gz\n:tar -xvf datachange_pa32.tar \nor\n:gunzip datachange_it64.tar.gz\n:tar -xvf datachange_it64.tar \n\nThe library file (datachng.sl or datachng.so) must remain in the /ASKPLUS directory.  The extract job (ask_datachange_job) should be moved to a location with access to the Spectrum databases and may be renamed.  The contents of the job may also be copied into UC4 a script.\n\nDownload data change files [http://www.vital-soft.com/product-downloads/ here].\n\n===Editing the Job Parameters===\n\nThe job contains a prompts section to customize the extract.  You may specify a date range and the name of the final SD file that is created.  You can also specify whether or not to include share history and/or loan history.\n\n *** Start of Prompts Section ***\n \n # StartDate is the range start-date (YYYYMMDD format)\n # EndDate is the range end-date (YYYYMMDD format)\n # OutputFile is the fully qualified file name of the final SD file.\n # IncludeShareHist is the flag to include SH-HISTORY (\"Y\" or \"N\")\n # IncludeLoanHist is the flag to include LN-HISTORY (\"Y\" or \"N\")\n \n export StartDate=20160101\n export EndDate=20160131\n export OutputFile=$SPXHOME/FI/DATA/DC-FILE\n export IncludeShareHist=Y\n export IncludeLoanHist=Y\n \n *** End of Prompts section ***\n\n===Accessing the SD file in AskPlus/Visimage===\nThe SD file may be used in AskPlus with an OPEN command or in Visimage using the View > Host Databases window.\n\nThe file contains one record for each item with a recorded data change value.  These data change records have a DC-TYPE = \"Change\" and include both a before (DC-BEFORE-VALUE) and an after (DC-AFTER-VALUE) value for the item. The file also contains constant records (DC-TYPE = \"Const\") that, in some cases, help to identify the record that was updated.  Const records do not have an after value.  The before and after values are stored as X50.  Numeric values can be easily converted by AskPlus.  \n\nEach record contains ENTRY-DATE, ACCOUNT, SUFFIX, TELLER-INTL, COMMAND, SEQUENCE and many more fields that identify the data change.  The specific data change records are as follows:\n\n'''Actual Change Records:\n\n DC-TYPE:         = \"Change\"\n DC-ITEM-NAME:    The name of the item (field) that was changed.\n                  - Array items are shown with the index, for example: ADDRESS-LINES(02)\n DC-ITEM-TYPE:    The Eloquence data type. For example: I2, X30\n DC-BEFORE-VALUE: The value of the item before the change.\n DC-AFTER-VALUE:  The value of the item after the change.\n\n'''Constant (Lookup) Records:\n DC-TYPE:         = \"Const\"\n DC-ITEM-NAME:    The name of the lookup (field) to help identify the change.\n DC-ITEM-TYPE:    The Eloquence data type. For example: I2, X30\n DC-BEFORE-VALUE: The value of the lookup item.\n DC-AFTER-VALUE:  Blank.\n\n===Sample AskPlus Query===\nOnce the extract job has been run, and the DC-FILE has been created, the following will find all changes made to the APR field.\n\n /ASKPLUS/askplus\n open /ASKPLUS/visimage/DC-FILE;\n find primary=DC-FILE; outsel=(@)\n DC-TYPE = \"Change\" and DC-ITEM-NAME = \"APR\""
                    }
                ]
            },
            "321": {
                "pageid": 321,
                "ns": 0,
                "title": "Reconciling to the Trial Balance",
                "revisions": [
                    {
                        "contentformat": "text/x-wiki",
                        "contentmodel": "wikitext",
                        "*": "== Membership Analysis Default View ==\nTo be counted (and reported) by default in the Vital Signs Membership Analysis document, members shares and loans must meet the following criteria.  These criteria are determined by macro definitions which can be customized for each client.\n\n=== Member / Account Counts ===\nTo be counted, the Account status must be '''Open''' or '''Dormant''' and must have at least one open share or one open loan.  The macro VS-ACTIVE-MBR is used to determine whether or not the member's account record has been closed.   The following statuses are possible:\n\n{| class=\"wikitable\"\n| '''Account Status'''\n| '''Explanation'''\n|-\n| Open\n| Not closed, not dormant and has at least one open share or loan.\n|-\n| Dormant\n| Dormant (not closed) and has at least one open share or loan.\n|-\n| Closed\n| Closed and has a valid CLOSED-DATE.\n|-\n| Other\n| The account does not meet any of the above criteria.\n|-\n| Dropped\n| The account existed in a prior period but no longer exists in the current period.\n|}\n\nThe following macros are used to determine the account status:\n\n  Macro VS-ACTIVE-MBR   = (MEMBER-FILE.REST-FLAG-11 <> 80) \n  Macro VSMBR-DORMANT   = (MEMBER-FILE.REST-FLAG-11 = 79)\n\nNote:  Member counts are similar to account counts, but instead of counting individual Spectrum accounts, the number of unique primary SSNs are reported.\n\n=== Share/Deposit Counts and Balances ===\nTo be counted, the share must not be closed and must not be charged off.  The macros VS-ACTIVE-SHARE and VS-CHGOFF-SHARE are used to determine if a share should be counted.  If an open share is associated with a closed member record, the share will '''not''' be included in the charts.  The following statuses are possible:\n\n{| class=\"wikitable\"\n| '''Share Status'''\n| '''Explanation'''\n|-\n| Open\n| Not closed and not charged off.\n|-\n| Charged Off\n| The share has been charged off.\n|-\n| Closed\n| Closed and has a valid CLOSED-DATE.\n|-\n| Other\n| The share does not meet any of the above criteria.\n|-\n| Dropped\n| The share existed in a prior period but no longer exists in the current period.\n|}\n\nThe following macros are used to determine the share status:\n\n  Macro VS-ACTIVE-SHARE  = (SHARE-FILE.REST-FLAG-11 <> 80)\n  Macro VS-CHGOFF-SHARE  = (SHARE-FILE.DESC-ABRV=\"COS\")\n\n=== Loan Counts and Balances ===\nTo be counted, the loan must not be closed, must not be charged off and must qualify as '''countable'''.  The macros VS-ACTIVE-LOAN, VS-CHGOFF-LOAN and VS-OPEN-LOAN are used to determine if a loan should be counted.  If an open loan is associated with a closed member record, the loan will not be included in the charts.  The following statuses are possible:\n\n{| class=\"wikitable\"\n| '''Loan Status'''\n| '''Explanation'''\n|-\n| Open\n| Not closed, not charged off and countable (see VS-OPEN-LOAN).\n|-\n| Charged Off\n| The loan has been charged off.\n|-\n| Closed\n| Closed and has a valid CLOSED-DATE.\n|-\n| Other\n| The loan does not meet any of the above criteria.\n|-\n| Dropped\n| The loan existed in a prior period but no longer exists in the current period.\n|}\n\nThe following macros are used to determine the share status:\n\n  Macro VS-ACTIVE-LOAN  = (LOAN-FILE.REST-FLAG-11 <> 80)\n  Macro VS-CHGOFF-LOAN  = (LOAN-FILE.ACTION = \"O\")\n  Macro VS-OPEN-LOAN    = ((LOAN-FILE.BALANCE > 0 OR LOAN-FILE.CREDIT-LIM > 0) AND LOAN-FILE.ACTION = \"D\",\"3\")\n\n=== Setting the Default View ===\n\nWhen using the Membership Analysis document in Vital Signs it is important to be aware of the default view: which date is currently selected, and what Account, Deposit and Loan statuses are selected.\n\n[[File:Membership Analysis Default View.jpg | 600px]]\n\n=== The Status Bar ===\n\nEach page of the document shows the status bar which displays the currently selected members, accounts, deposits and shares and compares them to the overall possible total.  The labels indicate which overall total is being displayed.  In the default view, the total reflects Open/Dormant Accounts, Open Deposits and Open loans as shown below.\n\n[[File:Membership Analysis Status Bar.jpg | 800px]]\n\n==== Locating Missing Deposits/Loans ====\n\nAs mentioned above, it is possible for some '''Open''' deposits and loans to be missing from the default view.  This occurs when there are '''open''' deposits and loans that are associated with a account record that is '''not open'''.  These deposits can be easily identified as follows:\n\n#In the Membership_Analysis document, click '''Unlock and Clear All'''.\n#Choose the Deposit Status:  '''Open'''\n#Choose the Account Status:  '''Closed''' and '''Other''' (Any possible status other than Open or Dormant)\n#The ''missing'' deposits should now be selected\n#Click '''View Details''' and choose the '''Deposit Details for selected Members''' chart\n\n:The same process will work for selecting any missing loans.  Simply start be selecting a '''Loan Status''' of '''Open''' and view the '''Loan Details''' when done.\n\n== Trial Balance Report ==\n\nThe main purpose of the '''Trial Balance Reconciliation''' chart is to tie back the totals reported by Vital Signs to the Spectrum Trial Balance (PGNTB) Report.  Like the Spectrum report, the Vital Signs chart is split into two sections: '''Balance by Account''' and '''Balance by Suffix'''.  The grand total of both of these sections should tie back to the Spectrum Report (*).  These total will not, however, match the Vital Signs totals displayed on the Status Bar.  This is because the Spectrum Trial Balance report includes closed shares and loans with a non-zero balance, as well as closed zero-balance shares with the share-draft flag set.  It will also report zero balance loans if they have a non-zero escrow balance.\n\nTo '''fully reconcile''' the differences between the Spectrum report and the Vital Signs Status Bar totals, you need to look at the '''Balance by Suffix''' section.  This section is further broken down into four sub-sections:\n\n#Closed Suffixes: This section reports all closed suffixes that qualify for the Trial Balance.\n#Other Suffixes: This section reports any shares or loans that qualify for the Trial Balance but they are not open and they are also not closed.  Examples are loans with a negative balance (zero credit limit), or improperly closed shares that still have the share-draft flag set.\n#Excluded Suffixes:  Shares and loans in this section are shown with a negative count and negative balance.  These are shares and loans that are '''not included''' in the Trial Balance, but are included in the Open count displayed on the status bar.  Zero balance open shares will be reported here, as well as any description abbreviations or collateral codes that have been specifically excluded from the trial balance.\n#Open Suffixes: This total should match the Vital Signs status Bar, it includes all open shares and loans that are included in the Trial Balance as well as any open products excluded from the Trial Balance (the ones reported separately in ''3. Excluded Suffixes''.\n\n:The sum of these 4 sections: Closed + Other + (-Excluded) + Open should match the Spectrum Trial Balance and the chart Grand Total.\n\n:(*) In some cases the total balances will match, but the counts will be slightly different.  The difference, if there is one, will be in the number of zero balance closed loans being reported."
                    }
                ]
            }
        }
    }
}