Overview

This article lists all Ci and CiA tables included in the automated data replication to the Spatial Cloud. Data replication is run nightly before midnight in your timezone. 

If you are a new CiA customer, or have moved from Ci P&R to CiA P&R ensure you have requested the relevant tables outlined here.


Standard Spatial Tables

Schema

Object

USE

Comments

*Default suite

TBGEO_SPATIAL_CATLG

Spatial Catalogue layer extract

The default suite for your CIA environment must be nominated to successfully include this data. If incorrect suite used the catalogue id for SpatialCatalogue extracts will not be populated

CES

TBGEO_MLSEARCH

New FID mapkey

These tables must first be generated in CiA by the Spatial Processing Engine job

PR

TBGEO_MLSEARCH

New FID mapkey

These tables must first be generated in CiA by the Spatial Processing Engine job 


Standard Assets Tables

Schema

Object

CES

F1ASR_ASSET_DEFECT

CES

F1ASR_ASSET_DEFECT_GEOM_LS

CES

F1ASR_ASSET_DEFECT_GEOM_PG

CES

F1ASR_ASSET_DEFECT_GEOM_PT

CES

F1ASR_REG_ASSET

CES

F1ASR_REG_ASSET_ATTR

CES

F1ASR_REG_ASSET_GEOM_LS

CES

F1ASR_REG_ASSET_GEOM_PG

CES

F1ASR_REG_ASSET_GEOM_PT

CES

F1ASR_REG_CTL

CES

F1ASR_REG_CTL_ATTR

CES

F1ASS_ASSET_SYSTEM

CES

F1ASS_ATTR_CTL

CES

F1ASS_ATTR_ITEM

CES

F1ASS_ATTR_ITEM_STRUCT

CES

F1USF_USER_FLD_CTL

CES

F1USF_USER_FLD_DEFN

CES

F1WRK_TASK_CTL

CES

F1WRK_TASK_GEOM_LS

CES

F1WRK_TASK_GEOM_PG

CES

F1WRK_TASK_GEOM_PT

CES

GLF_SELN_CODE

CES

TBGEO_LOCATION

CES

F1ASR_REG_RELN_ITM

CES

F1ASR_DEFECT_CTL

CES

F1WRK_PROJ_CTL

CES

F1ASR_REG_ASSET_SC

CES

F1ASR_REG_ASSET_UF

CES

F1WRK_TASK_CTL_ASS

CES

AMASS_UNIT_RATE_CTL

CES

F1ASR_DEFECT_CTL

CES

F1STC_CODE

CES

F1WRK_ACTY_CTL

CES

F1WRK_PROJ_CTL

CES

F1WRK_WORK_CODE

CES

TBBPM_ITEM_ENTITY


CiA P&R Tables

Schema

Object

PR

P1ANI_ANIMAL

PR

P1ANI_ANIMAL_TYPE

PR

P1ANI_BREED

PR

P1ANI_CLASSIFICATION

PR

P1ANI_COLOUR

PR

P1ANI_STATUS

PR

P1COM_APPLN

PR

P1COM_APPLN_TYPE

PR

P1COM_CATEGORY

PR

P1PLN_CONTACT

PR

P1PLN_LAND

PR

P1PLN_LAND_ALT_ADDRESS

PR

P1PLN_LOCATION

PR

P1PLN_NAME

PR

P1PLN_NAME_COM_METHOD

PR

P1PLN_NAME_POSTAL_ADDRESS

PR

P1PLN_NAME_PRIVATE

PR

P1PLN_NAME_TRANS_METHOD

PR

P1PLN_NAME_WS_CTL

PR

P1PLN_NAME_WS_CTL_LOG

PR

P1PLN_NAME_WS_NAME

PR

P1PLN_NAME_WS_NAME_MATCH

PR

P1PLN_PROP_ALT_ADDRESS

PR

P1PLN_PROP_LAND_SYSTEM

PR

P1PLN_PROP_LAYOUT

PR

P1PLN_PROP_LAYOUT_TYPE

PR

P1PLN_PROP_LAYOUT_TYPE_FLD

PR

P1PLN_PROP_LOCATION

PR

P1PLN_PROPERTY

PR

P1PLN_ROL_PROJECT

PR

P1PLN_ROL_PROP_LAND

PR

P1PLN_SPATIAL_ATTR_GEN

PR

P1PLN_STREET

PR

P1PLN_STREET_COMP

PR

P1PLN_STREET_COMP_LAYOUT

PR

P1PLN_TENANCY

PR

P1PLN_USER

PR

P1PLN_USER_TYPE

PR

P1PRC_ASSOCIATION

PR

P1PRC_SELECTION_CODE

PR

P1PRC_SYSTEM_LINK

PR

P1SRV_DEVICE

PR

P1SRV_DEVICE_TYPE

PR

P1SRV_SERVICE

PR

P1SRV_SERVICE_TYPE

PR

P1STC_CODE

PR

ABTBLS_T1_CMA_LOCA

PR

ABTBLS_T1_CMA_SECT 

PR

ABTBLS_T1_CMA_PLOT

PR

ABTBLS_T1_CMA_INTE

PR

TBENT_LINK

PR

P1REQ_REQUEST

PR

P1REQ_STAGE_DEF

PR

TBGEO_SPATIAL_CATLG

PR

P1DEB_ACCOUNT

PR

P1WTMCONNECTION

PR

P1PRC_THEME

PR

P1PRC_THEME_LINK

PR

P1BIL_VALUATION


Ci P&R Tables

Schema

Object

PR

ANIMASTER

PR

NUCADDRESS

PR

NUCALIAS

PR

NUCASSOCIATION

PR

NUCASSOCIATIONCONTROL

PR

NUCATTRIBUTE

PR

NUCATTRIBUTECONTROL

PR

NUCDESCRIPTOR

PR

NUCLAND

PR

NUCLAND_GEOM_LS

PR

NUCLAND_GEOM_PG

PR

NUCLAND_GEOM_PT

PR

NUCLOCALITY

PR

NUCNAME

PR

NUCPROPERTY

PR

NUCPROPERTY_GEOM_LS

PR

NUCPROPERTY_GEOM_PG

PR

NUCPROPERTY_GEOM_PT

PR

NUCSTREET

PR

NUCTHEME

PR

NUCTHEMECONTROL

PR

RAMAPPLICATIONPROCESS

PR

RAMCATEGORYCONTROL

PR

SRVSERVICE

PR

SRVSERVICECONTROL

PR

RAMGROUP

PR

NUCCHARGECONTROLAMOUNT

PR

NUCCHARGECONTROL

PR

NUCCHARGECONTROL