Export_Job_Doc


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name Export_Job_Doc
Entity Type ObjectView
Description PSS 2013.1 Export_Job_Doc DOV
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
CONTRIBUTOR STRING64 NA
_ No
VARCHAR2(64)
COVERAGE STRING255 NA
_ No
VARCHAR2(255)
CREATOR STRING64 NA
_ No
VARCHAR2(64)
DOCUMENT_BODY BLOB NA
_ No
BLOB
DOCUMENT_DATE DATE NA
_ No
DATE
DOCUMENT_FOLDER_ID NUMBER2 NA
_ No
NUMBER(2)
DOCUMENT_FORMAT STRING64 NA
_ Yes
VARCHAR2(64)
DOCUMENT_ID NUMBER2 NA
_ Yes
NUMBER(2)
DOCUMENT_TYPE STRING64 NA
_ Yes
VARCHAR2(64)
END_DATE DATE NA
_ No
DATE
END_INDEX NUMBER2 NA
_ No
NUMBER(2)
ENTITY_ID NUMBER2 NA
_ Yes
NUMBER(2)
FILE_SIZE NUMBER2 NA
_ No
NUMBER(2)
GUID STRING128 NA
_ No
VARCHAR2(128)
ID NUMBER2 NA
_ Yes
NUMBER(2)
INSERT_DATE DATE NA
_ No
DATE
INSERT_USER STRING64 NA
_ No
VARCHAR2(64)
MEDIA_TYPE STRING64 NA
_ No
VARCHAR2(64)
NAME STRING255 NA
_ No
VARCHAR2(255)
ORIGINAL_PATH STRING2000 NA
_ No
VARCHAR2(2000)
ORIGINAL_SOURCE STRING64 NA
_ No
VARCHAR2(64)
PATH STRING2000 NA
_ No
VARCHAR2(2000)
PRODUCED_BY STRING64 NA
_ No
VARCHAR2(64)
PUBLISHER STRING64 NA
_ No
VARCHAR2(64)
REMARKS STRING2000 NA
_ No
VARCHAR2(2000)
RIGHTS STRING128 NA
_ No
VARCHAR2(128)
SOURCE STRING64 NA
_ No
VARCHAR2(64)
SOURCE_LANGUAGE STRING64 NA
_ No
VARCHAR2(64)
START_DATE DATE NA
_ No
DATE
START_INDEX NUMBER2 NA
_ No
NUMBER(2)
STORAGE_TYPE STRING32 NA
_ No
VARCHAR2(32)
SUBJECT STRING128 NA
_ No
VARCHAR2(128)
TITLE STRING255 NA
_ No
VARCHAR2(255)
UPDATE_DATE DATE NA
_ No
DATE
UPDATE_USER STRING64 NA
_ No
VARCHAR2(64)
VERSION STRING255 NA
_ Yes
VARCHAR2(255)
VIEWER STRING64 NA
_ No
VARCHAR2(64)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Export_Job_Doc(ID, DOCUMENT_ID, ENTITY_ID, STORAGE_TYPE, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, VERSION, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, CONTRIBUTOR, COVERAGE, CREATOR, DOCUMENT_BODY, DOCUMENT_DATE, DOCUMENT_FOLDER_ID, DOCUMENT_FORMAT, DOCUMENT_TYPE, FILE_SIZE, MEDIA_TYPE, ORIGINAL_PATH, PATH, PUBLISHER, RIGHTS, SOURCE_LANGUAGE, SUBJECT, TITLE, VIEWER, START_DATE, END_DATE, START_INDEX, END_INDEX) AS SELECT
   EDI.ID,
   D.ID DOCUMENT_ID,
   EDI.ENTITY_ID,
   CASE WHEN DOCUMENT_BODY IS NOT NULL THEN 'Database'
        WHEN PATH          IS NOT NULL THEN 'File'
        ELSE                                'Reference' END STORAGE_TYPE,
   D.INSERT_DATE,
   D.INSERT_USER,
   D.UPDATE_DATE,
   D.UPDATE_USER,
   D.GUID,
   D.NAME,
   D.VERSION,
   D.ORIGINAL_SOURCE,
   D.PRODUCED_BY,
   D.REMARKS,
   D.SOURCE,
   D.CONTRIBUTOR,
   D.COVERAGE,
   D.CREATOR,
   D.DOCUMENT_BODY,
   D.DOCUMENT_DATE,
   D.DOCUMENT_FOLDER_ID,
   
D.DOCUMENT_FORMAT,
   D.DOCUMENT_TYPE,
   D.FILE_SIZE,
   D.MEDIA_TYPE,
   D.ORIGINAL_PATH,
   D.PATH,
   D.PUBLISHER,
   D.RIGHTS,
   D.SOURCE_LANGUAGE,
   D.SUBJECT,
   D.TITLE,
   D.VIEWER,
   EDI.START_DATE,
   EDI.END_DATE,
   EDI.START_INDEX,
   EDI.END_INDEX
FROM
   ENTITY_DOC_INVOLVEMENT EDI,
   DOCUMENT D
WHERE
   D.ID=EDI.DOCUMENT_ID AND EDI.ENTITY_TBL='Export_Job'
   


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.