# Globals

gvStr:
7/12/2007 4:19:29 AM (Riobel Solutions (Admin Acct))
(ID: 2037) Appointment Results Updated 

7/12/2007 2:57:39 AM (Riobel Solutions (Admin Acct))
New Appointment Created


gvStr:
4/10/2008 4:39:15 AM (Riobel Solutions (Admin Acct))
(ID: 44318) Appointment Results Updated 

4/10/2008 4:38:19 AM (Riobel Solutions (Admin Acct))
New Appointment Created

Description:
Appointment of Sales Interview ID and Comments


gvStr:
1/20/2008 12:07:58 AM (LOPEZ, MARIO)
(ID: 5) Lead result was updated from New Lead to Policy/Acct. (Sale)

1/19/2008 11:40:43 PM (LOPEZ, MARIO)
KEVIN WOULD LIKE MORE INFORMATION ABOUT OBTAINING WHOLE LIFE INS

1/19/2008 11:40:16 PM (LOPEZ, MARIO)
New Lead Created


Description:
Modified by the Bonus & Commission Subreports to avoid details from disqualified scorelines from appearing.


# tblGV

Description:
Field displaying verbiage for adjustments accrued


Description:
Field displaying the verbiage for the adjustments paid


Description:
Shows the option on the ScoreCard Manager to select Commission Only.


Description:
Boolean to Bypass Processing the Application


Description:
Boolean to Bypass the Service Rep Step in Processing


Description:
Number of Months to Require to remain on the books


gvStr:
© 2001-2007  www.riobel.com  All rights reserved.


Description:
Can User Modify the Date field to change the entry date?


Description:
Client Version - # Change to DB_be - #Change to Code. Both the int and str are in use!!!


Description:
EmployeeID of the User receving credit for application


Description:
Starting point for all scorelines extended.


Description:
How many days after the follow-up day before changing the results to no action taken.


Description:
Letter designation for line - used in CIN.


Description:
Amount of Commission for the previous pay-period.


Description:
Enable the calculation of previous pay-period in addition to current pay-period?


Description:
What version of Microsoft Access is in use?


Description:
What version of Microsoft Office is in use?


Description:
Identifies a user classification permitted to view Agency Reports


Description:
Disables/Enables the Quick Link Toolbars


Description:
Identifies a user classification permitted to update an IFR


Description:
Identifies a user classification permitted to update a record.


Description:
Identifies a user classification permitted to verify a Welcome Interview.


Description:
The last user displayed in Personnel Profiles


Description:
Prompt for Additional Records?  (Y or N)


Description:
The Referral/Lead ID to be carried over with Prompts.


Description:
The primary Date sorted by in the Report


Description:
STR(Type of Records in Report)  INT(0 Regular, 1 Pending)


Description:
Show the option on the Endorsements Form


Description:
Require ID for all applications (Agency)


Description:
Require Source of Business for all applications (Agency)


Description:
Require All Funds fields to be filled in


Description:
Require All Health fields to be filled in


Description:
Require All Other fields to be filled in


Description:
Make the Source of Business field required


Description:
Temporarily Stores the Record ID of the service activity to propely compensate.


Description:
Staff Member (Int) and Date (Str) to edit in form


Description:
Mutual Funds Assets Under Management Goal


Description:
Net paid-for Life and/or Annuity Policies


Description:
Update Version is to update the office after a build has already been pushed out.


# tblMenus

sMenuItem:
Charge Back Difference (enter months below)


# tblSelection

