Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Nome ColonnaAnnullabileTipo datoFonteComment
ACTIVATION_YEARYNUMBER(10,0)Anno fine validit?
APPLICATIONS_CONCATYVARCHAR2(4000)Concatenazione SSD di riferimento
APPLICATIONS_COUNTYNUMBER(10,0)Conteggio SSD di riferimento
ATTACHMENT_CONCATYVARCHAR2(4000) Allegati concatenazione
ATTACHMENT_COUNTYNUMBER(10,0) allegati conteggio
BUILDINGYVARCHAR2(4000)Edificio
COST_TYPE_CONCATYVARCHAR2(4000) Concatenazione tipologie di costo
COST_TYPE_COUNTYNUMBER(10,0)Conteggio tipologie di costo
CREATE_DATEYTIMESTAMP(6)(,6)Data di creazione
DESCRIPTIONYVARCHAR2(4000)Descrizione
END_DATEYTIMESTAMP(6)(,6)Data fine validit?
EQP_FLOORYVARCHAR2(4000)Piano
ESFRI_CLASSIFICATION_CONCATYVARCHAR2(4000) Concatenazione classificazioni ESFRI
ESFRI_CLASSIFICATION_COUNTYNUMBER(10,0) Conteggio classificazioni ESFRI
HISTORICAL_EVIDENCEYNUMBER(1,0)Oggetto di interesse storico
IDENTIFIERYVARCHAR2(1020)Codice identificativo
INTERNAL_ORG_UNIT_CONCATYVARCHAR2(4000)Concatenazione ORG UNIT di riferimento
INTERNAL_ORG_UNIT_COUNTYNUMBER(10,0)Conteggio ORG UNIT di riferimento
INTERNAL_REPRESENTATIVE_CONCATYVARCHAR2(4000)Concatenazione PERSON di riferimento
INTERNAL_REPRESENTATIVE_COUNTYNUMBER(10,0)Conteggio PERSON di riferimento
INVENTORY_CODEYVARCHAR2(4000)Codice d'inventario
IN_USEYNUMBER(1,0)Attualmente utilizzatoFunzionante
IS_A_SNAPSHOTYNUMBER(1,0)Indica se questa ? una versione SNAPSHOT
IS_MASTERYNUMBER(1,0) Indica se la versione ? quella master dell'ITEM
IS_MOST_VALIDATEDYNUMBER(1,0) Indica se questa versione ? quella ?pi? validata? secondo le regole definite
LAST_MODIFIEDYTIMESTAMP(6)(,6)Data di ultima modifica
MANIFACTURING_YEARYNUMBER(10,0)Anno di fabbricazione
MANUFACTORING_COMYVARCHAR2(4000)Azienda manifatturiera
NOTEYVARCHAR2(4000)Note
OWNER_CONCATYVARCHAR2(4000)Concatenazione PERSON di riferimento
OWNER_COUNTYNUMBER(10,0)Conteggio PERSON di riferimento
PRICEYNUMBER(18,3)Valore al momento dell acquisto
PRIZE_CONCATYVARCHAR2(4000) Premi concatenazione
PRIZE_COUNTYNUMBER(10,0)Premi conteggio
PROPERTY_EXTERNALYVARCHAR2(4000)Ente proprietario
PROPERTY_INTERNALYNUMBER(1,0)Propriet? dell ateneo
PUB_CALENDARYNUMBER(1,0)Calendario pubblico
REPARABLEYVARCHAR2(4000)Riparabile
RMCUSTOMCLASS_CONCATYVARCHAR2(4000)Tipologia personalizzata (concatenazione)
RMCUSTOMCLASS_COUNTYNUMBER(10,0)Tipologia personalizzata (conteggio)
ROOMYVARCHAR2(4000)Stanza
SERIAL_NUMBERYVARCHAR2(4000)Numero di serie
START_DATEYTIMESTAMP(6)(,6)Data inizio validit?
TARIFFYVARCHAR2(4000)Tariffario
TITLEYVARCHAR2(4000)Denominazione
UGOV_IDYNUMBER(10,0)Identificativo U-Gov
URL_PUB_CALENDARYVARCHAR2(4000)URL calenadrio pubblico
USER_TYPE_CONCATYVARCHAR2(4000)Concatenazione delle tipologie di utilizzo
USER_TYPE_COUNTYNUMBER(10,0)Conteggio delle tipologie di utilizzo
VISIBLE_ON_PORTALYNUMBER(1,0)Indica se debba essere visibile su portali pubblici
WF_ANCESTOR_TYPE_DESYVARCHAR2(4000)Descrizione del tipo radice dell'ITEM
WF_ANCESTOR_TYPE_IDYNUMBER(10,0)Identificativo univoco del tipo radice dell'ITEM
WF_ANCESTOR_TYPE_IDEYVARCHAR2(4000)Identificativo alfanumerico del tipo radice dell'ITEM
WF_ITEM_IDNNUMBER(10,0)Identificativo univoco della versione dell'ITEM (numerazione relativa ad ITEM derivanti dal modulo AP)
WF_ITEM_TYPE_DESYVARCHAR2(4000)Descrizione del tipo di ITEM
WF_ITEM_TYPE_IDYNUMBER(10,0)Identificativo univoco del tipo di ITEM
WF_ITEM_TYPE_IDEYVARCHAR2(4000)Identificativo alfanumerico del tipo di ITEM
WF_MASTER_IDYNUMBER(10,0) Identificativo della versione master dell'ITEM (identico a item_id in caso di ITEM con unica versione)
WF_MOST_VALIDATED_IDYNUMBER(10,0) Identificativo della versione pi? validata dell'ITEM
WF_PARENT_TYPE_DESYVARCHAR2(4000)Descrizione del tipo padre dell'ITEM
WF_PARENT_TYPE_IDYNUMBER(10,0)Identificativo univoco del tipo padre dell'ITEM
WF_PARENT_TYPE_IDEYVARCHAR2(4000)Identificativo alfanumerico del tipo padre dell'ITEM
WF_STATE_IDYNUMBER(10,0)Identificativo dello stato dell'ITEM
WF_STATE_IDEYVARCHAR2(255)Identificativo alfanumerico dello stato dell'ITEM
WITHDRAWNYNUMBER(1,0)Cancellazione logica
YEARYNUMBER(10,0)Anno di riferimento

