Hot Shareware 35/hot35.iso/ficheros/9UTI/TEAMBLDR.ZIP/TEAMBLDR.TXR

INI File | 1998-05-26 | 71KB | 1,542 lines

[LIBRARY]
VERSION(2003)
ENDUSER('off')
OPTION(0)

[REPORTS]
Report1 REPORT,FONT('Arial',10),LANDSCAPE,PRE(Report1),THOUS,AT(1000,2313,9000,5187) !Team Members by Organization
          HEADER,AT(1000,1000,9000,1313)
            STRING('TeamBuilder Version 1.1 Reports'),FONT(,14),AT(115,94)
            STRING('Report:'),AT(688,417)
            STRING('Organization Listing'),AT(1323,417)
            STRING(@n5),PAGENO,AT(1323,667)
            STRING('Page:'),AT(771,667)
            STRING(@s30),USE(Date:),AT(3229,667)
            STRING('Date:'),AT(2813,667)
            LINE,LINEWIDTH(20),AT(63,958,7094,0)
          END
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(ORG:Organization_ID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                  STRING('Organization Name:'),AT(0,0)
                  STRING(@s40),USE(ORG:Organization_Name),AT(1479,0)
                  STRING('Name'),AT(1050,313)
                  STRING('Functional Role'),AT(3770,313)
                  STRING('Comments'),AT(5012,313)
                  LINE,LINEWIDTH(15),AT(1000,481,8000,0)
                END
Detail1         DETAIL,FONT('Arial',8,0),AT(0,0,,400)
                  STRING(@s50),USE(PEO:Name),AT(1050,0)
                  STRING(@s15),USE(PEO:Functional_Role),AT(3770,0,1042)
                  TEXT,RESIZE,USE(PEO:Comments),AT(5012,0,1008,337)
                END
              END
            END
          END
Date:   FORMULA(@s30),VALUE('TODAY()') !Today's Date
        END
Report2 REPORT,FONT('Arial',10),LANDSCAPE,PRE(Report2),THOUS,AT(1000,1662,9000,5838),MARGINS(1000,1331,1000,1000) !Alpha Listing of Team Members
          HEADER,FONT('Times New Roman',11,0,4796),AT(1000,1331,,331)
            STRING('Name'),AT(50,0)
            STRING('Organization'),AT(2770,0)
            STRING('Functional Role'),AT(3971,0)
            STRING('Comments'),AT(5172,0)
            LINE,LINEWIDTH(15),AT(0,168,9000,0)
          END
_REPORT_  BREAK
_TOTALS_    BREAK
Detail1       DETAIL,FONT('Arial',8,0),AT(0,0,,400)
                STRING(@s50),USE(PEO:Name),AT(50,0)
                STRING(@s15),USE(PEO:Organization),AT(2770,0)
                STRING(@s15),USE(PEO:Functional_Role),AT(3971,0)
                TEXT,RESIZE,USE(PEO:Comments),AT(5172,0,1008,337)
              END
            END
          END
        END
Report3 REPORT,FONT('Arial',10),LANDSCAPE,PRE(Report3),THOUS,AT(1000,1000,9000,6500) !Basic Organization Information
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(ORG:Organization_Name)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                  STRING('Organization Name:'),AT(0,0)
                  STRING(@s40),USE(ORG:Organization_Name),AT(1423,0)
                  STRING('Phone Type'),AT(1050,313)
                  STRING('Phone Number'),AT(1892,313)
                  STRING('Address Type:'),AT(3107,313,789)
                  STRING('Addr 1'),AT(3946,313)
                  STRING('City'),AT(5511,313)
                  STRING('State'),AT(7076,313)
                  STRING('Zip'),AT(7470,313)
                  STRING('Country'),AT(8208,313)
                  LINE,LINEWIDTH(15),AT(1000,481,8000,0)
                END
Detail1         DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                  STRING(@s10),USE(OPH:Phone_Type),AT(1050,0,792)
                  STRING(@s30),USE(OPH:Phone_Number),AT(1892,0,1165)
                  STRING(@s20),USE(ORG1:org_addr_type),AT(3107,0,789)
                  STRING(@s40),USE(ORG1:Addr1),AT(3946,0,1515)
                  STRING(@s40),USE(ORG1:City),AT(5511,0,1515)
                  STRING(@s2),USE(ORG1:State),AT(7076,0,344)
                  STRING(@s10),USE(ORG1:Zip),AT(7470,0)
                  STRING(@s20),USE(ORG1:Country),AT(8208,0,789)
                END
              END
            END
          END
        END
Report4 REPORT,FONT('Arial',10),LANDSCAPE,PRE(Report4),THOUS,AT(1000,1662,9000,5838),MARGINS(1000,1331,1000,1000) !Basic Listing of Projects
          HEADER,FONT('Times New Roman',11,0,4796),AT(1000,1331,,331)
            STRING('Project ID'),AT(50,0)
            LINE,LINEWIDTH(15),AT(0,168,9000,0)
          END
_REPORT_  BREAK
_TOTALS_    BREAK
Detail1       DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                STRING(@s30),USE(off:OfficeID),AT(50,0)
              END
            END
          END
        END
Report5 REPORT,FONT('Arial',10),LANDSCAPE,PRE(Report5),THOUS,AT(1000,1000,9000,6500) !Projects & Phases
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                  STRING('Phase ID'),AT(1050,313)
                  STRING('Phase Description'),AT(2563,313)
                  STRING('Owner'),AT(5283,313,490)
                  LINE,LINEWIDTH(15),AT(1000,481,8000,0)
                END
Detail1         DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                  STRING(@S20),USE(PRO:ProjectID),AT(1050,0)
                  STRING(@S80),USE(PRO:ProjectDescription),AT(2563,0)
                  STRING(@s40),USE(PRO:OwnerLink),AT(5283,0)
                END
              END
            END
          END
        END
Report6 REPORT,FONT('Arial',10),LANDSCAPE,PRE(Report6),THOUS,AT(1000,1000,9000,6500) !Projects and Related Attachments
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                  STRING('Description'),AT(1050,313)
                  LINE,LINEWIDTH(15),AT(1000,481,8000,0)
                END
Detail1         DETAIL,FONT('Arial',8,0),AT(0,0,,400)
                  STRING(@s80),USE(BLO1:Description),AT(1050,0)
                END
              END
            END
          END
        END
Report8 REPORT,FONT('Arial',10),PRE(Report15),THOUS,AT(1000,1000,6500,9000) !docs w/update
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                END
_BREAK2         BREAK(PRO:ProjectID)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                    STRING('Phase Description:'),AT(1000,0)
                    STRING(@S80),USE(PRO:ProjectDescription),AT(2329,0)
                  END
_BREAK3           BREAK(doc:Documentation_ID)
                    HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                      STRING('Documentation Summary:'),AT(2000,0)
                      STRING(@s80),USE(doc:Documentation_Summary),AT(3819,0)
                      STRING('update date'),AT(3050,313)
                      STRING('update summary'),AT(3936,313)
                      LINE,LINEWIDTH(15),AT(3000,481,3500,0)
                    END
Detail1             DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                      STRING(@d2),USE(UPD5:update_date),AT(3050,0,792)
                      STRING(@s80),USE(UPD5:update_summary),AT(3936,0)
                    END
                  END
                END
              END
            END
          END
        END
Report9 REPORT,FONT('Arial',10),PRE(Report15),THOUS,AT(1000,1000,6500,9000) !ideas w/update
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                END
_BREAK2         BREAK(PRO:ProjectID)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                    STRING('Phase Description:'),AT(1000,0)
                    STRING(@S80),USE(PRO:ProjectDescription),AT(2329,0)
                  END
_BREAK3           BREAK(IDE:IdeaID)
                    HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                      STRING('Idea Summary:'),AT(2000,0)
                      STRING(@S80),USE(IDE:IdeaSummary),AT(3110,0)
                      STRING('update date'),AT(3050,313)
                      STRING('update summary'),AT(3936,313)
                      LINE,LINEWIDTH(15),AT(3000,481,3500,0)
                    END
Detail1             DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                      STRING(@d2),USE(UPD2:update_date),AT(3050,0,792)
                      STRING(@s80),USE(UPD2:update_summary),AT(3936,0)
                    END
                  END
                END
              END
            END
          END
        END
Report10 REPORT,FONT('Arial',10),PRE(Report15),THOUS,AT(1000,1000,6500,9000) !scope changes w/update
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                END
_BREAK2         BREAK(PRO:ProjectID)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                    STRING('Phase Description:'),AT(1000,0)
                    STRING(@S80),USE(PRO:ProjectDescription),AT(2329,0)
                  END
_BREAK3           BREAK(SCO:Change_ID)
                    HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                      STRING('Change Summary:'),AT(2000,0)
                      STRING(@s80),USE(SCO:Change_Summary),AT(3329,0)
                      STRING('update date'),AT(3050,313)
                      STRING('update summary'),AT(3936,313)
                      LINE,LINEWIDTH(15),AT(3000,481,3500,0)
                    END
Detail1             DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                      STRING(@d2),USE(UPD7:update_date),AT(3050,0,792)
                      STRING(@s80),USE(UPD7:update_summary),AT(3936,0)
                    END
                  END
                END
              END
            END
          END
        END
Report11 REPORT,FONT('Arial',10),PRE(Report15),THOUS,AT(1000,1000,6500,9000) !Issues w/update
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                END
_BREAK2         BREAK(PRO:ProjectID)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                    STRING('Phase Description:'),AT(1000,0)
                    STRING(@S80),USE(PRO:ProjectDescription),AT(2329,0)
                  END
_BREAK3           BREAK(ISS:Issue_ID)
                    HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                      STRING('Issue Summary:'),AT(2000,0)
                      STRING(@s80),USE(ISS:Issue_Summary),AT(3152,0)
                      STRING('update date'),AT(3050,313)
                      STRING('update summary'),AT(3936,313)
                      LINE,LINEWIDTH(15),AT(3000,481,3500,0)
                    END
Detail1             DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                      STRING(@d2),USE(UPD6:update_date),AT(3050,0,792)
                      STRING(@s80),USE(UPD6:update_summary),AT(3936,0)
                    END
                  END
                END
              END
            END
          END
        END
Report12 REPORT,FONT('Arial',10),PRE(Report15),THOUS,AT(1000,1000,6500,7832),MARGINS(1000,1000,1000,1584) !status w/updates
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                END
_BREAK2         BREAK(PRO:ProjectID)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                    STRING('Phase Description:'),AT(1000,0)
                    STRING(@S80),USE(PRO:ProjectDescription),AT(2329,0)
                  END
_BREAK3           BREAK(STR:Status_Report_ID)
                    HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                      STRING('Status Report Summary:'),AT(2000,0)
                      STRING(@s80),USE(STR:Status_Report_Summary),AT(3704,0)
                      STRING('update date'),AT(3050,313)
                      STRING('update summary'),AT(3936,313)
                      LINE,LINEWIDTH(15),AT(3000,481,3500,0)
                    END
Detail1             DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                      STRING(@d2),USE(UPD4:update_date),AT(3050,0,792)
                      STRING(@s80),USE(UPD4:update_summary),AT(3936,0)
                    END
                  END
                END
              END
            END
          END
          FOOTER,FONT('Times New Roman',9,0,4796),AT(1000,8832,,584)
            STRING('Page '),AT(5833,292)
            STRING(@n5),PAGENO,AT(6114,292)
          END
        END
Report13 REPORT,FONT('Arial',10),PRE(report13a),THOUS,AT(1000,1000,6500,7832),MARGINS(1000,1000,1000,1584) !devlp log w/updates
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                END
_BREAK2         BREAK(PRO:ProjectID)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                    STRING('Phase Description:'),AT(1000,0)
                    STRING(@S80),USE(PRO:ProjectDescription),AT(2329,0)
                  END
_BREAK3           BREAK(DVP:Development_ID)
                    HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                      STRING('Development Summary:'),AT(2000,0)
                      STRING(@s80),USE(DVP:Development_Summary),AT(3694,0)
                      STRING('update date'),AT(3050,313)
                      STRING('update summary'),AT(3936,313)
                      LINE,LINEWIDTH(15),AT(3000,481,3500,0)
                    END
Detail1             DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                      STRING(@d2),USE(UPD3:update_date),AT(3050,0,792)
                      STRING(@s80),USE(UPD3:update_summary),AT(3936,0)
                    END
                  END
                END
              END
            END
          END
          FOOTER,FONT('Times New Roman',9,0,4796),AT(1000,8832,,584)
            STRING('Page '),AT(5833,292)
            STRING(@n5),PAGENO,AT(6114,292)
          END
        END
Report14 REPORT,FONT('Arial',10),PRE(Report14a),THOUS,AT(1000,1000,6500,7832),MARGINS(1000,1000,1000,1584) !actions w/update
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                END
_BREAK2         BREAK(PRO:ProjectID)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                    STRING('Phase Description:'),AT(1000,0)
                    STRING(@S80),USE(PRO:ProjectDescription),AT(2329,0)
                  END
_BREAK3           BREAK(TOD:ToDoID)
                    HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                      STRING('Project Summary:'),AT(2000,0)
                      STRING(@s80),USE(TOD:ProjectSummary),AT(3288,0)
                      STRING('update date'),AT(3050,313)
                      STRING('update summary'),AT(3936,313)
                      LINE,LINEWIDTH(15),AT(3000,481,3500,0)
                    END
Detail1             DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                      STRING(@d2),USE(UPD:update_date),AT(3050,0,792)
                      STRING(@s80),USE(UPD:update_summary),AT(3936,0)
                    END
                  END
                END
              END
            END
          END
          FOOTER,FONT('Times New Roman',9,0,4796),AT(1000,8832,,584)
            STRING('Page '),AT(5833,292)
            STRING(@n5),PAGENO,AT(6114,292)
          END
        END
Report15 REPORT,FONT('Arial',10),PRE(Report15),THOUS,AT(1000,1000,6500,9000) !notes w/updates
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(off:OfficeID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                  STRING('Project ID'),AT(0,0)
                  STRING(@s30),USE(off:OfficeID),AT(746,0)
                END
_BREAK2         BREAK(PRO:ProjectID)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,313)
                    STRING('Phase Description:'),AT(1000,0)
                    STRING(@S80),USE(PRO:ProjectDescription),AT(2329,0)
                  END
_BREAK3           BREAK(NOT:NoteID)
                    HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                      STRING('Note Summary:'),AT(2000,0)
                      STRING(@s80),USE(NOT:NoteSummary),AT(3121,0)
                      STRING('update date'),AT(3050,313)
                      STRING('update summary'),AT(3936,313)
                      LINE,LINEWIDTH(15),AT(3000,481,3500,0)
                    END
Detail1             DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                      STRING(@d2),USE(UPD1:update_date),AT(3050,0,792)
                      STRING(@s80),USE(UPD1:update_summary),AT(3936,0)
                    END
                  END
                END
              END
            END
          END
        END
Report16 REPORT,FONT('Arial',10),PRE(Report16),THOUS,AT(1000,1000,6500,9000) !Team Members with Phone Numbers
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(PEO:Name)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,939)
                  STRING('Name:'),AT(0,0)
                  STRING('Organization:'),AT(0,313)
                  STRING('Functional Role:'),AT(0,626)
                  STRING(@s50),USE(PEO:Name),AT(1183,0)
                  STRING(@s15),USE(PEO:Organization),AT(1183,313)
                  STRING(@s15),USE(PEO:Functional_Role),AT(1183,626)
                END
