CA_BU_FEE_DEF(SQL Table) |
Index Back |
|---|---|
CA BU Fee Calculation Def.This table stores the analysis group that is used for the fee worksheet calculations. In addition, it stores the analysis type to be used for the fee row (billing and revenue fees). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_CA_NONVW |
| 2 | CA_FEE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Cost Plus Fee Type
01=None 02=Fixed Fee 03=Award Fee 04=Incentive Fee 05=Other Fee |
| 3 | ANALYSIS_GROUP_BIL | Character(5) | VARCHAR2(5) NOT NULL |
Analysis Group for Billing Fee
Prompt Table: PROJ_AN_GRP_TBL |
| 4 | ANALYSIS_TYPE_BIL | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type for Bil Cost Fee
Prompt Table: PROJ_ANTYPE_TBL |
| 5 | RESOURCE_TYPE_BIL | Character(5) | VARCHAR2(5) NOT NULL |
Source Type for Bil Fee Cost
Prompt Table: PROJ_RES_TYPE |
| 6 | RESOURCE_CAT_BIL | Character(5) | VARCHAR2(5) NOT NULL |
Category for Bil Cost Fee
Prompt Table: PROJ_CATG_TBL |
| 7 | RESOURCE_SCAT_BIL | Character(5) | VARCHAR2(5) NOT NULL |
SubCategory for Bil Fee Cost
Prompt Table: PROJ_SUBCAT_TBL |
| 8 | ANALYSIS_GROUP_REV | Character(5) | VARCHAR2(5) NOT NULL |
Analysis Group for Revenue Fee
Prompt Table: PROJ_AN_GRP_TBL |
| 9 | ANALYSIS_TYPE_REV | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type for Rev Cost Fee
Prompt Table: PROJ_ANTYPE_TBL |
| 10 | RESOURCE_TYPE_REV | Character(5) | VARCHAR2(5) NOT NULL |
Source Type for Rev Fee Cost
Prompt Table: PROJ_RES_TYPE |
| 11 | RESOURCE_CAT_REV | Character(5) | VARCHAR2(5) NOT NULL |
Category for Rev Fee Cost
Prompt Table: PROJ_CATG_TBL |
| 12 | RESOURCE_SCAT_REV | Character(5) | VARCHAR2(5) NOT NULL |
SubCategory for Rev Fee Cost
Prompt Table: PROJ_SUBCAT_TBL |