/
22.05 DB Schema Changes
22.05 DB Schema Changes
Deleted tables(s)
[tbl_Agency_User_Messages]
[tbl_User_Messages]
[tbl_User_Messages_Log]
Modified column(s)
[tbl_User_Settings]
Field | Data Type | NULLABLE |
---|---|---|
[str_Setting_Value] | VARCHAR (1000) | NO |
Added table(s)
[tbl_Document_Refund_Xref]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Document_Refund_Xref_Id_Nmbr] | INT | NO |
[lng_Ticket_Id] | INT | NO |
[lng_Emd_Id] | INT | NO |
[mny_Amount] | MONEY | NO |
[lng_GL_Payments_Refund_Id_Nmbr] | INT | NO |
[lng_GL_Payments_Id_Nmbr] | INT | NO |
[dtm_Creation_Date] | SMALLDATETIME | YES |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | YES |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Gate_Pass]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Gate_Pass_Id_Nmbr] | INT | NO |
[lng_Sked_Detail_Id_Nmbr] | INT | NO |
[str_Last_Name] | VARCHAR (100) | NO |
[str_First_Name] | VARCHAR (100) | NO |
[str_Middle_Name] | VARCHAR (100) | NO |
[str_Gender_Flag] | CHAR (1) | NO |
[dtm_Date_Of_Birth] | SMALLDATETIME | YES |
[str_Status_Flag] | CHAR (1) | NO |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Gate_Pass_Vetting]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Gate_Pass_Vetting_Id_Nmbr] | INT | NO |
[lng_Sked_Detail_Id_Nmbr] | INT | NO |
[lng_Gate_Pass_Id_Nmbr] | INT | NO |
[lng_Gate_Pass_Vetting_Result_Id_Nmbr] | INT | NO |
[str_Airport_Code] | VARCHAR (5) | NO |
[str_Last_Name] | VARCHAR (100) | NO |
[str_First_Name] | VARCHAR (100) | NO |
[str_Gender_Flag] | CHAR (1) | NO |
[dtm_Date_Of_Birth] | SMALLDATETIME | YES |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Gate_Pass_Vetting_History]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Gate_Pass_Vetting_History_Id_Nmbr] | INT | NO |
[lng_Sked_Detail_Id_Nmbr] | INT | NO |
[txt_Request] | NVARCHAR (MAX) | NO |
[txt_Response] | NVARCHAR (MAX) | NO |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Gate_Pass_Vetting_Result]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Gate_Pass_Vetting_Result_Id_Nmbr] | INT | NO |
[str_Result_Value] | VARCHAR (10) | NO |
[str_Result_Name] | VARCHAR (100) | NO |
[bit_Print_Permitted] | BIT | NO |
[bit_Selectee] | BIT | NO |
[str_Selectee_Indicator] | VARCHAR (1) | NO |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
, multiple selections available,
Related content
22.05 Release Notes
22.05 Release Notes
Read with this
22.06 DB Schema Changes
22.06 DB Schema Changes
More like this
23.10 DB Schema Changes
23.10 DB Schema Changes
More like this
20.06 DB Schema Changes
20.06 DB Schema Changes
More like this
21.09 DB Schema Changes
21.09 DB Schema Changes
More like this
23.11 DB Schema Changes
23.11 DB Schema Changes
More like this