pears.PayrollCompany

List of Payroll Companies defined.

• PayrollIdentifier

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."PayrollCompany"
-- Table comment: List of Payroll Companies defined.
-- Statement count: 6
 
CREATE TABLE "pears"."PayrollCompany" (
    "PayrollIdentifier"              CHAR(1) NOT NULL
   ,"Name"                           CHAR(250) NULL
   ,"LivePayroll"                    SMALLINT NULL DEFAULT 0
   ,"ParallelPayroll"                SMALLINT NULL DEFAULT 0
   ,"LastTransferBatch"              INTEGER NULL
   ,"LastParallelTransferBatch"      INTEGER NULL
   ,"EmailSignature"                 CHAR(20) NULL
   ,"SMTPSettings"                   CHAR(20) NULL
   ,"EmailAddress"                   CHAR(250) NULL
   ,"Body"                           long VARCHAR NULL
   ,"PayslipPassword"                SMALLINT NULL DEFAULT 0
   ,"UID"                            CHAR(50) NULL
   ,"PWD"                            CHAR(50) NULL
   ,"EmployerID"                     CHAR(50) NULL
   ,PRIMARY KEY ("PayrollIdentifier" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."PayrollCompany"."LivePayroll" IS 
	'0 - Other, 1 - Accord, 2 - none'
GO
 
 
COMMENT ON COLUMN "pears"."PayrollCompany"."ParallelPayroll" IS 
	'0 - none, 1 - Accord'
GO
 
 
COMMENT ON COLUMN "pears"."PayrollCompany"."LastTransferBatch" IS 
	'Read only. Updated by job'
GO
 
 
COMMENT ON COLUMN "pears"."PayrollCompany"."LastParallelTransferBatch" IS 
	'Read only. Updated by job'
GO
 
 
COMMENT ON TABLE "pears"."PayrollCompany" IS 
	'List of Payroll Companies defined.'
GO