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) |