Syntax:
(((tblRecords.intCategoryID)=1) OR ((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4) OR ((tblRecords.intCategoryID)=5) OR ((tblRecords.intCategoryID)=7))


# tblSyntax

sSyntax:
SELECT SUM(tblRecords.nCnvtAmount) As vCriteriaValue, SUM(tblRecords.cur01) As vCriteriaValue2

sNotes:
vCriteriaValue2 is used with Life Coverage


sSyntax:
SELECT AVG(tblRecords.nCnvtAmount) As vCriteriaValue, AVG(tblRecords.cur01) As vCriteriaValue2


sSyntax:
SELECT MIN(tblRecords.nCnvtAmount) As vCriteriaValue, MIN(tblRecords.cur01) As vCriteriaValue2


sSyntax:
SELECT MAX(tblRecords.nCnvtAmount) As vCriteriaValue, MAX(tblRecords.cur01) As vCriteriaValue2


sSyntax:
((((tblRecords.intCategoryID)=1) OR ((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4) OR ((tblRecords.intCategoryID)=5) OR ((tblRecords.intCategoryID)=7))


sSyntax:
((((tblRecords.intCategoryID)=8) OR ((tblRecords.intCategoryID)=12) OR ((tblRecords.intCategoryID)=13) OR ((tblRecords.intCategoryID)=14))


sSyntax:
AND (((tblRecords.int00)=1) AND ((tblRecords.bool04)=FALSE) AND ((tblRecords.bool05)=FALSE) AND ((tblRecords.bool06)=FALSE))


sSyntax:
((((tblRecords.intCategoryID)=1) OR ((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4) OR ((tblRecords.intCategoryID)=5) OR ((tblRecords.intCategoryID)=7) OR ((tblRecords.intCategoryID)=10) OR ((tblRecords.intCategoryID)=11))


sSyntax:
AND (((tblRecords.int13)=2) OR ((tblRecords.int13)=3) OR ((tblRecords.int13)=4))


sSyntax:
AND ((((tblRecords.int10)>=35) AND ((tblRecords.int10)<=42)) OR (((tblRecords.int10)>=53) AND ((tblRecords.int10)<=70)) OR (((tblRecords.int10)>=73) AND ((tblRecords.int10)<=88)))


sSyntax:
AND (((tblRecords.int00)=33) OR ((tblRecords.int00)=55) OR ((tblRecords.int00)=56) OR ((tblRecords.int00)=57))


sDescription:
NOT -> Single Premium Immediate Life Annuity


sSyntax:
AND (((tblRecords.int00)<>33) AND ((tblRecords.int00)<>55) AND ((tblRecords.int00)<>56) AND ((tblRecords.int00)<>57))


sSyntax:
AND ((((tblRecords.int00)=1) AND ((tblRecords.bool04)=FALSE) AND ((tblRecords.bool05)=FALSE) AND ((tblRecords.bool06)=FALSE)) OR (((tblRecords.int00)=1) AND ((((tblRecords.int10)>=35) AND ((tblRecords.int10)<=42)) OR (((tblRecords.int10)>=53) AND ((tblRecords.int10)<=70)) OR (((tblRecords.int10)>=73) AND ((tblRecords.int10)<=88)))))


sSyntax:
AND ((((tblRecords.int00)=1) AND ((tblRecords.bool04)=TRUE)) OR (((tblRecords.int00)=1) AND ((((tblRecords.int10)>=35) AND ((tblRecords.int10)<=42)) OR (((tblRecords.int10)>=53) AND ((tblRecords.int10)<=70)) OR (((tblRecords.int10)>=73) AND ((tblRecords.int10)<=88)))))


sSyntax:
AND ((((tblRecords.int00)=1) AND ((tblRecords.bool04)=TRUE)) AND (((tblRecords.int00)=1) AND (((tblRecords.int10)<35)) OR (((tblRecords.int10)>42 And (tblRecords.int10)<53)) OR (((tblRecords.int10)>70 And (tblRecords.int10)<73)) OR (((tblRecords.int10)>88))))


sSyntax:
AND (((tblRecords.int00)=131) OR ((tblRecords.int00)=137) OR ((tblRecords.int00)=37) OR ((tblRecords.int00)=33) OR ((tblRecords.int00)=55) OR ((tblRecords.int00)=56) OR ((tblRecords.int00)=57) OR ((tblRecords.int00)=16))


sSyntax:
AND (((tblRecords.int00)=35) OR ((tblRecords.int00)=18) OR ((tblRecords.int00)=110) OR ((tblRecords.int00)=38) OR ((tblRecords.int00)=17) OR ((tblRecords.int00)=36) OR ((tblRecords.int00)=15) OR ((tblRecords.int00)=30) OR ((tblRecords.int00)=34) OR ((tblRecords.int00)=31) OR ((tblRecords.int00)=14))


sSyntax:
AND (((tblRecords.int00)<>35) AND ((tblRecords.int00)<>18) AND ((tblRecords.int00)<>110) AND ((tblRecords.int00)<>38) AND ((tblRecords.int00)<>17) AND ((tblRecords.int00)<>36) AND ((tblRecords.int00)<>15) AND ((tblRecords.int00)<>30) AND ((tblRecords.int00)<>34) AND ((tblRecords.int00)<>31) AND ((tblRecords.int00)<>14))


sSyntax:
AND (((tblRecords.int00)<>131) AND ((tblRecords.int00)<>137) AND ((tblRecords.int00)<>37) AND ((tblRecords.int00)<>33) AND ((tblRecords.int00)<>55) AND ((tblRecords.int00)<>56) AND ((tblRecords.int00)<>57) AND ((tblRecords.int00)<>16))


sSyntax:
AND (((tblRecords.int00)=22) OR ((tblRecords.int00)=27) OR ((tblRecords.int00)=23) OR ((tblRecords.int00)=69) OR ((tblRecords.int00)=63) OR ((tblRecords.int00)=62))


sSyntax:
AND (((tblRecords.int00)=20) OR ((tblRecords.int00)=21)  OR ((tblRecords.int00)=59) OR ((tblRecords.int00)=61) OR ((tblRecords.int00)=60))


sSyntax:
AND (((tblRecords.int00)<>22) AND ((tblRecords.int00)<>26) AND ((tblRecords.int00)<>27) AND ((tblRecords.int00)<>23) AND ((tblRecords.int00)<>69) AND ((tblRecords.int00)<>63) AND ((tblRecords.int00)<>62))


sSyntax:
AND (((tblRecords.int00)<>20) AND ((tblRecords.int00)<>21) AND ((tblRecords.int00)<>59) AND ((tblRecords.int00)<>61) AND ((tblRecords.int00)<>60))


sSyntax:
AND (((tblRecords.int00)=27) OR ((tblRecords.int00)=28) OR ((tblRecords.int00)=62) OR ((tblRecords.int00)=63) OR ((tblRecords.int00)=69))


sSyntax:
AND (((tblRecords.int00)<>27) AND ((tblRecords.int00)<>28) AND ((tblRecords.int00)<>62) AND ((tblRecords.int00)<>63) AND ((tblRecords.int00)<>69))


sSyntax:
AND (((tblRecords.int01)=5) OR ((tblRecords.int01)=6) OR ((tblRecords.int01)=7) OR ((tblRecords.int01)=10))


sDescription:
Multi-Lined w/ Individual Credit Disibility


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=1)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=2)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=7)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=5)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4))


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=10)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=11)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=1) OR ((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4) OR ((tblRecords.intCategoryID)=5) OR ((tblRecords.intCategoryID)=7) OR ((tblRecords.intCategoryID)=10) OR ((tblRecords.intCategoryID)=11))


