GetOldAvailableReasons(String,String,Nullable<Int32>) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The GetOldAvailableReasons() method retrieves the possible final reasons (codes) for the specified entity.
This overload of the method uses a site name and entity name to specify the entity.
'Declaration
Public Overloads Shared Function GetOldAvailableReasons( _
ByVal entName As String, _
ByVal siteName As String, _
ByVal reasCd As Nullable(Of Integer) _
) As DataSet
'Usage
Dim entName As String
Dim siteName As String
Dim reasCd As Nullable(Of Integer)
Dim value As DataSet
value = UtilExec.GetOldAvailableReasons(entName, siteName, reasCd)
public static DataSet GetOldAvailableReasons(
string entName,
string siteName,
Nullable<int> reasCd
)
Parameters
- entName
- Required. Holds the name of the entity whose final reason codes are being retrieved.
- siteName
- Optional filter parameter. Holds the site name for the entity.
- reasCd
- Optional filter parameter. Holds a reason code by which to filter the retrieved results.
Return Value
Holds a DataSet that contains a list of all final reason codes that satisfy the specified filters. If no final reason codes satisfy the specified filters, then an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
reas_grp_id |
An integer that is the utilization reason group from the Util_Reas_Grp table linked to this reas_cd is returned. |
|
reas_grp_desc |
The description of the utilization reason group from Util_Reas_Grp table linked to this reas_grp_id for this reason is returned. |
|
reas_cd |
The utilization reason code, from the Util_Reas table. |
|
reas_desc |
The description of this utilization reason, from the Util_Reas table. |
|
l0_reas_grp_id |
An integer which contains ID of the top-level reason group. There can be up to 10 levels of reason groups above the reason. This will always contain a value and will be the same as the reas_grp_id in the case where there is only one reason group above the reason. |
|
l0_reas_grp_desc |
The description of the top-level reason group. |
|
l1_reas_grp_id |
An integer which contains the ID of the second-level reason group. This will be null if there is only one reason group above the reason. |
|
l1_reas_grp_desc |
The description of the second-level reason group. |
|
l2_reas_grp_id |
An integer which contains the ID of the third-level reason group. This will be null if there is only two levels of reason groups above the reason. |
|
l2_reas_grp_desc |
The description of the third-level reason group. |
|
l3_reas_grp_id |
An integer which contains the ID of the fourth-level reason group. This will be null if there is only three levels of reason groups above the reason. |
|
l3_reas_grp_desc |
The description of the fourth-level reason group. |
|
l4_reas_grp_id |
An integer which contains the ID of the fifth-level reason group. This will be null if there is only four levels of reason groups above the reason. |
|
l4_reas_grp_desc |
The description of the fifth -level reason group. |
|
l5_reas_grp_id |
An integer which contains the ID of the sixth-level reason group. This will be null if there is only five levels of reason groups above the reason. |
|
l5_reas_grp_desc |
The description of the sixth -level reason group. |
|
l6_reas_grp_id |
An integer which contains the ID of the seventh-level reason group. This will be null if there is only six levels of reason groups above the reason. |
|
l6_reas_grp_desc |
The description of the seventh -level reason group. |
|
l7_reas_grp_id |
An integer which contains the ID of the eighth-level reason group. This will be null if there is only seven levels of reason groups above the reason. |
|
l7_reas_grp_desc |
The description of the eighth -level reason group. |
|
l8_reas_grp_id |
An integer which contains the ID of the ninth-level reason group. This will be null if there is only eight levels of reason groups above the reason. |
|
l8_reas_grp_desc |
The description of the ninth -level reason group. |
|
l9_reas_grp_id |
An integer which contains the ID of the tenth-level reason group. This will be null if there is only nine levels of reason groups above the reason. |
|
l9_reas_grp_desc |
The description of the tenth -level reason group. |
For optional filter parameters that are not to be included as a filter, pass a null.
This method first verifies whether the supplied default reason code is configured to have raw reason codes for the supplied entity. If such raw reason code exists in the database, then all possible reasons for the identified raw reason codes are returned. If no such reasons exist in the database, then all utilization reasons are returned. If no rows are found, an empty DataSet is returned.