New columns added to existing tables - HxGN EAM - 12.0 - Release Bulletin - Hexagon

HxGN EAM Release Notes for 2022

Language
English
Product
HxGN EAM
Search by Category
Release Bulletin
HxGN EAM Version
12

The following columns have been added to existing tables in this release of HxGN EAM.

Table name

Column name

Oracle datatype

SQL Server datatype

OCAD_AE_DOCUMENTS

AE_DOC_SPACES_CFG

NVARCHAR2

OCAD_AE_LAYERS_STATUS

AE_LS_DOC_ORG

NVARCHAR2

OCAD_AE_LAYERS_STATUS

AE_LS_DOC_CODE

NVARCHAR2

OCAD_AE_LAYERS_STATUS

AE_LS_FILENAME_DWG

NVARCHAR2

OCAD_AE_LAYERS_STATUS

AE_LS_FILENAME_SVG

NVARCHAR2

OCAD_AE_LAYERS_STATUS

AE_LS_LAYERNAME

NVARCHAR2

OCAD_AE_LAYERS_STATUS

AE_LS_LAYER_ON

NVARCHAR2

OCAD_AE_LAYERS_STATUS

AE_LS_LAYER_FROZEN

NVARCHAR2

OCAD_AE_LAYERS_STATUS

AE_LS_LAYER_LOCK

NVARCHAR2

R5ACTCHECKLISTS

ACK_RESULTRENTITY

VARCHAR2(4)

nvarchar(4)

R5ACTCHECKLISTS

ACK_RESULTENTITYCLASSOPTIONS

VARCHAR2(500)

nvarchar(500)

R5ACTCHECKLISTS

ACK_RESULTENTITYCODE

VARCHAR2(30)

nvarchar(30)

R5ACTCHECKLISTS

ACK_RESULTENTITYORG

VARCHAR2(15)

nvarchar(15)

R5ACTIVITIES

ACT_CUEST

VARCHAR2(1)

nvarchar(1)

R5ACTIVITIES_ARCHIVE

ACA_CUEST

VARCHAR2(1)

nvarchar(1)

R5ALERTPICKTICKETFIELDMAP

APF_ALERT

VARCHAR2(30)

nvarchar(30)

R5ALERTPICKTICKETFIELDMAP

APF_PICKTICKETFIELD

VARCHAR2(30)

nvarchar(30)

R5ALERTPICKTICKETFIELDMAP

APF_GRIDFIELD

NUMBER(14,0)

numeric(14,0)

R5ALERTPICKTICKETFIELDMAP

APF_GRIDFIELDDATATYPE

VARCHAR2(10)

nvarchar(10)

R5ALERTPICKTICKETFIELDMAP

APF_BOILERTEXTNUMBER

NUMBER(4,0)

numeric(4,0)

R5ALERTPICKTICKETFIELDMAP

APF_UPDATECOUNT

NUMBER(38,0)

numeric(38,0)

R5ALERTPICKTICKETFIELDMAP

APF_LASTSAVED

DATE

datetime

R5ALERTS

ALT_ENABLEWOPICKTICKET

VARCHAR2(1)

nvarchar(1)

R5ALERTWOPICKTICKET

AWP_ALERT

VARCHAR2(30)

nvarchar(30)

R5ALERTWOPICKTICKET

AWP_STATUS

VARCHAR2(4)

nvarchar(4)

R5ALERTWOPICKTICKET

AWP_STORE

VARCHAR2(15)

nvarchar(15)

R5ALERTWOPICKTICKET

AWP_DESC

VARCHAR2(80)

nvarchar(80)

R5ALERTWOPICKTICKET

AWP_UPDATECOUNT

NUMBER(38,0)

numeric(38,0)

R5ALERTWOPICKTICKET

AWP_LASTSAVED

DATE

datetime

R5CASEMANAGEMENT

CSM_DOWNTIMECOST

NUMBER(24,6)

numeric(24,6)

R5CASEMANAGEMENT

R5CASEMANAGEMENT

NUMBER(24,6)

numeric(24,6)

R5CASEMANAGEMENT

CSM_TOTALCOST