sSyntax:
AND (((tblRecords.int00)=118) OR ((tblRecords.int00)=119) OR ((tblRecords.int00)=120))


sSyntax:
((((tblRecords.intCategoryID)=8) OR ((tblRecords.intCategoryID)=13) OR ((tblRecords.intCategoryID)=14)) AND (((tblRecords.intIFR)=62) OR ((tblRecords.intIFR)=63))


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4))


sSyntax:
AND (((tblRecords.int00)<>118) AND ((tblRecords.int00)<>119) AND ((tblRecords.int00)<>120))


sSyntax:
AND (((tblRecords.int00)<>109) AND ((tblRecords.int00)<>121) AND ((tblRecords.int00)<>122))


sSyntax:
AND (((tblRecords.int00)=18) OR ((tblRecords.int00)=30) OR ((tblRecords.int00)=34) OR ((tblRecords.int00)=36))


sSyntax:
AND (((tblRecords.int00)<>18) AND ((tblRecords.int00)<>30) AND ((tblRecords.int00)<>34) AND ((tblRecords.int00)<>36))


sSyntax:
AND (((tblRecords.int00)=30) OR ((tblRecords.int00)=31) OR ((tblRecords.int00)=34))


sSyntax:
AND (((tblRecords.int00)<>30) AND ((tblRecords.int00)<>31) AND ((tblRecords.int00)<>34))


