When a view is selected for inclusion in a Data Lake Schedule, the system requires a timestamp field be designated. However, a view is not an equivalent entity to a table. A view is a searchable object in a database defined by a query and may be comprised of data from multiple database tables. Some views comprised of multiple tables have a primary table (e.g. R5PROPERTYVALUES is the main table driving the data content for the view R5PROPERTIESOBJ) while other views have multiple main selects combined with UNIONs, but each are only using one table in each of the main selects.
The below table details all EAM views, specifying the main table name as well as the xxx_lastsaved column name.
If the Main Table Name has ‘Restricted’ notated, the view is restricted from selection and is referenced in table r5datalaketablesnotallowed. The ‘phrase’ after the comma indicates the reason for restriction. The ‘*’ after the Main Table Name indicates the actual view statement uses multiple tables. If there are multiple tables listed, it means the view statement is using UNION(s). In this case, there will also be multiple values for Column Name. If on the same line multiple columns are listed, the first indicates the name of the column used, the second is the name of the column used in the view. So, ‘obj_lastsaved cat_lastsaved' means column obj_lastsaved is being selected from r5objects, but view r5categories references it as cat_lastsaved
View Name |
Main Table Name |
Column Name |
---|---|---|
R5ACTORL |
r5activities * r5orderlines * |
act_lastsaved orl_lastsaved |
R5ACTSCHEDULESVIEW |
r5actschedules |
acs_lastsaved |
R5ADDETAILSRPTVW |
r5addetails |
add_lastsaved |
R5ADDETAILSVW |
r5addetails |
add_lastsaved |
R5ADDVIEW |
r5addetails |
add_lastsaved |
R5APPHIST |
r5entapplists * |
eal_lastsaved |
R5ASSETS |
r5objects |
ass_lastsaved |
R5ATTRIBLOVS |
r5addproperties * |
alv_lastsaved |
R5AUDITABLES |
Restricted, has distinct |
|
R5AUDVALUESVW |
r5audvalues |
ava_lastsaved |
R5BACKLOG |
r5events * |
evt_lastsaved |
R5BOILERTEXTSVW |
r5boilertexts |
bot_lastsaved |
R5BOOKEDHOURSX |
Restricted, has distinct |
|
R5BRTMPRVW |
r5elecarchive |
ela_lastsaved |
R5BUDGETDETAILITEMS |
r5budgetdetails * |
bdti_lastsaved |
R5CATEGORIES |
r5objects |
obj_lastsaved cat_lastsaved |
R5CHARGEDEFSEQUENCES |
Restricted, internal |
|
R5CHILDINSTOCKCOND |
Restricted, has sum |
|
R5CHILDINSTORECHILDREN |
Restricted, has count |
|
R5CHILDINTST |
Restricted, has sum |
|
R5CHILDJOBREPAIRS |
Restricted, has sum |
|
R5CHILDONORDER |
Restricted, has sum |
|
R5CHILDONORDER2 |
Restricted, has sum |
|
R5CHILDONREQUI |
Restricted, has sum |
|
R5CHILDONREQUI2 |
Restricted, has sum |
|
R5CHILDRESERVED |
Restricted, has sum |
|
R5CHILDSTOCK |
Restricted, has sum |
|
R5CLOCODECLASSES |
r5actclasses r5reqclasses r5failureclasses r5causeclasses |
acl_lastsaved coc_lastsaved rcl_lastsaved fal_lastsaved cau_lastsaved |
R5CLOCODES |
r5actioncodes r5requircodes r5failures r5causes |
acc_lastsaved clc_lastsaved rqm_lastsaved fca_lastsaved cac_lastsaved |
R5COMMENTS |
r5addetails * |
add_lastsaved |
R5CUSTATTRIBS |
r5addproperties |
apr_lastsaved pro_lastsaved |
R5DEFPARTSUMMARYVW |
r5deferredact * |
dfa_lastsaved dps_lastsaved |
R5DESCRIPTIONSVW |
r5descriptions |
des_lastsaved |
R5DEVCATEGORIES |
r5devices |
dev_lastsaved |
R5DUALCONVERSION |
Restricted, old |
|
R5DUEPERCENTAGE |
Restricted, has count |
|
R5DWACTUALCOMPDATES |
r5dwdates |
zdt_lastsaved zvf_lastsaved |
R5DWACTUALSTARTDATES |
r5dwdates |
zdt_lastsaved zve_lastsaved |
R5DWAPPROVEDDATES |
r5dwdates |
zdt_lastsaved zvj_lastsaved |
R5DWCREATEDDATES |
r5dwdates |
zdt_lastsaved zva_lastsaved |
R5DWDATAMARTSVIEW |
r5dwdatamarts * |
dmt_lastsaved |
R5DWDIMENSIONFIELDSVIEW |
r5dwdimensionfields * |
dmf_lastsaved |
R5DWDIMENSIONSVIEW |
r5dwdimensions * |
dim_lastsaved |
R5DWDUEDATES |
r5dwdates |
zdt_lastsaved zvk_lastsaved |
R5DWENDDATES |
r5dwdates |
zdt_lastsaved zvs_lastsaved |
R5DWFACTFIELDSVIEW * |
r5dwfactfields |
ffl_lastsaved |
R5DWFILEDDATES |
r5dwdates |
zdt_lastsaved zvh_lastsaved |
R5DWFROMSTATUSES |
r5dwstatuses |
zst_lastsaved zvu_lastsaved |
R5DWFROMSTORES |
r5dwstores |
zso_lastsaved zvl_lastsaved |
R5DWFROMSUPPLIERS |
r5dwsuppliers |
zsu_lastsaved zvn_lastsaved |
R5DWFROMWORKORDERS |
r5dwworkorders |
zwo_lastsaved zvp_lastsaved |
R5DWOBJECTROLLUPDAILYSNAP |
Restricted, has sum |
|
R5DWRECEIVEDDATES |
r5dwdates |
zdt_lastsaved zvw_lastsaved |
R5DWREPORTEDDATES |
r5dwdates |
zdt_lastsaved zvg_lastsaved |
R5DWREQUESTDATES |
r5dwdates |
zdt_lastsaved zvb_lastsaved |
R5DWRESOLVEDDATES |
r5dwdates |
zdt_lastsaved zvi_lastsaved |
R5DWSCHEDCOMPDATES |
r5dwdates |
zdt_lastsaved zvd_lastsaved |
R5DWSCHEDSTARTDATES |
r5dwdates |
zdt_lastsaved zvc_lastsaved |
R5DWSTARTDATES |
r5dwdates |
zdt_lastsaved zvr_lastsaved |
R5DWTOSTATUSES |
r5dwstatuses |
zst_lastsaved zvv_lastsaved |
R5DWTOSTORES |
r5dwstores |
zso_lastsaved zvm_lastsaved |
R5DWTOSUPPLIERS |
r5dwsuppliers |
zsu_lastsaved zvo_lastsaved |
R5DWTOWORKORDERS |
r5dwworkorders |
zwo_lastsaved zvq_lastsaved |
R5ELAVIEW |
r5elecarchive |
ela_lastsaved |
R5ERRORTEXT |
r5errtexts, r5errsource |
GREATEST( ert_lastsaved, res_lastsaved ) etv_lastsaved |
R5EVENTCODES |
r5actioncodes r5requircodes r5failures r5causes |
acc_lastsaved evc_lastsaved rqm_lastsaved fca_lastsaved cac_lastsaved |
R5EVTACT |
Restricted, performance (r5events, r5activities) |
|
R5EVTCOST |
r5events * |
evt_lastsaved ec_lastsaved |
R5EXTINVLHOW |
Restricted, old |
|
R5FUELTRANSACTIONS |
r5fuelissues * r5fuelreceipts * r5fuelinventoryadjustments * |
fli_lastsaved ftr_lastsaved flr_lastsaved fia_lastsaved |
R5GLREFCTRLVIEW |
r5glreferences * |
glf_lastsaved |
R5IESMENUSEARCH |
r5extmenus * |
emn_lastsaved ims_lastsaved |
R5IMPORTPOLINESVW |
r5orderlines * |
orl_lastsaved |
R5INSTALLVW |
r5install |
ins_lastsaved |
R5INSTOCKCOND |
Restricted, has sum |
|
R5INSTOCKCONDEXCLCHILDSTR |
Restricted, has sum |
|
R5INSTORECHILDREN |
Restricted, has count |
|
R5INSTOREREPCHILDREN |
Restricted, has count |
|
R5INTST |
Restricted, has sum |
|
R5INVALLOC |
r5invoiceallocations * |
ina_lastsaved |
R5INVLINESVIEW |
r5invoicelines * |
ivl_lastsaved |
R5IPBATCHITEMASSOC |
r5parts * |
par_lastsaved |
R5IPCANCELORDERLINES |
r5orderlines * |
orl_lastsaved |
R5IPCOMPANIESPRICEUPDATES |
r5catalogue * |
cat_lastsaved |
R5IPORDERLINEAVAIL |
r5orderlines * |
orl_lastsaved |
R5IPORDERLINES |
r5orderlines * |
orl_lastsaved |
R5IPORDERLINESEWS |
r5orderlines * |
orl_lastsaved |
R5IPORDERPRICEUPDATES |
r5orderlines * |
orl_lastsaved |
R5IPORDERS |
r5orders * |
ord_lastsaved |
R5IPORDERSEWS |
r5orders * |
ord_lastsaved |
R5IPPARTSPRICEUPDATES |
r5catalogue * |
cat_lastsaved |
R5IPREQLINEAVAIL |
r5requislines * |
rql_lastsaved |
R5IPREQUISITIONPRICEUPDATES |
r5requisitions * |
req_lastsaved |
R5IPRETURNITEMS |
r5translines * |
trl_lastsaved |
R5IPVENDORSVW |
r5ipvendors |
ipv_lastsaved vendorlastsaved |
R5ISSMAT |
Restricted, has UNION |
|
R5JOBACT |
r5events * |
evt_lastsaved jba_lastsaved |
R5JOBACTS |
r5events * |
evt_lastsaved |
R5JOBREPAIRS |
Restricted, has sum |
|
R5LABCOST |
Restricted, has sum |
|
R5LEVEL1 |
r5objects |
obj_lastsaved lvl_lastsaved |
R5LEVEL2 |
r5objects * |
obj_lastsaved lvl_lastsaved |
R5LEVEL3 |
r5objects * |
obj_lastsaved lvl_lastsaved |
R5LEVEL3A |
r5objects * |
obj_lastsaved lvl_lastsaved |
R5LEVEL4 |
r5objects * |
obj_lastsaved lvl_lastsaved |
R5LOADAVAIL |
Restricted, old |
|
R5LOCATIONS |
r5objects |
obj_lastsaved loc_lastsaved |
R5MATCOST |
Restricted, has sum |
|
R5MATRETURN |
Restricted, has sum |
|
R5MISCCOSTS |
r5translines r5bookedhours r5toolusage |
trl_lastsaved mis_lastsaved boo_lastsaved tou_lastsaved |
R5MISCCOSTS_ARCHIVE |
r5translines_archive r5bookedhours_archive r5toolusage_archive |
atl_lastsaved mis_lastsaved abk_lastsaved |
R5MOBILEQUERIESVIEW |
r5mobilequeries r5grid |
mqr_lastsaved grd_lastsaved |
R5MP2JBPR |
Restricted, old |
|
R5MP2OBCR |
Restricted, old |
|
R5MPRESOURCES |
r5mptool r5mppersonnel r5mpequipment r5mptrade r5mpsupplier |
mto_lastsaved msr_lastsaved mpp_lastsaved meq_lastsaved mtd_lastsaved msp_lastsaved |
R5MPRESOURCESEWS |
r5mptool r5mppersonnel r5mpequipment r5mptrade r5mpsupplier |
mto_lastsaved msw_lastsaved mpp_lastsaved meq_lastsaved mtd_lastsaved msp_lastsaved |
R5MPTASKS |
r5mpevents r5mpactivities * |
mpe_lastsaved mtk_lastsaved mpa_lastsaved |
R5MULTIORGPARTLIST |
r5partprices * r5parts * |
ppr_lastsaved par_lastsaved |
R5NCOBS |
r5nonconformities r5nonconformobservations * |
ncf_lastsaved nco_lastsaved |
R5OBHIST |
r5events * |
evt_lastsaved |
R5OBJCATASPECTS |
r5objectaspects |
oba_lastsaved |
R5OBJEVTTESTPOINTS |
r5evttestpoints r5objtestpoints * |
etp_lastsaved otp_lastsaved |
R5OBJOBS |
r5events * |
evt_lastsaved oj_lastsaved |
R5OBJYEARUNITS |
r5objunits * |
obu_lastsaved |
R5ODTMVAL |
Remove from list, uses dual |
|
R5ODTSVAL |
Remove from list, uses dual |
|
R5OGCMVAL |
Remove from list, uses dual |
|
R5OGCSVAL |
Remove from list, uses dual |
|
R5OGTMVAL |
Remove from list, uses dual |
|
R5OGTSVAL |
Remove from list, uses dual |
|
R5ONJOBLINES |
Remove from list, has sum |
|
R5ONORDER |
Remove from list, has sum |
|
R5ONORDER2 |
Remove from list, has sum |
|
R5ONORDER_DETAILS |
r5orderlines * r5requislines * |
orl_lastsaved onod_lastsaved rql_lastsaved |
R5ONREPREQ |
Remove from list, has sum |
|
R5ONREQUI |
Remove from list, has sum |
|
R5ONREQUI2 |
Remove from list, has sum |
|
R5OPDATATBL |
r5opvardata |
odt_lastsaved |
R5OPDBMSDATE |
Restricted, uses dual |
|
R5OPGRAPHCORRKEYS |
r5opgraphcorr |
ogc_lastsaved |
R5OPGRAPHTSKEYS |
Restricted, uses max |
|
R5OPPUBCORRFILES |
r5opfiles * |
ogf_lastsaved ocf_lastsaved |
R5OPPUBLICDATATBL |
r5opvardata * |
odt_lastsaved opd_lastsaved |
R5OPPUBLICLIMITS |
r5oplimits * |
opl_lastsaved pvl_lastsaved |
R5OPPUBLICVAREQ |
Restricted, uses view |
|
R5OPPUBTSFILES |
r5opfiles * |
otf_lastsaved |
R5OPSELECTVAR |
Restricted, uses view |
|
R5OPVARDESC |
r5opvariables |
ovd_lastsaved |
R5OPVARDESCKEYS |
Restricted, uses max |
|
R5ORDCLAUSES_REVISIONS |
r5ordclauses * r5ordclauserevs |
orc_lastsaved ocr_lastsaved |
R5ORDERLINESDESC |
r5orderlines * |
orl_lastsaved |
R5ORDERLINES_REVISIONS |
r5orderlines * r5orlrevisions |
orl_lastsaved olr_lastsaved |
R5ORDERS_REVISIONS |
r5orders r5ordrevisions |
ord_lastsaved orr_lastsaved |
R5ORDREALLOC |
Restricted, has sum |
|
R5OUTSTANDINGISSUES |
Restricted, has sum |
|
R5OUTSTANDINGTOOLISSUES |
Restricted, has sum |
|
R5OVDMVAL |
Restricted, uses dual |
|
R5OVDSVAL |
Restricted, uses dual |
|
R5PARTISSUED |
Restricted, has sum |
|
R5PARTOBJECTS |
r5entityparts * |
epa_lastsaved pao_lastsaved |
R5PARTORDERED |
Restricted, has sum |
|
R5PARTSUPPRETN |
Restricted, has sum |
|
R5PARTTRANSACTED |
Restricted, has sum |
|
R5PARTUSAGE |
Restricted, has sum |
|
R5PERQUALIFICATIONS |
r5tradequalifications * r5taskqualifications * |
trq_lastsaved pqu_lastsaved tqu_lastsaved |
R5PICKLISTANDPARTS |
r5picklistparts * |
pip_lastsaved |
R5PLNRESTRN |
Restricted, old |
|
R5PLNTRN |
r5translines * r5activities * |
trl_lastsaved act_lastsaved |
R5POCALCFIELDVALUES |
Restricted, has sum |
|
R5PPMPLANOBJECTS |
Restricted, has group by |
|
R5PPMWINDOWS |
r5events * |
evt_lastsaved ppw_lastsaved |
R5PROMPTLOVS |
Restricted, has distinct |
|
R5PROPERTIESEVT |
r5propertyvalues * |
prv_lastsaved |
R5PROPERTIESOBJ |
r5propertyvalues * |
prv_lastsaved |
R5PROPERTIESVIEW |
Restricted, old |
|
R5QUOTLIN2 |
Restricted, old |
|
R5REPORLCOL |
Restricted, uses view |
|
R5REPUOGVW |
Restricted, old |
|
R5REQSFORJOB |
r5requislines * |
rql_lastsaved rfj_lastsaved |
R5REQSFORORDER |
r5requislines * |
rql_lastsaved rfo_lastsaved |
R5RESERVED |
Restricted, has sum |
|
R5SELECTTEXT |
Restricted, has distinct |
|
R5SHFDAYS_VIEW |
Restricted, has sum |
|
R5SRLOWLVW |
r5stock |
sto_lastsaved |
R5SRPICKVW |
r5picklists |
pic_lastsaved |
R5STLOWLVW |
r5stock |
sto_lastsaved |
R5STOCKFORPARTS |
r5binstock * r5objects * |
bis_lastsaved obj_lastsaved |
R5STOCKISSUED |
Restricted, has sum |
|
R5SUMUSG |
Restricted, has max |
|
R5TEMPREPXFEREVT |
Restricted, temp |
|
R5TEMPREPXFERORD |
Restricted, temp |
|
R5TEMPREPXFERREQ |
Restricted, temp |
|
R5TEMPWORKLOADAVAILABILITY |
Restricted, temp |
|
R5TESTPOINTS |
r5evttestpoints * |
etp_lastsaved |
R5TLSVIEW_1 |
Restricted, temp |
|
R5TLSVIEW_2 |
Restricted, temp |
|
R5TLSVIEW_3 |
Restricted, temp |
|
R5TOOLCOST |
Restricted, has sum |
|
R5TOOLSUSED |
Restricted, has sum |
|
R5TRANRES |
Restricted, has sum |
|
R5USER_JOBS |
Restricted, uses system table |
|
R5VBOOKEDHOURS |
r5bookedhours * |
boo_lastsaved vbo_lastsaved |
R5VFLEETBILLLINES |
r5fleetbilllines |
fbl_lastsaved |
R5VFLEETBILLSUBLINES |
r5fleetbillsublines * |
fbs_lastsaved vbs_lastsaved |
R5VFLEETTICKETEXCEPTIONS |
r5fleetticketexceptions * |
fte_lastsaved vte_lastsaved |
R5VIOLATIONSVW |
r5violations |
vio_lastsaved |
R5VTRANSLINES |
r5translines * |
trl_lastsaved vtr_lastsaved |
R5WARRANTIES |
r5warcoverages * |
wcv_lastsaved |
R5WORKORDERPARTSUMMARY |
Restricted, old |
|
R5WSMESSAGESTATUSVW |
r5wsmessagestatus |
wss_lastsaved |