NUMBER(24,6)

numeric(24,6)

R5CASEMANAGEMENT

CSM_LOSTPRODUCTIVITYHRS

NUMBER(24,6)

numeric(24,6)

R5CASEMANAGEMENT

CSM_PROBLEMDESCRIPTION

VARCHAR2(4000)

nvarchar(4000)

R5CASEMANAGEMENT

CSM_WHATHAPPENED

VARCHAR2(4000)

nvarchar(4000)

R5CASEMANAGEMENT

CSM_WHY1

VARCHAR2(4000)

nvarchar(4000)

R5CASEMANAGEMENT

CSM_WHY2

VARCHAR2(4000)

nvarchar(4000)

R5CASEMANAGEMENT

CSM_WHY3

VARCHAR2(4000)

nvarchar(4000)

R5CASEMANAGEMENT

CSM_WHY4

VARCHAR2(4000)

nvarchar(4000)

R5CASEMANAGEMENT

CSM_WHY5

VARCHAR2(4000)

nvarchar(4000)

R5CASEMANAGEMENT

CSM_SOLUTION

VARCHAR2(4000)

nvarchar(4000)

R5CASEMANAGEMENT

CSM_PROBLEM

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_FAILURE

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_ACTION

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_CAUSE

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_FAILUREMODE

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_SYMPTOM

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_TACTICALCAUSE

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_HUMANFACTOR

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_WORKMANSHIP

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_HUMANOVERSIGHT

VARCHAR2(8)

nvarchar(8)

R5CASEMANAGEMENT

CSM_METHODOFDETECTION

VARCHAR2(8)

nvarchar(8)

R5CLASSES

CLS_SEGMENTVALUE

VARCHAR2(30)

nvarchar(30)

R5CLASSES

CLS_IMAGE

VARCHAR2(30)

nvarchar(30)

R5CLASSLINEARREFS

CLR_IMAGE

VARCHAR2(30)

nvarchar(30)

R5CODESTRUCTURE

CSR_IMAGE

VARCHAR2(30)

nvarchar(30)

R5CONTRACTORSIGNOFF

CSO_ISSIGNED

VARCHAR2(1)

nvarchar(1)

R5CREWS

CRW_SEGMENTVALUE

VARCHAR2(30)

nvarchar(30)

R5DOCUMENTS

DOC_ISIMAGE

VARCHAR2(1)

nvarchar(1)

R5ECSESSIONDETAILS

CSD_EXCLUDEEQUIPMENT

VARCHAR2(1)

nvarchar(1)

R5ECSESSIONDETAILS

CSD_PARENTEXCLUDED

VARCHAR2(1)

nvarchar(1)

R5ECSESSIONDETAILS

CSD_ALLOWVARQUANTITY

VARCHAR2(1)

nvarchar(1)

R5ECSESSIONDETAILS

CSD_DEFAULTQUANTITY

NUMBER(5,0)

numeric(5,0)

R5ECSESSIONDETAILS

CSD_QUANTITY

NUMBER(5,0)

numeric(5,0)

R5ECSESSIONDETAILS

CSD_MINQUANTITY

NUMBER(5,0)

numeric(5,0)

R5ECSESSIONDETAILS

CSD_MAXQUANTITY

NUMBER(5,0)

numeric(5,0)

R5ECSESSIONEQUIPMENT

CSE_PK

NUMBER

numeric(18,0)

R5ECSESSIONEQUIPMENT

CSE_PARENTPK

NUMBER

numeric(18,0)

R5ECSESSIONWARNINGS

CSW_CSEPK

NUMBER

numeric(18,0)

R5ELECARCHIVE

ELA_FLD445

VARCHAR2(256)

nvarchar(256)

R5ELECARCHIVE

ELA_FLD446

VARCHAR2(256)

nvarchar(256)

R5ELECARCHIVE

ELA_FLD447

VARCHAR2(256)

nvarchar(256)

R5ELECARCHIVE_ARCHIVE

AEA_FLD445

VARCHAR2(256)

nvarchar(256)

R5ELECARCHIVE_ARCHIVE

