{"id":1240,"date":"2015-09-18T08:50:01","date_gmt":"2015-09-18T13:50:01","guid":{"rendered":"https:\/\/danvanfleet.com\/?p=1240"},"modified":"2015-09-18T09:31:19","modified_gmt":"2015-09-18T14:31:19","slug":"lookup-tables-with-proform-classic-on-cd-page-2","status":"publish","type":"post","link":"https:\/\/danvanfleet.com\/index.php\/lookup-tables-with-proform-classic-on-cd-page-2\/","title":{"rendered":"Lookup Tables with ProForm Classic on CD Page 2"},"content":{"rendered":"

\"image\"<\/a>How do the Closing Disclosure Lookup Tables work with ProForm Classic 15 and 20? <\/p>\n

The first thing to wrap our heads around is, each section on page 2 of the CD in ProForm Classic 15 and 20 all come from one screen. On a purchase, there are 10 text positions to store lookup tables for pretty much the entire CD. Lookups for Surveyor, Pest Inspector, Tax Fees, HOA, Home Inspectors, and more all need to fit. That is going to require some thought as to how to lay out the data so that it’s easiest to use.<\/p>\n

<\/p>\n

 <\/p>\n

The fields that can have lookup tables on the CD in Classic 15, and likely 20 are all visible on this screen shot.<\/p>\n

\"clip_image001\"<\/a><\/p>\n

Here is a lookup table definition that fills out all of the fields. Use it in on different fields to refer to different data sets <\/p>\n

\nChargeToName = ToName
ChargeDescription = Description
ChargeBpac= BPaidAtClosing
ChargeSpAc = SPaidAtClosing
ChargeReference = Reference
ChargeDS = DS
ChargeAdr1 = Address
ChargeAdr2 = CityStateZip
ChargeCalcType = CalcType
ChargeCostPaidMethod = PaidMethod
ChargeBpBc = BPaidBefore
ChargeSpBC = SPaidBefore
ChargePBO = PaidByOthers
ChargeProcessAs = ProcessAs
ChargePaidBy = PaidBy
ChargeLoanEstimate = LoanEstimate
ChargeFeeType = FeeType<\/p>\n

There are 2 other fields that currently don’t appear to be able to be added to these lookup tables.<\/p>\n

ChargeSellerPayPercent = SellerPercent
ChargeToleranceCategory =ToleranceCat<\/p>\n

Both would seem to be necessarily added in some service pack. Also be aware the ChargeSellerPayPercent field can not have a lookup table associated with it. <\/p>\n

Note: Refinance deals won’t be able to access the lookup tables on ChargeSpAC and ChargeSpBC,the Seller-Paid items.<\/p>\n

In this example we will add a lookup table to the new fields each pointing to different data tables. The display order will remain the same starting with who’s being paid, what it’s for, and who’s paying it. Change the order as you desire, ProForm will display the columns in the order displayed here. (proTip, the order can be changed later, as long as you’re careful) <\/p>\n

I’ve already created some tables on this screen so I’m starting on the Borrower-Paid at Closing field, you can start on the Description field.<\/p>\n

\"clip_image002\"<\/a>Pressing F9 shows the create lookup window.<\/p>\n

Click Yes<\/p>\n

 <\/p>\n

Paste the above definition in the text box replacing what is there<\/p>\n

\"clip_image003\"<\/a><\/p>\n

 <\/p>\n

Leave the Table Name as is, or change it as you like.  It’s even possible to connect to an existing table, but for this example we’re simply creating new blank tables<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

I always backspace out any blank lines, not doing that sent ProForm into a tailspin at one time.  <\/p>\n

\"clip_image004\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Click OK and the table is ready for data<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\"clip_image005\"<\/a><\/p>\n

 <\/p>\n

In this case I’m creating lookup tables for all of these fields, so click Close. Tab to the next field, Press F9 and repeat until done.<\/p>\n

Another Pro-tip I recently found, To put lookup tables on drop down lists press <Ctlr> L.<\/p>\n

We can easily have 12 different base types of lookup tables. Surveyor and Pest Inspector and others can still be under different tables, rather than grouped in one big unwieldy list.<\/p>\n

What if more than 12 lookups are needed? You can use this <Ctrl> L tip to add 6 more.<\/p>\n

What if more than 18 lookups are needed? There may be options that need tested, contact Dan for up to date information.<\/p>\n","protected":false},"excerpt":{"rendered":"

How do the Closing Disclosure Lookup Tables work with ProForm Classic 15 and 20? The first thing to wrap our heads around is, each section on page 2 of the CD in ProForm Classic 15 and 20 all come from one screen. On a purchase, there are 10 text positions to store lookup tables for […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23],"tags":[42,38,28,21,17,41],"class_list":["post-1240","post","type-post","status-publish","format-standard","hentry","category-softpro-2","tag-cd","tag-cfpb","tag-lookup","tag-proform","tag-tips","tag-trid","entry"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wyVb-k0","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/comments?post=1240"}],"version-history":[{"count":5,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1240\/revisions"}],"predecessor-version":[{"id":1245,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1240\/revisions\/1245"}],"wp:attachment":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/media?parent=1240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/categories?post=1240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/tags?post=1240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}