Overview
This command will list the data of a maintenance activity.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
GNACTIVITY
|
Activity record
|
CDGENACTIVITY
|
ADALLUSERS
ADDEPARTMENT
ADMAILTASKREL
ADPOSITION
ADROLE
ADTEAM
ADUSEREXTERNALDATA
GNACTIVITYTIMECFG
GNAPPROV
GNASSOC
GNCALENDAR
GNCHECKLISTANSWER
GNCOSTCONFIG
GNEVALRESULTUSED
GNEVALREVISION
GNFAVORITE
GNOBJECTASSOCGROUP
GNTYPEROLE
SERICHTEXT
|
GNCOSTCONFIG
|
Stores the activity costs
|
CDCOSTCONFIG
|
|
ASEXECACTIVITY
|
Activity execution record
|
CDEXECACTIVITY
|
ADDOCUMENT
ASACTIVITY
ASPLANACTIVITY
ASSERVICECENTER
ASSERVICECENTERTEC
DCDOCREVISION
GNACTIVITY
GNFAVORITE
GNRESOURCE
GNTOOLSANALISYS
MAMAINTTYPE
|
ASACTIVITY
|
Standard activity record
|
CDACTIVITY
|
ADAPPROVALROUTE
ADCHECKLIST
ADDOCUMENT
ADTEAM
ASACTIVMODELTYPE
ASSERVICECENTER
ASSERVICECENTERTEC
CACONFIGURATION
GNACTIVITYTIMECFG
GNCOSTCONFIG
GNEVALRESULTUSED
GNEVALREVISION
GNMASK
GNRESOURCE
MAMAINTTYPE
SERICHTEXT
|
ADTEAM
|
Teams
|
CDTEAM
|
ADAUTHLDAPCONFIG
GNMAPPING
GNPERMISSION
|
ADALLUSERS
|
User record
|
CDUSER
|
ADALLUSERS
ADUSEREXTERNALDATA
GNFAVORITE
|
SERICHTEXT
|
System rich text data
|
OID
|
SETEXT
|
GNEVALRESULTUSED
|
Result of evaluations performed
|
CDEVALRESULTUSED
|
GNEVALRESULT
|
GNEVALRESULT
|
Evaluation method results
|
CDEVALRESULT
|
GNEVALREVISION
|
ASPLANACTIVITY
|
Activity plan record
|
CDPLANACTIVITY
|
ADMAILTASKREL
ADTEAM
ASACTIVITY
GNCALENDAR
GNEVALRESULTUSED
GNEVALREVISION
MAROUTE
|
ASSERVICECENTER
|
Service center record
|
CDSERVICECENTER
|
GNCALENDAR
|
GNRESOURCE
|
Resources
|
CDRESOURCE
|
ADALLUSERS
ADCOMPANY
GNASSOC
GNCALENDAR
GNRESOURCETYPE
OBOBJECTGROUP
|
GNAPPROV
|
Approval record
|
CDPROD
CDAPPROV
|
ADAPPROVALROUTE
|
ADAPPROVALROUTE
|
Responsibility route record
|
CDAPPROVALROUTE
|
|
MAMAINTTYPE
|
Maintenance type record
|
CDMAINTTYPE
|
|
GNEVAL
|
Evaluation method record
|
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 = 'MAINTENANCE_ID' /*NOTE 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 = 'MAINTENANCE_ID' /*NOTE 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 = 'MAINTENANCE_ID' /*NOTE 1*/
)
|
Notes
▪1: ID # of the maintenance to be filtered.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
IDACTIVITY
|
VARCHAR(50)
|
Activity ID #
|
2
|
NMPLANACTIVITY
|
VARCHAR(255)
|
Plan ID #
|
3
|
NMACTIVITYMODEL
|
VARCHAR(255)
|
Standard activity ID #
|
4
|
DTSTARTPLAN
|
DATETIME
|
Planned start date
|
5
|
QTTIMESTARTPLAN
|
NUMERIC(10)
|
Planned start time in minutes
|
6
|
DTFINISHPLAN
|
DATETIME
|
Planned end date
|
7
|
QTTIMEFINISHPLAN
|
NUMERIC(10)
|
Planned end time in minutes
|
8
|
QTDURATIONPLAN
|
NUMERIC(10)
|
Estimated duration
|
9
|
MNCOSTPROG
|
NUMERIC(28,12)
|
Planned total cost
|
10
|
NMPROGTEAM
|
VARCHAR(255)
|
Responsible team for planning
|
11
|
DTSTART
|
DATETIME
|
Actual start date
|
12
|
QTTIMESTART
|
NUMERIC(10)
|
Actual start time in minutes
|
13
|
DTFINISH
|
DATETIME
|
Actual end date
|
14
|
QTTIMEFINISH
|
NUMERIC(10)
|
Actual end time in minutes
|
15
|
QTDURATIONREAL
|
NUMERIC(10)
|
Actual duration
|
16
|
VLPERCENTAGEM
|
NUMERIC(28,12)
|
Percentage
|
17
|
MNCOSTREAL
|
NUMERIC(28,12)
|
Actual total cost
|
18
|
NMEXECTEAM
|
VARCHAR(255)
|
Responsible team for execution
|
19
|
NMEXECUTOR
|
VARCHAR(255)
|
Responsibility
|
20
|
NMSERVICECENTER
|
VARCHAR(255)
|
Service center
|
21
|
NMRESOURCERESPEXEC
|
VARCHAR(255)
|
Responsible technician
|
22
|
TXDESC
|
VARCHAR(MAX)
|
Description
|
23
|
NMEVALMETHOD
|
VARCHAR(255)
|
Evaluation method
|
24
|
NMEVALRESULT
|
VARCHAR(255)
|
Priority result
|
25
|
NMMAINTTYPE
|
VARCHAR(255)
|
Activity classification name
|
26
|
NMPROCEDURE
|
VARCHAR(255)
|
Procedure name
|
27
|
NMLOCAL
|
VARCHAR(255)
|
Location name
|
28
|
NMAPPPROG
|
VARCHAR(255)
|
Planning approval route
|
29
|
NMAPPEXEC
|
VARCHAR(255)
|
Execution approval route
|
|