AEA_FLD446

VARCHAR2(256)

nvarchar(256)

R5ELECARCHIVE_ARCHIVE

AEA_FLD447

VARCHAR2(256)

nvarchar(256)

R5EQUIPCONFIGSTRUCTURES

ECS_ALLOWVARQUANTITY

VARCHAR2(1)

nvarchar(1)

R5EQUIPCONFIGSTRUCTURES

ECS_DEFAULTQUANTITY

NUMBER(5,0)

numeric(5,0)

R5EQUIPCONFIGSTRUCTURES

ECS_MINQUANTITY

NUMBER(5,0)

numeric(5,0)

R5EQUIPCONFIGSTRUCTURES

ECS_MAXQUANTITY

NUMBER(5,0)

numeric(5,0)

R5EQUIPFUNCTIONLEVELS

EFL_NOUN

VARCHAR2(8)

nvarchar(8)

R5EQUIPFUNCTIONLEVELS

EFL_VERB

VARCHAR2(8)

nvarchar(8)

R5EQUIPFUNCTIONLEVELS

EFL_COMPLEMENT

VARCHAR2(80)

nvarchar(80)

R5EQUIPFUNCTIONLEVELS

EFL_EFFECTINDICATOR

VARCHAR2(4000)

nvarchar(4000)

R5EQUIPFUNCTIONLEVELS

EFL_EFFECTCONSEQUENCE

VARCHAR2(4000)

nvarchar(4000)

R5EQUIPFUNCTIONLEVELS

EFL_ORIGCODE

VARCHAR2(30)

nvarchar(30)

R5EVTTESTPOINTS

ETP_FULLDEVICEREADING

NUMBER(29,11)

numeric(29,11)

R5EVTTESTPOINTS

ETP_FULLDEVICEREADINGAL

NUMBER(29,11)

numeric(29,11)

R5EVTTESTPOINTS

ETP_TESTPOINT_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_STANDARD_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_STANDARDAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_OUTPUT_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_OUTPUTAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_DEVICETOLFROM_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_DEVICETOLFROMAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_DEVICETOLTO_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_DEVICETOLTOAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_DEVICEREADING_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_DEVICEREADINGAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_DEVIATION_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_DEVIATIONAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_FULLDEVREADING_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS

ETP_FULLDEVREADAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_FULLDEVICEREADING

NUMBER(29,11)

numeric(29,11)

R5EVTTESTPOINTS_ARCHIVE

AET_FULLDEVICEREADINGAL

NUMBER(29,11)

numeric(29,11)

R5EVTTESTPOINTS_ARCHIVE

AET_TESTPOINT_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_STANDARD_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_STANDARDAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_OUTPUT_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_OUTPUTAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_DEVICETOLFROM_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_DEVICETOLFROMAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_DEVICETOLTO_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_DEVICETOLTOAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_DEVICEREADING_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_DEVICEREADINGAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_DEVIATION_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_DEVIATIONAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_FULLDEVREADING_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5EVTTESTPOINTS_ARCHIVE

AET_FULLDEVREADAL_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5FUNCTIONS

FUN_PRODUCT

VARCHAR2(1)

nvarchar(1)

R5GLACCOUNTINGLOV

GLL_PK

VARCHAR2(4)

nvarchar(4)

R5GLACCOUNTINGLOV

GLL_MAINENTITY

VARCHAR2(4)

nvarchar(4)

R5GLACCOUNTINGLOV

GLL_ENTITY

VARCHAR2(4)

nvarchar(4)

R5GLACCOUNTINGLOV

GLL_COLUMNABB

VARCHAR2(10)

nvarchar(10)

R5GLACCOUNTINGLOV

GLL_BOTABB

VARCHAR2(10)

nvarchar(10)

R5GLACCOUNTINGLOV

GLL_FUNCTION

VARCHAR2(6)

nvarchar(6)

R5GLACCOUNTINGLOV

GLL_BOTNUMBER

NUMBER(4,0)

numeric(4,0)

R5GLACCOUNTINGLOV

GLL_VALUEFUNCTION

VARCHAR2(6)

nvarchar(6)

