pears.EBPayBand

Expense Benefit payband

• EBPayBandID

• No indexes found.

• No triggers found.

-- 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