PROJ_STA_CA_VW(SQL View) |
Index Back |
---|---|
Project StatusTo be used on Console |
SELECT DISTINCT CONTRACT_NUM , BUSINESS_UNIT , PS.PROJECT_ID , EFFDT , EFFSEQ , PROJECT_STATUS , PROJECT_PRIORITY , PERCENT_COMPLETE , INTEREST_FACTOR , TO_CHAR(DESCRLONG ) FROM PS_CA_DETAIL_PROJ DTL , PS_PROJECT_STATUS PS WHERE PS.BUSINESS_UNIT = DTL.BUSINESS_UNIT_PC AND PS.PROJECT_ID = DTL.PROJECT_ID AND PS.EFFDT = ( SELECT MAX(PS1.EFFDT) FROM PS_PROJECT_STATUS PS1 WHERE PS1.BUSINESS_UNIT = PS.BUSINESS_UNIT AND PS1.PROJECT_ID = PS.PROJECT_ID AND PS1.EFFDT <= %CurrentDateIn AND PS1.EFFSEQ = ( SELECT MAX(PS2.EFFSEQ) FROM PS_PROJECT_STATUS PS2 WHERE PS2.BUSINESS_UNIT = PS1.BUSINESS_UNIT AND PS2.PROJECT_ID = PS1.PROJECT_ID AND PS2.EFFDT = PS1.EFFDT)) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CONTR_HDR |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT |
4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
5 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
6 | PROJECT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted C=Closed H=Hold O=Open P=Proposed Prompt Table: %EDITTABLE3 |
7 | PROJECT_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Project Priority |
8 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
9 | INTEREST_FACTOR | Signed Number(5,2) | DECIMAL(3,2) NOT NULL | Interest Calculation Factor |
10 | DESCRLONG | Long Character | CLOB | Long Description |