# Datatype: Flag

## Properties

Property | Value
--- | ---
Name | Flag
ID | 258
Schema | dbo
Owner | dbo
User Defined |
Native Datatype | bit
Max Length (in bytes) | 1
Nullable |
Is Assembly Type |
Is Table Type |

## Extended Properties

No extended properties defined.

## Bound Defaults

No defaults bound to that datatype

## Bound Rules

No rules bound to that datatype

## [Flag] is used in the following columns

Column Name | Object Name | Description | ANSI Padded | Is Rowguidcol | Is Identity | Is Computed | Is Filestream | Is Replicated | Is Non Sql Subscribed | Is Merge Published | Is DTS Replicated | Is Xml Document | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
SalariedFlag | HumanResources.Employee | Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. |  |  |  |  |  |  |  |  |  |  |  |
CurrentFlag | HumanResources.Employee | 0 = Inactive, 1 = Active |  |  |  |  |  |  |  |  |  |  |  |
IsOnlyStateProvinceFlag | Person.StateProvince | 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. |  |  |  |  |  |  |  |  |  |  |  |
IsOnlyStateProvinceFlag | Person.vStateProvinceCountryRegion |  |  |  |  |  |  |  |  |  |  |  |  |
MakeFlag | Production.Product | 0 = Product is purchased, 1 = Product is manufactured in-house. |  |  |  |  |  |  |  |  |  |  |  |
FinishedGoodsFlag | Production.Product | 0 = Product is not a salable item. 1 = Product is salable. |  |  |  |  |  |  |  |  |  |  |  |
Primary | Production.ProductProductPhoto | 0 = Photo is not the principal image. 1 = Photo is the principal image. |  |  |  |  |  |  |  |  |  |  |  |
PreferredVendorStatus | Purchasing.Vendor | 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product. |  |  |  |  |  |  |  |  |  |  |  |
ActiveFlag | Purchasing.Vendor | 0 = Vendor no longer used. 1 = Vendor is actively used. |  |  |  |  |  |  |  |  |  |  |  |
OnlineOrderFlag | Sales.SalesOrderHeader | 0 = Order placed by sales person. 1 = Order placed online by customer. |  |  |  |  |  |  |  |  |  |  |  |

## [Flag] is used in the following parameters

Column Name | Object Name | Description | Is Xml Document
--- | --- | --- | ---
@CurrentFlag | HumanResources.uspUpdateEmployeeHireInfo | Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee. |
@CurrentFlag | HumanResources.uspUpdateEmployeeLogin | Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee. |

## Objects that depend on [Flag]

- dbo.Flag
  - HumanResources.Employee
    - dbo.ufnGetContactInformation
    - dbo.uspGetEmployeeManagers
    - dbo.uspGetManagerEmployees
    - dbo.vMobiEmployee
      - dbo.uMobiEmployeeTrg
    - HumanResources.dEmployee
    - HumanResources.EmployeeDepartmentHistory
      - HumanResources.vEmployeeDepartment
      - HumanResources.vEmployeeDepartmentHistory
    - HumanResources.EmployeePayHistory
      - HumanResources.uspUpdateEmployeeHireInfo
    - HumanResources.JobCandidate
      - dbo.uspSearchCandidateResumes
      - HumanResources.vJobCandidate
      - HumanResources.vJobCandidateEducation
      - HumanResources.vJobCandidateEmployment
    - HumanResources.uspUpdateEmployeeLogin
    - HumanResources.uspUpdateEmployeePersonalInfo
    - HumanResources.vEmployee
    - Production.Document
      - Production.ProductDocument
    - Purchasing.PurchaseOrderHeader
      - Purchasing.PurchaseOrderDetail
        - Purchasing.iPurchaseOrderDetail
        - Purchasing.uPurchaseOrderDetail
      - Purchasing.uPurchaseOrderHeader
    - Sales.SalesPerson
      - Sales.SalesOrderHeader
        - Sales.SalesOrderDetail
          - Sales.iduSalesOrderDetail
          - Sales.ufn_SalesByStore
        - Sales.SalesOrderHeaderSalesReason
        - Sales.uSalesOrderHeader
        - Sales.vSalesPersonSalesByFiscalYears
      - Sales.SalesPersonQuotaHistory
      - Sales.SalesTerritoryHistory
      - Sales.Store
        - Sales.Customer
          - Sales.vIndividualCustomer
        - Sales.vStoreWithAddresses
        - Sales.vStoreWithContacts
        - Sales.vStoreWithDemographics
      - Sales.vSalesPerson
  - Person.StateProvince
    - Person.Address
      - Person.BusinessEntityAddress
        - Purchasing.vVendorWithAddresses
    - Person.vStateProvinceCountryRegion
    - Sales.SalesTaxRate
  - Production.Product
    - dbo.KrystianProductView
    - dbo.ufnGetProductDealerPrice
      - Person.functionSynonym
    - dbo.ufnGetProductListPrice
    - dbo.ufnGetProductStandardCost
    - dbo.uspGetBillOfMaterials
      - HumanResources.ProcedureSynonym
    - dbo.uspGetWhereUsedProductID
    - Production.BillOfMaterials
    - Production.ProductCostHistory
    - Production.ProductInventory
      - dbo.ufnGetStock
    - Production.ProductListPriceHistory
    - Production.ProductProductPhoto
    - Production.ProductReview
    - Production.TransactionHistory
      - Production.WorkOrder
        - Production.iWorkOrder
        - Production.uWorkOrder
        - Production.WorkOrderRouting
    - Production.uspGetList
    - Production.vProductAndDescription
    - Purchasing.ProductVendor
    - Sales.ShoppingCartItem
    - Sales.SpecialOfferProduct
  - Purchasing.Vendor
    - Purchasing.dVendor
    - Purchasing.vVendorWithContacts

## Objects on which [Flag] depends

- dbo.Flag

## SQL

Script
CREATE TYPE [dbo].[Flag] FROM [bit] NOT NULL

#### See also

List of Datatypes