1. People
1.1. Azim, Bazilah, Dennis
1.1.1. Swab test status
1.2. Edwin, Kingsley
1.2.1. Automatic BN Number matching
1.3. LY
1.3.1. Update to read new format from DCD
2. New Requests
2.1. Update Swab Status to Database
2.1.1. Need to sync w/ Yinfei
2.2. Update missing BN number
2.2.1. Need to sync w/ Yinfei
2.3. SuE data source to use automated ones
2.3.1. 隊長's team is getting data
2.4. LY's spreadsheet conversion to also output can not "processed" close contacts
2.4.1. first line: valid rows/total rows, "case number", "col1", .. ,"col 5"
2.4.2. When one of IC, BN Number, Passport is not valid, need to count as "invalid data"
2.4.3. Only send the valid to the system
2.5. LY can log in to upload data directly
2.6. Edwin on High Risk Close Contact Data QA
2.7. Data import e2e test
3. Quarantined
3.1. PCR/Swab status update
3.1.1. 4 statuses
3.1.1.1. POSTIVE
3.1.1.2. NEGATIVE
3.1.1.3. PENDING
3.1.1.3.1. "specimen collected", no result in the record
3.1.1.4. NONE
3.1.2. Plan
3.1.2.1. now: manual, copy DCD report tab out to a separate file, update there
3.1.2.2. Later: get the quarantined people from the database, update the PCR status to the database
4. Close Contacts
4.1. BN Number missing
4.1.1. Strategy
4.1.1.1. ic number
4.1.1.1.1. citizen or not (first 2 digits)
4.1.1.2. Passport
4.1.1.3. birth cert
4.1.1.4. only name
4.1.1.4.1. low priority, will deal with it later
4.1.2. Integration
4.1.2.1. Can be run separately to update the database
4.1.2.2. As a library called by Yinfei's system
4.2. New format in new spreadsheet
4.2.1. contacts only 481-600