{ "ReportVersion": "2023.3.3", "ReportGuid": "edd27db66ac1f8d37986ad2407109c38", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "/Users/ericpoon/Desktop/JoinColumnContent.mrt", "ReportAuthor": "Eric Poon", "ReportCreated": "/Date(1709314147000-0800)/", "ReportChanged": "/Date(1709314396000-0800)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "Dictionary": { "Resources": { "0": { "Name": "FormatB-NDOT", "Alias": "FormatB-NDOT", "Type": "Json", "Image": "4DB9nPMPnZjQOqIMGKeobGp+jtrow7jRgdQIzBzkLadp46SH00eyyj6cMKZtSESQgpk4TPVNYVhoRLOKl3R45wVTsiP80NyytLanDmdBj+gpQowq5OhemU3su+qBj5p/zyqXk7LZBMkNMO8hZNex7joNNbE0UNGTzGm5z3u5czvHf5reGGX4y7xYmwodfifr2X8gSZdpmg56Ji7loxRcR4/MXlxBo93+2jFbSA4JqCdY1+fYGMP/qLd+s8h5bq1OBdBv7WuYhVtgpDJrNOjRcLWB9D7USaeTzj94hL0YvUp354vp96qpJSiHdpxy77zlYLfBk9YH+Hb5eO0UosEUhoJYxH9P/B9EbW2/ssZjkTVkaA9bWAeUm+DL81SFy9wWobvgIfVrtFTRCZ6n6mYW3isOx3MJ0bcAqvTzm2VP1f4uUkJtm9wOoV3N0mu5rccvqdmgjLqbwO5ExZatIac+fCQHNwujF9McisllkuH6mqMpjl+KdLxFN+yN8exGKnFrL067wg0fV4QtdUbXZzwwg9zGzbvVHy7x3DzkiT2yOYCwqWpe7CalYhmOHAl7nVGA37O53Umg/+wHzgq+buqP+L8NyfT0pKQzbkgfxlwLv0Gzfhbyy6X7k1MtHe49I2GhkZI3vH+/os2YKU58tmQ0CtuPtKuBX5Xu2USl2mKjfT7ceDARcpGXcZ4KXsBqfdU+9eiLWRrhjsHwJn21ftJKz2e57BOEc3xdUd3yF6nGNyI9BQQqDIjZ8YlAmYaMWgBj1LnliuHpCEUih25BsU0JJessUZOve8QS2SVv6+Z5Mq/EiDHdjsEKwwKP7hfKVRkq9kQITigv9OZMrPumy7Xk6VIO44xZyF25cqcXOcciiGV859jDTvF3ci2q124o5zg928x41nmQOB8wJBrjqCeXwqf/0/cN8uQRwBZY8P7UKiOoQPLic9Ln95jAxdVHxIQgN3X3AVOSqhDOAGBfpPvT0QNl9ihjceAD08qwH6jgDw1UQYePmBJ8sRuCwK7wF3V+X25TI3I7CGb3jG+k2H4aa7GSSYhzMvYcwi29G3/4EDw2OkQ70iKwPb9RAIEetIYEkt7D4JTLGehEVKGX+92hPxDYQUJ/Tkhi1w1XTFI1BHCzOX1lcq+ywhDbGMFOHf9EdSc4y0gILt6oSilWQAHEjSY8Zg7tWMLonEvqq2uB+ztbu+2hDSJuG2X9ftg2qqfSaQN5BdudDYfdQqgQzmTDZYZNp4khbH7SYELfHa2vQyRV9GtI7Y3p1VRkUlhG5Jy/ItBSrRgF4ExoPxGQ/zqOZdomxBmH16NDHi3/8Ghb99DfRLfPXLbxtMZkmYrFQV0L/oxF9H4BxvMrYp6uGDziZixQRjG0kU2zmRyCHJ+iJtGMstkFdZDMvIB2+zCU8EyitnDOCmuo9xhQ7s/CQTTHK9x0GxubhdKI8wqG+olg2bjkK7sE+KCR72cAaYMPoHUTJnP7PWlKQGvhQyKaVw0zkTOFOcb2KhYuQiNxtVRlOHfHLkzDmDxGszPKT5UgdocNHJizEj6sscvApHkeM913jSw3HNoIvFAr6/qRM/BA0cJ4qPye6jJFMYihZyzZp1KoTn0SPDGkl6ZgRhShLzPLYGMdq4Atv1bVON6aZ/sZc4j29xZKoQfU2TIBEaAfAsFYn0GR8eNlLguSCuVqQbG+hjKluqw6l/ZpyIMvDFErpllWI9DKIyASIsAdIq7IkrYixHlxf2nVZhWOXy0dl8Eq7ZOChPmbLZLVd/N29KsRqSFIHkUMOki0ZVTCs+QcUFCA4dwJhrzagITSelMklvk66IB+eS8YTYImlT2x11MNmDi+uODsf6fnXyifRaMty4sTTABjUEVEkdjdif0aiXpmwKrbPVoU5xIT7QOtqD0gQdiMnQGIhsbCzBA8nAe2NHRnfxCNwIRREiQaJ+UjrxtauFpbcr8VCNOQAiCiHWfFmzLstsem0a7mmoSrzBrFOv9FwvPC3UHp+QoBWfwjClrub9/+FYBu6msjmqY7PNoySX68X6byiof7v3/iMOPmPMqYeMOo99CNgTpFI1PnnCxXIwcb+yV5OxgWVkdsR/mTr41RyML3cDKNuS++4XzqRbRhEp2kaasfub2JpPkIZ57Nc0SKWiuba4YJ8+0pc12dMTPfN2cY98lck8IoQ73P/Qa4IAowo7d1o9AxCQMK1Grt83r9JRqY0pXKPdEG4+RQOHVXt3zypjCWm0S4jmA8cfoSV8B6TQ9uDqOEjQzWRytVIXxdjzKOFymzXGiTgOGNyZRGMPhMtBA4VjgdyK8UFfLbyGg839uBrmKN79suatTgmKQ15wRdudZE5SAzKmN8062sgDEQLr/fyxozqD2lQ9OjKUAEbuTCpKzHdciEyVgTWj+HrTCGFpvXXa2umPi4Rgjft37pernM2r9/kwDpPldgL3isDydSEURfptwaIRFxovVeHjK6we32QMKrInmyUzXh06gdHYNx9JhzOLSjeXByzgcIVlfSMECN3mwciWCLyZHfLyuxJoPibRuMX0Z8lfdB+1eKlmhELQlIfevsZFwe2DrCjb83rrmk9S6rQ3syZa5TvfjClrfG9nc1lfX9sg4G7XDTZp8MOVhcT3JiWMHkYrD4GSSoMgufpsXdUKChhFlZwjp6XomSBV0qCsH81Qx7Wbla/QTbtBRYhYZ9BF9S+1RedmwCfuLREv5Pi0zF3j7myUA7PrNv/DkrL+aieusWP7p/iZHEL0WwftBmZAyl4lHZmcCDjha/+Ims+zgMVnSOI27wp/rOzFo0Vo7nvZBPFCFPOknpBnli8IKfztA1asjOakkRUMJknXe2P6cCY6QniMTxcrKfWBrN+pZ127hvuQ+1ceXqzfOQYZidptSd2F0tajHd9fHu/p4C7w68vFoP8NmG+IyFDiMglkBwDKVLYyqvV67oVQ8FQboiWsj8PHA0KRnwbJ9g1vKTQiFOwj4Y8j/F61D+4wuOyUqxq9AgEiZ54jL4AkTgPPlrG1eMOnCiLhL55tgK+UVhQR7uLor+0mZGf0tjPMP82y/VxzVySdOCMqQEWMlkdHLhqWhPViNJXzU86lB/f67VcvPFaY3QsS4m6hzU1RJMv0mkpHSya1RCCnSNM5fH+wRFCgDVdwVZFGS8FoTC1HOob9tyBq5xOzvnhk5AxyzMUgQw930GS8mcobN5OUS5TSckpr85qTlALcnRf47nhBwjBQb7JeG1t6ltW/hxEHziDMd0dlucKg0AJYVgrrI+rIwgduytywLNeAg4gWpqc6N9lFem03iJq/VibeTZbwgc+y2ZnYgjbz8gjoSM5mEy/04wvDLBUB63iQ6DMl1yxKtL7EgacdyMIafeyqD31G2royXJHtBDvBM8vbe62doQAHpfdKN4Q81OumzP8dmbHweRcZ6JuDOdABd0IYW61e2FhYy7rbzNtUGQXDIXsWyF7iejUP7h1FHWLNB93YrC64pIMwEdqPkNZfs8SMgyPd4EOcRnFMTqNDnV+3mXSCZVbx4ew2fGYRiFmhV+W21eRXVy3EHkCSoht69TgL320DDBf2vph+0kPEhBN2IqaUL2cF9OjL8HggLVEB+qvu7ehuTogik4/SIoU3Ay9Q/r9n3VM9g7pPEx6uHA8/8T1gF1SbplS5gEL57ACN4CS59XCaRh0FKQs9uE262h6lWsi2uUKYUkf5TwHAltNmIPJs3sT2oQJPhDEWt25LS/z6kiQAJD+4MZ/Jmqd3JZS61lO/RoHJBvzESPoKPz3//ajlxE78Mvs+3fkv1EIs+nppJDSMjv+S/FbDra+JG4zTSZcvQezm/6hLApKJCmCEZSVvwG3Pv2jEBBF4+la07egKpNmutvjDBRUGWYSxEV+gRvxBBPpH+u+tsiRNRXPWfDpLR9Cz7Q+CjZGP6ZpbkjgW5GoNkxY0E8SExZ83KQ5NVI3Ucn0nVyF+4LMrkXdeaCEa/oKzvvW674/a9jaP8TRdzKqzc95AuBjdsifySARHFfkw3RKR0qK+lTUJgeophEf1Hyre7UcbVeHOPIk3NJaEnhAHw1ZcIaSP5P+Ex/NBULJ5cIt4YyzfOUa+/it5NhWTaSOdQS0uO3PWGQijmP/WWyF42Gxt6+EwOv9Ht+ob2AgnLFbAA8w7A07N+thXzPH2ZShOKo94+qM9B/6sj4pYRmnBCC6qjRdkhqJUr8uhUoIVou3Uz1c0P7rOAj86kgqdn+raCoe4pFOfIKT2F65KXQmRQzwSJhw4U0b12BOJ1430wa54gtCBBljgoQjDxUgw9q7GVzDXlhof32a17EXwCbakMtQ0buTPvDFG77KZ2yMNrtQLcylOJLrY33GtUb7LOMAbUSgidTW9iI6nDvQbcC0ncxOAFd181KoWwMdjSshQBH83TDdlp54SUxqInbQhMOI06Cu5sHr4SFbc96FR4PrlyLGgSmro6p/U9KnJUsjOhJj/4Ms6GrzrJXXS0mIdd8PWEB4YT5Vzyx8VimNgxz3S9DrqwqgTWe9uLHdUzYQAGpqKYKN0pErzEH97ts/eiUlb8iqvM8ZTLnU4aYDqY2LeDpqRtgj6nn6jz8u2M6scjVOklUeyGVeyHHaK3GhBur8QNm7d+LZ2QqC6TuhWn9HWSTWZPBNCicZ5M9DzgrJr5UlG9WQvm47r+EZrw9FF9fzYlmMQGuKg2b7OTZFuEIKLbVAJBjjj1a/3TxQdwIZzD3B6Ju10xdhIj4f1GcvkKJ5KRcBoxCTj62NdzugIU0dpR33UgnDwqwvwjMvM4irN2/6tCXlLxrl8h12EO4nsE5l5XYKhgPYByCB2pF+Xuc0EpnxPSJYYavlyhTwz1wgNK7uE7XHUMObhTp4rYZoloCFoAKuKsnMI9qvqKX/yZoRhDPPppPxYn+GulY8035Ld4qslTkkmMcNFQmZKeGdcBHP5ICIUOFjhUnN3I5Ph3N1Hw9EnXgDqB69vBaSeRS6vC7SBwWmQDmX3XAXm/2GwQTfz5sAUaBKsUXUn+1PqROfnHhgCTZzZPbdQMn3Xs8EF8kAKHfcSBqenIe2shPaaKGazSCYl64mpcndikUT8c0XJEMuQiNYEzFBDc1FGFmxKOzYVXnrQmCOtEulH+D9YY3mqfu0uHfsEMud9GRGNys8E6UJr2ZNEXTaqVl9xWnvC1f7M2qnil62WAOi3GrX8wZOJOLdmMoPuFP8vTRBLFZESbrOx49ZvGuGdLQFN0zW13245FXjhHKKRS1Se88vCiq25rJHTWVhF/o5rkvSGkZMhrB/dYM+xDlj5HaPKiUv4KoReipkTGevkFxp04HZvqWV+9pCH5vpRRZa/X0jhFSodawnMmLd/vQIVp+rs6MgyDcameVuUJ/iKkpCJRxCvMEHgTHHkh8DDjVtKu/1aSJ5JR08Rdl8Ehubydp1tJn1Xf8Nk4yGELUJXhL2iXmOJOsMI7CSFtsqtdPE3rsCOYnNuLmpwGkGRkk3wAqjgw0ebjHZ9WLpKF5iJbWU0mtnXuQMhOMVdhEkqruQC1dE0yGbYsJ/S27Fi5HQzm4hcWcz4xYgVlVjTmclX9FLAq9w2lkZBrStsY9WBmkVXidiEN68kNOaRDWAupM5Dt+rRIOHidVvUso9qDsudV7rJfQrMT18W+LNWiL38yjv4PIdYqFiGcSRpklkAanWWS3SG5oGW9ylbauczDCDUWKni5l5PGAvZo20FN6m5OC6d5/slr6V0FyZyZk73yl87zRvuxSd2AlwK3LmdWgt5GQItMPnBUqnNKAKoXo1aWuDAFYQAZ4wV6SafKLhbuRZrVxqfUp/YP+fPE5VVHYL2P8auYh+KtVkADfdkuo0xAyjVKGmSoyXd8nEgwmMj6JNtdsq28uC3Zhn7Fi2IUQaaaLOhHDDEwph9+dtuV8bleUtu0OSgpd/KBomCmNhtP28i8HBq8Fdr7xeZ3DZz2FKkT3zrvGOUVa+KXq36tGZRbr+vUlT3lLHzI2YqTBGkx+hQHgl6qrUKw6tfady9ARh/0csVpFfKxP2NzFqRbEXtgnAsE8jFyG5EFCElGehTRHKoXLJbzNWtAEgcvg2uRcaxWDF2DCbJAXtIdGgSSGoN/7qYwsNBQ5ee8lYHbbDVgMOdBShHsFXQx075qoHjVFWW0/wi4+Ze+gO+B4/xTkNenWvuleMvPGnU2QRqON2vLl3Sr4s8Jc1o5jzuSztoFT4b++NgbLYs+wtpmWVXbJcxD1EA+Hl32b14VRopgQBzARd6G+hP2yzUQWB/tvlWjLb11+HtwSTzwdNB+p/YvsrnQnAZJlY7IileRpKKj6upT648razkLXAHH2p3+UgAJchM2s4o+p1Rbo1ilXOlyw7eypuQ61NHfqkwgeplKu9lAPK/EOw5BemnzdeHShj1wJxC1VoIvWRWElvYlW+pFOggfD5X7/VRDeGLn0UCKXuTzdsZqexdLRNgN0baN1pVUvtDsLDoZ/rt4nHZk/WqZATE6Cd52M4JgNMvD6iTBz9K755VyiWhne2hUbofsz2Yob1vc38QZ7NdhnMMBdSZADxcPW82kYOBj/4SEFnPSOQG1iKLYGWo+bob/Wv1qizG0wwiGkwQqtT48peoby/+0jvfU2kxIktxYpDFulXZDD7AYVTswwoLNKPFNMlTmIuJ3jkm7iiC+PhxRkCk6NMuZ04WLof3LLWMwgoWWzF6Ro7Ul1vsGqqD6P7Xfn/ZKjxLuGNdcMb/ZgrWHH0gVWSb1pspWXtwN7HotLiwP/p37+IF7/3g/SSo8LDB5WvprpKbPAcYajfeVvcVSh1ABFQXm8TtRcWSCPaDHnFxCazZyjcjHgHq5Qn0ds8Rbp09FY7Nazj1iMsc5u5hKQX+hRb2rWrva8ZZYpAis+UvJCrTNu6qG/kZuufB6ZRAYAOwfibLTJ+jE1T5rs09+Jl0KGzVI/omsfngv/S4rMh6EyiLgGnOFRTA+Y0PcxT/bsnFkfyWILtmzFk6jhS5uAhIYeLIzyzJpvOcKfZxr7TPGj7wD7+oeW5lFYwPJNDCrx1RF6VemOIn/AjRGilTy5cJ7mXW7TSLBqBdWDIVbFg6uHaik3sicmMhNbmitcjxKKfgqsXOdeTttE6ehBJexObH8xjcU4e9SyH2wxfPLHhkd7Cyut8yDnzzYPO9mBswyX62lY8Qak+93n/IdJrd1W86ewk7afr6boN1NOCTcb+fTAgfhuvxg1Ozt6QCKjl1LEm9ZuRNweHkNzl8n2DEEMhY8KetBS8lHcBKhTda0h5DftwtN84EdeT2vYfGf0ACu7WRB3LCpiRLi/VMKrYjPDlqTUbfE7s4A2nYG3yLEYQIjtfC/9bfw9ZMvnhU+A4hYJqgVgwmGwQKXpxIY93ws2cngkqYvvhZcYrbkEgcNdz79d9JifDX46B94bHnXrpGxfAL7ETdwIraw7Bhg4kt/XGUTpv5h8YfRZWUsPyyTO8T4u0qFtP5rNJzgoea7oqHlug5kH2fXwhVCnANKI0UpgbJlYDJke+oub9OFK3KUn7YZI+PwXm5J7AWGdQkOG+W+SasiiH6NhsT+GiBdr9AwXQvbgoli+fW/YPvzB7/3bLaWJeOLk+6jNHKs1Z3+LvDHu7G9xFcdL2Z18e6ehL+Kw/2evM/01YxfFcxt3XJvDc4wO0iuJ6KgpxV3drygtlkV9cNOL44jqDXEMNheW1Lq3Su+aeKusIk8wco5uYNlXLfvaSfIjtB5l+3Ytfq9BZEFOZBhxcXPCd+emGyMxGBR1IkMMd9Y5IzWF3QaH7wsig4j6+xqkKbk47mgpWxbwA19Mn4zkdCVZXAtqcccgLwJ7trQhk4PYZ7JmCM3hH0QSMOBv9AP/GDvHw89lcNbfEsIk1pwCh+zcK4aexob5fwWzoe6H5yUKE7lKIqYGD+W9dhV7PIFDMN3JXxoHyz2cHw+S09xlaoST7+RlvxEDG70JoMRPv8MepZOeqzW8J4U7SFz01yLn+pHsCtXDrPaRRrX3hj0OAb62GYi8vatk+zowBOuj7wc4piOG7Ef2DbkBxiNA+kRqS4pf+Oif1fhEc2U8sVB5aIlV7gOPjlpyedES8Nm5sRkiQ0GUslyc7Dmv1G+46Eg2N3D/MzV+dqSr0Sr4IKtbGHB09nclQjCN7jTn3IQ7kRgdDlHeOi7fIKwthUp/UjXtNd2XeQ5Zawvg//QajDYmkmXyWjhylYRCf9XxnzOXvetI7Pm8tfHaf71Q3F0nefdFelT3E8CuwMH4LICqDt5g/AC3ccKk6In6RtLxHmw0HhE9bx84DhUM2M/8yM6v+0jBGzW4tDkdtgw8791ML+HDC32pOoz2p7wZI8TtLrYg2lecGhVHCunyQog2VPfeOXyq/XYDpE1KpfhQVbn6K8RDUjYv4V9CdlfctsK7ymtYbBSl7v3NOM5Qw9VIv87hS8X5ETNL/69a2XeVtysfHgCBaHJvUXjRkNH/yKu6QCdwh8W2yiw3dgJ5jns6vSEuHvLSS0JpCkmC3nXOn8s79/Q/D8pa/m5LfxgJ/kT/B8/qHqWzq8ypq+O/VyKX2BZDTLH9e/qySmPvqa5FQUHjLXmZCtpWeTZgFN7LWp+Sfcx5Zgl/q8VCrOHICEKCxjZfmrG4eR/N17gNRF7TW+dRyaEWE4TK7/9RlNfBoDGCNuQXanAD+6tchvYngXPT97tUrGI1txbJ9m1NPsget5VSJy3vrcyRNd879UEY9O6vqk38V2Vl/In5bBLXGrx1Yq/urv88kpW6IYul2dY2+ux0AfYK7/lPR1uoTrrPYxmOTi+n97X7M+Mh/Ev1DoGCQEGtUCp9aIM7fY1la+WK2oTRU3CQboRupBE/lOEOg6sKCDS8xNWIplKxXlTgWrJMVBRU1orFuDwsJKWBjknXV1zeUaCzVqkE3pwLEzVmr6UYsDg8gijjSP1Uxd5GKZl5tAB7hGMyDRGDPS9nD03X81IulSgQ6/PSyTX1OdMqwllBuYUBeaU/N7NLyvnQOsjy72U4U4nzR+OEMKX78b7wUQkK8hPUkGsFgw+eStSkyM1PVRT/+0GbBBnUNmSCIGL7i9Gj62Qwv0TOLz9sO+OX3ZhHGgS7LvbpktgXggmFQ0Sc8Jz5jBD2qV8oG/8w86aDIEq+vbBxRly6eR7OdmNi8cMOQYJZxPNyPv2kkrP2i4qmpRQqqeWuqTAbTDNLmivmLeKa/YXYPGETOqyXwdB4qLvoAVAH5xTjd6Uv4RWi5g/CB86Ah5XPX4p4KhXkGsIjAIbDvAgOWcnCrofCazQHB9q58aJqtjn0rzkPeeupeZev5kq2xoCTJo/GHuIfJoaVqV3f6l32X1hoc+LDsQvslQHbe9mb5VUYjGYOmyyNCLt449NCNxr1CJGu4faIpXlgVYXaUraUPk1YhvVlcuM5HR5XgeC64IGbtfsUbmVcy+/M/kyRAieT1RS5JHF2L3LtO7qDK6RE4gj7OUhLHuPMmxRdTlB1iMEUEc4cp8coVp7z1cAM1+obaWo3cwKz5xULmeby9LpchxTCuEPl+4lfQ5Hd1PCTYTYo6a7KWfib5XIgTQTVhS3u+SEDXrfuD+YVs6WYHKgvW9pEQWa0QO8Ng0QXZiGQ4tAvR6na9hm1xDUz8r55ZINdXLU1BncXNQzyEXwGYijPa+N9LzxQw+4lFjA+ebuRtV2cLJO2gB6viZM89yNDevk6DPj9FexgOW9oWileXzd9eJFpMmA+Lg/IZLodU7npjk7L55NTiC6y6ZLOwKNwIb+Yq5+6p2m+GbHuN5mTeoF4cZvBYJCVj59VL4JI3G0FHyL3viG2FGtVq+XuMcNjPZQRfVOoMZnZI+IdEe3IUSLWb8b/Duvb5MToQlZksUjJKAAvN6HT5wSZTb6TL8yziY8PDYEbH2LE2uFUE0fVD7jEhAz8og87VZfyT0xUdIlTTPWsoDxBbmoqiudjV2EUnlkuFF0Ytos1l6SY/Y9FOHu8dpSle1zZ+jMjEC2XJbHbQlL3m87ah6kURlXd2ojfY2lq/imfgFtmx594a64iprL5UQBN1kjYMWivUolvD/aOc/mCX993PIdJ72c7kK+XWrE6+sMhRC8VOi8s6VOmKQhP0+4D2UzpNfbDexkKTU9Mp+qZfNJ5iKt03S7S6sw2lgbTzZKer6ifSrUdLylb1sxqrRgQhHDjhWtOP4jlmTvNgjyOV0B4XvPbVum8agnZw+DqF4undQX7Lr0+TQMYK7I1qJPTD7j3rXbwC+EQiajjzb8uVkn8ZUQGUi1J5QtczuR0S7zn+Y9KcfVokYXwJQDNJgD+dC9iH7K9pWv5XTPj/fxJvpZPaQsgt1Lo2hhb7i8KC+9f5KGcocaHNikHY5D9hAvAhCVGL8jTgKSfLRXx51kJYNs8oMPTYkK3CPcZxG4DGLmzVPE4D0wc5VOCYKkEYvhMgUnvJhBCdIxz0UEvAv8/ui+3FnbVC4Qm2BmTS99m5hOuZFp80wbbrETZ4Wp3ePoaQaiJ3pjvfIuo3LtfeynF+LAhtIyJmdgSl2FroTDqyhxSxdSntUEffVco+SwHNiHGlr0hMWoMbREQ8xeb2GExJ3OjYUNS33yvx/TjYTznM2pnHJALzlI3cgHLn18J52+AUmiosAoPex6+P1ciV2jwYGWibWSsE7+f70Dy1ik7gboOW9tbwSDoAO/23YAzeFYxI27pmp4x4VxX1LwVM4rzptnZJjYLS9eEU+sgh+/wqkX8LwyNwpNQeZ3KZlY+fLDjrVK09ioYGAweXNsEZ2w9vQN43U2saAzl6Jr8TOwYgDDOjbZMAkGgY/375+f5pLxuP2KS/i306fi3GGPIpb9ydO3vi5HFqD4yH5dy+BUMYtpCu1DlNPm4TuL9pWC82APGmX2a6oWBiMulTNIQ1JUQX1HMUNOYH/46V/GqllNSF6hFtboFvR+qCI4kKuqfouri+XChRNkOxOlKBV7b8szZIxTXjQPc/yDXgl1GtGQMQLm2NmLesivggWlQfpR1JXIES9crD7+j/Y9YXTMIiR/8nDTSaCpUMEEl+pRjnThQvHU03Km3LNsqKRohwO5mgnyEtKGtv4j69Ygfd1KV7mB9VaTZysSFWaritBYPoBnb8ImnVPuaFAR8WEipC3k3XC+Us0hpj+3lI+sv2vCsRW12STglQLMgGCXdrgAzzqUmvfQKgPChAgWBrFtpnezyrSkPn2wDcTvkjzCW9+QZuHTTUB/qKU6ZLMNtXs3FKcvOsGTS2pvanjR0oltQh4KIjznVh99YkJ5sNIH2dN/5RnMtan6D4rMdmxGFUDxO3Qd/7hC4Pc7f4/KESelOaaGAjh8kM6mTHkqYdWfdcC2t+nOkSSEsyMTbwEFsKwkk5WJk097360JNobtTuS1LWcNhJA/xGxjNVjFm/FwOV5zZ/nlfZhaG7h0RaXPQdNmac9EpLHWyOsrqTvVMXSMgr/iMwfoh50XtlPXsu2Iggk397l+X+Y0xUdUFqJ+JXD+V+cqBQmGnKe0hCEDHUgBoc/IGFExbwUDUiLDc42enzPzFBHGzScHjsFC7Rjh065xuoUMFhgxC8XVnb/hXZT/GBLwBYPgsjsyV8bQ8n1BC6KxKO5+F7eTkF319Hww2nBnl9qejIgDb6usYnCRVPUdwyvnPoCAefhnBHDlASWdY5Piw8NtRPrtelXWlI+XeXtVAfwcYKx9bYAr3uRHMllbPJgCwbt2vJrmuMQ/ZRCfFxc1CD7p7EsrEPfSewe1lSpdgcmDiTs32HsdvcCNrlj51U3fi/Wo/vOIFqgqRmf2yz/O/Gjl4N7zaHj0iP+f99UTIllNJP+6RbBXdbyElgNhclHDNLlcZjShFYLHXS3luXjUHWjbNkHXcI95fU36sDtUn3+l7vSpQgXfLVYCra/bM3QyoxQfj0J8oSTrCETUS7okXNSAMQJvhwZ5nviPaaNi+/k5kzPncfo8j2rkGSxE5O0oZK2UUxJdBbC0ZOgLvOlx4Zr6v3DZRDpeJXjat5VcXrbvHLYb6gUDTkzolPp3z6S7fakNMs5rYH6lAUvC0jd0t1mczqJnML2aJVs93W3rhdFELVh8Bzg6+OmRtdvNaWLCkDk+pHlUaf733wyGdcDGk0AFPOWUHHGJzZM/DqeVaVyfGAlheodg18k9XnE5YQyWCsEDSmwv4Yva8SEqfjBn7vwt/hDAIb4JUHMnHX/40pxV/L5CIRfnDFxgXoaR0yktf40jWK/oWaAqpAqXjcMBlwQRxi3aDGRgP4+G+6GmiH4H3oq4GkUhOfWA5Hh+P2dSd8Fr+k7U8V9+RRhIWqviqWGetMYiqfPUWrUFjK3c68shsVP2lqKyTvcjy8OceCpe5yo65GB1yx1lmSsS1ahwT4+a80QsMftVvWb0pxMiCpU05BEXtBb0dW0hzTz5m22fKRSlvioZVt9gyK40hYCINBwjYqPBofYM7UQKgJaFNx0lv7pDZvAaivwd7Zg5I86sNIe3Lb9IS1rZvnjXR/tfkf3MhVVrWf4zuzN0Hkn176Cty2grb3lve4oAb0pOL28spIh+O5hy29jPk/qNMvVDFWXv1ZXg9jvHlnxI+ghKgVHTmxYMcXORaO6XIIgaj3+68DmnEhRsn1ptOOX8ZnuzF7+PU9SfOQ2/tofkv9G4Hsk9DO2cmON/IMYVoS2OYxf5X67wSYnoEcF+SevhWEaaWJGDKg1hPlQPAf0SqQhQAW9uMzyVeTBOuf/Q8X03AMIra7sj5qRptHtOANVoFwhk+gMIkdb7nzHZOk4KgHNHxxI2R81qA7BSqczqVtJLrlYT6+OR191aasvRBp8hRnkeAK0MNBFZrhEH2GVsLVk0UFUAFVE3snsoy7e9NCZA9qkWFARxxqwuar02geLOXOHe9rJ4v40CUVcRHvEZwnMOcL1bUPD2JKlmy2iGIptChsy2BVYZyYWkEiCQza8773cqg7KRUjOhRPt6YLUMPFb8qO/bj1Ds4eseRvFtaRlxKtoMIuEivUbMj8PZAJt1GGQetlzkOuPo8thBSxfEXLvdaCYhEIxqt9MAXLHd2FZaIl4JC3CNm2KXnLr9HaUglt/uYFj6uN+ReCdCYA4cM7/SPPCanSJ3zJtaMZqK90klP+JHQ7a0qwZpaWxvIw29xI+7+m7Hac3vU3nkO49Yx0CSiHuUQKsIJ5NHubMH9HFk5QG1LMhmRrOi7Q1BIO2wQsITEr8j0T8sWiopyQB3bl65xBq84+/4vuHhyYMOpsrxGxm7/MJJYF1MLH3Eupc2GcIjujTteZ9PRKjG6xnAAIi2TRZWXwmnPfFtqwhtFTkyzztijrC1N6P+b5YI62So1Cu+j7FaSkZvrbNl88eqTaCPNy0gHHdfT2BYYPT1gZL73nAm+5bCJAYhVXaIHt3Dw2+G97yIKr5b90YeJ6Mlibw9a7kjRldX6ppIyBF/CtFo5nRAXbvItXkZJyjQOxsWlDiF/qkTV9B+/CIEvtu7QNtegCUNmxIlMX3NsOJQei/zoBS+unaLLHJD/IJA60dQn/WyZ9vB5hzYZHSaAcwfwfhI/cM8a9NYyes7L+m5n3Lo+8jTBRchCwqC0bnvfe4xgeJQE5+VhXYbMvnUF8qFzNpSc1BSLibY1++dc6GkePpp0OVHKtKHIVK//OEXg/WNvANiCnN9fUo8tMGrToCA7zEStPkYWQJc2I2HMocDmkWGE5xu+t3Zkrba2gY5dnicuQkO0ZkRX4CrEAXl5ZkiTeacX+b/lHOkOzF/7a3EHbBBPmmGQzg+OnAditDjw0C5XILAUlyS6bssOUWsRO76keJWeXvWu4yW+7+NMPdhc3AeLQM/WqVAIwcpFnVLo/1JdLLQZ6bP7BWhsc2qQ0LzKT2Zx2DfdbD+qMy6p0pazJn3GBxwvvd3xXRJ26xgTC13hcJBg2TMg21hkDyO+9Z8aW2MB3mx887ByEYaMQLG0SZy0ets1EliNz9OMTFENygkzTLXyf58umWdECykKPPJWeHN2whAKiuoCDBBhmhCb8aWir88mtERfb6voqDA4q44IkwVrfFHUEddNetWLMycmIApOh9OhfGM8148fuI7XNPJf6EqFndM6dxWauO2pMEpOXUCR5m5GhAYSlOred43uSv4RThIuB+BUi3xmFvpTca1lGryJUp9NHDImisGNpYuDgoDTSjQwJfrvVZ9wncUqE0uK8VAdQxdHZuxSqGRs8LExOxcHYFwk3+RNmCHzoiglLKSBLwnWbj2znBe6JYRlQp4YW2wh+ZHhsBc0KQTEzmbKapGVlfKqa73buMKiMUuxOY98mgEemJFAl/qhNILADvmNH26aT1l0ILFjWP3KqcuotPWRdJG37x4BkE3vb4ZsbpT7hWMBwHhgCGrdXpADaOt/N8Q1ZcWThkb/Ud0ywdILMetfz9QjFwkrhG5SA5Em2i7YQ18SVY0EGUsIwtXmnx1FyT+aDYbO1zrtmfhKwIWGJSHSCnsAXSok5Pot1ETflqvJJHChMlGYkVARnhhDEy7xI5en9eb9xfgKy6aSKLuQl+TccO+5i/Ez+4JFmaT5TGHwsXY0uZzUAR/yfgLcW8SEF7huBiQ/A1/6IgAm1rkfd1u1Yc9WmT7SwPeUbuY6urJRTXOsyBQvF9PUkyFd0gjE4pfVotn+BjxbSq2k44bbJZ3+Xi1n+QoVT2KgsD10PKnGQs+LeaTUAoUM0s0zVSkhVWI3gO5Jykr+G8w73jfUrOBFMkW/+7Kbeih+bWy80bTFmLEq7wqtiTwOJKVDubPp8HRxPFXf0HLi4FklaJFidV3IIr9pQf4N/S5mDqkjtCcbI4KWIcfd4xkU92j8aXgnpYEU/h2LsKPVK+AUo54rRJpel8OVSVWj1vh/7Pa9Bdot20LYsrf5WGs0f4Lx2sWvCJ7C//UOdU3Bfrba9ugtd2pXAtf6cxz5Fwq2F7+CMbVPGFpzUHSVgWVCAXXjTAfwh1lnf1Bsc8rGTE3JPmkuwkqBjFmK7XgPMvO9GE3Qsbz3vXNGXVT7SjLgFdyDnevvswbZ4B/vRSQi+e4pQqpdXUTUXTf3CGq9RVmUMhItfjWWnFwvROQ90MRvEl0GGvD+czhpH7ZUIlhfn7hCwSFM+G/bZ2VKl1vd0Za1oU4DKDWaaFGFSvt1PS/b4vcxZn6oS3ggNkh3pijNsjXfmgLL+fI/rcOdfg4OoFrmC4usQOmtyGtM7PRKhwNnFlXWBobN2pjVl5klMSjjuoacfGFzSi4GYlUOtCea5udf+Le2UPEzFSnjme19V6CpQGdC6tlYTtTHoK570tGwEVg2NnvHzGQrT0H7YOh8IIx03hbSvQ4uaYNlC8X7jlRx93Y0k6ZAOQ3Yhqrec+xWlBoBf3mfHVPIVGFzxnInvt+Hv+GI6rpByadXU9oC/7DGFgZzFniWzGK8N3Qh3X9wD8+ne703cIqVeCQydbPIVxhZJ6QNadvLs6vZ6LAaHDrOk9b5BEItC/9KM2DcCYKwlO1YCXLaumK462hFvlhVEzrAs8M5GxOxUnH4Qy2b3hziSOwcAs3mQnBvcs1HRbYpezsxlZ17BFfIQoLjC3OvQfD0VEjjrdQ2kKzl0WuQ6d+dEJjL+D1m8liFQMgHyP2mz9i2fMlFIJ/egZoZ9ma/cMk0kllIWxTNi2znUCGPQ1YPkgGFLhMoz++q4SiSQbM9jRrPtXDAR/DDDmPECkuqgp1aLyfaK1B2a91HCmdUIXKiNLxnCbBCmgBVHyuO+iyu7+cwVGElTtbG2E7L0V6XSXmJM+5bEuQCxw5xpqkTXyw4KmTncvJwVcVU1OdrBHrfmTqxMyXflROF1sUENhTyKd9lKwj+K7SY8hC2E7G1lDPs44ZUVZwwmOykfHlR7qE8eKk+0LQqVoReC18PdQ2WYJszRLTxc8ta5TaTH8saz4ZAAaozuul9wDxy38YupJ7ZNa916Sroz3bvRgJKXQ==" } }, "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "FilterCriteria", "Alias": "FilterCriteria", "Columns": { "0": { "Name": "calculateDeliveryStatus", "NameInSource": "calculateDeliveryStatus", "Alias": "calculateDeliveryStatus", "Type": "System.Boolean" }, "1": { "Name": "includeCompletedProjects", "NameInSource": "includeCompletedProjects", "Alias": "includeCompletedProjects", "Type": "System.Boolean" }, "2": { "Name": "includeGroupProjects", "NameInSource": "includeGroupProjects", "Alias": "includeGroupProjects", "Type": "System.Boolean" }, "3": { "Name": "includePartialIdMatches", "NameInSource": "includePartialIdMatches", "Alias": "includePartialIdMatches", "Type": "System.Boolean" }, "4": { "Name": "includePreviousProjects", "NameInSource": "includePreviousProjects", "Alias": "includePreviousProjects", "Type": "System.Boolean" }, "5": { "Name": "includeRemovedProjects", "NameInSource": "includeRemovedProjects", "Alias": "includeRemovedProjects", "Type": "System.Boolean" }, "6": { "Name": "includeSubProjects", "NameInSource": "includeSubProjects", "Alias": "includeSubProjects", "Type": "System.Boolean" }, "7": { "Name": "isFromReports", "NameInSource": "isFromReports", "Alias": "isFromReports", "Type": "System.Boolean" }, "8": { "Name": "page", "NameInSource": "page", "Alias": "page", "Type": "System.Decimal" }, "9": { "Name": "pageSize", "NameInSource": "pageSize", "Alias": "pageSize", "Type": "System.Decimal" }, "10": { "Name": "planCycles", "NameInSource": "planCycles", "Alias": "planCycles", "Type": "System.String" }, "11": { "Name": "useProjectDeliveryMode", "NameInSource": "useProjectDeliveryMode", "Alias": "useProjectDeliveryMode", "Type": "System.Boolean" } }, "NameInSource": "FormatB-NDOT.FilterCriteria" }, "1": { "Ident": "StiDataTableSource", "Name": "FilterCriteria_planCycles", "Alias": "FilterCriteria_planCycles", "Columns": { "0": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "1": { "Name": "value", "NameInSource": "value", "Alias": "value", "Type": "System.String" } }, "NameInSource": "FormatB-NDOT.FilterCriteria_planCycles" }, "2": { "Ident": "StiDataTableSource", "Name": "PlanCycle", "Alias": "PlanCycle", "Columns": { "0": { "Name": "FiscalYearEnd", "NameInSource": "FiscalYearEnd", "Alias": "FiscalYearEnd", "Type": "System.Decimal" }, "1": { "Name": "FiscalYearStart", "NameInSource": "FiscalYearStart", "Alias": "FiscalYearStart", "Type": "System.Decimal" }, "2": { "Name": "FiscalYears", "NameInSource": "FiscalYears", "Alias": "FiscalYears", "Type": "System.String" }, "3": { "Name": "Id", "NameInSource": "Id", "Alias": "Id", "Type": "System.Decimal" }, "4": { "Name": "Name", "NameInSource": "Name", "Alias": "Name", "Type": "System.String" }, "5": { "Name": "PlanId", "NameInSource": "PlanId", "Alias": "PlanId", "Type": "System.Decimal" }, "6": { "Name": "PlanLongName", "NameInSource": "PlanLongName", "Alias": "PlanLongName", "Type": "System.String" }, "7": { "Name": "PlanName", "NameInSource": "PlanName", "Alias": "PlanName", "Type": "System.String" }, "8": { "Name": "PlanOrganizationName", "NameInSource": "PlanOrganizationName", "Alias": "PlanOrganizationName", "Type": "System.String" }, "9": { "Name": "PlanOwnerId", "NameInSource": "PlanOwnerId", "Alias": "PlanOwnerId", "Type": "System.Decimal" }, "10": { "Name": "PlanParentFullName", "NameInSource": "PlanParentFullName", "Alias": "PlanParentFullName", "Type": "System.String" }, "11": { "Name": "ProjectCount", "NameInSource": "ProjectCount", "Alias": "ProjectCount", "Type": "System.String" }, "12": { "Name": "RevisionCount", "NameInSource": "RevisionCount", "Alias": "RevisionCount", "Type": "System.String" }, "13": { "Name": "ShortName", "NameInSource": "ShortName", "Alias": "ShortName", "Type": "System.String" }, "14": { "Name": "Status", "NameInSource": "Status", "Alias": "Status", "Type": "System.String" }, "15": { "Name": "StatusOrder", "NameInSource": "StatusOrder", "Alias": "StatusOrder", "Type": "System.Decimal" }, "16": { "Name": "SystemId", "NameInSource": "SystemId", "Alias": "SystemId", "Type": "System.Decimal" } }, "NameInSource": "FormatB-NDOT.PlanCycle" }, "3": { "Ident": "StiDataTableSource", "Name": "PlanCycle_FiscalYears", "Alias": "PlanCycle_FiscalYears", "Columns": { "0": { "Name": "FiscalYear", "NameInSource": "FiscalYear", "Alias": "FiscalYear", "Type": "System.Decimal" }, "1": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB-NDOT.PlanCycle_FiscalYears" }, "4": { "Ident": "StiDataTableSource", "Name": "Projects", "Alias": "Projects", "Columns": { "0": { "Name": "CurrentProjectRevision", "NameInSource": "CurrentProjectRevision", "Alias": "CurrentProjectRevision", "Type": "System.String" }, "1": { "Name": "PreviousProjectRevision", "NameInSource": "PreviousProjectRevision", "Alias": "PreviousProjectRevision", "Type": "System.String" } }, "NameInSource": "FormatB-NDOT.Projects" }, "5": { "Ident": "StiDataTableSource", "Name": "Projects_CurrentProjectRevision", "Alias": "Projects_CurrentProjectRevision", "Columns": { "0": { "Name": "2019", "NameInSource": "2019", "Alias": "2019", "Type": "System.String" }, "1": { "Name": "2020", "NameInSource": "2020", "Alias": "2020", "Type": "System.String" }, "2": { "Name": "2021", "NameInSource": "2021", "Alias": "2021", "Type": "System.String" }, "3": { "Name": "2022", "NameInSource": "2022", "Alias": "2022", "Type": "System.String" }, "4": { "Name": "2023", "NameInSource": "2023", "Alias": "2023", "Type": "System.String" }, "5": { "Name": "AQConformity", "NameInSource": "AQConformity", "Alias": "AQConformity", "Type": "System.String" }, "6": { "Name": "AQExempt", "NameInSource": "AQExempt", "Alias": "AQExempt", "Type": "System.String" }, "7": { "Name": "Agency", "NameInSource": "Agency", "Alias": "Agency", "Type": "System.String" }, "8": { "Name": "Beyond", "NameInSource": "Beyond", "Alias": "Beyond", "Type": "System.String" }, "9": { "Name": "BoardApproval", "NameInSource": "BoardApproval", "Alias": "BoardApproval", "Type": "System.String" }, "10": { "Name": "CMP", "NameInSource": "CMP", "Alias": "CMP", "Type": "System.String" }, "11": { "Name": "CON", "NameInSource": "CON", "Alias": "CON", "Type": "System.String" }, "12": { "Name": "Capacity", "NameInSource": "Capacity", "Alias": "Capacity", "Type": "System.String" }, "13": { "Name": "ChangeReason", "NameInSource": "ChangeReason", "Alias": "ChangeReason", "Type": "System.String" }, "14": { "Name": "ChangeReasonDetails", "NameInSource": "ChangeReasonDetails", "Alias": "ChangeReasonDetails", "Type": "System.String" }, "15": { "Name": "ChangedFedAmount", "NameInSource": "ChangedFedAmount", "Alias": "ChangedFedAmount", "Type": "System.String" }, "16": { "Name": "ChangedFedPercent", "NameInSource": "ChangedFedPercent", "Alias": "ChangedFedPercent", "Type": "System.String" }, "17": { "Name": "ChangedTotalAmount", "NameInSource": "ChangedTotalAmount", "Alias": "ChangedTotalAmount", "Type": "System.String" }, "18": { "Name": "ChangedTotalPercent", "NameInSource": "ChangedTotalPercent", "Alias": "ChangedTotalPercent", "Type": "System.String" }, "19": { "Name": "ClientProjectId", "NameInSource": "ClientProjectId", "Alias": "ClientProjectId", "Type": "System.String" }, "20": { "Name": "Contract", "NameInSource": "Contract", "Alias": "Contract", "Type": "System.String" }, "21": { "Name": "County", "NameInSource": "County", "Alias": "County", "Type": "System.String" }, "22": { "Name": "Description", "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "23": { "Name": "DoesThisProjectHaveMulti-ModalElements?", "NameInSource": "DoesThisProjectHaveMulti-ModalElements?", "Alias": "DoesThisProjectHaveMulti-ModalElements?", "Type": "System.String" }, "24": { "Name": "EA", "NameInSource": "EA", "Alias": "EA", "Type": "System.String" }, "25": { "Name": "FHWAApproval", "NameInSource": "FHWAApproval", "Alias": "FHWAApproval", "Type": "System.String" }, "26": { "Name": "FTAApproval", "NameInSource": "FTAApproval", "Alias": "FTAApproval", "Type": "System.String" }, "27": { "Name": "Federal", "NameInSource": "Federal", "Alias": "Federal", "Type": "System.String" }, "28": { "Name": "FederalProject", "NameInSource": "FederalProject", "Alias": "FederalProject", "Type": "System.String" }, "29": { "Name": "FundType(s)", "NameInSource": "FundType(s)", "Alias": "FundType(s)", "Type": "System.String" }, "30": { "Name": "FundTypes(All)", "NameInSource": "FundTypes(All)", "Alias": "FundTypes(All)", "Type": "System.String" }, "31": { "Name": "FundTypes(Federal)", "NameInSource": "FundTypes(Federal)", "Alias": "FundTypes(Federal)", "Type": "System.String" }, "32": { "Name": "FundingChanges", "NameInSource": "FundingChanges", "Alias": "FundingChanges", "Type": "System.String" }, "33": { "Name": "FundingYears", "NameInSource": "FundingYears", "Alias": "FundingYears", "Type": "System.String" }, "34": { "Name": "ID", "NameInSource": "ID", "Alias": "ID", "Type": "System.String" }, "35": { "Name": "IsThisanLPAProject?", "NameInSource": "IsThisanLPAProject?", "Alias": "IsThisanLPAProject?", "Type": "System.String" }, "36": { "Name": "Local", "NameInSource": "Local", "Alias": "Local", "Type": "System.String" }, "37": { "Name": "LocalProjectID", "NameInSource": "LocalProjectID", "Alias": "LocalProjectID", "Type": "System.String" }, "38": { "Name": "LocatedWithinMPOBoundary", "NameInSource": "LocatedWithinMPOBoundary", "Alias": "LocatedWithinMPOBoundary", "Type": "System.String" }, "39": { "Name": "LocationDetails", "NameInSource": "LocationDetails", "Alias": "LocationDetails", "Type": "System.String" }, "40": { "Name": "MPO", "NameInSource": "MPO", "Alias": "MPO", "Type": "System.String" }, "41": { "Name": "MPOApproval", "NameInSource": "MPOApproval", "Alias": "MPOApproval", "Type": "System.String" }, "42": { "Name": "Municipality", "NameInSource": "Municipality", "Alias": "Municipality", "Type": "System.String" }, "43": { "Name": "NDOTDistrict", "NameInSource": "NDOTDistrict", "Alias": "NDOTDistrict", "Type": "System.String" }, "44": { "Name": "NarrativeDescriptionofChanges", "NameInSource": "NarrativeDescriptionofChanges", "Alias": "NarrativeDescriptionofChanges", "Type": "System.String" }, "45": { "Name": "OTHER", "NameInSource": "OTHER", "Alias": "OTHER", "Type": "System.String" }, "46": { "Name": "OldRTCNumber", "NameInSource": "OldRTCNumber", "Alias": "OldRTCNumber", "Type": "System.String" }, "47": { "Name": "P-CEMS", "NameInSource": "P-CEMS", "Alias": "P-CEMS", "Type": "System.String" }, "48": { "Name": "PE", "NameInSource": "PE", "Alias": "PE", "Type": "System.String" }, "49": { "Name": "PSAMS", "NameInSource": "PSAMS", "Alias": "PSAMS", "Type": "System.String" }, "50": { "Name": "PlanRevision", "NameInSource": "PlanRevision", "Alias": "PlanRevision", "Type": "System.String" }, "51": { "Name": "Prior", "NameInSource": "Prior", "Alias": "Prior", "Type": "System.String" }, "52": { "Name": "Prioritized", "NameInSource": "Prioritized", "Alias": "Prioritized", "Type": "System.String" }, "53": { "Name": "ProjectChanges", "NameInSource": "ProjectChanges", "Alias": "ProjectChanges", "Type": "System.String" }, "54": { "Name": "ProjectManagerEmail", "NameInSource": "ProjectManagerEmail", "Alias": "ProjectManagerEmail", "Type": "System.String" }, "55": { "Name": "ProjectManagerName", "NameInSource": "ProjectManagerName", "Alias": "ProjectManagerName", "Type": "System.String" }, "56": { "Name": "ProjectManagerOrganization", "NameInSource": "ProjectManagerOrganization", "Alias": "ProjectManagerOrganization", "Type": "System.String" }, "57": { "Name": "ProjectManagerPhone", "NameInSource": "ProjectManagerPhone", "Alias": "ProjectManagerPhone", "Type": "System.String" }, "58": { "Name": "ProjectQuestions", "NameInSource": "ProjectQuestions", "Alias": "ProjectQuestions", "Type": "System.String" }, "59": { "Name": "ProjectRevisionFunding", "NameInSource": "ProjectRevisionFunding", "Alias": "ProjectRevisionFunding", "Type": "System.String" }, "60": { "Name": "PublicLink", "NameInSource": "PublicLink", "Alias": "PublicLink", "Type": "System.String" }, "61": { "Name": "ROW", "NameInSource": "ROW", "Alias": "ROW", "Type": "System.String" }, "62": { "Name": "SecondaryProjectCategory", "NameInSource": "SecondaryProjectCategory", "Alias": "SecondaryProjectCategory", "Type": "System.String" }, "63": { "Name": "State", "NameInSource": "State", "Alias": "State", "Type": "System.String" }, "64": { "Name": "StateApproval", "NameInSource": "StateApproval", "Alias": "StateApproval", "Type": "System.String" }, "65": { "Name": "StatePJID(TSP)", "NameInSource": "StatePJID(TSP)", "Alias": "StatePJID(TSP)", "Type": "System.String" }, "66": { "Name": "StateStaffApproval", "NameInSource": "StateStaffApproval", "Alias": "StateStaffApproval", "Type": "System.String" }, "67": { "Name": "TCM", "NameInSource": "TCM", "Alias": "TCM", "Type": "System.String" }, "68": { "Name": "TIP/AWP", "NameInSource": "TIP/AWP", "Alias": "TIP/AWP", "Type": "System.String" }, "69": { "Name": "Title", "NameInSource": "Title", "Alias": "Title", "Type": "System.String" }, "70": { "Name": "TotalCost", "NameInSource": "TotalCost", "Alias": "TotalCost", "Type": "System.String" }, "71": { "Name": "Type", "NameInSource": "Type", "Alias": "Type", "Type": "System.String" }, "72": { "Name": "Year1", "NameInSource": "Year1", "Alias": "Year1", "Type": "System.String" }, "73": { "Name": "Year2", "NameInSource": "Year2", "Alias": "Year2", "Type": "System.String" }, "74": { "Name": "Year3", "NameInSource": "Year3", "Alias": "Year3", "Type": "System.String" }, "75": { "Name": "Year4", "NameInSource": "Year4", "Alias": "Year4", "Type": "System.String" }, "76": { "Name": "Year5", "NameInSource": "Year5", "Alias": "Year5", "Type": "System.String" }, "77": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB-NDOT.Projects_CurrentProjectRevision" }, "6": { "Ident": "StiDataTableSource", "Name": "Projects_CurrentProjectRevision_LocationDetails", "Alias": "Projects_CurrentProjectRevision_LocationDetails", "Columns": { "0": { "Name": "#Locations", "NameInSource": "#Locations", "Alias": "#Locations", "Type": "System.String" }, "1": { "Name": "Agency", "NameInSource": "Agency", "Alias": "Agency", "Type": "System.String" }, "2": { "Name": "BridgeNumber", "NameInSource": "BridgeNumber", "Alias": "BridgeNumber", "Type": "System.String" }, "3": { "Name": "County", "NameInSource": "County", "Alias": "County", "Type": "System.String" }, "4": { "Name": "Description", "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "5": { "Name": "From/Primary", "NameInSource": "From/Primary", "Alias": "From/Primary", "Type": "System.String" }, "6": { "Name": "FundTypes(All)", "NameInSource": "FundTypes(All)", "Alias": "FundTypes(All)", "Type": "System.String" }, "7": { "Name": "ID", "NameInSource": "ID", "Alias": "ID", "Type": "System.String" }, "8": { "Name": "LocationType", "NameInSource": "LocationType", "Alias": "LocationType", "Type": "System.String" }, "9": { "Name": "MilePostBegin", "NameInSource": "MilePostBegin", "Alias": "MilePostBegin", "Type": "System.String" }, "10": { "Name": "MilePostEnd", "NameInSource": "MilePostEnd", "Alias": "MilePostEnd", "Type": "System.String" }, "11": { "Name": "PlanRevision", "NameInSource": "PlanRevision", "Alias": "PlanRevision", "Type": "System.String" }, "12": { "Name": "Road/Trail/PathName", "NameInSource": "Road/Trail/PathName", "Alias": "Road/Trail/PathName", "Type": "System.String" }, "13": { "Name": "Route", "NameInSource": "Route", "Alias": "Route", "Type": "System.String" }, "14": { "Name": "System", "NameInSource": "System", "Alias": "System", "Type": "System.String" }, "15": { "Name": "Title", "NameInSource": "Title", "Alias": "Title", "Type": "System.String" }, "16": { "Name": "To/Secondary", "NameInSource": "To/Secondary", "Alias": "To/Secondary", "Type": "System.String" }, "17": { "Name": "TotalCost", "NameInSource": "TotalCost", "Alias": "TotalCost", "Type": "System.String" }, "18": { "Name": "Type", "NameInSource": "Type", "Alias": "Type", "Type": "System.String" }, "19": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB-NDOT.Projects_CurrentProjectRevision_LocationDetails" }, "7": { "Ident": "StiDataTableSource", "Name": "Projects_CurrentProjectRevision_ProjectQuestions", "Alias": "Projects_CurrentProjectRevision_ProjectQuestions", "Columns": { "0": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB-NDOT.Projects_CurrentProjectRevision_ProjectQuestions" }, "8": { "Ident": "StiDataTableSource", "Name": "Projects_CurrentProjectRevision_ProjectRevisionFunding", "Alias": "Projects_CurrentProjectRevision_ProjectRevisionFunding", "Columns": { "0": { "Name": "AC/CP", "NameInSource": "AC/CP", "Alias": "AC/CP", "Type": "System.String" }, "1": { "Name": "Agency", "NameInSource": "Agency", "Alias": "Agency", "Type": "System.String" }, "2": { "Name": "CON", "NameInSource": "CON", "Alias": "CON", "Type": "System.String" }, "3": { "Name": "County", "NameInSource": "County", "Alias": "County", "Type": "System.String" }, "4": { "Name": "Description", "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "5": { "Name": "FY", "NameInSource": "FY", "Alias": "FY", "Type": "System.String" }, "6": { "Name": "FundCategory", "NameInSource": "FundCategory", "Alias": "FundCategory", "Type": "System.String" }, "7": { "Name": "FundType", "NameInSource": "FundType", "Alias": "FundType", "Type": "System.String" }, "8": { "Name": "ID", "NameInSource": "ID", "Alias": "ID", "Type": "System.String" }, "9": { "Name": "OTHER", "NameInSource": "OTHER", "Alias": "OTHER", "Type": "System.String" }, "10": { "Name": "PE", "NameInSource": "PE", "Alias": "PE", "Type": "System.String" }, "11": { "Name": "PlanRevision", "NameInSource": "PlanRevision", "Alias": "PlanRevision", "Type": "System.String" }, "12": { "Name": "ROW", "NameInSource": "ROW", "Alias": "ROW", "Type": "System.String" }, "13": { "Name": "Title", "NameInSource": "Title", "Alias": "Title", "Type": "System.String" }, "14": { "Name": "Total", "NameInSource": "Total", "Alias": "Total", "Type": "System.String" }, "15": { "Name": "Type", "NameInSource": "Type", "Alias": "Type", "Type": "System.String" }, "16": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB-NDOT.Projects_CurrentProjectRevision_ProjectRevisionFunding" } }, "Databases": { "0": { "Ident": "StiJsonDatabase", "Name": "FormatB-NDOT", "Alias": "FormatB-NDOT", "PathData": "/Users/ericpoon/Desktop/StimulsoftReport DataSource/FormatB-NDOT.json", "HeadersString": "YyoQVHvZXeyY3LY5ASN05g==" } }, "Relations": { "0": { "Name": "FilterCriteria", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "planCycles" }, "NameInSource": "FilterCriteria_planCycles", "Alias": "FilterCriteria", "ParentSource": "FilterCriteria", "ChildSource": "FilterCriteria_planCycles" }, "1": { "Name": "PlanCycle", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "FiscalYears" }, "NameInSource": "PlanCycle_FiscalYears", "Alias": "PlanCycle", "ParentSource": "PlanCycle", "ChildSource": "PlanCycle_FiscalYears" }, "2": { "Name": "Projects", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "CurrentProjectRevision" }, "NameInSource": "Projects_CurrentProjectRevision", "Alias": "Projects", "ParentSource": "Projects", "ChildSource": "Projects_CurrentProjectRevision" }, "3": { "Name": "Projects_CurrentProjectRevision", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "LocationDetails" }, "NameInSource": "Projects_CurrentProjectRevision_LocationDetails", "Alias": "Projects_CurrentProjectRevision", "ParentSource": "Projects_CurrentProjectRevision", "ChildSource": "Projects_CurrentProjectRevision_LocationDetails" }, "4": { "Name": "Projects_CurrentProjectRevision", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectQuestions" }, "NameInSource": "Projects_CurrentProjectRevision_ProjectQuestions", "Alias": "Projects_CurrentProjectRevision", "ParentSource": "Projects_CurrentProjectRevision", "ChildSource": "Projects_CurrentProjectRevision_ProjectQuestions" }, "5": { "Name": "Projects_CurrentProjectRevision", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectRevisionFunding" }, "NameInSource": "Projects_CurrentProjectRevision_ProjectRevisionFunding", "Alias": "Projects_CurrentProjectRevision", "ParentSource": "Projects_CurrentProjectRevision", "ChildSource": "Projects_CurrentProjectRevision_ProjectRevisionFunding" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "8d3498472c6b0cd30c8f53ba65b56386", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,0.4,19.01,0.8", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "ClientRectangle": "3.4,0,9.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "JoinColumnContent(Projects_CurrentProjectRevision, \"ClientProjectId\", \",\")" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text2", "ClientRectangle": "0,0,3,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_CurrentProjectRevision.ClientProjectId}" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" } }, "DataSourceName": "Projects_CurrentProjectRevision" } }, "PageWidth": 21.01, "PageHeight": 29.69, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1, "Right": 1, "Top": 1, "Bottom": 1 } } } }