...

Nome ColonnaAnnullabileTipo datoFonteComment
ACTIVATION_YEARYNUMBER(10,0)
APPLICATIONS_CONCATYVARCHAR2(4000)
APPLICATIONS_COUNTYNUMBER(10,0)
ATTACHMENT_CONCATYVARCHAR2(4000)
ATTACHMENT_COUNTYNUMBER(10,0)
BUILDINGYVARCHAR2(4000)
COST_TYPE_CONCATYVARCHAR2(4000)
COST_TYPE_COUNTYNUMBER(10,0)
CREATE_DATEYTIMESTAMP(6)(,6)
DESCRIPTIONYVARCHAR2(4000)
END_DATEYTIMESTAMP(6)(,6)
EQP_FLOORYVARCHAR2(4000)
ESFRI_CLASSIFICATION_CONCATYVARCHAR2(4000)
ESFRI_CLASSIFICATION_COUNTYNUMBER(10,0)
HISTORICAL_EVIDENCEYNUMBER(1,0)
IDENTIFIERYVARCHAR2(1020)
INTERNAL_ORG_UNIT_CONCATYVARCHAR2(4000)
INTERNAL_ORG_UNIT_COUNTYNUMBER(10,0)
INTERNAL_REPRESENTATIVE_CONCATYVARCHAR2(4000)
INTERNAL_REPRESENTATIVE_COUNTYNUMBER(10,0)
INVENTORY_CODEYVARCHAR2(4000)
IN_USEYNUMBER(1,0)
IS_A_SNAPSHOTYNUMBER(1,0)
IS_MASTERYNUMBER(1,0)
IS_MOST_VALIDATEDYNUMBER(1,0)
LAST_MODIFIEDYTIMESTAMP(6)(,6)
MANIFACTURING_YEARYNUMBER(10,0)
MANUFACTORING_COMYVARCHAR2(4000)
NOTEYVARCHAR2(4000)
OWNER_CONCATYVARCHAR2(4000)
OWNER_COUNTYNUMBER(10,0)
PRICEYNUMBER(18,3)
PRIZE_CONCATYVARCHAR2(4000)
PRIZE_COUNTYNUMBER(10,0)
PROPERTY_EXTERNALYVARCHAR2(4000)
PROPERTY_INTERNALYNUMBER(1,0)
PUB_CALENDARYNUMBER(1,0)
REPARABLEYVARCHAR2(4000)
RMCUSTOMCLASS_CONCATYVARCHAR2(4000)
RMCUSTOMCLASS_COUNTYNUMBER(10,0)
ROOMYNUMBERVARCHAR2(10,04000)
SERIAL_NUMBERYVARCHAR2(4000)
START_DATEYTIMESTAMP(6)(,6)
TARIFFYVARCHAR2(4000)
TITLEYVARCHAR2(4000)
UGOV_IDYNUMBER(10,0)
URL_PUB_CALENDARYVARCHAR2(4000)
USER_TYPE_CONCATYVARCHAR2(4000)
USER_TYPE_COUNTYNUMBER(10,0)
VISIBLE_ON_PORTALYNUMBER(1,0)
WF_ANCESTOR_TYPE_DESYVARCHAR2(4000)
WF_ANCESTOR_TYPE_IDYNUMBER(10,0)
WF_ANCESTOR_TYPE_IDEYVARCHAR2(4000)
WF_ITEM_IDNNUMBER(10,0)
WF_ITEM_TYPE_DESYVARCHAR2(4000)
WF_ITEM_TYPE_IDYNUMBER(10,0)
WF_ITEM_TYPE_IDEYVARCHAR2(4000)
WF_MASTER_IDYNUMBER(10,0)
WF_MOST_VALIDATED_IDYNUMBER(10,0)
WF_PARENT_TYPE_DESYVARCHAR2(4000)
WF_PARENT_TYPE_IDYNUMBER(10,0)
WF_PARENT_TYPE_IDEYVARCHAR2(4000)
WF_STATE_IDYNUMBER(10,0)
WF_STATE_IDEYVARCHAR2(255)
WITHDRAWNYNUMBER(1,0)
YEARYNUMBER(10,0)