R5GLACCOUNTINGSETUP

GLA_PK

VARCHAR2(30)

nvarchar(30)

R5GLACCOUNTINGSETUP

GLA_SEGMENTENTITY

VARCHAR2(4)

nvarchar(4)

R5GLACCOUNTINGSETUP

GLA_SEGMENT

VARCHAR2(30)

nvarchar(30)

R5GLACCOUNTINGSETUP

GLA_ORG

VARCHAR2(15)

nvarchar(15)

R5GLACCOUNTINGSETUP

GLA_LEVELSOURCEFIELD1

VARCHAR2(4)

nvarchar(4)

R5GLACCOUNTINGSETUP

GLA_LEVELSEGMENTVALUE1

VARCHAR2(30)

nvarchar(30)

R5GLACCOUNTINGSETUP

GLA_LEVELSOURCEFIELD2

VARCHAR2(4)

nvarchar(4)

R5GLACCOUNTINGSETUP

GLA_LEVELSEGMENTVALUE2

VARCHAR2(30)

nvarchar(30)

R5GLACCOUNTINGSETUP

GLA_LEVELSOURCEFIELD3

VARCHAR2(4)

nvarchar(4)

R5GLACCOUNTINGSETUP

GLA_LEVELSEGMENTVALUE3

VARCHAR2(30)

nvarchar(30)

R5GLACCOUNTINGSETUP

GLA_UPDATECOUNT

NUMBER(38,0)

numeric(38,0)

R5GLACCOUNTINGSETUP

GLA_LASTSAVED

DATE

datetime

R5GLACCOUNTINGSETUP

GLA_ACCOUNTED

VARCHAR2(2)

nvarchar(2)

R5INVESTMENTPLANCONDITIONS

IPC_INVESTMENTPLANNING

VARCHAR2(30)

nvarchar(30)

R5INVESTMENTPLANCONDITIONS

IPC_INVESTMENTPLANNINGREV

NUMBER(4,0)

numeric(4,0)

R5INVESTMENTPLANCONDITIONS

IPC_INVESTMENTPLANNING_ORG

VARCHAR2(15)

nvarchar(15)

R5INVESTMENTPLANCONDITIONS

IPC_OBJECT

VARCHAR2(30)

nvarchar(30)

R5INVESTMENTPLANCONDITIONS

IPC_OBJECT_ORG

VARCHAR2(15)

nvarchar(15)

R5INVESTMENTPLANCONDITIONS

IPC_PERIOD

NUMBER(2,0)

numeric(2,0)

R5INVESTMENTPLANCONDITIONS

IPC_STARTDATE

DATE

datetime

R5INVESTMENTPLANCONDITIONS

IPC_ENDDATE

DATE

datetime

R5INVESTMENTPLANCONDITIONS

IPC_STARTSCORE

NUMBER(24,6)

numeric(24,6)

R5INVESTMENTPLANCONDITIONS

IPC_ENDSCORE

NUMBER(24,6)

numeric(24,6)

R5INVESTMENTPLANCONDITIONS

IPC_STARTINDEX

VARCHAR2(8)

nvarchar(8)

R5INVESTMENTPLANCONDITIONS

IPC_ENDINDEX

VARCHAR2(8)

nvarchar(8)

R5INVESTMENTPLANCONDITIONS

IPC_ENDUSAGE

NUMBER(24,6)

numeric(24,6)

R5INVESTMENTPLANCONDITIONS

IPC_STARTRATING

NUMBER(3,0)

numeric(3,0)

R5INVESTMENTPLANCONDITIONS

IPC_ENDRATING

NUMBER(3,0)

numeric(3,0)

R5INVESTMENTPLANCONDITIONS

IPC_CORRSCORE

NUMBER(24,6)

numeric(24,6)

R5INVESTMENTPLANCONDITIONS

IPC_CORRSCOREDATE

DATE

datetime

R5INVESTMENTPLANCONDITIONS

IPC_CORRSCOREUSAGE

NUMBER(24,6)

numeric(24,6)

R5INVESTMENTPLANCONDITIONS

