PC_CUR_STAT_VW3(SQL View) |
Index Back |
---|---|
Project Status ViewThis view displays the current effective project status and corresponding status description. |
SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.EFFDT , A.PROJECT_STATUS , TBL.DESCR FROM PS_PROJECT_STATUS A , PS_PROJ_STATUS_TBL TBL , PS_SET_CNTRL_REC CTL WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PROJECT_STATUS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_PROJECT_STATUS C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND A.EFFDT = C.EFFDT) AND CTL.SETCNTRLVALUE = A.BUSINESS_UNIT AND CTL.RECNAME = 'PROJ_STATUS_TBL' AND CTL.SETID = TBL.SETID AND A.PROJECT_STATUS = TBL.PROJECT_STATUS |
# | 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
Prompt Table: PROJECT |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | PROJECT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted C=Closed H=Hold O=Open P=Proposed Prompt Table: %EDITTABLE3 |
5 | STATUS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Status Description |