pears.PlacementElementType

Stages in the calculation of fees and other headings for optional data collected at placement time.

• PlacementElementTypeID

• No outgoing foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."PlacementElementType"
-- Table comment: Stages in the calculation of fees and other headings for optional data collected at placement time.
-- Statement count: 4
 
CREATE TABLE "pears"."PlacementElementType" (
    "PlacementElementTypeID"         CHAR(20) NOT NULL
   ,"Name"                           CHAR(30) NOT NULL
   ,"Description"                    CHAR(50) NOT NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"Temp"                           SMALLINT NULL DEFAULT 0
   ,"Hidden"                         SMALLINT NULL DEFAULT 0
   ,"ReadOnly"                       SMALLINT NULL DEFAULT 0
   ,"DataType"                       CHAR(1) NOT NULL
   ,"DefaultValue"                   long VARCHAR NULL
   ,"ValidationCheck"                long VARCHAR NULL
   ,"ValidationMessage"              long VARCHAR NULL
   ,"WarningCheck"                   long VARCHAR NULL
   ,"WarningMessage"                 long VARCHAR NULL
   ,"AuditFlag"                      SMALLINT NULL DEFAULT 0
   ,"CanEditWhenAuthorised"          SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("PlacementElementTypeID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."PlacementElementType" IS 
	'Stages in the calculation of fees and other headings for optional data collected at placement time.'
GO
 
 
CREATE INDEX "PlacElType_SortOrder" ON "pears"."PlacementElementType"
    ( "SortOrder" )
GO
 
 
CREATE UNIQUE INDEX "PlacElType_Name" ON "pears"."PlacementElementType"
    ( "Name" )
GO