Using DAL To Output To A Database Table

Here is an example of the DDL statements you could use to create a database table for use by Documaker Server and Documaker Connector. Documaker DAL writes to this table and Documaker Connector reads the records to determine which incoming documents to process.

Note:

Below is shown a typical example. For information on the minimum requirements, see Minimum DAL Output Database Table section.

CREATE TABLE "ORACLE"."AOR" (
"JOBID" VARCHAR2(50) NOT NULL,
"TRANID" VARCHAR2(50) NOT NULL,
"BATCHID" VARCHAR2(50) NOT NULL,
"DOCID" VARCHAR2(50) NOT NULL,
"NAME" VARCHAR2(30),
"TYPE" VARCHAR2(30),
"TITLE" VARCHAR2(255),
"AUTHOR" VARCHAR2(50),
"SECGROUP" VARCHAR2(30),
"CABINET" VARCHAR2(30),
"PFILE" VARCHAR2(255),
"STATUSCD" INTEGER DEFAULT 0 NOT NULL,
"STARTTIME" TIMESTAMP,
"ENDTIME" TIMESTAMP,
"RESULTDESC" VARCHAR2(2000),
"RETENTION" TIMESTAMP,
"CATEGORY" VARCHAR2(30),
"KEY1" VARCHAR2(100),
"KEY2" VARCHAR2(100),
"KEYID" VARCHAR2(100),
"TRANCODE" VARCHAR2(30), "RUNDATE" TIMESTAMP,
"CURRUSER" VARCHAR2(30),
"AGENCYID" VARCHAR2(30),
"EFFDATE" TIMESTAMP,
"EXPDATE" TIMESTAMP,
"CUSTID" VARCHAR2(30),
"POLNUM" VARCHAR2(100),
"INSFNAME" VARCHAR2(30),
"INSLNAME" VARCHAR2(30),
"INSADD1" VARCHAR2(30),
"INSADD2" VARCHAR2(30),
"INSCITY" VARCHAR2(30),
"INSSTATE" VARCHAR2(5),
"INSZIP" VARCHAR2(30),
"INSPHONE" VARCHAR2(30),
"INSDOB" DATE,
"INDEX01" VARCHAR2(30), "INDEX02" VARCHAR2(30), "INDEX03" VARCHAR2(30),
"INDEX04" VARCHAR2(30), "INDEX05" VARCHAR2(30), "INDEX06" 
VARCHAR2(30),
"INDEX07" VARCHAR2(30), "INDEX08" VARCHAR2(30), "INDEX09" VARCHAR2(30),
"INDEX10" VARCHAR2(30), "INDEX11" VARCHAR2(30), "INDEX12" 
VARCHAR2(30),
PRIMARY KEY ("JOBID", "TRANID", "BATCHID", "DOCID") VALIDATE
);
CREATE INDEX "ORACLE"."AORIDX1" ON "ORACLE"."AOR" ("DOCID");