Visão geral
Este comando listará os dados de uma atividade de manutenção.
Tabelas relacionadas
TABELA
|
Descrição
|
Chave primária (PK)
|
Tabelas de ligação
|
GNACTIVITY
|
Cadastro de atividades
|
CDGENACTIVITY
|
ADALLUSERS
ADDEPARTMENT
ADMAILTASKREL
ADPOSITION
ADROLE
ADTEAM
ADUSEREXTERNALDATA
GNACTIVITYTIMECFG
GNAPPROV
GNASSOC
GNCALENDAR
GNCHECKLISTANSWER
GNCOSTCONFIG
GNEVALRESULTUSED
GNEVALREVISION
GNFAVORITE
GNOBJECTASSOCGROUP
GNTYPEROLE
SERICHTEXT
|
GNCOSTCONFIG
|
Armazena os custos da atividade
|
CDCOSTCONFIG
|
|
ASEXECACTIVITY
|
Cadastro de execução de atividades
|
CDEXECACTIVITY
|
ADDOCUMENT
ASACTIVITY
ASPLANACTIVITY
ASSERVICECENTER
ASSERVICECENTERTEC
DCDOCREVISION
GNACTIVITY
GNFAVORITE
GNRESOURCE
GNTOOLSANALISYS
MAMAINTTYPE
|
ASACTIVITY
|
Cadastro de atividades modelo
|
CDACTIVITY
|
ADAPPROVALROUTE
ADCHECKLIST
ADDOCUMENT
ADTEAM
ASACTIVMODELTYPE
ASSERVICECENTER
ASSERVICECENTERTEC
CACONFIGURATION
GNACTIVITYTIMECFG
GNCOSTCONFIG
GNEVALRESULTUSED
GNEVALREVISION
GNMASK
GNRESOURCE
MAMAINTTYPE
SERICHTEXT
|
ADTEAM
|
Cadastro de equipe
|
CDTEAM
|
ADAUTHLDAPCONFIG
GNMAPPING
GNPERMISSION
|
ADALLUSERS
|
Cadastro de usuário
|
CDUSER
|
ADALLUSERS
ADUSEREXTERNALDATA
GNFAVORITE
|
SERICHTEXT
|
Dados do rich text do sistema
|
OID
|
SETEXT
|
GNEVALRESULTUSED
|
Resultado das avaliações realizadas
|
CDEVALRESULTUSED
|
GNEVALRESULT
|
GNEVALRESULT
|
Resultados do método de avaliação
|
CDEVALRESULT
|
GNEVALREVISION
|
ASPLANACTIVITY
|
Cadastro de plano de atividades
|
CDPLANACTIVITY
|
ADMAILTASKREL
ADTEAM
ASACTIVITY
GNCALENDAR
GNEVALRESULTUSED
GNEVALREVISION
MAROUTE
|
ASSERVICECENTER
|
Cadastro de centro de serviço
|
CDSERVICECENTER
|
GNCALENDAR
|
GNRESOURCE
|
Cadastro de recursos
|
CDRESOURCE
|
ADALLUSERS
ADCOMPANY
GNASSOC
GNCALENDAR
GNRESOURCETYPE
OBOBJECTGROUP
|
GNAPPROV
|
Cadastro de aprovação
|
CDPROD
CDAPPROV
|
ADAPPROVALROUTE
|
ADAPPROVALROUTE
|
Cadastro de roteiro responsável
|
CDAPPROVALROUTE
|
|
MAMAINTTYPE
|
Cadastro de tipo de manutenção
|
CDMAINTTYPE
|
|
GNEVAL
|
Cadastro de métodos de avaliação
|
CDEVAL
|
|
Oracle
SELECT
GNACT.IDACTIVITY,
ASPLANACT.IDPLANACTIVITY || ' - ' || ASPLANACT.NMPLANACTIVITY NMPLANAC-TIVITY,
ASACTMODEL.IDACTIVITY || ' - ' || ASACTMODEL.NMACTIVITY NMACTIVITYMODEL,
GNACT.DTSTARTPLAN,
GNACT.QTTIMESTARTPLAN,
GNACT.DTFINISHPLAN,
GNACT.QTTIMEFINISHPLAN,
SEF_QT_WK_DAYS_PERIOD(GNACT.DTSTARTPLAN, GNACT.DTFINISHPLAN, GNACT.CDCALENDAR) AS QTDURATIONPLAN,
GNCOSTCFG.MNCOSTPROG,
TEAMPROG.IDTEAM || ' - ' || TEAMPROG.NMTEAM NMPROGTEAM,
GNACT.DTSTART,
GNACT.QTTIMESTART,
GNACT.DTFINISH,
GNACT.QTTIMEFINISH,
SEF_QT_WK_DAYS_PERIOD(GNACT.DTSTART, GNACT.DTFINISH, GNACT.CDCALENDAR) AS QTDURATIONREAL,
GNACT.VLPERCENTAGEM,
GNCOSTCFG.MNCOSTREAL,
TEAMEXEC.IDTEAM || ' - ' || TEAMEXEC.NMTEAM NMEXCECTEAM,
USREXEC.IDUSER || ' - ' || USREXEC.NMUSER NMEXECUTOR,
GNACT.FGEXECUTERLOCK,
ASSRVCENT_EXEC.IDCOMMERCIAL || ' - ' || ASSRVCENT_EXEC.NMCOMPANY NMSER-VICECENTER,
GNRV.IDRESOURCE || ' - ' || GNRV.NMRESOURCE NMRESOURCERESPEXEC,
DESCTXT.TXDATA TXDESC,
GNEVAL.IDEVAL || ' - ' || GNEVAL.NMEVAL NMEVALMETHOD,
GNRESLT.NMEVALRESULT,
MAMNTYPE.IDMAINTTYPE || ' - ' || MAMNTYPE.NMMAINTTYPE NMMAINTTYPE,
CASE
WHEN ASEXECACT.FGUSEISODOC = 1 THEN (SELECT IDDOCUMENT || ' - ' || NMTITLE FROM DCDOCREVISION WHERE CDDOCUMENT = ASEXECACT.CDDOCISODOC AND CDREVI-SION = ASEXECACT.CDREVDOCISODOC)
ELSE (SELECT IDDOC || ' - ' || NMDOC FROM ADDOCUMENT WHERE CDDOC = ASEXECACT.CDDOCUMENT)
END NMPROCEDURE,
ASEXECACT.NMLOCAL,
ADAPPRVROUT_PROG.IDAPPROVALROUTE || ' - ' || ADAP-PRVROUT_PROG.NMAPPROVALROUTE NMAPPPROG,
ADAPPRVROUT_EXEC.IDAPPROVALROUTE || ' - ' || ADAP-PRVROUT_EXEC.NMAPPROVALROUTE NMAPPEXEC,
ACTTKNTXT.TXDATA TXACTTAKEN
FROM GNACTIVITY GNACT
LEFT JOIN GNCOSTCONFIG GNCOSTCFG ON ( GNCOSTCFG.CDCOSTCONFIG = GNACT.CDCOSTCONFIG )
INNER JOIN ASEXECACTIVITY ASEXECACT ON ( ASEXECACT.CDGENACTIVITY = GNACT.CDGENACTIVITY )
INNER JOIN ASACTIVITY ASACT ON ( ASACT.CDACTIVITY = ASEXECACT.CDACTIVITY )
LEFT JOIN ADTEAM TEAMPROG ON ( TEAMPROG.CDTEAM = ASACT.CDPLANTEAM )
LEFT JOIN ADTEAM TEAMEXEC ON ( TEAMEXEC.CDTEAM = ASACT.CDTEAM )
LEFT JOIN ADALLUSERS USREXEC ON ( USREXEC.CDUSER = GNACT.CDUSER )
LEFT JOIN SERICHTEXT DESCRICHTEXT ON ( DESCRICHTEXT.OID = GNACT.OIDDESCRIPTION )
LEFT JOIN SETEXT DESCTXT ON ( DESCTXT.OID = DESCRICHTEXT.OIDHTMLCONTENT )
LEFT JOIN SERICHTEXT ACTTKNRICHTEXT ON ( ACTTKNRICHTEXT.OID = GNACT.OIDACTIONTAKEN )
LEFT JOIN SETEXT ACTTKNTXT ON ( ACTTKNTXT.OID = ACTTKN-RICHTEXT.OIDHTMLCONTENT )
LEFT JOIN GNEVALRESULTUSED GNRESLTUSD ON ( GNRESLTUSD.CDEVALRESULTUSED = GNACT.CDEVALRSLTPRIORITY )
LEFT JOIN GNEVALRESULT GNRESLT ON ( GNRESLT.CDEVALRESULT = GNRESL-TUSD.CDEVALRESULT )
LEFT JOIN ASACTIVITY ASACTMODEL ON ( ASACTMODEL.CDACTIVITY = ASEXE-CACT.CDORIGINACTIVMODEL )
LEFT JOIN ASPLANACTIVITY ASPLANACT ON ( ASPLANACT.CDPLANACTIVITY = ASE-XECACT.CDPLANNING )
LEFT JOIN ASSERVICECENTER ASSRVCENT_EXEC ON ( ASS-RVCENT_EXEC.CDSERVICECENTER = ASEXECACT.CDSERVICECENTERE )
LEFT JOIN GNRESOURCE GNRV ON ( GNRV.CDRESOURCE = ASEXE-CACT.CDRESOURCERESP )
LEFT JOIN GNAPPROV GNAPPRV_PROG ON ( GNAPPRV_PROG.CDAPPROV = GNACT.CDPLANROUTE AND GNAPPRV_PROG.CDPROD = GNACT.CDPLANPRODROUTE )
LEFT JOIN ADAPPROVALROUTE ADAPPRVROUT_PROG ON ( ADAP-PRVROUT_PROG.CDAPPROVALROUTE = GNAPPRV_PROG.CDAPPROVALROUTE )
LEFT JOIN GNAPPROV GNAPPRV_EXEC ON ( GNAPPRV_EXEC.CDAPPROV = GNACT.CDEXECROUTE AND GNAPPRV_EXEC.CDPROD = GNACT.CDPRODROUTE )
LEFT JOIN ADAPPROVALROUTE ADAPPRVROUT_EXEC ON ( ADAP-PRVROUT_EXEC.CDAPPROVALROUTE = GNAPPRV_EXEC.CDAPPROVALROUTE )
LEFT JOIN MAMAINTTYPE MAMNTYPE ON ( MAMNTYPE.CDMAINTTYPE = ASEXE-CACT.CDACTIVCLASS )
LEFT JOIN GNEVAL GNEVAL ON ( GNACT.CDEVAL = GNEVAL.CDEVAL )
WHERE (
GNACT.IDACTIVITY = 'IDENTIFICADOR_DA_MANUTENÇÃO' /*OBS 1*/
)
|
Postgres
SELECT
GNACT.IDACTIVITY,
ASPLANACT.IDPLANACTIVITY || ' - ' || ASPLANACT.NMPLANACTIVITY NMPLANAC-TIVITY,
ASACTMODEL.IDACTIVITY || ' - ' || ASACTMODEL.NMACTIVITY NMACTIVITYMODEL,
GNACT.DTSTARTPLAN,
GNACT.QTTIMESTARTPLAN,
GNACT.DTFINISHPLAN,
GNACT.QTTIMEFINISHPLAN,
SEF_QT_WK_DAYS_PERIOD(GNACT.DTSTARTPLAN, GNACT.DTFINISHPLAN, GNACT.CDCALENDAR) AS QTDURATIONPLAN,
GNCOSTCFG.MNCOSTPROG,
TEAMPROG.IDTEAM || ' - ' || TEAMPROG.NMTEAM NMPROGTEAM,
GNACT.DTSTART,
GNACT.QTTIMESTART,
GNACT.DTFINISH,
GNACT.QTTIMEFINISH,
SEF_QT_WK_DAYS_PERIOD(GNACT.DTSTART, GNACT.DTFINISH, GNACT.CDCALENDAR) AS QTDURATIONREAL,
GNACT.VLPERCENTAGEM,
GNCOSTCFG.MNCOSTREAL,
TEAMEXEC.IDTEAM || ' - ' || TEAMEXEC.NMTEAM NMEXCECTEAM,
USREXEC.IDUSER || ' - ' || USREXEC.NMUSER NMEXECUTOR,
GNACT.FGEXECUTERLOCK,
ASSRVCENT_EXEC.IDCOMMERCIAL || ' - ' || ASSRVCENT_EXEC.NMCOMPANY NMSER-VICECENTER,
GNRV.IDRESOURCE || ' - ' || GNRV.NMRESOURCE NMRESOURCERESPEXEC,
DESCTXT.TXDATA TXDESC,
GNEVAL.IDEVAL || ' - ' || GNEVAL.NMEVAL NMEVALMETHOD,
GNRESLT.NMEVALRESULT,
MAMNTYPE.IDMAINTTYPE || ' - ' || MAMNTYPE.NMMAINTTYPE NMMAINTTYPE,
CASE
WHEN ASEXECACT.FGUSEISODOC = 1 THEN (SELECT IDDOCUMENT || ' - ' || NMTITLE FROM DCDOCREVISION WHERE CDDOCUMENT = ASEXECACT.CDDOCISODOC AND CDREVI-SION = ASEXECACT.CDREVDOCISODOC)
ELSE (SELECT IDDOC || ' - ' || NMDOC FROM ADDOCUMENT WHERE CDDOC = ASEXECACT.CDDOCUMENT)
END NMPROCEDURE,
ASEXECACT.NMLOCAL,
ADAPPRVROUT_PROG.IDAPPROVALROUTE || ' - ' || ADAP-PRVROUT_PROG.NMAPPROVALROUTE NMAPPPROG,
ADAPPRVROUT_EXEC.IDAPPROVALROUTE || ' - ' || ADAP-PRVROUT_EXEC.NMAPPROVALROUTE NMAPPEXEC,
ACTTKNTXT.TXDATA TXACTTAKEN
FROM GNACTIVITY GNACT
LEFT JOIN GNCOSTCONFIG GNCOSTCFG ON ( GNCOSTCFG.CDCOSTCONFIG = GNACT.CDCOSTCONFIG )
INNER JOIN ASEXECACTIVITY ASEXECACT ON ( ASEXECACT.CDGENACTIVITY = GNACT.CDGENACTIVITY )
INNER JOIN ASACTIVITY ASACT ON ( ASACT.CDACTIVITY = ASEXECACT.CDACTIVITY )
LEFT JOIN ADTEAM TEAMPROG ON ( TEAMPROG.CDTEAM = ASACT.CDPLANTEAM )
LEFT JOIN ADTEAM TEAMEXEC ON ( TEAMEXEC.CDTEAM = ASACT.CDTEAM )
LEFT JOIN ADALLUSERS USREXEC ON ( USREXEC.CDUSER = GNACT.CDUSER )
LEFT JOIN SERICHTEXT DESCRICHTEXT ON ( DESCRICHTEXT.OID = GNACT.OIDDESCRIPTION )
LEFT JOIN SETEXT DESCTXT ON ( DESCTXT.OID = DESCRICHTEXT.OIDHTMLCONTENT )
LEFT JOIN SERICHTEXT ACTTKNRICHTEXT ON ( ACTTKNRICHTEXT.OID = GNACT.OIDACTIONTAKEN )
LEFT JOIN SETEXT ACTTKNTXT ON ( ACTTKNTXT.OID = ACTTKN-RICHTEXT.OIDHTMLCONTENT )
LEFT JOIN GNEVALRESULTUSED GNRESLTUSD ON ( GNRESLTUSD.CDEVALRESULTUSED = GNACT.CDEVALRSLTPRIORITY )
LEFT JOIN GNEVALRESULT GNRESLT ON ( GNRESLT.CDEVALRESULT = GNRESL-TUSD.CDEVALRESULT )
LEFT JOIN ASACTIVITY ASACTMODEL ON ( ASACTMODEL.CDACTIVITY = ASEXE-CACT.CDORIGINACTIVMODEL )
LEFT JOIN ASPLANACTIVITY ASPLANACT ON ( ASPLANACT.CDPLANACTIVITY = ASE-XECACT.CDPLANNING )
LEFT JOIN ASSERVICECENTER ASSRVCENT_EXEC ON ( ASS-RVCENT_EXEC.CDSERVICECENTER = ASEXECACT.CDSERVICECENTERE )
LEFT JOIN GNRESOURCE GNRV ON ( GNRV.CDRESOURCE = ASEXE-CACT.CDRESOURCERESP )
LEFT JOIN GNAPPROV GNAPPRV_PROG ON ( GNAPPRV_PROG.CDAPPROV = GNACT.CDPLANROUTE AND GNAPPRV_PROG.CDPROD = GNACT.CDPLANPRODROUTE )
LEFT JOIN ADAPPROVALROUTE ADAPPRVROUT_PROG ON ( ADAP-PRVROUT_PROG.CDAPPROVALROUTE = GNAPPRV_PROG.CDAPPROVALROUTE )
LEFT JOIN GNAPPROV GNAPPRV_EXEC ON ( GNAPPRV_EXEC.CDAPPROV = GNACT.CDEXECROUTE AND GNAPPRV_EXEC.CDPROD = GNACT.CDPRODROUTE )
LEFT JOIN ADAPPROVALROUTE ADAPPRVROUT_EXEC ON ( ADAP-PRVROUT_EXEC.CDAPPROVALROUTE = GNAPPRV_EXEC.CDAPPROVALROUTE )
LEFT JOIN MAMAINTTYPE MAMNTYPE ON ( MAMNTYPE.CDMAINTTYPE = ASEXE-CACT.CDACTIVCLASS )
LEFT JOIN GNEVAL GNEVAL ON ( GNACT.CDEVAL = GNEVAL.CDEVAL )
WHERE (
GNACT.IDACTIVITY = 'IDENTIFICADOR_DA_MANUTENÇÃO' /*OBS 1*/
)
|
SQL Server
SELECT
GNACT.IDACTIVITY,
ASPLANACT.IDPLANACTIVITY + ' - ' + ASPLANACT.NMPLANACTIVITY NMPLANACTIVITY,
ASACTMODEL.IDACTIVITY + ' - ' + ASACTMODEL.NMACTIVITY NMACTIVITYMODEL,
GNACT.DTSTARTPLAN,
GNACT.QTTIMESTARTPLAN,
GNACT.DTFINISHPLAN,
GNACT.QTTIMEFINISHPLAN,
dbo.SEF_QT_WK_DAYS_PERIOD(CONVERT(DATETIME,GNACT.DTSTARTPLAN), CONVERT(DATETIME,GNACT.DTFINISHPLAN), GNACT.CDCALENDAR) AS QTDURATIONPLAN,
GNCOSTCFG.MNCOSTPROG,
TEAMPROG.IDTEAM + ' - ' + TEAMPROG.NMTEAM NMPROGTEAM,
GNACT.DTSTART,
GNACT.QTTIMESTART,
GNACT.DTFINISH,
GNACT.QTTIMEFINISH,
dbo.SEF_QT_WK_DAYS_PERIOD(CONVERT(DATETIME,GNACT.DTSTART), CONVERT(DATETIME,GNACT.DTFINISH), GNACT.CDCALENDAR) AS QTDURATIONREAL,
GNACT.VLPERCENTAGEM,
GNCOSTCFG.MNCOSTREAL,
TEAMEXEC.IDTEAM + ' - ' + TEAMEXEC.NMTEAM NMEXCECTEAM,
USREXEC.IDUSER + ' - ' + USREXEC.NMUSER NMEXECUTOR,
GNACT.FGEXECUTERLOCK,
ASSRVCENT_EXEC.IDCOMMERCIAL + ' - ' + ASSRVCENT_EXEC.NMCOMPANY NMSERVICECENTER,
GNRV.IDRESOURCE + ' - ' + GNRV.NMRESOURCE NMRESOURCERESPEXEC,
DESCTXT.TXDATA TXDESC,
GNEVAL.IDEVAL + ' - ' + GNEVAL.NMEVAL NMEVALMETHOD,
GNRESLT.NMEVALRESULT,
MAMNTYPE.IDMAINTTYPE + ' - ' + MAMNTYPE.NMMAINTTYPE NMMAINTTYPE,
CASE
WHEN ASEXECACT.FGUSEISODOC = 1 THEN (SELECT IDDOCUMENT + ' - ' + NMTITLE FROM DCDOCREVISION WHERE CDDOCUMENT = ASEXECACT.CDDOCISODOC AND CDREVISION = ASEXECACT.CDREVDOCISODOC)
ELSE (SELECT IDDOC + ' - ' + NMDOC FROM ADDOCUMENT WHERE CDDOC = ASEXECACT.CDDOCUMENT)
END NMPROCEDURE,
ASEXECACT.NMLOCAL,
ADAPPRVROUT_PROG.IDAPPROVALROUTE + ' - ' + ADAPPRVROUT_PROG.NMAPPROVALROUTE NMAPPPROG,
ADAPPRVROUT_EXEC.IDAPPROVALROUTE + ' - ' + ADAPPRVROUT_EXEC.NMAPPROVALROUTE NMAPPEXEC,
ACTTKNTXT.TXDATA TXACTTAKEN
FROM GNACTIVITY GNACT
LEFT JOIN GNCOSTCONFIG GNCOSTCFG ON ( GNCOSTCFG.CDCOSTCONFIG = GNACT.CDCOSTCONFIG )
INNER JOIN ASEXECACTIVITY ASEXECACT ON ( ASEXECACT.CDGENACTIVITY = GNACT.CDGENACTIVITY )
INNER JOIN ASACTIVITY ASACT ON ( ASACT.CDACTIVITY = ASEXECACT.CDACTIVITY )
LEFT JOIN ADTEAM TEAMPROG ON ( TEAMPROG.CDTEAM = ASACT.CDPLANTEAM )
LEFT JOIN ADTEAM TEAMEXEC ON ( TEAMEXEC.CDTEAM = ASACT.CDTEAM )
LEFT JOIN ADALLUSERS USREXEC ON ( USREXEC.CDUSER = GNACT.CDUSER )
LEFT JOIN SERICHTEXT DESCRICHTEXT ON ( DESCRICHTEXT.OID = GNACT.OIDDESCRIPTION )
LEFT JOIN SETEXT DESCTXT ON ( DESCTXT.OID = DESCRICHTEXT.OIDHTMLCONTENT )
LEFT JOIN SERICHTEXT ACTTKNRICHTEXT ON ( ACTTKNRICHTEXT.OID = GNACT.OIDACTIONTAKEN )
LEFT JOIN SETEXT ACTTKNTXT ON ( ACTTKNTXT.OID = ACTTKNRICHTEXT.OIDHTMLCONTENT )
LEFT JOIN GNEVALRESULTUSED GNRESLTUSD ON ( GNRESLTUSD.CDEVALRESULTUSED = GNACT.CDEVALRSLTPRIORITY )
LEFT JOIN GNEVALRESULT GNRESLT ON ( GNRESLT.CDEVALRESULT = GNRESLTUSD.CDEVALRESULT )
LEFT JOIN ASACTIVITY ASACTMODEL ON ( ASACTMODEL.CDACTIVITY = ASEXECACT.CDORIGINACTIVMODEL )
LEFT JOIN ASPLANACTIVITY ASPLANACT ON ( ASPLANACT.CDPLANACTIVITY = ASEXECACT.CDPLANNING )
LEFT JOIN ASSERVICECENTER ASSRVCENT_EXEC ON ( ASSRVCENT_EXEC.CDSERVICECENTER = ASEXECACT.CDSERVICECENTERE )
LEFT JOIN GNRESOURCE GNRV ON ( GNRV.CDRESOURCE = ASEXECACT.CDRESOURCERESP )
LEFT JOIN GNAPPROV GNAPPRV_PROG ON ( GNAPPRV_PROG.CDAPPROV = GNACT.CDPLANROUTE AND GNAPPRV_PROG.CDPROD = GNACT.CDPLANPRODROUTE )
LEFT JOIN ADAPPROVALROUTE ADAPPRVROUT_PROG ON ( ADAPPRVROUT_PROG.CDAPPROVALROUTE = GNAPPRV_PROG.CDAPPROVALROUTE )
LEFT JOIN GNAPPROV GNAPPRV_EXEC ON ( GNAPPRV_EXEC.CDAPPROV = GNACT.CDEXECROUTE AND GNAPPRV_EXEC.CDPROD = GNACT.CDPRODROUTE )
LEFT JOIN ADAPPROVALROUTE ADAPPRVROUT_EXEC ON ( ADAPPRVROUT_EXEC.CDAPPROVALROUTE = GNAPPRV_EXEC.CDAPPROVALROUTE )
LEFT JOIN MAMAINTTYPE MAMNTYPE ON ( MAMNTYPE.CDMAINTTYPE = ASEXECACT.CDACTIVCLASS )
LEFT JOIN GNEVAL GNEVAL ON ( GNACT.CDEVAL = GNEVAL.CDEVAL )
WHERE (
GNACT.IDACTIVITY = 'IDENTIFICADOR_DA_MANUTENÇÃO' /*OBS 1*/
)
|
Observações
▪1: Identificador da manutenção a ser filtrada.
Campos utilizados na consulta
Nº
|
ID do campo
|
Tipo
|
Observação
|
1
|
IDACTIVITY
|
VARCHAR(50)
|
Identificador da atividade
|
2
|
NMPLANACTIVITY
|
VARCHAR(255)
|
Identificador do plano
|
3
|
NMACTIVITYMODEL
|
VARCHAR(255)
|
Identificador da atividade modelo
|
4
|
DTSTARTPLAN
|
DATETIME
|
Início planejado
|
5
|
QTTIMESTARTPLAN
|
NUMERIC(10)
|
Hora do início planejado em minutos
|
6
|
DTFINISHPLAN
|
DATETIME
|
Término planejado
|
7
|
QTTIMEFINISHPLAN
|
NUMERIC(10)
|
Hora do término planejado em minutos
|
8
|
QTDURATIONPLAN
|
NUMERIC(10)
|
Duração planejada
|
9
|
MNCOSTPROG
|
NUMERIC(28,12)
|
Custo total planejado
|
10
|
NMPROGTEAM
|
VARCHAR(255)
|
Equipe responsável pelo planejamento
|
11
|
DTSTART
|
DATETIME
|
Início real
|
12
|
QTTIMESTART
|
NUMERIC(10)
|
Hora do início real em minutos
|
13
|
DTFINISH
|
DATETIME
|
Fim real
|
14
|
QTTIMEFINISH
|
NUMERIC(10)
|
Hora do fim real em minutos
|
15
|
QTDURATIONREAL
|
NUMERIC(10)
|
Duração real
|
16
|
VLPERCENTAGEM
|
NUMERIC(28,12)
|
Porcentagem
|
17
|
MNCOSTREAL
|
NUMERIC(28,12)
|
Custo total real
|
18
|
NMEXECTEAM
|
VARCHAR(255)
|
Equipe responsável pela execução
|
19
|
NMEXECUTOR
|
VARCHAR(255)
|
Responsável
|
20
|
NMSERVICECENTER
|
VARCHAR(255)
|
Centro de serviço
|
21
|
NMRESOURCERESPEXEC
|
VARCHAR(255)
|
Técnico responsável
|
22
|
TXDESC
|
VARCHAR(MAX)
|
Descrição
|
23
|
NMEVALMETHOD
|
VARCHAR(255)
|
Método de avaliação
|
24
|
NMEVALRESULT
|
VARCHAR(255)
|
Resultado da prioridade
|
25
|
NMMAINTTYPE
|
VARCHAR(255)
|
Nome da classificação da atividade
|
26
|
NMPROCEDURE
|
VARCHAR(255)
|
Nome do procedimento
|
27
|
NMLOCAL
|
VARCHAR(255)
|
Nome do local
|
28
|
NMAPPPROG
|
VARCHAR(255)
|
Roteiro de aprovação do planejamento
|
29
|
NMAPPEXEC
|
VARCHAR(255)
|
Roteiro de aprovação da execução
|
|