====== pears.EBPayBand ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Description =====
Expense Benefit payband

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **EBPayBandID** | char(20) | NOT NULL |  |  |
| Description | char(50) | NOT NULL |  | e.g. Training, Hotel etc |
| Unit | char(20) | NULL |  | Hours, Days etc |
| PayrollFlag | char(10) | NULL |  | Indicates payroll treatment e.g. taxable, holiday etc |
| SortOrder | smallint | NULL |  |  |
| ExtNumber | integer | NULL |  | used for Is Admin |
| ExternalCode | char(50) | NULL |  |  |
| AnalysisCode | char(10) | NULL |  |  |
| DivisionID | char(20) | NULL |  |  |

===== Primary Key =====
  * EBPayBandID

===== Foreign Keys =====
^ Constraint ^ Columns ^ References ^ Delete/update action ^
| division | DivisionID | [[database:tables:pears_division|pears.Division (divisionid)]] | ON DELETE SET NULL |

===== Referenced By =====
^ Table ^ Constraint ^ Columns ^ Referenced columns ^
| [[database:tables:pears_ebtimesheetline|pears.EBTimeSheetLine]] | EBPayBand | EBPayBandID | EBPayBandID |

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."EBPayBand"
-- Table comment: Expense Benefit payband
-- Statement count: 7

CREATE TABLE "pears"."EBPayBand" (
    "EBPayBandID"                    char(20) NOT NULL
   ,"Description"                    char(50) NOT NULL
   ,"Unit"                           char(20) NULL
   ,"PayrollFlag"                    char(10) NULL
   ,"SortOrder"                      smallint NULL
   ,"ExtNumber"                      integer NULL
   ,"ExternalCode"                   char(50) NULL
   ,"AnalysisCode"                   char(10) NULL
   ,"DivisionID"                     char(20) NULL
   ,PRIMARY KEY ("EBPayBandID" ASC) 
)
go


COMMENT ON COLUMN "pears"."EBPayBand"."Description" IS 
	'e.g. Training, Hotel etc'
go


COMMENT ON COLUMN "pears"."EBPayBand"."Unit" IS 
	'Hours, Days etc'
go


COMMENT ON COLUMN "pears"."EBPayBand"."PayrollFlag" IS 
	'Indicates payroll treatment e.g. taxable, holiday etc'
go


COMMENT ON COLUMN "pears"."EBPayBand"."ExtNumber" IS 
	'used for Is Admin'
go


COMMENT ON TABLE "pears"."EBPayBand" IS 
	'Expense Benefit payband'
go


ALTER TABLE "pears"."EBPayBand"
    ADD FOREIGN KEY "division" ("DivisionID" ASC)
    REFERENCES "pears"."Division" ("divisionid")
    ON DELETE SET NULL
go
</code>