BUSINESS_UNITTEMPLATE_IDPROJ_ACT_TMPVW1(SQL View) |
Index Back |
|---|---|
Project Activity Temp View |
| SELECT DISTINCT A.BUSINESS_UNIT, A.PROJECT_ID, A.DESCR, B.ACT_TEMPLATE_SW FROM PS_PROJECT A, PS_PROJ_ACTIVITY B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PROJECT_ID = A.PROJECT_ID AND ( B.ACT_TEMPLATE_SW = 'Y' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | TEMPLATE_SW | Character(1) | VARCHAR2(1) NOT NULL | Allows the user to indicate whether a given bank transfer transaction should be designated as a |