_BREAK2         BREAK(PEO1:Phone_Type)
                  HEADER,FONT('Arial',10,0,700),AT(0,0,,939)
                    STRING('Phone Type:'),AT(1000,0)
                    STRING('Phone Number:'),AT(1000,313)
                    STRING(@s10),USE(PEO1:Phone_Type),AT(2131,0)
                    STRING(@s30),USE(PEO1:Phone_Number),AT(2131,313)
                    LINE,LINEWIDTH(15),AT(2000,794,4500,0)
                  END
Detail1           DETAIL,FONT('Arial',8,0),AT(0,0,,253)
                  END
                END
              END
            END
          END
        END
Report17 REPORT,FONT('Arial',10),PRE(Report17),THOUS,AT(1000,1000,6500,9000) !Functional Areas & Team Members
_REPORT_  BREAK
_TOTALS_    BREAK
_BREAK1       BREAK(FUN:Functional_ID)
                HEADER,FONT('Arial',10,0,700),AT(0,0,,626)
                  STRING('Functional Role Desc:'),AT(0,0)
                  STRING(@s40),USE(FUN:Functional_Role_Desc),AT(1538,0)
                  STRING('Name'),AT(1050,313)
                  STRING('Organization'),AT(3770,313)
                  STRING('Comments'),AT(4971,313)
                  LINE,LINEWIDTH(15),AT(1000,481,5500,0)
                END
Detail1         DETAIL,FONT('Arial',8,0),AT(0,0,,400)
                  STRING(@s50),USE(PEO:Name),AT(1050,0)
                  STRING(@s15),USE(PEO:Organization),AT(3770,0)
                  TEXT,RESIZE,USE(PEO:Comments),AT(4971,0,1008,337)
                END
              END
            END
          END
        END

[FILES]
People  FILE,PRE(PEO),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!people') !Team Members
KeyName   KEY(PEO:Name),NOCASE,OPT,PRIMARY !Name
keyFunctionalRole KEY(PEO:Functional_Role),DUP,NOCASE,OPT
keyOrganization KEY(PEO:Organization),DUP,NOCASE,OPT !Organization
Comments  MEMO(5000),PROMPT('Comments:'),HEADER('Comments')
__Record  RECORD
Name        STRING(50),PICTURE(@s50),PROMPT('Name:'),HEADER('Name')
Organization STRING(15),PICTURE(@s15),PROMPT('Organization:'),HEADER('Organization')
Functional_Role STRING(15),PICTURE(@s15),PROMPT('Functional Role:'),HEADER('Functional Role')
          END
        END
