/
19.10 DB Schema Changes

19.10 DB Schema Changes

Owned by Steven Parent (Unlicensed)
Last updated: Oct 24, 2019 by Long Tran (Unlicensed)

[tbl_Password_Policy]

Added Field(s)

Field

Datatype

NULLABLE

[lng_Initial_Max_Age_Days]INTNO

[tbl_GL_Charge_Type_Definition]

Added Field(s)

Field

Datatype

NULLABLE

[str_Refundable]CHAR(1)YES
[str_Consumed_At_Issuance]CHAR(1)YES

[tbl_GL_SurCharge]

Added Field(s)

Field

Datatype

NULLABLE

[str_Refundable]CHAR(1)YES
[str_Consumed_At_Issuance]CHAR(1)YES

[tbl_Pax]

Added Field(s)

Field

Datatype

NULLABLE

[lng_Pref_Language_Id_Nmbr]INTYES

[tbl_Res_Header]

Added Field(s)

Field

Datatype

NULLABLE

[lng_Pref_Language_Id_Nmbr]INTYES

[tbl_User_Profile]

Added Field(s)

Field

Datatype

NULLABLE

[lng_Pref_Language_Id_Nmbr]INTYES


[tbl_RAS]

New Table

Field

Datatype

NULLABLE

[lng_RAS_Id_Nmbr]INTNO
[str_Airline_Code]NVARCHAR (3)NO
[str_Flight_Nmbr]NVARCHAR (10NO
[str_Operating_Airline_Code]NVARCHAR (3)NO
[str_Operating_Flight_Nmbr]NVARCHAR (10)NO
[dtm_Dep_Date_Local]SMALLDATETIMENO
[str_Dep_Airport_Ident]NVARCHAR (5)NO
[str_Arr_Airport_Ident]NVARCHAR (5)NO
[str_Trigger_Reason]NVARCHAR (20)NO
[str_Processed]NVARCHAR (1)NO
[tsp_Timestamp]ROWVERSIONNO
[dtm_Creation_Date]SMALLDATETIMENO
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMENO
[lng_Last_Mod_User_Id_Nmbr]INTNO


Related content

19.04 DB Schema Changes
19.04 DB Schema Changes
InteliSys Service Desk Documentation
More like this
18.10 DB Schema Changes
18.10 DB Schema Changes
InteliSys Service Desk Documentation
More like this
21.12 DB Schema Changes
21.12 DB Schema Changes
InteliSys Service Desk Documentation
More like this
20.09 DB Schema Changes
20.09 DB Schema Changes
InteliSys Service Desk Documentation
More like this
19.12 DB Schema Changes
19.12 DB Schema Changes
InteliSys Service Desk Documentation
More like this
23.10 DB Schema Changes
23.10 DB Schema Changes
InteliSys Service Desk Documentation
More like this