PROJ_NOSUMM_VW(SQL View) |
Index Back |
---|---|
Exclude Summary ProjectsExclude Summary Projects |
SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.EFF_STATUS , A.DESCR , A.PROJECT_TYPE , A.ENFORCE , A.ENFORCE_TYPE FROM PS_PROJECT A WHERE A.EFF_STATUS = 'A' AND A.SUMMARY_PRJ = 'N' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: OPR_DEF_TBL_PC.PROJECT_ID Prompt Table: SP_PROJ_NONVW |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | PROJECT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Project Type
A=Activity G=Grant H=Phase P=Project S=Segment Prompt Table: PROJ_TYPE_TBL |
6 | ENFORCE | Character(1) | VARCHAR2(1) NOT NULL |
Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
E=Expenses N=No T=Time&Labor Y=Exp and TL Default Value: BUS_UNIT_OPT_PC.ENFORCE |
7 | ENFORCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Enforce project and activity team based prompt.
B=Project and Activity Team N=Do Not Enforce P=Project Team Only R=Project Resource Pools Only S=Project Activity Resource Pool X=Decide at the Project Level Default Value: BUS_UNIT_OPT_PC.ENFORCE_TYPE |