Functions FILE,PRE(FUN),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!functions')
keyFunctionalID KEY(FUN:Functional_ID),NOCASE,OPT,PRIMARY !Functional ID
__Record  RECORD
Functional_ID STRING(15),PICTURE(@s15),PROMPT('Functional ID:'),HEADER('Functional ID')
Functional_Role_Desc STRING(40),PICTURE(@s40),PROMPT('Functional Role Desc:'),HEADER('Functional Role Desc')
          END
        END
Organizations FILE,PRE(ORG),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!organizations')
key_OrganizationID KEY(ORG:Organization_ID),NOCASE,OPT,PRIMARY !By ID
key_org_name KEY(ORG:Organization_Name),DUP,NOCASE,OPT !By Name
__Record  RECORD
Organization_ID STRING(15),PICTURE(@s15),PROMPT('Organization ID:'),HEADER('Organization ID')
Organization_Name STRING(40),PICTURE(@s40),PROMPT('Organization Name:'),HEADER('Organization Name')
          END
        END
org_addresses FILE,PRE(ORG1),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!org_addresses') !Organization Addresses
key_org_id KEY(ORG1:org_addr_ID),NOCASE,OPT,PRIMARY !ID
key_link_to_org KEY(ORG1:link_to_org),DUP,NOCASE,OPT
key_addr_type KEY(ORG1:org_addr_type),DUP,NOCASE,OPT !Address Type
__Record  RECORD
org_addr_ID ULONG,PICTURE(@n13),PROMPT('org addr ID:'),HEADER('org addr ID')
org_addr_type STRING(20),PICTURE(@s20),PROMPT('Address Type:'),HEADER('Address Type:')
Addr1       STRING(40),PICTURE(@s40),PROMPT('Addr 1:'),HEADER('Addr 1')
link_to_org STRING(15),PICTURE(@s15),PROMPT('link to org:'),HEADER('link to org')
Addr2       STRING(40),PICTURE(@s40),PROMPT('Addr 2:'),HEADER('Addr 2')
City        STRING(40),PICTURE(@s40),PROMPT('City:'),HEADER('City')
State       STRING(2),PICTURE(@s2),PROMPT('State:'),HEADER('State')
Zip         STRING(10),PICTURE(@s10),PROMPT('Zip:'),HEADER('Zip')
Country     STRING(20),PICTURE(@s20),PROMPT('Country:'),HEADER('Country')
          END
        END
org_phones FILE,PRE(OPH),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!org_phones') !Organization Phones
key_Phone_id KEY(OPH:phone_number_id),NOCASE,OPT,PRIMARY
key_org_link KEY(OPH:org_link),DUP,NOCASE,OPT
key_phone_type KEY(OPH:Phone_Type),DUP,NOCASE,OPT
__Record  RECORD
phone_number_id LONG,PICTURE(@n-13),PROMPT('phone number id:'),HEADER('phone number id')
org_link    STRING(15),PICTURE(@s15),PROMPT('org link:'),HEADER('org link') !Name
Phone_Number STRING(30),PICTURE(@s30),PROMPT('Phone Number:'),HEADER('Phone Number') !Phone Number
Phone_Type  STRING(10),PICTURE(@s10),PROMPT('Phone Type:'),HEADER('Phone Type') !Type
          END
        END
address_types FILE,PRE(ADD),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!address_types') !Address Types
keyAddrType KEY(ADD:Addr_Type),NOCASE,OPT,PRIMARY
__Record  RECORD
Addr_Type   STRING(20),PICTURE(@s20),PROMPT('Addr Type:'),HEADER('Addr Type') !Address Type
          END
        END
Blob_Project FILE,PRE(BLO1),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_project') !Project Attachments
key_id    KEY(BLO1:blob_project_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO1:link_to_project),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_project_id ULONG,PICTURE(@n13),PROMPT('blob project id:'),HEADER('blob project id')
link_to_project STRING(30),PICTURE(@s30),PROMPT('link to project:'),HEADER('link to project')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
Blob_Phase FILE,PRE(BLO2),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_phase') !Phase Attachments
key_id    KEY(BLO2:blob_phase_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO2:link_to_phase),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_phase_id ULONG,PICTURE(@n13),PROMPT('blob phase id:'),HEADER('blob phase id')
link_to_phase STRING(15),PICTURE(@s15),PROMPT('link to phase:'),HEADER('link to phase')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
Blob_action FILE,PRE(BLO21),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_action') !Action Item Attachments
key_id    KEY(BLO21:blob_action_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO21:link_to_action),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_action_id ULONG,PICTURE(@n13),PROMPT('blob action id:'),HEADER('blob action id')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
Blob_ideas FILE,PRE(BLO3),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_ideas') !Idea Attachments
key_id    KEY(BLO3:blob_ideas_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO3:link_to_ideas),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_ideas_id ULONG,PICTURE(@n13),PROMPT('blob ideas id:'),HEADER('blob ideas id')
link_to_ideas ULONG,PICTURE(@n13),PROMPT('link to ideas:'),HEADER('link to ideas')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
Blob_issues FILE,PRE(BLO31),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_issues') !Issue Attachments
key_id    KEY(BLO31:blob_issues_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO31:link_to_issues),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_issues_id ULONG,PICTURE(@n13),PROMPT('blob issues id:'),HEADER('blob issues id')
link_to_issues ULONG,PICTURE(@n13),PROMPT('link to issues:'),HEADER('link to issues')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
Blob_scope FILE,PRE(BLO5),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_scope') !Scope Change Attachments
key_id    KEY(BLO5:blob_scope_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO5:link_to_scope),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_scope_id ULONG,PICTURE(@n13),PROMPT('blob scope id:'),HEADER('blob scope id')
link_to_scope ULONG,PICTURE(@n13),PROMPT('link to scope:'),HEADER('link to scope')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
Blob_devl FILE,PRE(BLO4),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_devl') !Development Log Attachments
key_id    KEY(BLO4:blob_issues_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO4:link_to_devl),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_issues_id ULONG,PICTURE(@n13),PROMPT('blob issues id:'),HEADER('blob issues id')
link_to_devl ULONG,PICTURE(@n13),PROMPT('link to devl:'),HEADER('link to devl')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
Blob_doc FILE,PRE(BLO41),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_doc') !Documentation Attachments
key_id    KEY(BLO41:blob_doc_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO41:link_to_doc),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_doc_id ULONG,PICTURE(@n13),PROMPT('blob doc id:'),HEADER('blob doc id')
link_to_doc ULONG,PICTURE(@n13),PROMPT('link to doc:'),HEADER('link to doc')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
people_phone FILE,PRE(PEO1),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!phone_numbers') !Team Member Phone Numbers
key_Phone_id KEY(PEO1:phone_number_id),NOCASE,OPT,PRIMARY
key_person_link KEY(PEO1:person_link),DUP,NOCASE,OPT
key_phone_type KEY(PEO1:Phone_Type),DUP,NOCASE,OPT
__Record  RECORD
phone_number_id LONG,PICTURE(@n-13),PROMPT('phone number id:'),HEADER('phone number id')
person_link STRING(50),PICTURE(@s50),PROMPT('person link:'),HEADER('person link') !Name
Phone_Number STRING(30),PICTURE(@s30),PROMPT('Phone Number:'),HEADER('Phone Number') !Phone Number
Phone_Type  STRING(10),PICTURE(@s10),PROMPT('Phone Type:'),HEADER('Phone Type') !Type
          END
        END
org_phone FILE,PRE(org11),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!org_phones') !Organization Phone Numbers
key_Phone_id KEY(org11:phone_number_id),NOCASE,OPT,PRIMARY
key_person_link KEY(org11:org_link),DUP,NOCASE,OPT
key_phone_type KEY(org11:Phone_Type),DUP,NOCASE,OPT
__Record  RECORD
phone_number_id LONG,PICTURE(@n-13),PROMPT('phone number id:'),HEADER('phone number id')
org_link    STRING(15),PICTURE(@s15),PROMPT('org link:'),HEADER('org link') !Name
Phone_Number STRING(30),PICTURE(@s30),PROMPT('Phone Number:'),HEADER('Phone Number') !Phone Number
Phone_Type  STRING(10),PICTURE(@s10),PROMPT('Phone Type:'),HEADER('Phone Type') !Type
          END
        END
Scope_Changes FILE,PRE(SCO),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!scope_changes') !Scope Changes
key_projectlink_and_sequence KEY(SCO:project_link,-SCO:status,SCO:Sequence_Number),DUP,NOCASE,OPT
keyCreateDate KEY(SCO:Create_Date),DUP,NOCASE,OPT !Create Date
key_project_link KEY(SCO:project_link),DUP,NOCASE,OPT
keyOwner_Link KEY(SCO:owner_id,-SCO:status,SCO:Sequence_Number),DUP,NOCASE,OPT
key_change_id KEY(SCO:Change_ID),NOCASE,OPT,PRIMARY
key_sequence KEY(SCO:Sequence_Number),DUP,NOCASE,OPT !Sequence
key_Change_Summary KEY(SCO:Change_Summary),DUP,NOCASE,OPT !Change Summary
Change_Details MEMO(64000),PROMPT('Change Details:'),HEADER('Change Details')
__Record  RECORD
Change_ID   ULONG,PICTURE(@n13),PROMPT('Change ID:'),HEADER('Change ID')
project_link STRING(15),PICTURE(@s15),PROMPT('project link:'),HEADER('project link')
owner_id    STRING(40),PICTURE(@s40),PROMPT('Owner:'),HEADER('Owner')
Sequence_Number DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence Number:'),HEADER('Sequence Number')
Change_Summary STRING(80),PICTURE(@s80),PROMPT('Change Summary:'),HEADER('Change Summary')
status      BYTE,PROMPT('Active?'),HEADER('Active?') !Active?
Create_Date STRING(20),PICTURE(@d2),PROMPT('Create Date:'),HEADER('Create Date')
          END
        END
Issues  FILE,PRE(ISS),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!issues') !Issues
key_project_link KEY(ISS:project_link),DUP,NOCASE,OPT
keyCreateDate KEY(ISS:Create_Date),DUP,NOCASE,OPT !Create Date
key_change_id KEY(ISS:Issue_ID),NOCASE,OPT,PRIMARY
key_sequence KEY(ISS:Sequence_Number),DUP,NOCASE,OPT !Sequence
key_Change_Summary KEY(ISS:Issue_Summary),DUP,NOCASE,OPT !Issue Summary
keyOwner_Link KEY(ISS:owner_id,-ISS:status,ISS:Sequence_Number),DUP,NOCASE,OPT
key_projectlink_and_sequence KEY(ISS:project_link,-ISS:status,ISS:Sequence_Number),DUP,NOCASE,OPT
Issue_Details MEMO(64000),PROMPT('Issue Details:'),HEADER('Issue Details')
__Record  RECORD
Issue_ID    ULONG,PICTURE(@n13),PROMPT('Issue ID:'),HEADER('Issue ID')
project_link STRING(15),PICTURE(@s15),PROMPT('project link:'),HEADER('project link')
Issue_Summary STRING(80),PICTURE(@s80),PROMPT('Issue Summary:'),HEADER('Issue Summary')
owner_id    STRING(40),PICTURE(@s40),PROMPT('owner id:'),HEADER('owner id')
Sequence_Number DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence Number:'),HEADER('Sequence Number')
status      BYTE,PROMPT('Active?'),HEADER('Active?') !Active?
Create_Date STRING(20),PICTURE(@d2),PROMPT('Create Date:'),HEADER('Create Date')
          END
        END
Documentation FILE,PRE(doc),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!documentation') !Documentation
key_project_link KEY(doc:project_link),DUP,NOCASE,OPT
keyCreateDate KEY(doc:Create_Date),DUP,NOCASE,OPT !Create Date
key_documentation_id KEY(doc:Documentation_ID),NOCASE,OPT,PRIMARY
key_sequence KEY(doc:Sequence_Number),DUP,NOCASE,OPT !Sequence
key_Documentation_Summary KEY(doc:Documentation_Summary),DUP,NOCASE,OPT !Documentation Summary
keyOwner_Link KEY(doc:owner_id,-doc:status,doc:Sequence_Number),DUP,NOCASE,OPT
key_projectlink_and_sequence KEY(doc:project_link,-doc:status,doc:Sequence_Number),DUP,NOCASE,OPT
Documentation_Details MEMO(64000),PROMPT('Documentation Details:'),HEADER('Documentation Details')
__Record  RECORD
Documentation_ID ULONG,PICTURE(@n13),PROMPT('Documentation ID:'),HEADER('Documentation ID')
project_link STRING(15),PICTURE(@s15),PROMPT('project link:'),HEADER('project link')
owner_id    STRING(40),PICTURE(@s40),PROMPT('owner id:'),HEADER('owner id')
Documentation_Summary STRING(80),PICTURE(@s80),PROMPT('Documentation Summary:'),HEADER('Documentation Summary')
Sequence_Number DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence Number:'),HEADER('Sequence Number')
status      BYTE,PROMPT('Active?'),HEADER('Active?') !Active?
Create_Date STRING(20),PICTURE(@d2),PROMPT('Create Date:'),HEADER('Create Date')
          END
        END
phonetypes FILE,PRE(PHO),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!phone_types') !Phone Types
keyPhoneType KEY(PHO:PhoneType),NOCASE,OPT,PRIMARY
__Record  RECORD
PhoneType   STRING(20),PICTURE(@s20),PROMPT('Phone Type:'),HEADER('Phone Type') !Phone Type
          END
        END
status_reports FILE,PRE(STR),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!status_reports') !Status Reports
key_project_link KEY(STR:project_link),DUP,NOCASE,OPT
keyCreateDate KEY(STR:Create_Date),DUP,NOCASE,OPT !Create Date
keyOwner_Link KEY(STR:owner_id,-STR:status,STR:Sequence_Number),DUP,NOCASE,OPT
key_status_report_id KEY(STR:Status_Report_ID),NOCASE,OPT,PRIMARY
key_sequence KEY(STR:Sequence_Number),DUP,NOCASE,OPT !Sequence
key_status_report_Summary KEY(STR:Status_Report_Summary),DUP,NOCASE,OPT !Status Report Summary
key_projectlink_and_sequence KEY(STR:project_link,-STR:status,STR:Sequence_Number),DUP,NOCASE,OPT
Status_Report_Details MEMO(64000),PROMPT('Status Report Details:'),HEADER('Status Report Details')
__Record  RECORD
Status_Report_ID ULONG,PICTURE(@n13),PROMPT('Status Report ID:'),HEADER('Status Report ID')
project_link STRING(15),PICTURE(@s15),PROMPT('project link:'),HEADER('project link')
owner_id    STRING(40),PICTURE(@s40),PROMPT('owner id:'),HEADER('owner id')
Sequence_Number DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence Number:'),HEADER('Sequence Number')
Status_Report_Summary STRING(80),PICTURE(@s80),PROMPT('Status Report Summary:'),HEADER('Status Report Summary')
status      BYTE,PROMPT('Active?'),HEADER('Active?') !Active?
Create_Date STRING(20),PICTURE(@d2),PROMPT('Create Date:'),HEADER('Create Date')
          END
        END
Project FILE,PRE(off),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!office') !Project
keySequence KEY(off:Sequence,off:OfficeID),DUP,NOCASE,OPT
KeyOfficeID KEY(off:OfficeID),NOCASE,OPT,PRIMARY !Office ID Key
keySequence2 KEY(off:Sequence),DUP,NOCASE,OPT
__Record  RECORD
Sequence    DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence:'),HEADER('Sequence')
OfficeID    STRING(30),PICTURE(@s30),PROMPT('Project ID'),HEADER('Project ID') !Project
          END
        END
development_log FILE,PRE(DVP),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!development_log') !Development Log
key_project_link KEY(DVP:project_link),DUP,NOCASE,OPT
keyCreateDate KEY(DVP:Create_Date),DUP,NOCASE,OPT !Create Date
keyOwner_Link KEY(DVP:owner_id,-DVP:status,DVP:Sequence_Number),DUP,NOCASE,OPT
key_development_id KEY(DVP:Development_ID),NOCASE,OPT,PRIMARY
key_sequence KEY(DVP:Sequence_Number),DUP,NOCASE,OPT !Sequence
key_development_summary KEY(DVP:Development_Summary),DUP,NOCASE,OPT !Development Summary
key_projectlink_and_sequence KEY(DVP:project_link,-DVP:status,DVP:Sequence_Number),DUP,NOCASE,OPT
Development_Details MEMO(64000),PROMPT('Development Details:'),HEADER('Development Details')
__Record  RECORD
Development_ID ULONG,PICTURE(@n13),PROMPT('Development ID:'),HEADER('Development ID')
project_link STRING(15),PICTURE(@s15),PROMPT('project link:'),HEADER('project link')
owner_id    STRING(40),PICTURE(@s40),PROMPT('owner id:'),HEADER('owner id')
Development_Summary STRING(80),PICTURE(@s80),PROMPT('Development Summary:'),HEADER('Development Summary')
Sequence_Number DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence Number:'),HEADER('Sequence Number')
status      BYTE,PROMPT('Active?'),HEADER('Active?') !Active?
Create_Date STRING(20),PICTURE(@d2),PROMPT('Create Date:'),HEADER('Create Date')
          END
        END
Phases  FILE,PRE(PRO),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!projects') !Phases
keySequence_and_ID KEY(PRO:Sequence,PRO:ProjectID,PRO:OfficeLink),DUP,NOCASE,OPT
KeyProjectID KEY(PRO:ProjectID),NOCASE,OPT,PRIMARY !Project
keySequenceOnly KEY(PRO:Sequence),DUP,NOCASE,OPT
KeyOffice_and_ProjectID KEY(PRO:OfficeLink,PRO:ProjectID),DUP,NOCASE,OPT
KeyOfficeLink KEY(PRO:OfficeLink),DUP,NOCASE,OPT !Office Link Key
KeyProjectDescription KEY(PRO:ProjectDescription),DUP,NOCASE,OPT !Description
KeyOwnerLink KEY(PRO:OwnerLink),DUP,NOCASE,OPT !Owner
__Record  RECORD
ProjectID   STRING(15),PICTURE(@S20),PROMPT('Phase ID:'),HEADER('Phase ID') !Phase ID
OfficeLink  STRING(30),PICTURE(@s30),PROMPT('Office Link:'),HEADER('Office Link') !Office Link
OwnerLink   STRING(40),PICTURE(@s40),PROMPT('Owner Link:'),HEADER('Owner Link')
Sequence    DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence:'),HEADER('Sequence')
ProjectDescription STRING(80),PICTURE(@S80),PROMPT('Phase Description:'),HEADER('Phase Description') !Phase Description
          END
        END
