CA_BP_EV_PM_VW

(SQL View)
 Index Back

Contract Rev Plan Evnt View

Record will contain one row for each pending Billing Plan event that is associated with a Project milestone/activity. A pending event is an event of Pending, Ready, or Recycled status

SELECT BP.BUSINESS_UNIT_PC ,BP.PROJECT_ID ,BP.ACTIVITY_ID ,BP.CONTRACT_NUM ,BP.BILL_PLAN_ID ,BP.EVENT_OCCURRENCE ,BP.ACTIVITY_STATUS ,HDR.DESCR ,HDR.SOLD_TO_CUST_ID ,HDR.BUSINESS_UNIT ,'Billing' AS CONTR_IMP_AREA FROM PS_CA_BP_EVENTS BP , PS_CA_CONTR_HDR HDR WHERE BP.BILL_EVENT_TYPE = '02' AND BP.MILESTONE_ORIGIN = 'A' AND BP.BP_EVENT_STATUS IN ('PND','RCL','RRP', 'RDY') AND BP.CONTRACT_NUM = HDR.CONTRACT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: BUS_UNIT_PC_VW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: CA_PROJ_MS_VW

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: CA_ACT_MS_VW

4 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
5 AP_BP_MLS_ID Character(15) VARCHAR2(15) NOT NULL Rev/Bill Plan or Milestone ID
6 EVENT_COND_NUM Number(3,0) SMALLINT NOT NULL Event /Condition Number
7 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status

Prompt Table: PROJ_STATUS_TBL

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 CONTR_IMP_AREA Character(15) VARCHAR2(15) NOT NULL Contract Impact Area