pears.ExpenseBenefitType [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.ExpenseBenefitType ======
<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 =====
Definitions of types of Expense Benefit available with behaviour settings

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **ExpenseBenefitTypeID** | char(20) | NOT NULL |  |  |
| Description | char(50) | NULL |  |  |
| Class | char(10) | NULL |  |  |
| Period | char(10) | NULL |  |  |
| PayrollFlag | char(10) | NULL |  | Passed to payroll system |
| ExpenseCode | char(10) | NULL |  | Used by payroll transfer to apply rules |
| SortOrder | integer | NULL |  |  |

===== Primary Key =====
  * ExpenseBenefitTypeID

===== Foreign Keys =====
  * No outgoing foreign keys found.

===== Referenced By =====
^ Table ^ Constraint ^ Columns ^ Referenced columns ^
| [[database:tables:pears_expensebenefitchoice|pears.ExpenseBenefitChoice]] | ExpenseBenefitType | ExpenseBenefitTypeID | ExpenseBenefitTypeID |
| [[database:tables:pears_expensebenefitplacementitem|pears.ExpenseBenefitPlacementItem]] | ExpenseBenefitType | ExpenseBenefitTypeID | ExpenseBenefitTypeID |
| [[database:tables:pears_expensebenefitschemeitem|pears.ExpenseBenefitSchemeItem]] | ExpenseBenefitType | ExpenseBenefitTypeID | ExpenseBenefitTypeID |
| [[database:tables:pears_expensebenefitshiftitem|pears.ExpenseBenefitShiftItem]] | ExpenseBenefitType | ExpenseBenefitTypeID | ExpenseBenefitTypeID |

===== 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"."ExpenseBenefitType"
-- Table comment: Definitions of types of Expense Benefit available with behaviour settings
-- Statement count: 4

CREATE TABLE "pears"."ExpenseBenefitType" (
    "ExpenseBenefitTypeID"           char(20) NOT NULL
   ,"Description"                    char(50) NULL
   ,"Class"                          char(10) NULL
   ,"Period"                         char(10) NULL
   ,"PayrollFlag"                    char(10) NULL
   ,"ExpenseCode"                    char(10) NULL
   ,"SortOrder"                      integer NULL
   ,PRIMARY KEY ("ExpenseBenefitTypeID" ASC) 
)
go


COMMENT ON COLUMN "pears"."ExpenseBenefitType"."PayrollFlag" IS 
	'Passed to payroll system'
go


COMMENT ON COLUMN "pears"."ExpenseBenefitType"."ExpenseCode" IS 
	'Used by payroll transfer to apply rules'
go


COMMENT ON TABLE "pears"."ExpenseBenefitType" IS 
	'Definitions of types of Expense Benefit available with behaviour settings'
go
</code>