Time_Categories FILE,PRE(TIM),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!time_categories') !Time Categories
key_Time_Category_ID KEY(TIM:Time_Category_ID),NOCASE,OPT,PRIMARY !ID
key_time_category_description KEY(TIM:Time_Category_Description),DUP,NOCASE,OPT !Description
__Record  RECORD
Time_Category_ID STRING(15),PICTURE(@s15),PROMPT('Time Category ID:'),HEADER('Time Category ID')
Time_Category_Description STRING(40),PICTURE(@s40),PROMPT('Time Category Description:'),HEADER('Time Category Description')
          END
        END
Ideas   FILE,PRE(IDE),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!ideas') !Ideas
KeyIdeaID KEY(IDE:IdeaID),NOCASE,OPT,PRIMARY
keyCreateDate KEY(IDE:Create_Date),DUP,NOCASE,OPT !Create Date
KeyProjectLink_and_Sequence KEY(IDE:ProjectLink,-IDE:status,IDE:Sequence_ID),DUP,NOCASE,OPT
key_sequence KEY(IDE:Sequence_ID),DUP,NOCASE,OPT !Sequence
KeyProjectLink_and_Summary KEY(IDE:ProjectLink,IDE:IdeaSummary),DUP,NOCASE,OPT
KeyIdeaSummary KEY(IDE:IdeaSummary),DUP,NOCASE,OPT !Summary
KeyOwnerLink KEY(IDE:OwnerLink,-IDE:status,IDE:Sequence_ID),DUP,NOCASE,OPT !Owner
KeyProjectLink KEY(IDE:ProjectLink),DUP,NOCASE !Project
IdeaDetails MEMO(64000),PROMPT('Idea Details:'),HEADER('Idea Details')
__Record  RECORD
IdeaID      ULONG,PICTURE(@S20),PROMPT('Idea ID:'),HEADER('Idea ID')
ProjectLink STRING(15),PICTURE(@S20),PROMPT('Project Link:'),HEADER('Project Link')
OwnerLink   STRING(40),PICTURE(@s40),PROMPT('Owner Link:'),HEADER('Owner Link')
IdeaSummary STRING(80),PICTURE(@S80),PROMPT('Idea Summary:'),HEADER('Idea Summary')
Sequence_ID DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence ID:'),HEADER('Sequence ID')
status      BYTE,PROMPT('Active?'),HEADER('Active?') !Active?
Create_Date STRING(20),PICTURE(@d2),PROMPT('Create Date:'),HEADER('Create Date')
          END
        END
Action  FILE,PRE(TOD),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!todo') !Action Items
KeyToDoID KEY(TOD:ToDoID),NOCASE,OPT,PRIMARY
keyCreateDate KEY(TOD:Create_Date),DUP,NOCASE,OPT !Create Date
KeyProjectLink_and_Sequence KEY(TOD:ProjectLink,-TOD:status,TOD:Sequence),DUP,NOCASE,OPT
keySequence KEY(TOD:Sequence),DUP,NOCASE,OPT !Sequence
keyTargetDate KEY(TOD:Target_Date),DUP,NOCASE,OPT !Target Date
KeyToDoSummary KEY(TOD:ProjectSummary),DUP,NOCASE,OPT !Summary Index
KeyProjectLink_and_Summary KEY(TOD:ProjectLink,TOD:ProjectSummary),DUP,NOCASE,OPT
KeyProjectLink KEY(TOD:ProjectLink),DUP,NOCASE !Project
KeyAssignedToLink KEY(TOD:AssignedToLink,-TOD:status,TOD:Sequence),DUP,NOCASE,OPT !Assigned To
ToDoDetails MEMO(64000),PROMPT('To Do Details:'),HEADER('To Do Details')
__Record  RECORD
ToDoID      ULONG,PICTURE(@S20),PROMPT('To Do ID:'),HEADER('To Do ID')
ProjectLink STRING(15),PICTURE(@S20),PROMPT('Project Link:'),HEADER('Project Link')
Sequence    DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence:'),HEADER('Sequence')
AssignedToLink STRING(40),PICTURE(@s40),PROMPT('Assigned To Link:'),HEADER('Assigned To Link')
ProjectSummary STRING(80),PICTURE(@s80),PROMPT('Project Summary:'),HEADER('Project Summary')
status      BYTE,PROMPT('Active?'),HEADER('Active?') !Active?
Create_Date STRING(20),PICTURE(@d2),PROMPT('Create Date:'),HEADER('Create Date')
Target_Date STRING(20),PICTURE(@d2),PROMPT('Target Date:'),HEADER('Target Date')
Percent_Complete SHORT,PICTURE(@n-6),PROMPT('Percent Complete:'),HEADER('Percent Complete')
          END
        END
TodoTime FILE,PRE(TOD1),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!todo_time') !Time Recording
keytimeID KEY(TOD1:timeID),NOCASE,OPT,PRIMARY !ID
keyTeamMember KEY(TOD1:Team_Member),DUP,NOCASE,OPT !Team Member
key_link_to_todo KEY(TOD1:link_to_todo),DUP,NOCASE,OPT
key_time_type KEY(TOD1:time_type),DUP,NOCASE,OPT !Time Type
__Record  RECORD
timeID      ULONG,PICTURE(@n13),PROMPT('time ID:'),HEADER('time ID')
link_to_todo ULONG,PICTURE(@n13),PROMPT('link to todo:'),HEADER('link to todo')
time_type   STRING(15),PICTURE(@s15),PROMPT('time type:'),HEADER('time type')
Team_Member STRING(50),PICTURE(@s50),PROMPT('Team Member:'),HEADER('Team Member')
Time        DECIMAL(2,1),PICTURE(@n-4.1),PROMPT('Time:'),HEADER('Time')
          END
        END
Notes   FILE,PRE(NOT),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!notes') !Notes
KeyNoteID KEY(NOT:NoteID),NOCASE,OPT,PRIMARY
keyCreateDate KEY(NOT:Create_Date),DUP,NOCASE,OPT !Create Date
KeyProjectLink_and_Sequence KEY(NOT:ProjectLink,-NOT:status,NOT:Sequence,NOT:NoteID),DUP,NOCASE,OPT
keySequence KEY(NOT:Sequence),DUP,NOCASE,OPT !Sequence
KeyProjectLink_and_Summary KEY(NOT:ProjectLink,NOT:NoteSummary),DUP,NOCASE,OPT
KeyOwnerLink KEY(NOT:OwnerLink,-NOT:status,NOT:Sequence),DUP,NOCASE,OPT !Owner
KeyProjectLink KEY(NOT:ProjectLink),DUP,NOCASE !Project
NoteDetails MEMO(64000),PROMPT('Note Details:'),HEADER('Note Details')
__Record  RECORD
NoteID      ULONG,PICTURE(@S20),PROMPT('Note ID:'),HEADER('Note ID')
ProjectLink STRING(15),PICTURE(@S20),PROMPT('Project Link:'),HEADER('Project Link')
OwnerLink   STRING(40),PICTURE(@s40),PROMPT('Owner Link:'),HEADER('Owner Link')
NoteSummary STRING(80),PICTURE(@s80),PROMPT('Note Summary:'),HEADER('Note Summary')
Sequence    DECIMAL(7,2),PICTURE(@n-10.2),PROMPT('Sequence:'),HEADER('Sequence') !Sequence
status      BYTE,PROMPT('Active?'),HEADER('Active?') !Active?
Create_Date STRING(20),PICTURE(@d2),PROMPT('Create Date:'),HEADER('Create Date') !Create Date
          END
        END
Blob_Notes FILE,PRE(BLO),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_notes') !Note Attachments
key_blob_note_id KEY(BLO:blob_note_ID),NOCASE,OPT,PRIMARY
key_link_to_notes KEY(BLO:Link_to_Notes),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_note_ID ULONG,PICTURE(@n13),PROMPT('blob note ID:'),HEADER('blob note ID')
Link_to_Notes ULONG,PICTURE(@n13),PROMPT('Link to Notes:'),HEADER('Link to Notes')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END
Update_Action FILE,PRE(UPD),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!update_action') !Update Action Items
key_id    KEY(UPD:update_ID),NOCASE,OPT,PRIMARY
key_link_and_date KEY(UPD:link_to_action,UPD:update_date),DUP,NOCASE,OPT
update_details MEMO(5000),PROMPT('update details:'),HEADER('update details')
__Record  RECORD
update_ID   ULONG,PICTURE(@n13),PROMPT('update ID:'),HEADER('update ID')
update_date STRING(20),PICTURE(@d2),PROMPT('update date:'),HEADER('update date')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
update_summary STRING(80),PICTURE(@s80),PROMPT('update summary:'),HEADER('update summary')
          END
        END
