PROCESS_INSTANCEOPRIDTREE_NODE_NUMN=Detail Project
Y=Program
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
A=Active
I=Inactive
P=Pending
T=Template
F=Fair
G=Good
P=Poor
PGM_REVIEW_PROG(SQL Table) |
Index Back |
|---|---|
Review Program DataThis is a table that holds the results of the Review Program query for a given operator, process instance. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 6 | SUMMARY_PRJ | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project Y=Program |
| 7 | PARENT_PROGRAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Parent Program ID |
| 8 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | PROJECT_MANAGER | Character(11) | VARCHAR2(11) NOT NULL | Project Manager |
| 11 | PROJECT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted C=Closed H=Hold O=Open P=Proposed |
| 12 | STATUS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Status Description |
| 13 | PC_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The processing state of a project.
A=Active I=Inactive P=Pending T=Template |
| 14 | PC_HEALTH | Character(1) | VARCHAR2(1) NOT NULL |
Calculated based on user-defined criteria, this field shows the overall health of a project.
F=Fair G=Good P=Poor |
| 15 | PC_HEALTH_DTTM | DateTime(26) | TIMESTAMP | The datetime stamp of when Project Health was either calculated or manually entered. |
| 16 | PC_BUDGET_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The budget amount in the currency of the Projects business unit. |
| 17 | BUDGET_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Projects Budget Amount |
| 18 | PC_COST_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total cost for a project. |
| 19 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
| 20 | START_DT | Date(10) | DATE | Start Date |
| 21 | END_DT | Date(10) | DATE | End Date |
| 22 | PGM_ISS_TOTAL | Number(15,0) | DECIMAL(15) NOT NULL | Total number of unresolved issues. |
| 23 | PGM_ISS_CRITICAL | Number(15,0) | DECIMAL(15) NOT NULL | Number of Critical Issues |
| 24 | PGM_DELV_TOTAL | Number(15,0) | DECIMAL(15) NOT NULL | Total number of deliverables. |
| 25 | PC_DELV_OVERDUE | Number(4,0) | SMALLINT NOT NULL | Number of Overdue Deliverables |
| 26 | RELEASE | Character(15) | VARCHAR2(15) NOT NULL | Release - Carries Release Information driven by the BUSINESS_UNIT |
| 27 | CATEGORY_IND | Character(10) | VARCHAR2(10) NOT NULL | An additional attribute of the project, program, or project request for further classification. This field is user-defined. Examples of usage include "Strategic", "Operational", "Tactical", etc. |
| 28 | APPLICATION | Character(10) | VARCHAR2(10) NOT NULL | Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area. |
| 29 | APPLICATION_AREA | Character(10) | VARCHAR2(10) NOT NULL | The general area in which an application belongs. Examples: "Financials", "Human Resources", etc. |
| 30 | TOTAL_RISKS | Number(8,0) | INTEGER NOT NULL | Total Risks |
| 31 | RISKS_NO_PLAN | Number(8,0) | INTEGER NOT NULL | Risks without Action Plan |