IPC_SCOREIMPROVEMENT

NUMBER(24,6)

numeric(24,6)

R5INVESTMENTPLANCONDITIONS

IPC_FINAL

VARCHAR2(1)

nvarchar(1)

R5INVESTMENTPLANCONDITIONS

IPC_RUNID

VARCHAR2(100)

nvarchar(100)

R5INVESTMENTPLANCONDITIONS

IPC_CHK

VARCHAR2(4)

nvarchar(4)

R5INVESTMENTPLANCONDITIONS

IPC_MESSAGE

VARCHAR2(500)

nvarchar(500)

R5INVESTMENTPLANCONDITIONS

IPC_UPDATECOUNT

NUMBER(38,0)

numeric(38,0)

R5INVESTMENTPLANCONDITIONS

IPC_LASTSAVED

DATE

datetime

R5INVESTMENTPLANNING

INP_CONDCALCSTATUS

VARCHAR2(8)

nvarchar(8)

R5INVESTMENTPLANNING

INP_CONDCALCREQUESTDATE

DATE

datetime

R5INVESTMENTPLANNING

INP_CONDCALCRUNDATE

DATE

datetime

R5KPISCORES

KPS_IMAGE

VARCHAR2(30)

nvarchar(30)

R5MOBILELBSDATA

LBS_ZCOORDINATE

NUMBER(24,6)

numeric(24,6)

R5MOBILELBSDATA

LBS_LOCATIONAVAILABLE

VARCHAR2(1)

nvarchar(1)

R5MOBILELBSDATA

LBS_NETWORKAVAILABLE

VARCHAR2(1)

nvarchar(1)

R5NONCONFORMITYTYPEASPECTS

NTA_SEVERITY

VARCHAR2(8)

nvarchar(8)

R5OBJECTS

OBJ_SEGMENTVALUE

VARCHAR2(30)

nvarchar(30)

R5OBJECTS

OBJ_DEVICETOLFROM_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5OBJECTS

OBJ_DEVICETOLTO_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5OBJLINEARREF

LRF_IMAGE

VARCHAR2(30)

nvarchar(30)

R5OBJTESTPOINTS

OTP_TESTPOINT_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5OBJTESTPOINTS

OTP_OUTPUT_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5OBJTESTPOINTS

OTP_DEVICETOLFROM_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5OBJTESTPOINTS

OTP_DEVICETOLTO_DECIMALS

NUMBER(2,0)

numeric(2,0)

R5ORGANIZATION

ORG_RCMLEVEL

VARCHAR2(4)

nvarchar(4)

R5ORGANIZATION

ORG_RCASERVICECODE

VARCHAR2(30)

nvarchar(30)

R5ORGANIZATION

ORG_RCASERVICECODE_ORG

VARCHAR2(15)

nvarchar(15)

R5ORGANIZATION

ORG_DEEPDIVESERVICECODE

VARCHAR2(30)

nvarchar(30)

R5ORGANIZATION

ORG_DEEPDIVESERVICECODE_ORG

VARCHAR2(15)

nvarchar(15)

R5PICKLISTS

PIC_UDFCHAR01

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR02

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR03

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR04

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR05

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR06

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR07

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR08

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR09

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR10

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR11

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR12

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR13

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR14

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR15

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR16

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR17

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR18

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR19

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR20

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR21

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR22

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR23

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR24

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR25

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR26

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR27

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR28

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR29

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFCHAR30

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS

PIC_UDFNUM01

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS

PIC_UDFNUM02

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS

PIC_UDFNUM03

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS

PIC_UDFNUM04

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS

PIC_UDFNUM05

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS

PIC_UDFDATE01

DATE

datetime

R5PICKLISTS

PIC_UDFDATE02

DATE

datetime

R5PICKLISTS

PIC_UDFDATE03

DATE

datetime

R5PICKLISTS

PIC_UDFDATE04

DATE

datetime

R5PICKLISTS

PIC_UDFDATE05

DATE

datetime

R5PICKLISTS

PIC_UDFCHKBOX01

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS

PIC_UDFCHKBOX02

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS

PIC_UDFCHKBOX03

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS

