correspondent.bankofinternet.comMortgage Director Technical Wiki - Mortgage Director Technical Wiki - Confluence

Skip to content Skip to breadcrumbs Skip to header menu Skip to action menu Skip to quick search Linked Applications Loading… Spaces Create Hit enter to search Help Online Help Keyboard Shortcuts Feed Builder What’s new Available Gadgets About Confluence Log in Mortgage Director Technical Wiki Search Page tree Browse pages Configure Space tools A t tachments (2) Page History People who can view Page Information Resolved comments View in Hierarchy View Source Export to PDF Export to Word Copy Pages Skip to end of banner Jira links Go to start of banner Mortgage Director Technical Wiki Skip to end of metadata Created by Fiona Rice , last modified on Oct 08, 2020 Go to start of metadata Welcome to the Mortgage Director Technical Wiki, a resource for getting into the nitty gritty of our products. This guide provides information on how to connect with our LOS externally, and unique methods for to handling data from within the LOS itself. Search this documentation Search PRICE API User Guide This guide covers all the calls available in our API. Each method page identifies which version of the LOS the method became available. Additionally, the ICE to PRICE table has a list of calls we plan on converting from our old web service to our new, external web service and which release or quarter they can be expected in. Contents: Click here to expand... Endpoint Index Endpoints by LOS Version Error Codes PRICE FAQ Credentials: AppSecret ICE Migration to PRICE Asset Endpoints Company Management Creating a Loan: Endpoints & Instructions Credit Endpoints Data Check Endpoints Data Upload Endpoints Date Endpoints Deposit Endpoints Extra & Virtual Data Endpoints Fee Endpoints Income Endpoints Liability Endpoints Loan Endpoints Notification Endpoints Password Endpoints Person Record Endpoints Pricing/Locking Endpoints Property Endpoints LOS Configuration Endpoints Secondary Endpoints Security Endpoints Session Management Task Item & Document Management Vendor Integration Endpoints Conversation Log Endpoints PRICE API User Guide Files PRICE Method Apps Correspondent Endpoints TPO Endpoints Interface Management Other Endpoints PAL Dictionary Designed to be used alongside our existing Data Language , this programming language leverages the Pascal programming language to allow a more dynamic output of information. Contents: Click here to expand... Pascal for PAL Quick Guide Reducing the need for Classic Data Language - Loan Object Abs AddReadableNumberSuffix AmountToWords Assigned AnsiLowerCase AnsiUpperCase B64UrlDecode B64UrlEncode Base64Decode Base64Encode BooleanToTF BooleanToTrueFalse BooleanToYesNo BooleanToYN Ceiling ContainsText Copy Cos DateOf DayOf DayOfTheWeek DayOfTheYear DaysBetween DupeString EndOfAMonth EndOfAQuarter EndOfAYear EndOfTheDay EndOfTheMonth EndOfTheQuarter EndOfTheWeek EndOfTheYear EndsText FloatToStr Floor Format Characters FormatDateTime FormatFloat FuzzyStringToFloat FuzzyStringToInteger FuzzyVariantToString GetStateAbbreviation GetStateHMDACode GetStateName GMTNow GUIDString HourOf HoursBetween HS256 IfThenInteger IfThenString IfThenValue IncDay IncMonth IncWeek IncYear Int IntToStr IsZero Length MatchesMask Max Min MinuteOf MinutesBetween MonthOf MonthsBetween Now Pi Pos PosEx ProcessString QuarterOf QuotedStr Random RandomFrom RandomIntegerFrom RandomRange ReplaceText Replicate Round SameDate SameDateTime SameNumber SameText SecondOf SecondsBetween Sin Sqrt StartOfAMonth StartOfAQuarter StartOfAYear StartOfTheDay StartOfTheMonth StartOfTheQuarter StartOfTheWeek StartOfTheYear StartsText StringArrayToVarArray StringIsANumber StringIsEmpty StringIsFalse StringIsTrue StringOfChar StringsAreEqual StrToCurr StrToCurrDef StrToDateTime StrToDateTimeDef StrToFloat StrToInt StrToIntDef Today (PAL) Tomorrow Trim TrimLeft TrimRight Trunc URLDecode URLEncode UTCString VarArrayAsCommaText VarArrayAsText VarArrayCreate VarArrayDimCount VarArrayGetValue VarArrayHighBound VarArrayLowBound VarArrayToStringArray VarIsArray VarIsBlank VarIsFloat VarIsNumeric VarIsStr VarToDateTime VarToIntDef VarToStr VarToStrDef WeekOfTheYear WeeksBetween YearOf YearsBetween Yesterday PAL Custom Functions and Procedures Data Language Dictionary A comprehensive list of our internal data language methods, including examples and proper syntax. For a list of screen-specific data language calls, see our data language guide . Customers who have access to our Customer Portal on SharePoint may view our database schema here . Contents: Click here to expand... Format Strings ihAppend ihAscii ihAssigned ihCall ihChar ihClear ihCondition ihData ihDateCalculation ihDateMath ihDateToNumber ihElse ihExit ihField ihFile ihFind ihFindSum ihForEach ihForm ihFunction ihGet ihGetKey ihIf ihIIF ihIncrement ihInfo ihInteger ihIsEmpty ihLeftTrim ihLength ihLowerCase ihMath ihMinimum ihNextKey ihNoOp ihNumberSpeak ihPad ihReadableNumberSuffix ihReplace ihRightTrim ihScan ihSet ihSubStr ihTrim ihUpperCase ihRange Screen Link Guide A comprehensive list of screen links, which allow users to link directly to fields from our data checks and overview tabs. Contents: Click here to expand... Accessing 1003 Fields Accessing Assets (draft) Accessing Borrowers Accessing Contacts on the Loan Data Tree Accessing Fields on the Mortgage Data Screen Accessing Incomes Accessing Liabilities Useful PAL, DL and Grids A comprehensive list of the most commonly requested data language. Contents: Click here to expand... All Liability Types Present Comparing S/E Companies Customization on Report Grids Previously Requested Data Language Screen Link to First Blank Liabilities ADO Driver Information on how to use our ADO connection, including guides on how to connect with Excel and with Crystal Reports, is stored here. For troubleshooting tips, see the troubleshooting page . Additional issues should be sent to your customer service representative. Contents: Click here to expand... Troubleshooting Command Line Export An explanation on how to pull information from the LOS via Window's command line. Contents: Click here to expand... How to... Step-by-step guides for all our products can be found here. Contents: Click here to expand... Add a Data Check Bulk Data Extract Create a UDL File Download the LOS Find the Base URL for PRICE Force an ELF Log Generate a Report for Loans Modified in the Last Hour Google Analytics Workaround Handle Large GET Methods Pass LSZ Codes Through a DU File Import Retrieve a StatusID Use SSIS to export table from PCLender LOS using IHM ADO FAQ Questions that are posed with some frequency are collected and posted in a comprehensive resource. These are divided by product, to assist with finding an answer faster. Contents: Click here to expand... 2FA & Soft Password Reset FAQ ADO FAQ Database FAQ Questions? Feedback? Get in touch with us at wiki@pclender.com Acronyms 2FA - Two - F actor A uthentication ADO - A ctiveX D ata O bject API - A pplication P rogramming I nterface DU - D ocument U nderwriter ELF - E xecutable and L inkable F ormat ICE - I nternet C ommunications E ngine IHM - I n H ouse M ortgage LEI - L egal E ntity I dentifier LOS - L oan O rigination S ystem LSZ - customs tags made specifically for importing additional information into DU PAL - P CLender A pplication L anguage PRICE - P ublicly R eachable I nternet C ommunications E ngine SQL - S tructured Q uery L anguage SSIS - S QL S erver I ntegration S ervices ULD - U nified L uminaire D ata ULI - U niversal L oan I dentifier URL - U niform R esource L ocator No labels Overview Content Tools Powered by Atlassian Confluence 7.3.5 Printed by Atlassian Confluence 7.3.5 Report a bug Atlassian News Atlassian...