Date
Attendees
IR group (UM, USM, UMF & UMA)
DARTS
- Linda Reid
Goals
- Identify the needs for flat program plan view (REPORT-461)
Discussion items
Current Issues: UM_FLT_PRGPLN is as of the maximum effective date of each that is less than or equal to the current date. It contains data from STRM = 1210 and later.
Justin : Need data as of census day
- Lisa : Need data as of census day. Need data from STRM=1120.
- Linda: Need Requirement term. Need sequence number.
- DARTS: The view is too big.
2. Additional requests from others?
3. Timing for creation : probably in July or August
Action items
For existing PS_UM_FLT_PRGPLN:
- add requirement term since effective date is related to the term
- add sequence number - need to talk to Linda again
- check the STRM field logic. It seems the term is not reflected to what it was at the time.
For new table or view:
- create snapshot of the data as of census (frozen data)
- check if the past data can be populated or not