====== pears.MasterRosterChangeReason ======
<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 =====
Look-up of allowed change reasons for Master Rosters.

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **MasterRosterChangeReasonID** | char(20) | NOT NULL |  |  |
| Reason | char(30) | NOT NULL |  |  |
| SortOrder | smallint | NULL | 0 |  |

===== Primary Key =====
  * MasterRosterChangeReasonID

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

===== Referenced By =====
  * No incoming foreign keys found.

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

===== Triggers =====
^ Name ^ Timing ^ Event ^
| WPK_masterrosterchangereason_MASTERROSTERREASON | after | insert,delete,update order 1 |

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."MasterRosterChangeReason"
-- Table comment: Look-up of allowed change reasons for Master Rosters.
-- Statement count: 4

CREATE TABLE "pears"."MasterRosterChangeReason" (
    "MasterRosterChangeReasonID"     char(20) NOT NULL
   ,"Reason"                         char(30) NOT NULL
   ,"SortOrder"                      smallint NULL DEFAULT 0
   ,PRIMARY KEY ("MasterRosterChangeReasonID" ASC) 
)
go


COMMENT ON TABLE "pears"."MasterRosterChangeReason" IS 
	'Look-up of allowed change reasons for Master Rosters.'
go


create trigger "WPK_masterrosterchangereason_MASTERROSTERREASON" after insert,delete,update order 1 on
"pears"."masterrosterchangereason"
for each statement
begin
  call "WPKTrackChange"('P','MASTERROSTERREASON')
end
go


COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."MasterRosterChangeReason"."WPK_masterrosterchangereason_MASTERROSTERREASON" IS 
{create trigger WPK_masterrosterchangereason_MASTERROSTERREASON 
 after insert,delete,update order 1 on
masterrosterchangereason
for each statement
begin
  call WPKTrackChange('P','MASTERROSTERREASON')
end
}
go
</code>