Update_Scope FILE,PRE(UPD7),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!update_scope') !Update Scope Changes
key_id    KEY(UPD7:update_ID),NOCASE,OPT,PRIMARY
key_link_and_date KEY(UPD7:link_to_action,UPD7:update_date),DUP,NOCASE,OPT
update_details MEMO(5000),PROMPT('update details:'),HEADER('update details')
__Record  RECORD
update_ID   ULONG,PICTURE(@n13),PROMPT('update ID:'),HEADER('update ID')
update_date STRING(20),PICTURE(@d2),PROMPT('update date:'),HEADER('update date')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
update_summary STRING(80),PICTURE(@s80),PROMPT('update summary:'),HEADER('update summary')
          END
        END
Update_Issues FILE,PRE(UPD6),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!update_Issues') !Update Issues
key_id    KEY(UPD6:update_ID),NOCASE,OPT,PRIMARY
key_link_and_date KEY(UPD6:link_to_action,UPD6:update_date),DUP,NOCASE,OPT
update_details MEMO(5000),PROMPT('update details:'),HEADER('update details')
__Record  RECORD
update_ID   ULONG,PICTURE(@n13),PROMPT('update ID:'),HEADER('update ID')
update_date STRING(20),PICTURE(@d2),PROMPT('update date:'),HEADER('update date')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
update_summary STRING(80),PICTURE(@s80),PROMPT('update summary:'),HEADER('update summary')
          END
        END
Update_Documentation FILE,PRE(UPD5),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!update_doc') !Update Documentation
key_id    KEY(UPD5:update_ID),NOCASE,OPT,PRIMARY
key_link_and_date KEY(UPD5:link_to_action,UPD5:update_date),DUP,NOCASE,OPT
update_details MEMO(5000),PROMPT('update details:'),HEADER('update details')
__Record  RECORD
update_ID   ULONG,PICTURE(@n13),PROMPT('update ID:'),HEADER('update ID')
update_date STRING(20),PICTURE(@d2),PROMPT('update date:'),HEADER('update date')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
update_summary STRING(80),PICTURE(@s80),PROMPT('update summary:'),HEADER('update summary')
          END
        END
Update_status FILE,PRE(UPD4),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!update_staus') !Update Status Reports
key_id    KEY(UPD4:update_ID),NOCASE,OPT,PRIMARY
key_link_and_date KEY(UPD4:link_to_action,UPD4:update_date),DUP,NOCASE,OPT
update_details MEMO(5000),PROMPT('update details:'),HEADER('update details')
__Record  RECORD
update_ID   ULONG,PICTURE(@n13),PROMPT('update ID:'),HEADER('update ID')
update_date STRING(20),PICTURE(@d2),PROMPT('update date:'),HEADER('update date')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
update_summary STRING(80),PICTURE(@s80),PROMPT('update summary:'),HEADER('update summary')
          END
        END
Update_Devlp FILE,PRE(UPD3),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!update_devl') !Update Development Log
key_id    KEY(UPD3:update_ID),NOCASE,OPT,PRIMARY
key_link_and_date KEY(UPD3:link_to_action,UPD3:update_date),DUP,NOCASE,OPT
update_details MEMO(5000),PROMPT('update details:'),HEADER('update details')
__Record  RECORD
update_ID   ULONG,PICTURE(@n13),PROMPT('update ID:'),HEADER('update ID')
update_date STRING(20),PICTURE(@d2),PROMPT('update date:'),HEADER('update date')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
update_summary STRING(80),PICTURE(@s80),PROMPT('update summary:'),HEADER('update summary')
          END
        END
Update_ideas FILE,PRE(UPD2),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!update_ideas') !Update Ideas
key_id    KEY(UPD2:update_ID),NOCASE,OPT,PRIMARY
key_link_and_date KEY(UPD2:link_to_action,UPD2:update_date),DUP,NOCASE,OPT
update_details MEMO(5000),PROMPT('update details:'),HEADER('update details')
__Record  RECORD
update_ID   ULONG,PICTURE(@n13),PROMPT('update ID:'),HEADER('update ID')
update_date STRING(20),PICTURE(@d2),PROMPT('update date:'),HEADER('update date')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
update_summary STRING(80),PICTURE(@s80),PROMPT('update summary:'),HEADER('update summary')
          END
        END
Update_notes FILE,PRE(UPD1),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('teambldr\!update_notes') !Update Notes
key_id    KEY(UPD1:update_ID),NOCASE,OPT,PRIMARY
key_link_and_date KEY(UPD1:link_to_action,UPD1:update_date),DUP,NOCASE,OPT
update_details MEMO(5000),PROMPT('update details:'),HEADER('update details')
__Record  RECORD
update_ID   ULONG,PICTURE(@n13),PROMPT('update ID:'),HEADER('update ID')
update_date STRING(20),PICTURE(@d2),PROMPT('update date:'),HEADER('update date')
link_to_action ULONG,PICTURE(@n13),PROMPT('link to action:'),HEADER('link to action')
update_summary STRING(80),PICTURE(@s80),PROMPT('update summary:'),HEADER('update summary')
          END
        END
Blob_status FILE,PRE(BLO411),DRIVER('TOPSPEED',,'CW2tps16','TPS'),CREATE,RECLAIM,NAME('tb_blobs\!blob_status') !Status Reports  Attachments
key_id    KEY(BLO411:blob_status_id),NOCASE,OPT,PRIMARY
key_link  KEY(BLO411:link_to_status),DUP,NOCASE,OPT
blob      BLOB
__Record  RECORD
blob_status_id ULONG,PICTURE(@n13),PROMPT('blob status id:'),HEADER('blob status id')
link_to_status ULONG,PICTURE(@n13),PROMPT('link to status:'),HEADER('link to status')
Description STRING(80),PICTURE(@s80),PROMPT('Description:'),HEADER('Description')
          END
        END

[RELATIONS]
        RELATION,ONE:MANY
Functions FILE(FUN:keyFunctionalID)
People    RELATED_FILE(PEO:keyFunctionalRole)
          FILE_TO_RELATED_KEY
            FIELD(FUN:Functional_ID,PEO:Functional_Role)
          END
          RELATED_FILE_TO_KEY
            FIELD(PEO:Functional_Role,FUN:Functional_ID)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
TodoTime  RELATED_FILE(TOD1:keyTeamMember)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,TOD1:Team_Member)
          END
          RELATED_FILE_TO_KEY
            FIELD(TOD1:Team_Member,PEO:Name)
          END
        END
        RELATION,ONE:MANY
status_reports FILE(STR:key_status_report_id)
Blob_status RELATED_FILE(BLO411:key_link)
          FILE_TO_RELATED_KEY
            FIELD(STR:Status_Report_ID,BLO411:link_to_status)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO411:link_to_status,STR:Status_Report_ID)
          END
        END
        RELATION,ONE:MANY
phonetypes FILE(PHO:keyPhoneType)
org_phones RELATED_FILE(OPH:key_phone_type)
          FILE_TO_RELATED_KEY
            FIELD(PHO:PhoneType,OPH:Phone_Type)
          END
          RELATED_FILE_TO_KEY
            FIELD(OPH:Phone_Type,PHO:PhoneType)
          END
        END
        RELATION,ONE:MANY
Organizations FILE(ORG:key_OrganizationID)
org_phones RELATED_FILE(OPH:key_org_link)
          FILE_TO_RELATED_KEY
            FIELD(ORG:Organization_ID,OPH:org_link)
          END
          RELATED_FILE_TO_KEY
            FIELD(OPH:org_link,ORG:Organization_ID)
          END
        END
        RELATION,ONE:MANY
Time_Categories FILE(TIM:key_Time_Category_ID)
TodoTime  RELATED_FILE(TOD1:key_time_type)
          FILE_TO_RELATED_KEY
            FIELD(TIM:Time_Category_ID,TOD1:time_type)
          END
          RELATED_FILE_TO_KEY
            FIELD(TOD1:time_type,TIM:Time_Category_ID)
          END
        END
        RELATION,ONE:MANY
Action    FILE(TOD:KeyToDoID)
TodoTime  RELATED_FILE(TOD1:key_link_to_todo)
          FILE_TO_RELATED_KEY
            FIELD(TOD:ToDoID,TOD1:link_to_todo)
          END
          RELATED_FILE_TO_KEY
            FIELD(TOD1:link_to_todo,TOD:ToDoID)
          END
        END
        RELATION,ONE:MANY
org_phone FILE(org11:key_phone_type)
phonetypes RELATED_FILE(PHO:keyPhoneType)
          FILE_TO_RELATED_KEY
            FIELD(org11:Phone_Type,PHO:PhoneType)
          END
          RELATED_FILE_TO_KEY
            FIELD(PHO:PhoneType,org11:Phone_Type)
          END
        END
        RELATION,ONE:MANY
