Overview
This command will list the data of initiatives in the evaluation step.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
PFPORTFOLIO
|
Stores the initiative data
|
CDPORTFOLIO
CDPFLREVISION
|
PFPORTFOLIOTYPE
PFPFLPROJECT
|
PFPORTFOLIOTYPE
|
Stores the initiative type data
|
CDPORTFOLIOTYPE
|
|
GNVWAPPROVRESP
|
Stores the initiative evaluation data
|
|
|
Oracle/Postgres/SQL Server
SELECT
PFPORTFOLIO.IDPORTFOLIO,
PFPORTFOLIO.NMPORTFOLIO,
PFPORTFOLIOTYPE.IDPORTFOLIOTYPE,
PFPORTFOLIOTYPE.NMPORTFOLIOTYPE,
PFPORTFOLIO.FGSTATUS,
PFPORTFOLIO.CDPFLREVISION,
PFPORTFOLIO.DTREVISION
FROM
PFPORTFOLIO
INNER JOIN
PFPORTFOLIOTYPE ON PFPORTFOLIOTYPE.CDPORTFOLIOTYPE = PFPORTFOLIO.CDPORTFOLIOTYPE
INNER JOIN
GNVWAPPROVRESP ON GNVWAPPROVRESP.CDPROD = PFPORTFOLIO.CDDRAFTPROD AND PFPORTFOLIO.CDDRAFTROUTE = GNVWAPPROVRESP.CDAPPROV
WHERE
GNVWAPPROVRESP.FGPEND = 1 /* NOTE 1 */ AND PFPORTFOLIO.FGSTATUS = 2 /* NOTE 2 */
ORDER BY PFPORTFOLIO.IDPORTFOLIO, PFPORTFOLIO.CDPFLREVISION /* NOTE 3 */
|
Notes
▪1: The FGPEND = 1 field determines that only initiatives whose evaluation task has not been executed will be displayed. ▪2: The FGSTATUS = 2 field determines that only initiatives in the draft step will be displayed. ▪3: Sorting records through the initiative revision and ID #.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
IDPORTFOLIO
|
VARCHAR(50) NULL
|
|
2
|
NMPORTFOLIO
|
VARCHAR(255) NULL
|
|
3
|
IDPORTFOLIOTYPE
NMPORTFOLIOTYPE
|
VARCHAR(50) NULL
VARCHAR(255) NULL
|
|
4
|
FGSTATUS
|
NUMERIC(2,0) NULL
|
1 - Planning
2 - Draft
3 - Approval
4 - Released
5- Revision
|
5
|
CDPFLREVISION
|
NUMERIC(10,0) NOT NULL
|
|
6
|
DTREVISION
|
DATETIME NULL
|
|
|