CA_BPSCHPGP_VW (SQL View)	Index Back
View for BP Schedule. This view is to generate the REV/UAR lines for the Progress Payment with Immediate Bill Plan.

CA_BPSCHPGP_VW

(SQL View)

View for BP Schedule.

This view is to generate the REV/UAR lines for the Progress Payment with Immediate Bill Plan.

SELECT PGP.CONTRACT_NUM , PGP.CA_PGP_SEQ , PGP.SEQ_NBR_3 , PGP.BILL_PLAN_ID , PGP.CA_ITEM_27 , LN.BPLAN_LN_NBR FROM PS_CA_PGP_WKS PGP , PS_CA_BP_LINES LN WHERE LN.CONTRACT_NUM = PGP.CONTRACT_NUM AND LN.BILL_PLAN_ID = PGP.BILL_PLAN_ID AND LN.CA_PGP_SEQ = PGP.CA_PGP_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Prompt Table: CA_PREPAID_SRCH

2 CA_PGP_SEQ Number(3,0) SMALLINT NOT NULL Progress Payment Sequence

3 SEQ_NBR_3 Number(3,0) SMALLINT NOT NULL Sequence

4 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
Prompt Table: CA_PPD_BP_VW

5 CA_ITEM_27 Signed Number(28,3) DECIMAL(26,3) NOT NULL 27. Amount Approved

6 BPLAN_LN_NBR Number(3,0) SMALLINT NOT NULL Bill Plan Line Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_PREPAID_SRCH
2	CA_PGP_SEQ	Number(3,0)	SMALLINT NOT NULL	Progress Payment Sequence
3	SEQ_NBR_3	Number(3,0)	SMALLINT NOT NULL	Sequence
4	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID Prompt Table: CA_PPD_BP_VW
5	CA_ITEM_27	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	27. Amount Approved
6	BPLAN_LN_NBR	Number(3,0)	SMALLINT NOT NULL	Bill Plan Line Number