HMCF_PC_BUS_UNITPROJECT_IDE=Enforce in Expenses Only
N=Do Not Enforce Project Team
T=Enforce in Time and Labor Only
Y=Enforce in Expenses and T&L
PROJ_PC_BU_VW(SQL View) |
Index Back |
|---|---|
PC Business Unit Projects ViewThe view provides an easy to use on-line prompt for the project table. |
| SELECT BUSINESS_UNIT ,PROJECT_ID ,DESCR ,ENFORCE FROM PS_PROJECT WHERE EFF_STATUS='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HMCF_PC_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Chartfield Project Costing Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project/Grant |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ENFORCE | Character(1) | VARCHAR2(1) NOT NULL |
Enforce Project Team?
E=Enforce in Expenses Only N=Do Not Enforce Project Team T=Enforce in Time and Labor Only Y=Enforce in Expenses and T&L |