0c <aNAMECDFILEC QUERYC)úTYPEC#QLOCKL$QFLOCKL%VLOCKL&MLISTL'QF1C( QT1C2QOP1C3QFF1CLQV1CjxQF2Câ QT2CìQOP2CíQFF2CQV2C$xQF3Cœ QT3C¦QOP3C§QFF3CÀQV3CÞxQF4CV QT4C`QOP4CaQFF4CzQV4C˜xDATASOURCEC(RELATIONALL8LINKTABLESC9( All Records MEMBER .t. BTT T Members F"MEMBER" Roster MEMBER INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE","INACTIVE") BT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE","INACTIVE") Members F"MEMBER" Associate Members MEMBER INLIST(MEMBER.TYPE,"ASSOCIATE") BT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE") Members F"MEMBER" Insurance Members MEMBER INLIST(MEMBER.TYPE,"INSURANCE") BT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"INSURANCE") Members F"MEMBER" Inactive Members MEMBER INLIST(MEMBER.TYPE,"INACTIVE") BT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"INACTIVE") Members F"MEMBER" Applicant MEMBER INLIST(MEMBER.TYPE,"APPLICANT") BT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"APPLICANT") Members F"MEMBER" Candidates MEMBER INLIST(MEMBER.TYPE,"CANDIDATE") BT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"CANDIDATE") Members F"MEMBER" Knight Alert Billing Status MEMBER INLIST(MEMBER.BILLSTATUS,"KNIGHT ALERT") BT TBILLSTATUSCEqual To MEMBER.BILLSTATUS INLIST(MEMBER.BILLSTATUS,"KNIGHT ALERT") Members F"MEMBER" Status Change MEMBER INLIST(MEMBER.BILLSTATUS,"STATUS CHANGE") BT TBILLSTATUSCEqual To MEMBER.BILLSTATUS INLIST(MEMBER.BILLSTATUS,"STATUS CHANGE") Members F"MEMBER" Inactive And Insurance MembersMEMBER INLIST(MEMBER.TYPE,"INACTIVE","INSURANCE") BT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"INSURANCE","INACTIVE") Members F"MEMBER" First Degree Members MEMBER INLIST(MEMBER.DEGREE,"1st") BT TDEGREE CEqual To MEMBER.DEGREE INLIST(MEMBER.DEGREE,"1st") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Second Degree Members MEMBER INLIST(MEMBER.DEGREE,"2nd") .and. inlist(MEMBER.TYPE,'INSURANCE','ASSOCIATE') BT TDEGREE CEqual To MEMBER.DEGREE INLIST(MEMBER.DEGREE,"2nd") TYPE CEqual To MEMBER.TYPE inlist(MEMBER.TYPE,'INSURANCE','ASSOCIATE') Members F"MEMBER" Third Degree Members MEMBER INLIST(MEMBER.DEGREE,"3rd") .and. INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") BT TDEGREE CEqual To MEMBER.DEGREE INLIST(MEMBER.DEGREE,"3rd") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Fourth Degree Members MEMBER INLIST(MEMBER.DEGREE,"4th") BT TDEGREE CEqual To MEMBER.DEGREE INLIST(MEMBER.DEGREE,"4th") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Single Member MEMBER BTT F Members F"MEMBER" Quarterly Payers MEMBER INLIST(MEMBER.FREQUENCY,"QUARTERLY") B FFREQUENCY CEqual To MEMBER.FREQUENCY INLIST(MEMBER.FREQUENCY,"QUARTERLY") Members F"MEMBER" Bill 1st Quarter MEMBER INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") .and. (.NOT. MEMBER.DEAD) .and. member.payment>0 BT FTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") DEAD L.NOT. MEMBER.DEAD (.NOT. MEMBER.DEAD) NOBILL L.NOT. MEMBER.NOBILL (.NOT. MEMBER.NOBILL) Members F"MEMBER" Bill 2nd Quarter MEMBER INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") .and. (.NOT. MEMBER.DEAD) .and. INLIST(MEMBER.FREQUENCY,"QUARTERLY") .and. member.payment>0 BTF FTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") DEAD L.NOT. MEMBER.DEAD (.NOT. MEMBER.DEAD) NOBILL L.NOT. MEMBER.NOBILL (.NOT. MEMBER.NOBILL) FREQUENCY CEqual To MEMBER.FREQUENCY INLIST(MEMBER.FREQUENCY,"QUARTERLY") Members F"MEMBER" Bill 3rd Quarter MEMBER INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") .and. (.NOT. MEMBER.DEAD) .and. INLIST(MEMBER.FREQUENCY,"QUARTERLY","SEMI-ANNUAL") .and. member.payment>0 BTF FTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") DEAD L.NOT. MEMBER.DEAD (.NOT. MEMBER.DEAD) NOBILL L.NOT. MEMBER.NOBILL (.NOT. MEMBER.NOBILL) FREQUENCY CEqual To MEMBER.FREQUENCY INLIST(MEMBER.FREQUENCY,"QUARTERLY","SEMI-ANNUAL") Members F"MEMBER" Bill 4th Quarter MEMBER INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") .and. (.NOT. MEMBER.DEAD) .and. INLIST(MEMBER.FREQUENCY,"QUARTERLY") .and. member.payment>0 BTF FTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") DEAD L.NOT. MEMBER.DEAD (.NOT. MEMBER.DEAD) NOBILL L.NOT. MEMBER.NOBILL (.NOT. MEMBER.NOBILL) FREQUENCY CEqual To MEMBER.FREQUENCY INLIST(MEMBER.FREQUENCY,"QUARTERLY") Members F"MEMBER" Membership Cards MEMBER INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") .and. (.NOT. MEMBER.DEAD) .and. MEMBER.PAIDTHRU > MEMBER.PRINTTHRU .and. MEMBER.PAIDTHRU > DATE() BTTFTTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"INSURANCE","ASSOCIATE") DEAD L.NOT. MEMBER.DEAD (.NOT. MEMBER.DEAD) PAIDTHRU DGreater Than COUNCIL.PAYTO1ST MEMBER.PAIDTHRU > MEMBER.PRINTTHRU PAIDTHRU DGreater Than MEMBER.PAIDTHRU MEMBER.PAIDTHRU > DATE() Members F"MEMBER" Birthday Report MEMBER inlist(MEMBER.BMONTH,) B T FBMONTH CEqual To MEMBER.BMONTH inlist(MEMBER.BMONTH,) Members F"MEMBER" Wife's Birthday Report MEMBER inlist(MEMBER.WBMONTH,'December') BFTFFWBMONTH CEqual To MEMBER.WBMONTH inlist(MEMBER.WBMONTH,'December') Members F"MEMBER" Anniversary Report MEMBER inlist(CMONTH(MEMBER.ANNIVERSRY),'January') .and. inlist(MEMBER.MARITAL,'Married') B T FANNIVERSRYCEqual To CMONTH(MEMBER.ANNIVERSRY) inlist(CMONTH(MEMBER.ANNIVERSRY),'January') MARITAL CEqual To MEMBER.MARITAL inlist(MEMBER.MARITAL,'Married') Members F"MEMBER" Event Number EITEM EITEM.EVENT_NO < 9 B FEVENT NUMBNLess Than EITEM.EVENT_NO EITEM.EVENT_NO < 9 Members F"MEMBER" Officers MEMBER .NOT. INLIST(MEMBER.OFFICE," ") BFT TOFFICE CNot Equal To MEMBER.OFFICE .NOT. INLIST(MEMBER.OFFICE," ") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Council Transaction Date RECVOUCH RECVOUCH.RVDATE > CTOD("01/01/94") .and. RECVOUCH.RVDATE < CTOD("05/01/94") B T FCOUNCIL TRDGreater Than RECVOUCH.RVDATE RECVOUCH.RVDATE > CTOD("01/01/94") COUNCIL TRDLess Than RECVOUCH.RVDATE RECVOUCH.RVDATE < CTOD("05/01/94") Members F"MEMBER" Council Transaction Batch RECVOUCH RECVOUCH.BATCH>=1 BFT FCOUNCIL BANGreater Than Or Equal To RECVOUCH.BATCH RECVOUCH.BATCH>=1 Members F"MEMBER" First & 2nd Degree Members MEMBER INLIST(MEMBER.DEGREE,"1st","2nd") BT TDEGREE CEqual To MEMBER.DEGREE INLIST(MEMBER.DEGREE,"1st","2nd") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Mailing List MEMBER INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE","MAIL LIST") BTTFTTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE","MAIL LIST") Members F"MEMBER" Honorary MEMBER INLIST(MEMBER.CLASS,"HONORARY","HONORARY LIFE","DISABLED HONORARY") BTF TCLASS CEqual To MEMBER.CLASS INLIST(MEMBER.CLASS,"HONORARY","HONORARY LIFE","DISABLED HONORARY") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Associate & Insurance MEMBER INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") .and. (.not. member.dead) BTTFTTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE","INACTIVE") Council Setup F"MEMBER" Member Payment Batch TRANSACT TRANSACT.PAY_BATCH>1 .and. TRANSACT.PAY_BATCH < 200 B T FPAY_BATCH NGreater Than TRANSACT.PAY_BATCH TRANSACT.PAY_BATCH>1 PAY_BATCH NLess Than TRANSACT.PAY_BATCH TRANSACT.PAY_BATCH < 200 Members F"MEMBER" Only Mail List Type MEMBER INLIST(MEMBER.TYPE,"MAIL LIST") B TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"MAIL LIST") Members F"MEMBER" Last Name MEMBER B LASTNAME CEqual To MEMBER.LASTNAME Members F"MEMBER" Billable Members MEMBER INLIST(MEMBER.CLASS,"REGULAR","HONORARY ") .and. INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") BTT TCLASS CEqual To MEMBER.CLASS INLIST(MEMBER.CLASS,"REGULAR","HONORARY ") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") NOBILL LEqual To MEMBER.NOBILL MEMBER.NOBILL =.F. Members F"MEMBER" Honorary Only MEMBER INLIST(MEMBER.CLASS,"HONORARY") .and. .NOT. INLIST(MEMBER.CLASS,"HONORARY LIFE") BTFFTCLASS CEqual To MEMBER.CLASS INLIST(MEMBER.CLASS,"HONORARY") CLASS CNot Equal To MEMBER.CLASS .NOT. INLIST(MEMBER.CLASS,"HONORARY LIFE") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Disabled Honorary MEMBER INLIST(MEMBER.CLASS,"DISABLED HONORARY") BTFFTCLASS CEqual To MEMBER.CLASS INLIST(MEMBER.CLASS,"DISABLED HONORARY") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Honorary Life MEMBER INLIST(MEMBER.CLASS,"HONORARY LIFE") BTFFTCLASS CEqual To MEMBER.CLASS INLIST(MEMBER.CLASS,"HONORARY LIFE") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" Suspended-non Payment MEMBER INLIST(MEMBER.TYPE,"SUSPENDED-NON PAYMENT") BTT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"SUSPENDED-NON PAYMENT") Members F"MEMBER" Suspended Board Action MEMBER INLIST(MEMBER.TYPE,"SUSPENDED-BOARD ACTION") BTT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"SUSPENDED-BOARD ACTION") Members F"MEMBER" Withdrawal MEMBER INLIST(MEMBER.TYPE,"WITHDRAWAL") BTT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"WITHDRAWAL") Members F"MEMBER" Transfer Out MEMBER INLIST(MEMBER.TYPE,"TRANSFER OUT") BTT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"TRANSFER OUT") Members F"MEMBER" Deceased MEMBER INLIST(MEMBER.TYPE,"DECEASED") BTT TTYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"DECEASED") Members F"MEMBER" Disabled MEMBER INLIST(MEMBER.CLASS,"DISABLED","DISABLED HONORARY") .and. INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") BTF TCLASS CEqual To MEMBER.CLASS INLIST(MEMBER.CLASS,"DISABLED","DISABLED HONORARY") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members F"MEMBER" No Billing Frequency MEMBER INLIST(MEMBER.FREQUENCY," ") BTT FREQUENCY CEqual To MEMBER.FREQUENCY INLIST(MEMBER.FREQUENCY," ") Members F"MEMBER" User Defined Report Query MEMBER .t. BTTFT Members F"MEMBER" Officers & Program Personnel MEMBER .NOT. INLIST(MEMBER.OFFICE," ") .and. .NOT. EMPTY(SERVICE.POSITION) BTTFTOFFICE CNot Equal To MEMBER.OFFICE .NOT. INLIST(MEMBER.OFFICE," ") SERVPOS1 CNot Equal To MEMBER.SERVPOS1 .NOT. INLIST(MEMBER.SERVPOS1,"' '") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members Linked to Service History T"MEMBER","SERVICE" Program Personnel MEMBER .NOT. EMPTY(service.position) .and. INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") BTT TSERVPOS1 CNot Equal To MEMBER.SERVPOS1 .NOT. INLIST(MEMBER.SERVPOS1,"' '") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members Linked to Service History T"MEMBER","SERVICE" Officers or Program Personnel MEMBER .NOT. INLIST(MEMBER.OFFICE," ") .or. .NOT. EMPTY(SERVICE.POSITION) BTTFTOFFICE CNot Equal To MEMBER.OFFICE .NOT. INLIST(MEMBER.OFFICE," ") SERVPOS1 CNot Equal To MEMBER.SERVPOS1 .NOT. INLIST(MEMBER.SERVPOS1,"' '") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") Members Linked to Service History T"MEMBER","SERVICE" Retention Committee MEMBER MEMBER.BALANCEDUE > 0 .and. MEMBER.DEAD =.F. BT FTBALANCEDUENGreater Than MEMBER.BALANCEDUE MEMBER.BALANCEDUE > 0 DEAD LEqual To MEMBER.DEAD MEMBER.DEAD =.F. E Members F"MEMBER" Outstanding Balances MEMBER MEMBER.BALANCEDUE > 0 .and. MEMBER.DEAD =.F. BTFFTBALANCEDUENGreater Than MEMBER.BALANCEDUE MEMBER.BALANCEDUE > 0 DEAD LEqual To MEMBER.DEAD MEMBER.DEAD =.F. Members F"MEMBER" Third & Fourth Degree MEMBER INLIST(MEMBER.DEGREE,"3rd","4th") .and. inlist(MEMBER.TYPE,'ASSOCIATE','INSURANCE') BT TDEGREE CEqual To MEMBER.DEGREE INLIST(MEMBER.DEGREE,"3rd","4th") TYPE CEqual To MEMBER.TYPE inlist(MEMBER.TYPE,'ASSOCIATE','INSURANCE') Members F"MEMBER" Member Payments Trial Balance TRANSACT TRANSACT.PAY_BATCH = 0 .AND. TRANSACT.TYPE="PAYMENT" .AND. STATUS<>"**VOID**" .AND. .NOT. TRANSACT.NONCASH BTTFFPAY_BATCH NEqual To TRANSACT.PAY_BATCH TRANSACT.PAY_BATCH = 0 Members F"MEMBER" Payment Date TRACK between(TRACK.PAY_DATE,ctod('01/01/1999'), ctod('12/31/1999')) BFT FPAY_DATE DBetween TRACK.PAY_DATE between(TRACK.PAY_DATE,ctod('01/01/1999'), ctod('12/31/1999')) Payments Linked to Transactions F"TRACK","TRANSACT" Council COUNCIL .T. BT F Council Setup F"COUNCIL" Paments - All TRACK .T. BT Payments Linked to Transactions T"TRACK","TRANSACT" Membership Cards - Reprint MEMBER between(MEMBER.PRINTTHRU,ctod('01/01/1999'), ctod('01/01/2000')) BFFFTPRINTTHRU DBetween MEMBER.PRINTTHRU between(MEMBER.PRINTTHRU,ctod('01/01/1999'), ctod('01/01/2000')) Members F"MEMBER" Billable Members (Modifiable) MEMBER INLIST(MEMBER.CLASS,"REGULAR","HONORARY ") .and. INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") BFFFTCLASS CEqual To MEMBER.CLASS INLIST(MEMBER.CLASS,"REGULAR","HONORARY ") TYPE CEqual To MEMBER.TYPE INLIST(MEMBER.TYPE,"ASSOCIATE","INSURANCE") NOBILL LEqual To MEMBER.NOBILL MEMBER.NOBILL =.F. Members F"MEMBER" Ordination Anniversiary ReportMEMBER inlist(MEMBER.MARITAL,'Clergy') .and. inlist(MEMBER.AMONTH,'January') B T TMARITAL CEqual To MEMBER.MARITAL inlist(MEMBER.MARITAL,'Clergy') AMONTH CEqual To MEMBER.AMONTH inlist(MEMBER.AMONTH,'January') Members