PIC_UDFCHKBOX04

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS

PIC_UDFCHKBOX05

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS

PIC_UDFNOTE01

VARCHAR2(2000)

nvarchar(2000)

R5PICKLISTS

PIC_UDFNOTE02

VARCHAR2(2000)

nvarchar(2000)

R5PICKLISTS_ARCHIVE

API_UDFCHAR01

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR02

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR03

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR04

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR05

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR06

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR07

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR08

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR09

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR10

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR11

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR12

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR13

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR14

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR15

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR16

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR17

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR18

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR19

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR20

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR21

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR22

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR23

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR24

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR25

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR26

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR27

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR28

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR29

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFCHAR30

VARCHAR2(80)

nvarchar(80)

R5PICKLISTS_ARCHIVE

API_UDFNUM01

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS_ARCHIVE

API_UDFNUM02

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS_ARCHIVE

API_UDFNUM03

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS_ARCHIVE

API_UDFNUM04

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS_ARCHIVE

API_UDFNUM05

NUMBER(24,6)

numeric(24,6)

R5PICKLISTS_ARCHIVE

API_UDFDATE01

DATE

datetime

R5PICKLISTS_ARCHIVE

API_UDFDATE02

DATE

datetime

R5PICKLISTS_ARCHIVE

API_UDFDATE03

DATE

datetime

R5PICKLISTS_ARCHIVE

API_UDFDATE04

DATE

datetime

R5PICKLISTS_ARCHIVE

API_UDFDATE05

DATE

datetime

R5PICKLISTS_ARCHIVE

API_UDFCHKBOX01

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS_ARCHIVE

API_UDFCHKBOX02

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS_ARCHIVE

API_UDFCHKBOX03

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS_ARCHIVE

API_UDFCHKBOX04

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS_ARCHIVE

API_UDFCHKBOX05

VARCHAR2(1)

nvarchar(1)

R5PICKLISTS_ARCHIVE

API_UDFNOTE01

VARCHAR2(2000)

nvarchar(2000)

R5PICKLISTS_ARCHIVE

API_UDFNOTE02

VARCHAR2(2000)

nvarchar(2000)

R5PMPSESSIONLINES

PPL_PPOPK

NUMBER

int

R5PPMOBJECTS

PPO_UDFCHAR46

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR47

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR48

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR49

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR50

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR51

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR52

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR53

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR54

VARCHAR2(80)

nvarchar(80)

R5PPMOBJECTS

PPO_UDFCHAR55

VARCHAR2(80)

nvarchar(80)

R5RELIABILITYRANKINGRANKS

RRR_IMAGE

VARCHAR2(30)

nvarchar(30)

R5RISKMATRIXCONSEQUENCES

RMC_IMAGE

VARCHAR2(30)

nvarchar(30)

R5RISKMATRIXSETUP

RMS_IMAGE

VARCHAR2(30)

nvarchar(30)

R5ROLES

ROL_MOBILEAPP

VARCHAR2(8)

nvarchar(8)

R5STOCKTAKELINES

STL_SUBLINE

NUMBER(8,0)

numeric(8,0)

R5STOCKTAKELINES

STL_OBJECT

VARCHAR2(30)

nvarchar(30)

R5STOCKTAKELINES

STL_OBJECT_ORG

VARCHAR2(15)

nvarchar(15)

R5STOCKTAKELINES

STL_ACTION

VARCHAR2(2)

nvarchar(2)

R5STOCKTAKELINES

STL_WOOBJECT

VARCHAR2(30)

nvarchar(30)

R5STOCKTAKELINES

STL_WOOBJECT_ORG

VARCHAR2(15)

nvarchar(15)

R5STOCKTAKELINES

STL_ATTACHTO

VARCHAR2(30)

nvarchar(30)

R5STOCKTAKELINES

STL_ATTACHTO_ORG

VARCHAR2(15)

nvarchar(15)

R5STOCKTAKELINES

STL_WITHDRAWSTATUS

VARCHAR2(4)

nvarchar(4)

R5STOCKTAKELINES

STL_TOBIN

VARCHAR2(15)