sSyntax:
AND (((tblRecords.int00)=10) OR ((tblRecords.int00)=11) OR ((tblRecords.int00)=39))


sSyntax:
AND (((tblRecords.int00)<>10) AND ((tblRecords.int00)<>11) AND ((tblRecords.int00)<>39))


sSyntax:
AND (((tblRecords.int00)=109) OR ((tblRecords.int00)=121) OR ((tblRecords.int00)=122))


sSyntax:
((((tblRecords.intCategoryID)=10) OR ((tblRecords.intCategoryID)=11) OR ((tblRecords.intCategoryID)=7 AND (((tblRecords.int00)=30) OR ((tblRecords.int00)=31) OR ((tblRecords.int00)=34) OR ((tblRecords.int00)=109) OR ((tblRecords.int00)=121) OR ((tblRecords.int00)=122))))


sSyntax:
AND (((tblRecords.int00)=1) OR ((tblRecords.int00)=2) OR ((tblRecords.int00)=3) OR ((tblRecords.int00)=5) OR ((tblRecords.int00)=7) OR ((tblRecords.int00)=10) OR ((tblRecords.int00)=11) OR ((tblRecords.int00)=19))


sSyntax:
AND (((tblRecords.int10)=55) OR ((tblRecords.int10)=57) OR ((tblRecords.int10)=54) OR ((tblRecords.int10)=58))


sSyntax:
AND (((tblRecords.int10)=59) OR ((tblRecords.int10)=60) OR ((tblRecords.int10)=61))


sSyntax:
AND (((tblRecords.int10)=55) OR ((tblRecords.int10)=57) OR ((tblRecords.int10)=60) OR ((tblRecords.int10)=61))


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=1)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=2)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=7)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=5)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.intRecordID, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int11, tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4))


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=10)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE (((tblRecords.intCategoryID)=11)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4))


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=1) OR ((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4) OR ((tblRecords.intCategoryID)=5) OR ((tblRecords.intCategoryID)=7) OR ((tblRecords.intCategoryID)=10) OR ((tblRecords.intCategoryID)=11)


sSyntax:
AND (((tblRecords.int00)=1) OR ((tblRecords.int00)=2) OR ((tblRecords.int00)=3) OR ((tblRecords.int00)=5) OR ((tblRecords.int00)=7) OR ((tblRecords.int00)=10) OR ((tblRecords.int00)=11))


sSyntax:
SELECT COUNT(*) As vCriteriaValue FROM tblBonusDeductions WHERE (((tblBonusDeductions.intCategoryID)=6)


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=1) OR ((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4) OR ((tblRecords.intCategoryID)=5) OR ((tblRecords.intCategoryID)=7))


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered,  tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=10) OR ((tblRecords.intCategoryID)=11))


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=1) OR ((tblRecords.intCategoryID)=2) OR ((tblRecords.intCategoryID)=3) OR ((tblRecords.intCategoryID)=4) OR ((tblRecords.intCategoryID)=5) OR ((tblRecords.intCategoryID)=7))


sSyntax:
SELECT tblRecords.nCnvtAmount As vCriteriaValue, tblRecords.intRecordID, tblRecords.dteDate, tblRecords.dteChargeBack, tblRecords.dtePolicyEntered, tblRecords.int12 FROM tblRecords WHERE ((((tblRecords.intCategoryID)=10) OR ((tblRecords.intCategoryID)=11))


sSyntax:
ACTUAL vs PERSONAL PLANNING Scoreline to be run.


sSyntax:
ACTUAL vs AGENCY PLANNING Scoreline to be run.


sSyntax:
AND (((tblRecords.int00)=1) OR ((tblRecords.int00)=2) OR ((tblRecords.int00)=3) OR ((tblRecords.int00)=5) OR ((tblRecords.int00)=7))


sSyntax:
AND (((tblRecords.int03)=39) OR ((tblRecords.int03)=42) OR ((tblRecords.int03)=110))


sSyntax:
AND (((tblRecords.bool03)=TRUE) AND (((tblRecords.nMultiLined)=14) OR ((tblRecords.nMultiLined)=15) OR ((tblRecords.nMultiLined)=16) OR ((tblRecords.nMultiLined)=17) OR ((tblRecords.nMultiLined)=18) OR ((tblRecords.nMultiLined)=30) OR ((tblRecords.nMultiLined)=31) OR ((tblRecords.nMultiLined)=32) OR ((tblRecords.nMultiLined)=33) OR ((tblRecords.nMultiLined)=34) OR ((tblRecords.nMultiLined)=35) OR ((tblRecords.nMultiLined)=36) OR ((tblRecords.nMultiLined)=37) OR ((tblRecords.nMultiLined)=38) OR ((tblRecords.nMultiLined)=55) OR ((tblRecords.nMultiLined)=56) OR ((tblRecords.nMultiLined)=57) OR ((tblRecords.nMultiLined)=58) OR ((tblRecords.nMultiLined)=109) OR ((tblRecords.nMultiLined)=110) OR ((tblRecords.nMultiLined)=121) OR ((tblRecords.nMultiLined)=122) OR ((tblRecords.nMultiLined)=124) OR ((tblRecords.nMultiLined)=131) OR ((tblRecords.nMultiLined)=132) OR ((tblRecords.nMultiLined)=133) OR ((tblRecords.nMultiLined)=134) OR ((tblRecords.nMultiLined)=135) OR ((tblRecords.nMultiLined)=137))


sSyntax:
AND (((tblRecords.bool03)=TRUE) AND (((tblRecords.nMultiLined)=7) OR ((tblRecords.nMultiLined)=8) OR ((tblRecords.nMultiLined)=9) OR ((tblRecords.nMultiLined)=10) OR ((tblRecords.nMultiLined)=11) OR ((tblRecords.nMultiLined)=12) OR ((tblRecords.nMultiLined)=39) OR ((tblRecords.nMultiLined)=41) OR ((tblRecords.nMultiLined)=42) OR ((tblRecords.nMultiLined)=118) OR ((tblRecords.nMultiLined)=119) OR ((tblRecords.nMultiLined)=120))


sSyntax:
SELECT COUNT(*) As vCriteriaValue FROM tblBonusDeductions WHERE (((tblBonusDeductions.intCategoryID)=21)


sSyntax:
SELECT COUNT(*) As vCriteriaValue FROM tblBonusDeductions WHERE (((tblBonusDeductions.intCategoryID)=20)


sDescription:
NOT -> Src of Busn = "Centers Influence"


sDescription:
NOT -> Src of Busn = "Existing Business"


sDescription:
NOT -> Src of Busn = "Referred Business"


sSyntax:
SCORECARD LEVEL ACHIEVED (ScoreCard ID to RUN)


sSyntax:
AND (((tblRecords.int01)=3) OR ((tblRecords.int01)=4) OR ((tblRecords.int01)=5) OR ((tblRecords.int01)=6) OR ((tblRecords.int01)=7) OR ((tblRecords.int01)=10))


sSyntax:
AND (((tblRecords.int01)=22) OR ((tblRecords.int01)=27) OR ((tblRecords.int01)=23) OR ((tblRecords.int01)=69) OR ((tblRecords.int01)=63) OR ((tblRecords.int01)=62) OR ((tblRecords.int01)=28))


sSyntax:
AND (((tblRecords.int01)=20) OR ((tblRecords.int01)=21)  OR ((tblRecords.int01)=61) OR ((tblRecords.int01)=60) OR ((tblRecords.int00)=221) OR ((tblRecords.int00)=221) OR ((tblRecords.int00)=221))


sSyntax:
AND (((tblRecords.int13)=1) OR ((tblRecords.int13)=3) OR ((tblRecords.int13)=4))


sSyntax:
AND (((tblRecords.int01)=2) OR ((tblRecords.int01)=3) OR ((tblRecords.int01)=4) OR ((tblRecords.int01)=5) OR ((tblRecords.int01)=6) OR ((tblRecords.int01)=7) OR ((tblRecords.int01)=10))


sSyntax:
AND (((tblRecords.int01)=4) OR ((tblRecords.int01)=5) OR ((tblRecords.int01)=6) OR ((tblRecords.int01)=7) OR ((tblRecords.int01)=10))


sSyntax:
AND (((tblRecords.int01)=6) OR ((tblRecords.int01)=7) OR ((tblRecords.int01)=10))


sSyntax:
Qualifier: SCORELINE LEVEL ACHIEVED (ScoreLine ID to RUN)


sSyntax:
Qualifier: SCORECARD LEVEL ACHIEVED (ScoreCard ID to RUN)


sSyntax:
SCORELINE LEVEL ACHIEVED (ScoreLine ID to RUN)


sSyntax:
AND (((tblRecords.int01)=1) OR ((tblRecords.int01)=9) OR ((tblRecords.int01)=2) OR ((tblRecords.int01)=3))


sSyntax:
AND (((tblRecords.int01)=1) OR ((tblRecords.int01)=9) OR ((tblRecords.int01)=2) OR ((tblRecords.int01)=3) OR ((tblRecords.int01)=4))


sSyntax:
AND (((tblRecords.int01)=1) OR ((tblRecords.int01)=9) OR ((tblRecords.int01)=2) OR ((tblRecords.int01)=3) OR ((tblRecords.int01)=4) OR ((tblRecords.int01)=10))


sSyntax:
AND (((tblRecords.int01)=1) OR ((tblRecords.int01)=9) OR ((tblRecords.int01)=2) OR ((tblRecords.int01)=3) OR ((tblRecords.int01)=4) OR ((tblRecords.int01)=10) OR ((tblRecords.int01)=5))


sSyntax:
AND (((tblRecords.int01)=1) OR ((tblRecords.int01)=9) OR ((tblRecords.int01)=2) OR ((tblRecords.int01)=3) OR ((tblRecords.int01)=4) OR ((tblRecords.int01)=10) OR ((tblRecords.int01)=5) OR ((tblRecords.int01)=6))


sSyntax:
AND (((tblRecords.int01)=1) OR ((tblRecords.int01)=9) OR ((tblRecords.int01)=2) OR ((tblRecords.int01)=3) OR ((tblRecords.int01)=4) OR ((tblRecords.int01)=10) OR ((tblRecords.int01)=5) OR ((tblRecords.int01)=6) OR ((tblRecords.int01)=7))


sSyntax:
AND (((tblRecords.bool03)=TRUE) AND (((tblRecords.nMultiLined)=248) OR ((tblRecords.nMultiLined)=247) OR ((tblRecords.nMultiLined)=255)))


sSyntax:
AND (((tblRecords.bool03)=TRUE) AND (((tblRecords.nMultiLined)=248) OR ((tblRecords.nMultiLined)=247)))


sSyntax:
AND (((tblRecords.bool03)=TRUE) AND (((tblRecords.nMultiLined)=248) OR ((tblRecords.nMultiLined)=255)))


sSyntax:
AND (((tblRecords.bool03)=TRUE) AND (((tblRecords.nMultiLined)=9)) OR ((tblRecords.nMultiLined)=42)) OR ((tblRecords.nMultiLined)=41)))


sSyntax:
AND (((tblRecords.bool03)=TRUE) AND (((tblRecords.nMultiLined)=20)) OR ((tblRecords.nMultiLined)=21)) OR ((tblRecords.nMultiLined)=61)) OR ((tblRecords.nMultiLined)=60)))


# tmpProducts

sProductName:
Home Mortgage Loan Refinance - Previous SF


