PROJ_SRCH_NP(SQL View) |
Index Back |
---|---|
Secured Project SearchThis search view is the same as PROJ_SRCH except it does not allow 'pending' projects to be selected. |
SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.DESCR , A.PROJECT_TYPE , A.EFF_STATUS , A.INTEGRATION_TMPL , A.SUMMARY_PRJ , ' ' FROM PS_PROJECT A WHERE A.EFF_STATUS IN ('A', 'I') |
# | 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: PROJECT_VW |
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 Prompt Table: PROJ_TYPE_TBL |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
6 | INTEGRATION_TMPL | Character(15) | VARCHAR2(15) NOT NULL |
Integration
Default Value: OPR_DEF_TBL_PC.INTEGRATION_TMPL Prompt Table: PC_INT_TMPL |
7 | SUMMARY_PRJ | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project Y=Program |
8 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |