Table of Contents



pears.EBPayBand

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

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

Foreign Keys

Constraint Columns References Delete/update action
division DivisionID pears.Division (divisionid) ON DELETE SET NULL

Referenced By

Table Constraint Columns Referenced columns
pears.EBTimeSheetLine EBPayBand EBPayBandID EBPayBandID

Indexes

Triggers

Original 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