7:30 – 5:30
- Added S2A role and a bunch of new users for Anne
- Deployed the documentation
- Spent some time with Dong working out how to handle the linkages in the data laid out by Jim yesterday. Here are the records as I have in my notes (additionally, note that each field(!?) needs to be able to store a STATIC/DYNAMIC flag and comments. My initial thought is that these fields default to some value, and any actual change is stored in a FIELD_STATE and COMMENTS table, since I’m guessing that they will be used infrequently:
- Person Record
- Last Name
- First Name
- Unclass Phone
- Class Phone
- JWCS email
- SIPR email
- Unclass email
- Title (i.e. Project Manager, TRP Member, TST Portfolio Manager, etc)
- Secretary for (Person Record/Cofund Record combo? Multiple)
- Project Record
- Project Number (I’m guessing this is a string)
- Project Name
- Project Description (can have classified parts)
- TST Portfolio Manager (Person Record)
- Co-funds (1+ Co-Fund Records)
- Cofund Record
- Project Manager (Person Record)
- TRP Member (Person Record)
- Financial Analyst (Person Record)
- “Secretaries” – people who are authorized to enter data for someone else (Person Record)
- Lab Location (City and State)
- Period of Performance (Start and End)
- Funding Source(s) (Funding and UFR Records)
- Unfunded Requests (Funding and UFR Records)
- Supplemental (Funding and UFR Records)
- Contract (Contract Record)
- MIPR Number
- Invoices (Invoice Record)
- Funding (And Unfunded Request) Record
- Funding Source
- Name
- Amount
- Remarks
- Fiscal Year
- Contract Record (For prime only)
- Contract Number
- Vendor Name
- Vendor City
- Vendor State
- Invoice Record
- Number
- Date Sent
- Date Received
- Amount
- Person Record
- Rolled in Mikes icon-drawing changes
- Going to try to spend a minute or two on script handling. Hey! Got it working!
viztales 