
CREATE TABLE "PPSNEPL"."EPL_IEN_GENERATOR" (
		"CONCEPT" VARCHAR2(50) NOT NULL,
		"LAST_USED_IEN" NUMBER(30 , 0) NOT NULL,
		"CREATED_BY" VARCHAR2(50) NOT NULL,
		"CREATED_DTM" TIMESTAMP NOT NULL,
		"LAST_MODIFIED_BY" VARCHAR2(50),
		"LAST_MODIFIED_DTM" TIMESTAMP
	);

CREATE INDEX "PPSNEPL"."EPL_IEN_PK_IDX" ON "PPSNEPL"."EPL_IEN_GENERATOR" ("CONCEPT" ASC);

ALTER TABLE "PPSNEPL"."EPL_IEN_GENERATOR" ADD CONSTRAINT "SYS_C0032207" CHECK ("CONCEPT" IS NOT NULL);

ALTER TABLE "PPSNEPL"."EPL_IEN_GENERATOR" ADD CONSTRAINT "SYS_C0032209" CHECK ("CREATED_BY" IS NOT NULL);

ALTER TABLE "PPSNEPL"."EPL_IEN_GENERATOR" ADD CONSTRAINT "SYS_C0032208" CHECK ("LAST_USED_IEN" IS NOT NULL);

ALTER TABLE "PPSNEPL"."EPL_IEN_GENERATOR" ADD CONSTRAINT "EPL_IEN_PK" PRIMARY KEY ("CONCEPT");

ALTER TABLE "PPSNEPL"."EPL_IEN_GENERATOR" ADD CONSTRAINT "SYS_C0032210" CHECK ("CREATED_DTM" IS NOT NULL);

GRANT SELECT ON "PPSNEPL"."EPL_IEN_GENERATOR" TO PPSNEPL_READ_ONLY_ROLE;