Organizations FILE(ORG:key_OrganizationID)
People    RELATED_FILE(PEO:keyOrganization)
          FILE_TO_RELATED_KEY
            FIELD(ORG:Organization_ID,PEO:Organization)
          END
          RELATED_FILE_TO_KEY
            FIELD(PEO:Organization,ORG:Organization_ID)
          END
        END
        RELATION,ONE:MANY
address_types FILE(ADD:keyAddrType)
org_addresses RELATED_FILE(ORG1:key_addr_type)
          FILE_TO_RELATED_KEY
            FIELD(ADD:Addr_Type,ORG1:org_addr_type)
          END
          RELATED_FILE_TO_KEY
            FIELD(ORG1:org_addr_type,ADD:Addr_Type)
          END
        END
        RELATION,ONE:MANY
Organizations FILE(ORG:key_OrganizationID)
org_addresses RELATED_FILE(ORG1:key_link_to_org)
          FILE_TO_RELATED_KEY
            FIELD(ORG:Organization_ID,ORG1:link_to_org)
          END
          RELATED_FILE_TO_KEY
            FIELD(ORG1:link_to_org,ORG:Organization_ID)
          END
        END
        RELATION,ONE:MANY
Notes     FILE(NOT:KeyNoteID)
Update_notes RELATED_FILE(UPD1:key_link_and_date)
          FILE_TO_RELATED_KEY
            FIELD(NOT:NoteID,UPD1:link_to_action)
            FIELD(NOLINK,UPD1:update_date)
          END
          RELATED_FILE_TO_KEY
            FIELD(UPD1:link_to_action,NOT:NoteID)
          END
        END
        RELATION,ONE:MANY
Ideas     FILE(IDE:KeyIdeaID)
Update_ideas RELATED_FILE(UPD2:key_link_and_date)
          FILE_TO_RELATED_KEY
            FIELD(IDE:IdeaID,UPD2:link_to_action)
            FIELD(NOLINK,UPD2:update_date)
          END
          RELATED_FILE_TO_KEY
            FIELD(UPD2:link_to_action,IDE:IdeaID)
          END
        END
        RELATION,ONE:MANY
status_reports FILE(STR:key_status_report_id)
Update_status RELATED_FILE(UPD4:key_link_and_date)
          FILE_TO_RELATED_KEY
            FIELD(STR:Status_Report_ID,UPD4:link_to_action)
            FIELD(NOLINK,UPD4:update_date)
          END
          RELATED_FILE_TO_KEY
            FIELD(UPD4:link_to_action,STR:Status_Report_ID)
          END
        END
        RELATION,ONE:MANY
Scope_Changes FILE(SCO:key_change_id)
Update_Scope RELATED_FILE(UPD7:key_link_and_date)
          FILE_TO_RELATED_KEY
            FIELD(SCO:Change_ID,UPD7:link_to_action)
            FIELD(NOLINK,UPD7:update_date)
          END
          RELATED_FILE_TO_KEY
            FIELD(UPD7:link_to_action,SCO:Change_ID)
          END
        END
        RELATION,ONE:MANY
Issues    FILE(ISS:key_change_id)
Update_Issues RELATED_FILE(UPD6:key_link_and_date)
          FILE_TO_RELATED_KEY
            FIELD(ISS:Issue_ID,UPD6:link_to_action)
            FIELD(NOLINK,UPD6:update_date)
          END
          RELATED_FILE_TO_KEY
            FIELD(UPD6:link_to_action,ISS:Issue_ID)
          END
        END
        RELATION,ONE:MANY
Documentation FILE(doc:key_documentation_id)
Update_Documentation RELATED_FILE(UPD5:key_link_and_date)
          FILE_TO_RELATED_KEY
            FIELD(doc:Documentation_ID,UPD5:link_to_action)
            FIELD(NOLINK,UPD5:update_date)
          END
          RELATED_FILE_TO_KEY
            FIELD(UPD5:link_to_action,doc:Documentation_ID)
          END
        END
        RELATION,ONE:MANY
development_log FILE(DVP:key_development_id)
Update_Devlp RELATED_FILE(UPD3:key_link_and_date)
          FILE_TO_RELATED_KEY
            FIELD(DVP:Development_ID,UPD3:link_to_action)
            FIELD(NOLINK,UPD3:update_date)
          END
          RELATED_FILE_TO_KEY
            FIELD(UPD3:link_to_action,DVP:Development_ID)
          END
        END
        RELATION,ONE:MANY
Documentation FILE(doc:key_documentation_id)
Blob_doc  RELATED_FILE(BLO41:key_link)
          FILE_TO_RELATED_KEY
            FIELD(doc:Documentation_ID,BLO41:link_to_doc)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO41:link_to_doc,doc:Documentation_ID)
          END
        END
        RELATION,ONE:MANY
Action    FILE(TOD:KeyToDoID)
Update_Action RELATED_FILE(UPD:key_link_and_date)
          FILE_TO_RELATED_KEY
            FIELD(TOD:ToDoID,UPD:link_to_action)
            FIELD(NOLINK,UPD:update_date)
          END
          RELATED_FILE_TO_KEY
            FIELD(UPD:link_to_action,TOD:ToDoID)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
Documentation RELATED_FILE(doc:key_projectlink_and_sequence)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,doc:project_link)
            FIELD(NOLINK,doc:status)
            FIELD(NOLINK,doc:Sequence_Number)
          END
          RELATED_FILE_TO_KEY
            FIELD(doc:project_link,PRO:ProjectID)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
Documentation RELATED_FILE(doc:keyOwner_Link)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,doc:owner_id)
            FIELD(NOLINK,doc:status)
            FIELD(NOLINK,doc:Sequence_Number)
          END
          RELATED_FILE_TO_KEY
            FIELD(doc:owner_id,PEO:Name)
          END
        END
        RELATION,ONE:MANY
Scope_Changes FILE(SCO:key_change_id)
Blob_scope RELATED_FILE(BLO5:key_link)
          FILE_TO_RELATED_KEY
            FIELD(SCO:Change_ID,BLO5:link_to_scope)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO5:link_to_scope,SCO:Change_ID)
          END
        END
        RELATION,ONE:MANY
development_log FILE(DVP:key_development_id)
Blob_devl RELATED_FILE(BLO4:key_link)
          FILE_TO_RELATED_KEY
            FIELD(DVP:Development_ID,BLO4:link_to_devl)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO4:link_to_devl,DVP:Development_ID)
          END
        END
        RELATION,ONE:MANY
Issues    FILE(ISS:key_change_id)
Blob_issues RELATED_FILE(BLO31:key_link)
          FILE_TO_RELATED_KEY
            FIELD(ISS:Issue_ID,BLO31:link_to_issues)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO31:link_to_issues,ISS:Issue_ID)
          END
        END
        RELATION,ONE:MANY
Ideas     FILE(IDE:KeyIdeaID)
Blob_ideas RELATED_FILE(BLO3:key_link)
          FILE_TO_RELATED_KEY
            FIELD(IDE:IdeaID,BLO3:link_to_ideas)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO3:link_to_ideas,IDE:IdeaID)
          END
        END
        RELATION,ONE:MANY
Action    FILE(TOD:KeyToDoID)
Blob_action RELATED_FILE(BLO21:key_link)
          FILE_TO_RELATED_KEY
            FIELD(TOD:ToDoID,BLO21:link_to_action)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO21:link_to_action,TOD:ToDoID)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
Blob_Phase RELATED_FILE(BLO2:key_link)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,BLO2:link_to_phase)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO2:link_to_phase,PRO:ProjectID)
          END
        END
        RELATION,ONE:MANY
Project   FILE(off:KeyOfficeID)
Blob_Project RELATED_FILE(BLO1:key_link)
          FILE_TO_RELATED_KEY
            FIELD(off:OfficeID,BLO1:link_to_project)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO1:link_to_project,off:OfficeID)
          END
        END
        RELATION,ONE:MANY
Notes     FILE(NOT:KeyNoteID)
Blob_Notes RELATED_FILE(BLO:key_link_to_notes)
          FILE_TO_RELATED_KEY
            FIELD(NOT:NoteID,BLO:Link_to_Notes)
          END
          RELATED_FILE_TO_KEY
            FIELD(BLO:Link_to_Notes,NOT:NoteID)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
Scope_Changes RELATED_FILE(SCO:keyOwner_Link)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,SCO:owner_id)
            FIELD(NOLINK,SCO:status)
            FIELD(NOLINK,SCO:Sequence_Number)
          END
          RELATED_FILE_TO_KEY
            FIELD(SCO:owner_id,PEO:Name)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
Issues    RELATED_FILE(ISS:keyOwner_Link)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,ISS:owner_id)
            FIELD(NOLINK,ISS:status)
            FIELD(NOLINK,ISS:Sequence_Number)
          END
          RELATED_FILE_TO_KEY
            FIELD(ISS:owner_id,PEO:Name)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
status_reports RELATED_FILE(STR:keyOwner_Link)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,STR:owner_id)
            FIELD(NOLINK,STR:status)
            FIELD(NOLINK,STR:Sequence_Number)
          END
          RELATED_FILE_TO_KEY
            FIELD(STR:owner_id,PEO:Name)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
