Navigation: Portfolio >

Initiatives

Overview

This command will list the initiative data.

Related tables

TABLE

Description

Primary key (PK)

Connection tables

PFPORTFOLIO

Stores the initiative data

CDPORTFOLIO

CDPFLREVISION

PFPORTFOLIOTYPE

Stores the initiative type data

CDPORTFOLIOTYPE

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
ORDER BY PFPORTFOLIO.IDPORTFOLIO, PFPORTFOLIO.CDPFLREVISION /* NOTE 1 */

Notes

▪1: Sorting records through the initiative revision and ID #.

Fields used on the view screen

portfolio-01

#	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