OREGON EPERMITTING
  • Blog
  • Meet our Team
  • Facts
  • Contact Us
  • Accela Upgrade Information
  • Jurisidiction HUB
  • Blog
  • Meet our Team
  • Facts
  • Contact Us
  • Accela Upgrade Information
  • Jurisidiction HUB

Stay in the know

What Happens when the Displayed Record Number or Alt_id is Changed?

1/4/2021

0 Comments

 
First did you know that all records – permits, applications, and licenses have a unique identification code within their agency called the Record Id?  The Record Id often appears in the extreme right hand column on the Building or Record List portlet. 

The Record Id is used to link all of the components – like custom fields, owner, site address, parcel, inspections and work flow – to the record.  In the data base each of these components represents a table. 

The Record Number exists in two places in the data base – the main table for the record (B1PERMIT) and the table that includes all the financial transactions for the record (ACCOUNTING_AUDIT_TRAIL) starting when fees are invoiced.  Both tables have the Record Id as well.  The table with the financial transactions copies the Record Number from the main table for records for each step in financial transactions.
​
The Record Number can be modified on the ‘Description of Work/Copy Recs (Unrelated)’ portlet.  When the Record Number is modified, the date the modification occurred can be found by using the ‘View Log’ button on the ‘Description of Work/Copy Recs (Unrelated)’ portlet.

When reports are run, the report will show the Record Number as it existed at run time.  This is not a problem unless a report was run that shows the original system generated Record Number and subsequent report was run that show the modified Record Number. 

The problems can be increased when report results end up as a documents attached to the record.  It is possible to have  documents with different Record Numbers attached to the same record.

Reports include invoices, receipts, permits and applications as well as tabular reports like Permits Issued.

To prevent these problems either never change the Record Number or only change the Record Number before invoicing fees and an application is printed.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Disclaimer

    Please be aware that this content is relevant at the time it is published, but as time goes on may become out-of-date. We will do our best to keep the content alive and relevant.

    Archives

    December 2022
    October 2022
    August 2022
    May 2022
    April 2022
    March 2022
    January 2022
    August 2021
    March 2021
    January 2021
    July 2020
    April 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    August 2019
    June 2019
    April 2019
    January 2019
    November 2018
    October 2018
    September 2018
    August 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017

    Categories

    All
    In The Spotlight
    Online Training
    OSM Best Practice
    OSM Changes
    OSM Future Implementations
    Projects
    Reminders
    Tips And Tricks
    What's New

    RSS Feed

Jurisdiction Resources

ePermitting Knowledgebase
Register for ePermitting Brochure
Inspection Codes Brochure
Modelo Estandar de Oregon Codigos de inspeccion
SelecTXT Brochure
IVR Call Flow Brochure Insert
End of Day Report
ePermitting Advertising Business Cards
​Building Department Directory

Participating Jurisdictions
​​
© COPYRIGHT 2019. ALL RIGHTS RESERVED.