BUSINESS_UNITPROJECT_IDA=Activity
G=Grant
H=Phase
P=Project
S=Segment
A=Active
I=Inactive
P=Pending
T=Template
F=Fair
G=Good
P=Poor
N=Detail Project
Y=Program
PC_PROJINFO_VW(SQL View) |
Index Back |
|---|---|
My Projects View |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.DESCR , A.PROJECT_TYPE , A.EFF_STATUS , A.START_DT , A.END_DT , B.PC_HEALTH , %DatePart(B.PC_HEALTH_DTTM) , A.INTEGRATION_TMPL , A.SUMMARY_PRJ , A.PERCENT_COMPLETE FROM PS_PROJECT A , PS_PC_PROJHEALTH B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.PC_HEALTH_TYPE = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PROJECT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Project Type
A=Activity G=Grant H=Phase P=Project S=Segment |
| 5 | PC_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The processing state of a project.
A=Active I=Inactive P=Pending T=Template |
| 6 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | 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 |
| 9 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 10 | INTEGRATION_TMPL | Character(15) | VARCHAR2(15) NOT NULL | Integration |
| 11 | SUMMARY_PRJ | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project Y=Program |
| 12 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |