79 lines
2.5 KiB
SQL
79 lines
2.5 KiB
SQL
--
|
|
-- $Id$
|
|
--
|
|
-- KW1C#81204 Implementatie FMIS KW1C
|
|
-- Import voor MJOB taken kw1c_import_insp_mjob heeft een tabel nodig
|
|
--
|
|
--
|
|
DEFINE thisfile = 'KW1C#81204.SQL'
|
|
DEFINE dbuser = '^KW1C'
|
|
|
|
SET ECHO ON
|
|
SET DEFINE ON
|
|
COLUMN fcltlogfile NEW_VALUE fcltlogfile NOPRINT;
|
|
COLUMN fcltcusterr NEW_VALUE fcltcusterr NOPRINT;
|
|
WHENEVER SQLERROR CONTINUE;
|
|
SELECT adm.getscriptspoolfile('&thisfile') AS fcltlogfile FROM DUAL;
|
|
SPOOL &fcltlogfile
|
|
WHENEVER SQLERROR EXIT;
|
|
SELECT adm.checkscriptcust('&dbuser') AS fcltcusterr FROM DUAL;
|
|
WHENEVER SQLERROR CONTINUE;
|
|
PROMPT &fcltcusterr
|
|
SET DEFINE OFF
|
|
|
|
------ payload begin ------
|
|
|
|
-- Import inspecties / MJOB
|
|
-- Generieke import om op te nemen in de core #FCLT#81526 Standaard import voor MJOB
|
|
-- Tabel nodig: TMP_IMP_MJB
|
|
-------------------------------------------
|
|
DROP TABLE tmp_imp_mjb;
|
|
|
|
CREATE TABLE tmp_imp_mjb
|
|
(
|
|
LOCATIECODE VARCHAR2(1000),
|
|
OBJECTOMSCHRIJVING VARCHAR2(1000),
|
|
OBJECTAANTEH VARCHAR2(1000),
|
|
OBJECTAANTAL VARCHAR2(1000),
|
|
TAAKCATEGORIE VARCHAR2(1000),
|
|
TAAKOMSCHRIJVING VARCHAR2(1000),
|
|
TAAKOPMERKING VARCHAR2(1000),
|
|
TAAKPRIORITEIT VARCHAR2(1000),
|
|
TAAKBTW VARCHAR2(1000),
|
|
TAAKKOSTENPLAATSNR VARCHAR2(1000),
|
|
TAAKKOSTENPLAATSOMSCHRIJVING VARCHAR2(1000),
|
|
TAAKOBJECTPERCENTAGE VARCHAR2(1000),
|
|
TAAKOBJECTOPMERKING VARCHAR2(1000),
|
|
TAAKOBJECTPERIODE VARCHAR2(1000),
|
|
TAAKOBJECTSTARTJAAR DATE,
|
|
TAAKOBJECTEINDJAAR DATE,
|
|
TAAKOBJECTMATERIAAL VARCHAR2(1000),
|
|
TAAKOBJECTKOSTEN VARCHAR2(1000),
|
|
TAAKOBJECTEENHEID VARCHAR2(1000),
|
|
DEEL_KEY NUMBER(10),
|
|
DISCIPLINE_KEY NUMBER(10),
|
|
ISMJOB NUMBER,
|
|
EXTRA_VELD1 VARCHAR2(1000),
|
|
EXTRA_VELD2 VARCHAR2(1000),
|
|
EXTRA_VELD3 VARCHAR2(1000),
|
|
EXTRA_VELD4 VARCHAR2(1000),
|
|
EXTRA_VELD5 VARCHAR2(1000),
|
|
TAAKGROEP VARCHAR2(60),
|
|
TAAKDIENST VARCHAR2(1000),
|
|
INS_SRTCONTROLE_KEY NUMBER(10),
|
|
INS_SRTCONTROLEDL_XCP_KEY NUMBER(10),
|
|
INS_SRTDEEL_KEY NUMBER(10)
|
|
);
|
|
|
|
------ payload end ------
|
|
|
|
SET DEFINE OFF
|
|
BEGIN adm.systrackscriptId ('$Id$', 1); END;
|
|
/
|
|
|
|
COMMIT;
|
|
SET ECHO OFF
|
|
SPOOL OFF
|
|
SET DEFINE ON
|
|
PROMPT Logfile of this upgrade is: &fcltlogfile
|