BUSINESS_UNITPrompt Table: OPR_DEF_TBL_PC
TEMPLATE_IDCHARTFIELD_IDPrompt Table: PROJ_RES_TYPE
Prompt Table: PROJ_CATG_TBL
Prompt Table: PROJ_SUBCAT_TBL
PC_ANLCHARTFLD(SQL Table) |
Index Back |
|---|---|
Project Valuation ChartfieldsProject Valuation Chartfields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: OPR_DEF_TBL_PC |
| 2 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 3 | CHARTFIELD_ID |
Number(2,0) | SMALLINT NOT NULL | Chartfield ID |
| 4 | CHARTFIELD_LBL | Character(30) | VARCHAR2(30) NOT NULL | Charifield Label |
| 5 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table: PROJ_RES_TYPE |
| 6 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table: PROJ_CATG_TBL |
| 7 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table: PROJ_SUBCAT_TBL |