nvarchar(15)

R5STOCKTAKELINES

STL_NOTE

VARCHAR2(2000)

nvarchar(2000)

R5STOCKTAKELINES

STL_NEWASSETFUNC

VARCHAR2(1)

nvarchar(1)

R5TASKCHECKLISTS

TCH_RESULTRENTITY

VARCHAR2(4)

nvarchar(4)

R5TASKCHECKLISTS

TCH_RESULTENTITYCLASSOPTIONS

VARCHAR2(500)

nvarchar(500)

R5TOOLS

TOO_SEGMENTVALUE

VARCHAR2(30)

nvarchar(30)

R5TRANSLINES

TRL_STOCKTAKE

VARCHAR2(30)

nvarchar(30)

R5TRANSLINES

TRL_STOCKTAKEACTION

VARCHAR2(2)

nvarchar(2)

R5TRANSLINES

TRL_RECEIVEREQ

VARCHAR2(1)

nvarchar(1)

R5TRANSLINES_ARCHIVE

ATL_STOCKTAKE

VARCHAR2(30)

nvarchar(30)

R5TRANSLINES_ARCHIVE

ATL_STOCKTAKEACTION

VARCHAR2(2)

nvarchar(2)

R5TRANSLINES_ARCHIVE

ATL_RECEIVEREQ

VARCHAR2(1)

nvarchar(1)

R5UCODES

UCO_IMAGE

VARCHAR2(30)

nvarchar(30)

R5USERS

USR_PWDRESETLINKGENTIME

DATE

datetime

R5USERS

USR_PWDRESETCOUNT

NUMBER(1,0)

numeric(1,0)

R5USERWIDGETCHART

UWC_FUNCTION

VARCHAR2(6)

nvarchar(6)

R5USERWIDGETCHART

UWC_DATASPYID

NUMBER(14,0)

numeric(24,0)

R5USERWIDGETCHART

UWC_TAB

VARCHAR2(6)

nvarchar(6)

R5USERWIDGETCHART

UWC_WIDTH

NUMBER(4,0)

numeric(4,0)

R5USERWIDGETCHART

UWC_HEIGHT

NUMBER(4,0)

numeric(4,0)

R5USERWIDGETCHART

UWC_COLOR

VARCHAR2(8)

nvarchar(8)

R5USERWIDGETCHART

UWC_SHAPE

VARCHAR2(1)

nvarchar(1)

R5USERWIDGETEQUIPMENTHEALTH

WEH_WIDGETID

VARCHAR2(30)

nvarchar(30)

R5USERWIDGETEQUIPMENTHEALTH

WEH_WIDGETTITLE

VARCHAR2(80)

nvarchar(80)

R5USERWIDGETEQUIPMENTHEALTH

WEH_CREATED

DATE

datetime

R5USERWIDGETEQUIPMENTHEALTH

WEH_CREATEDBY

VARCHAR2(255)

nvarchar(255)

R5USERWIDGETEQUIPMENTHEALTH

WEH_UPDATED

DATE

datetime

R5USERWIDGETEQUIPMENTHEALTH

WEH_UPDATEDBY

VARCHAR2(255)

nvarchar(255)

R5USERWIDGETEQUIPMENTHEALTH

WEH_UPDATECOUNT

NUMBER(38,0)

numeric(38,0)

R5USERWIDGETEQUIPMENTHEALTH

WEH_LASTSAVED

DATE

datetime

R5USERWIDGETEQUIPMENTSUMMARY

WES_WIDGETID

VARCHAR2(30)

nvarchar(30)

R5USERWIDGETEQUIPMENTSUMMARY

WES_FUNCTION

VARCHAR2(6)

nvarchar(6)

R5USERWIDGETEQUIPMENTSUMMARY

WES_DATASPYID

NUMBER(14,0)

numeric(14,0)

R5USERWIDGETEQUIPMENTSUMMARY

WES_WIDGETTITLE

VARCHAR2(80)

nvarchar(80)

R5USERWIDGETEQUIPMENTSUMMARY

WES_SHOWPROFILEIMAGE

VARCHAR2(1)