...

Nome ColonnaAnnullabileTipo datoFonteComment
ACTIVATION_YEARYNUMBER(10,0)
APPLICATIONS_CONCATYVARCHAR2(4000)
APPLICATIONS_COUNTYNUMBER(10,0)
ATTACHMENT_CONCATYVARCHAR2(4000)
ATTACHMENT_COUNTYNUMBER(10,0)
BUILDINGYVARCHAR2(4000)
COST_TYPE_CONCATYVARCHAR2(4000)
COST_TYPE_COUNTYNUMBER(10,0)
CREATE_DATEYTIMESTAMP(6)(,6)
DESCRIPTIONYVARCHAR2(4000)
END_DATEYTIMESTAMP(6)(,6)
EQP_FLOORYVARCHAR2(4000)
ESFRI_CLASSIFICATION_CONCATYVARCHAR2(4000)
ESFRI_CLASSIFICATION_COUNTYNUMBER(10,0)
HISTORICAL_EVIDENCEYNUMBER(1,0)
IDENTIFIERYVARCHAR2(1020)
INTERNAL_ORG_UNIT_CONCATYVARCHAR2(4000)
INTERNAL_ORG_UNIT_COUNTYNUMBER(10,0)
INTERNAL_REPRESENTATIVE_CONCATYVARCHAR2(4000)
INTERNAL_REPRESENTATIVE_COUNTYNUMBER(10,0)
INVENTORY_CODEYVARCHAR2(4000)
IN_USEYNUMBER(1,0)
IS_A_SNAPSHOTYNUMBER(1,0)
IS_MASTERYNUMBER(1,0)
IS_MOST_VALIDATEDYNUMBER(1,0)
LAST_MODIFIEDYTIMESTAMP(6)(,6)
MANIFACTURING_YEARYNUMBER(10,0)
MANUFACTORING_COMYVARCHAR2(4000)
NOTEYVARCHAR2(4000)
OWNER_CONCATYVARCHAR2(4000)
OWNER_COUNTYNUMBER(10,0)
PRICEYNUMBER(18,3)
PRIZE_CONCATYVARCHAR2(4000)
PRIZE_COUNTYNUMBER(10,0)
PROPERTY_EXTERNALYVARCHAR2(4000)
PROPERTY_INTERNALYNUMBER(1,0)
PUB_CALENDARYNUMBER(1,0)
REPARABLEYVARCHAR2(4000)
RMCUSTOMCLASS_CONCATYVARCHAR2(4000)
RMCUSTOMCLASS_COUNTYNUMBER(10,0)
ROOMYVARCHAR2(4000)
SERIAL_NUMBERYVARCHAR2(4000)
START_DATEYTIMESTAMP(6)(,6)
TARIFFYVARCHAR2(4000)
TITLEYVARCHAR2(4000)
UGOV_IDYNUMBER(10,0)
URL_PUB_CALENDARYVARCHAR2(4000)
USER_TYPE_CONCATYVARCHAR2(4000)
USER_TYPE_COUNTYNUMBER(10,0)
VISIBLE_ON_PORTALYNUMBER(1,0)
WF_ANCESTOR_TYPE_DESYVARCHAR2(4000)
WF_ANCESTOR_TYPE_IDYNUMBER(10,0)
WF_ANCESTOR_TYPE_IDEYVARCHAR2(4000)
WF_ITEM_IDNNUMBER(10,0)
WF_ITEM_TYPE_DESYVARCHAR2(4000)
WF_ITEM_TYPE_IDYNUMBER(10,0)
WF_ITEM_TYPE_IDEYVARCHAR2(4000)
WF_MASTER_IDYNUMBER(10,0)
WF_MOST_VALIDATED_IDYNUMBER(10,0)
WF_PARENT_TYPE_DESYVARCHAR2(4000)
WF_PARENT_TYPE_IDYNUMBER(10,0)
WF_PARENT_TYPE_IDEYVARCHAR2(4000)
WF_STATE_IDYNUMBER(10,0)
WF_STATE_IDEYVARCHAR2(255)
WITHDRAWNYNUMBER(1,0)
YEARYNUMBER(10,0)

...