GM_BU_PM_SETUP

(SQL Table)
 Index Back

Ppsl Mgmt Contract Setup

Any fields added to this recdefn NEED to be added to GM_BU_GNR_SETUP.

# 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_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

2 PROJ_GRANT_STATUS Character(1) VARCHAR2(1) NOT NULL Status
A=Approved
C=Completed
I=In Progress
P=Proposed

Default Value: I

3 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

Default Value: BUS_UNIT_TBL_CA.BUSINESS_UNIT_BI

Prompt Table: SP_BUCABI_NONVW

4 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

Default Value: BUS_UNIT_TBL_CA.BILL_TYPE_ID

Prompt Table: BI_TYPE_EF_VW
Set Control Field: BUSINESS_UNIT_BI

5 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RES_TYPE
Set Control Field: BUSINESS_UNIT_PC

6 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: PROJ_CATG_TBL
Set Control Field: BUSINESS_UNIT_PC

7 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: PROJ_SUBCAT_TBL
Set Control Field: BUSINESS_UNIT_PC

8 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

Prompt Table: CA_TYPE_TBL
Set Control Field: BUSINESS_UNIT

9 CONTR_LEGAL_ENTITY Character(15) VARCHAR2(15) NOT NULL Contract Legal Entity

Prompt Table: CA_LEGAL_ENTITY
Set Control Field: BUSINESS_UNIT

10 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: SP_BU_PC_NONVW

11 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

Prompt Table: BI_SRC_EF_VW
Set Control Field: BUSINESS_UNIT_BI

12 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status

Prompt Table: CA_STAT_PND1_VW
Set Control Field: BUSINESS_UNIT

13 TOLERANCE_AMT Number(16,2) DECIMAL(15,2) NOT NULL Tolerance Amount
14 PM_SECURITY_IND Character(1) VARCHAR2(1) NOT NULL Security
N=No
Y=Yes

Default Value: N

15 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: GM_PRDCT_AI_VW
Set Control Field: BUSINESS_UNIT

16 PRODUCT_ID_ALT Character(18) VARCHAR2(18) NOT NULL Alternate Product ID

Prompt Table: GM_PRDCT_FF_VW
Set Control Field: BUSINESS_UNIT

17 CONFIDENCE_LOW Number(3,0) SMALLINT NOT NULL Low Confidence

Default Value: 0

18 CONFIDENCE_MEDIUM Number(3,0) SMALLINT NOT NULL Medium Confidence
19 CONFIDENCE_HIGH Number(3,0) SMALLINT NOT NULL High Confidence