AuthorizeStatus


Description

Authorization status definitions defining the various states that service authorizations can have throughout their lifecycle. This lookup table provides standardized status values for authorizations including active, pending, closed, and other workflow states for authorization management and reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AuthStatusID int identity 4 √ null

Primary key - Unique identifier for each authorization status
AuthStatusDesc varchar 50 √ null

Status description - Descriptive name for the authorization status (Active, Pending, Closed, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_AuthorizeStatus Primary key Asc AuthStatusID

Relationships

Close relationships within degrees of separation