SP/GP pipeline - Filing user missing on dashboard

[droberts27]

TODOs:

• [x] update COLIN event/filing data retrieval query to use latest data extract(new event timestamp field for user creation date) with updated user info
• [x] add middle_name column to LEAR users table
• [x] update legal api user tests
• [x] update pipeline to use event timestamp
• [x] update pipeline to save COLIN filing_user data to LEAR user table

[droberts27]

@lmcclung Do we need to display the filing users directly on the dashboard? COLIN has them directly on the ledger. FM0292609 is an example. Different filings have "Filed By" dalessar, PT81928, and "Leanne Lewis - ACBC" @argush3 This data is in filings.filing_json except the reference to ACBC.

[argush3]

will need to populate user table and maybe pushed to auth

[droberts27]

I have mapped the filing_user Oracle table to the users Postgres table. The only middle names in the filing_user table are for ACBC users. The users table has no middle name so I have not included middle name. I have rerun the data extract.

[argush3]

@droberts27 Was talking to @rarmitag just now and I think we still need the middle name. I can see in prod that middle names are appended to the users.first_name field in prod. We might add a middle_name field to the LEAR users table and populate the COLIN filing_users.middle_name value there.

[droberts27]

@argush3 @rarmitag I have added the middle name and will do a complete conversion at 3:00am tomorrow.

select u.event_id ||rpad(nvl(u.user_id ,' '),032) ||rpad(nvl(u.last_nme ,' '),200) ||rpad(nvl(u.first_nme ,' '),050) ||rpad(nvl(u.middle_nme,' '),050) ||rpad(nvl(u.email_addr,' '),254) ||to_char(e.event_timestmp,'yyyymmdd hh24:mi:ss') from filing_user u ,event e where u.event_id=e.event_id and u.event_id in (select event_id from event where corp_num like 'FM%' and corp_num not in ('FM0116100','FM0437866')) -- LP order by u.event_id;

[argush3]

Verified in DEV that filing user is correctly displaying after "filed by" on each ledger item for a SP/GP imported from COLIN now.

FM0292609, FM0554196 and FM0608573 have been data loaded into DEV for verification purposes.