Table of Contents



pears.TempTimeSheetCancellation

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

Description

Holds records of Timesheet Cancellations - works in conjunction with code in the TempTimesheetCancel and TempTimesheetComplete functions.

Columns

Column Type Null Default Comment
TempTimeSheetCancellationID char(20) NOT NULL
OriginalTempTimesheetID char(20) NOT NULL
PayCorrected smallint NOT NULL 0
ChargeCorrected smallint NOT NULL 0
ReplacementProvTimesheetSerialNumber char(12) NULL Only populated while replacement provisional timesheet exists - blanked afterwards
ContraTempTimeSheetID char(20) NULL
ReplacementTempTimeSheetID char(20) NULL
WhenCancelled timestamp NOT NULL current timestamp
WhoCancelled char(20) NULL
WhenReplacementCompleted timestamp NULL
WhoCompletedReplacement char(20) NULL
Description long varchar NULL
TimesheetCancelReasonID char(20) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
TimesheetCancelReason TimesheetCancelReasonID pears.TimesheetCancelReason (TimesheetCancelReasonID)

Referenced By

Indexes

Name Type Columns Detail
TempTSCanc_Orig Index OriginalTempTimesheetID
TempTSCanc_Contra Index ContraTempTimeSheetID
TempTSCanc_Repl Index ReplacementTempTimeSheetID

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempTimeSheetCancellation"
-- Table comment: Holds records of Timesheet Cancellations - works in conjunction with code in the TempTimesheetCancel and TempTimesheetComplete functions.
-- Statement count: 7
 
CREATE TABLE "pears"."TempTimeSheetCancellation" (
    "TempTimeSheetCancellationID"    CHAR(20) NOT NULL
   ,"OriginalTempTimesheetID"        CHAR(20) NOT NULL
   ,"PayCorrected"                   SMALLINT NOT NULL DEFAULT 0
   ,"ChargeCorrected"                SMALLINT NOT NULL DEFAULT 0
   ,"ReplacementProvTimesheetSerialNumber" CHAR(12) NULL
   ,"ContraTempTimeSheetID"          CHAR(20) NULL
   ,"ReplacementTempTimeSheetID"     CHAR(20) NULL
   ,"WhenCancelled"                  TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP
   ,"WhoCancelled"                   CHAR(20) NULL
   ,"WhenReplacementCompleted"       TIMESTAMP NULL
   ,"WhoCompletedReplacement"        CHAR(20) NULL
   ,"Description"                    long VARCHAR NULL
   ,"TimesheetCancelReasonID"        CHAR(20) NULL
   ,PRIMARY KEY ("TempTimeSheetCancellationID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."TempTimeSheetCancellation"."ReplacementProvTimesheetSerialNumber" IS 
	'Only populated while replacement provisional timesheet exists - blanked afterwards'
GO
 
 
COMMENT ON TABLE "pears"."TempTimeSheetCancellation" IS 
	'Holds records of Timesheet Cancellations - works in conjunction with code in the TempTimesheetCancel and TempTimesheetComplete functions.'
GO
 
 
ALTER TABLE "pears"."TempTimeSheetCancellation"
    ADD FOREIGN KEY "TimesheetCancelReason" ("TimesheetCancelReasonID" ASC)
    REFERENCES "pears"."TimesheetCancelReason" ("TimesheetCancelReasonID")
GO
 
 
CREATE INDEX "TempTSCanc_Orig" ON "pears"."TempTimeSheetCancellation"
    ( "OriginalTempTimesheetID" )
GO
 
 
CREATE INDEX "TempTSCanc_Contra" ON "pears"."TempTimeSheetCancellation"
    ( "ContraTempTimeSheetID" )
GO
 
 
CREATE INDEX "TempTSCanc_Repl" ON "pears"."TempTimeSheetCancellation"
    ( "ReplacementTempTimeSheetID" )
GO