development_log RELATED_FILE(DVP:keyOwner_Link)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,DVP:owner_id)
            FIELD(NOLINK,DVP:status)
            FIELD(NOLINK,DVP:Sequence_Number)
          END
          RELATED_FILE_TO_KEY
            FIELD(DVP:owner_id,PEO:Name)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
Scope_Changes RELATED_FILE(SCO:key_project_link)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,SCO:project_link)
          END
          RELATED_FILE_TO_KEY
            FIELD(SCO:project_link,PRO:ProjectID)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
Issues    RELATED_FILE(ISS:key_project_link)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,ISS:project_link)
          END
          RELATED_FILE_TO_KEY
            FIELD(ISS:project_link,PRO:ProjectID)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
status_reports RELATED_FILE(STR:key_project_link)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,STR:project_link)
          END
          RELATED_FILE_TO_KEY
            FIELD(STR:project_link,PRO:ProjectID)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
development_log RELATED_FILE(DVP:key_project_link)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,DVP:project_link)
          END
          RELATED_FILE_TO_KEY
            FIELD(DVP:project_link,PRO:ProjectID)
          END
        END
        RELATION,ONE:MANY
phonetypes FILE(PHO:keyPhoneType)
people_phone RELATED_FILE(PEO1:key_phone_type)
          FILE_TO_RELATED_KEY
            FIELD(PHO:PhoneType,PEO1:Phone_Type)
          END
          RELATED_FILE_TO_KEY
            FIELD(PEO1:Phone_Type,PHO:PhoneType)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
people_phone RELATED_FILE(PEO1:key_person_link)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,PEO1:person_link)
          END
          RELATED_FILE_TO_KEY
            FIELD(PEO1:person_link,PEO:Name)
          END
        END
        RELATION,ONE:MANY
Project   FILE(off:KeyOfficeID)
Phases    RELATED_FILE(PRO:KeyOfficeLink)
          FILE_TO_RELATED_KEY
            FIELD(off:OfficeID,PRO:OfficeLink)
          END
          RELATED_FILE_TO_KEY
            FIELD(PRO:OfficeLink,off:OfficeID)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
Notes     RELATED_FILE(NOT:KeyOwnerLink)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,NOT:OwnerLink)
            FIELD(NOLINK,NOT:status)
            FIELD(NOLINK,NOT:Sequence)
          END
          RELATED_FILE_TO_KEY
            FIELD(NOT:OwnerLink,PEO:Name)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
Ideas     RELATED_FILE(IDE:KeyOwnerLink)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,IDE:OwnerLink)
            FIELD(NOLINK,IDE:status)
            FIELD(NOLINK,IDE:Sequence_ID)
          END
          RELATED_FILE_TO_KEY
            FIELD(IDE:OwnerLink,PEO:Name)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
Action    RELATED_FILE(TOD:KeyAssignedToLink)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,TOD:AssignedToLink)
            FIELD(NOLINK,TOD:status)
            FIELD(NOLINK,TOD:Sequence)
          END
          RELATED_FILE_TO_KEY
            FIELD(TOD:AssignedToLink,PEO:Name)
          END
        END
        RELATION,ONE:MANY
People    FILE(PEO:KeyName)
Phases    RELATED_FILE(PRO:KeyOwnerLink)
          FILE_TO_RELATED_KEY
            FIELD(PEO:Name,PRO:OwnerLink)
          END
          RELATED_FILE_TO_KEY
            FIELD(PRO:OwnerLink,PEO:Name)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
Action    RELATED_FILE(TOD:KeyProjectLink)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,TOD:ProjectLink)
          END
          RELATED_FILE_TO_KEY
            FIELD(TOD:ProjectLink,PRO:ProjectID)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
Ideas     RELATED_FILE(IDE:KeyProjectLink)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,IDE:ProjectLink)
          END
          RELATED_FILE_TO_KEY
            FIELD(IDE:ProjectLink,PRO:ProjectID)
          END
        END
        RELATION,ONE:MANY
Phases    FILE(PRO:KeyProjectID)
Notes     RELATED_FILE(NOT:KeyProjectLink)
          FILE_TO_RELATED_KEY
            FIELD(PRO:ProjectID,NOT:ProjectLink)
          END
          RELATED_FILE_TO_KEY
            FIELD(NOT:ProjectLink,PRO:ProjectID)
          END
        END

[REPORTVIEWS]
Report1 VIEW(Organizations),ORDER('UPPER(ORG:Organization_Name),ORG:Organization_ID'),KEY(ORG:key_org_name)
          JOIN(PEO:keyOrganization,ORG:Organization_ID),CHILD
          END
        END
Report2 VIEW(People),ORDER('UPPER(PEO:Name)'),KEY(PEO:KeyName)
        END
Report3 VIEW(Organizations),OPT,ORDER('ORG:Organization_Name')
          JOIN(OPH:key_org_link,ORG:Organization_ID),CHILD
          END
          JOIN(ORG1:key_link_to_org,ORG:Organization_ID),CHILD
          END
        END
Report4 VIEW(Project),ORDER('off:Sequence,off:OfficeID')
        END
Report5 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:Sequence,PRO:ProjectID')
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
          END
        END
Report6 VIEW(Project),ORDER('off:Sequence,off:OfficeID')
          JOIN(BLO1:key_link,off:OfficeID),CHILD
          END
        END
Report14 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:ProjectID,TOD:ToDoID,UPD:update_date'),KEY(off:keySequence2)
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
            JOIN(TOD:KeyProjectLink,PRO:ProjectID),CHILD
              JOIN(UPD:key_link_and_date,TOD:ToDoID),CHILD
              END
            END
          END
        END
Report13 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:ProjectID,DVP:Development_ID,UPD3:update_date'),KEY(off:keySequence2)
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
            JOIN(DVP:key_project_link,PRO:ProjectID),CHILD
              JOIN(UPD3:key_link_and_date,DVP:Development_ID),CHILD
              END
            END
          END
        END
Report12 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:ProjectID,STR:Status_Report_ID,UPD4:update_date'),KEY(off:keySequence2)
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
            JOIN(STR:key_project_link,PRO:ProjectID),CHILD
              JOIN(UPD4:key_link_and_date,STR:Status_Report_ID),CHILD
              END
            END
          END
        END
Report11 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:ProjectID,ISS:Issue_ID,UPD6:update_date'),KEY(off:keySequence2)
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
            JOIN(ISS:key_project_link,PRO:ProjectID),CHILD
              JOIN(UPD6:key_link_and_date,ISS:Issue_ID),CHILD
              END
            END
          END
        END
Report10 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:ProjectID,SCO:Change_ID,UPD7:update_date'),KEY(off:keySequence2)
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
            JOIN(SCO:key_project_link,PRO:ProjectID),CHILD
              JOIN(UPD7:key_link_and_date,SCO:Change_ID),CHILD
              END
            END
          END
        END
Report9 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:ProjectID,IDE:IdeaID,UPD2:update_date'),KEY(off:keySequence2)
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
            JOIN(IDE:KeyProjectLink,PRO:ProjectID),CHILD
              JOIN(UPD2:key_link_and_date,IDE:IdeaID),CHILD
              END
            END
          END
        END
Report8 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:ProjectID,-doc:status,doc:Sequence_Number,doc:Documentation_ID,UPD5:update_date'),KEY(off:keySequence2)
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
            JOIN(doc:key_projectlink_and_sequence,PRO:ProjectID),CHILD
              JOIN(UPD5:key_link_and_date,doc:Documentation_ID),CHILD
              END
            END
          END
        END
Report15 VIEW(Project),ORDER('off:Sequence,off:OfficeID,PRO:ProjectID,NOT:NoteID,UPD1:update_date'),KEY(off:keySequence2)
          JOIN(PRO:KeyOfficeLink,off:OfficeID),CHILD
            JOIN(NOT:KeyProjectLink,PRO:ProjectID),CHILD
              JOIN(UPD1:key_link_and_date,NOT:NoteID),CHILD
              END
            END
          END
        END
Report16 VIEW(People),OPT,ORDER('PEO:Name,PEO1:Phone_Type,PEO1:Phone_Number')
          JOIN(PEO1:key_person_link,PEO:Name),CHILD
            JOIN(PHO:keyPhoneType,PEO1:Phone_Type)
            END
          END
        END
Report17 VIEW(Functions),ORDER('UPPER(FUN:Functional_ID)'),KEY(FUN:keyFunctionalID)
          JOIN(PEO:keyFunctionalRole,FUN:Functional_ID),CHILD
          END
        END

[SOURCES]
        DICTIONARY,VERSION('1.0 r40'),DATE(72102),TIME(7881900),NAME('E:\DEVELO~1\TEAMBU~1\TEAMBLDR.DCT')

[SEARCHPATHS]
        PATH('TEAMBLDR.TPS','E:\DEVELO~1\TEAMBU~1\')
        PATH('TB_BLOBS.TPS','E:\DEVELO~1\TEAMBU~1\')