nvarchar(1)

R5USERWIDGETEQUIPMENTSUMMARY

WES_SHOWIMAGEURL

VARCHAR2(1)

nvarchar(1)

R5USERWIDGETEQUIPMENTSUMMARY

WES_CREATED

DATE

datetime

R5USERWIDGETEQUIPMENTSUMMARY

WES_CREATEDBY

VARCHAR2(255)

nvarchar(255)

R5USERWIDGETEQUIPMENTSUMMARY

WES_UPDATED

DATE

datetime

R5USERWIDGETEQUIPMENTSUMMARY

WES_UPDATEDBY

VARCHAR2(255)

nvarchar(255)

R5USERWIDGETEQUIPMENTSUMMARY

WES_UPDATECOUNT

NUMBER(38,0)

numeric(38,0)

R5USERWIDGETEQUIPMENTSUMMARY

WES_LASTSAVED

DATE

datetime

R5USERWIDGETNONCONFORMITY

UWN_WIDGETID

VARCHAR2(30)

nvarchar(30)

R5USERWIDGETNONCONFORMITY

UWN_FUNCTION

VARCHAR2(6)

nvarchar(6)

R5USERWIDGETNONCONFORMITY

UWN_DATASPYID

NUMBER(14,0)

numeric(14,0)

R5USERWIDGETNONCONFORMITY

UWN_WIDGETTITLE

VARCHAR2(80)

nvarchar(80)

R5USERWIDGETNONCONFORMITY

UWN_CREATED

DATE

datetime

R5USERWIDGETNONCONFORMITY

UWN_CREATEDBY

VARCHAR2(255)

nvarchar(255)

R5USERWIDGETNONCONFORMITY

UWN_UPDATED

DATE

datetime

R5USERWIDGETNONCONFORMITY

UWN_UPDATEDBY

VARCHAR2(255)

nvarchar(255)

R5USERWIDGETNONCONFORMITY

UWN_UPDATECOUNT

NUMBER(38,0)

numeric(38,0)

R5USERWIDGETNONCONFORMITY

UWN_LASTSAVED

DATE

datetime

R5USERWIDGETREPORT

UWR_WIDGETID

VARCHAR2(30)

nvarchar(30)

R5USERWIDGETREPORT

UWR_FUNCTION

VARCHAR2(6)

nvarchar(6)

R5USERWIDGETREPORT

UWR_WIDGETTITLE

VARCHAR2(80)

nvarchar(80)

R5USERWIDGETREPORT

UWR_CREATED

DATE

datetime

R5USERWIDGETREPORT

UWR_CREATEDBY

VARCHAR2(255)

nvarchar(255)

R5USERWIDGETREPORT

UWR_UPDATED

DATE

datetime

R5USERWIDGETREPORT

UWR_UPDATEDBY

VARCHAR2(255)

nvarchar(255)

R5USERWIDGETREPORT

UWR_UPDATECOUNT

NUMBER(38,0)

numeric(38,0)

R5USERWIDGETREPORT

UWR_LASTSAVED

DATE

datetime

TXALERTS

ALT_ENABLEWOPICKTICKET

VARCHAR2(1)

nvarchar(1)

TXCLONESTATS

CST_CLONE

VARCHAR2(6)

nvarchar(6)

TXCLONESTATS

CST_STAT

VARCHAR2(4000)

nvarchar(4000)

U5OCAD_SVG_SEC_CGRID

OC_CGR_SVG

VARCHAR2(1)

U5OCAD_SVG_SEC_CGRID

OC_CGR_BIM

VARCHAR2(1)

U5OCAD_SVG_SEC_CGRID

OC_CGR_DSH

VARCHAR2(1)

U5OCAD_SVG_SEC_CGRID

OC_CGR_REFSH

NUMBER(10,0)

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE01

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE02

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE03

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE04

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE05

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE06

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE07

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE08

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE09

CLOB

U5OCAD_SVG_SEC_CGRID

OC_CGR_RULE10

CLOB

U5OCAD_SVG_TB_SECURITY

TB_ENABLE_CTA

VARCHAR2(1)