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

Bound Defaults

Bound Rules

[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

See also