Rain - Air Coordinator Dashboard is not showing under MyProgram

Root Folder
  • Adding a New Rain user:
  1. It is important to check if a user already exists as inactive in the database before attempting to add new one. Failure to do so will cause the sync job to fail
  2. Add a New user to this table [RAIN2018].[dbo].[rainusers]
     
  • 1) Rain Changes
    • Select * from [RAIN2018].[dbo].[rainusers] order by 1 desc -- 77
    • select * FROM    [Registrations2018].dbo.Program order by 1 desc -- 660
    • --Add in this
      •   select * from [Registrations2018].regadmin.AdditionalTriPStaffs
 
  • 2a) Travel Management changes
    • Update [tm_employeeID] field in [RAIN2018].[dbo].[rainusers] for Air coordinator to match employeeID in tripmanager.
    • [tm_employeeID]  ->[RAIN2018].[dbo].[rainusers]
    • employeeID - > [LOCAL_travelManagement].[dbo].[employees]
 
                    --SELECT * from jobs where clientname like '%X1%' 
--select * from trips where jobID =X2
--select * from [dbo].[staff] where role='AC'  and  tripID =X3
--select * from [dbo].[employees] where employeeID=X4
 2b)  Add Staff to Trip also
 
 
 
 
 
Article ID: 43, , Modified: March 6, 2024 at 7:20 PM

Add Feedback

Was this article helpful?

Share this article

FacebookGoogle+TwitterOther Social NetworksPrint