BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW
ASSET_ACQ_PCVW(SQL View) |
Index Back |
|---|---|
Asset Acquisition Dtl - PCUsed for Projects drillback |
| SELECT BUSINESS_UNIt_PC , MASTER_PROJECT , PROJECT_ID , ACTIVITY_ID , ANALYSIS_TYPE , RESOURCE_TYPE , RESOURCE_CATEGORY , RESOURCE_SUB_CAT FROM PS_ASSET_ACQ_DET WHERE BUSINESS_UNIT_PC<>' ' |
| # | 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_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 2 | MASTER_PROJECT | Character(15) | VARCHAR2(15) NOT NULL | Master Project |
| 3 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 4 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 5 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 6 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 7 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 8 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |