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

HxGN EAM Release Notes for 2022

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

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

Table name

Column name

Oracle datatype

SQL Server datatype

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)

R5ALERTS

ALT_ENABLEWOPICKTICKET

VARCHAR2(1)

nvarchar(1)

R5CASEMANAGEMENT

CSM_DOWNTIMECOST

NUMBER(24,6)

numeric(24,6)

R5CASEMANAGEMENT

CSM_DOWNTIMEHRS

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)

R5ELECARCHIVE

ELA_FLD445

VARCHAR2(256)

nvarchar(256)

R5ELECARCHIVE_ARCHIVE

AEA_FLD445

VARCHAR2(256)

nvarchar(256)

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)

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)

R5OBJECTS

OBJ_SEGMENTVALUE

VARCHAR2(30)

nvarchar(30)

R5OBJLINEARREF

LRF_IMAGE

VARCHAR2(30)

nvarchar(30)

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)

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)