CA_BU_FEE_DEFEX (SQL Table)	Index Back
CA BU Fee Calc. Exclusions This table stores the source types that have been defined by the user to be excluded from the fee calcution by BU and fee type.

CA_BU_FEE_DEFEX

(SQL Table)

CA BU Fee Calc. Exclusions

This table stores the source types that have been defined by the user to be excluded from the fee calcution by BU and fee type.

# 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 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RES_TYPE

#	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	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RES_TYPE