CA_NOTE_SRCH_VW

(SQL View)
Index Back

Revenue Plan Search Dialogue

Master contracts are excluded from this view.

SELECT HDR.BUSINESS_UNIT , NOTE.CONTRACT_NUM , HDR.CONTRACT_ADMIN , NOTE.NOTES_SEQ_NUM , NOTE.CONTRACT_COMPONENT , NOTE.CONTRACT_LINE_NUM ,NOTE.BILL_PLAN_ID ,NOTE.ACCT_PLAN_ID ,NOTE.CHG_ID ,NOTE.MS_SEQNUM ,NOTE.INCENTIVE_ID ,NOTE.EARLY_OUT_CD ,NOTE.CA_PGP_SEQ FROM PS_CA_CONTR_HDR HDR , PS_CA_NOTE NOTE WHERE NOTE.CONTRACT_NUM = HDR.CONTRACT_NUM

# 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 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_NO_MSTR_VW

3 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

Prompt Table: MEMBER_VW

4 NOTES_SEQ_NUM Number(3,0) SMALLINT NOT NULL Notes Sequence Num
5 CONTRACT_COMPONENT Character(4) VARCHAR2(4) NOT NULL Contract Component
AMT=Amount Allocation
BIL=Billing Plan
CHG=Amendments
EO=Early Out Options
HDR=Contract Header
LINE=Contract Line
MLST=Contract Milestone
PEN=Bonus/Penalty
PGP=Progress Payments Terms
PPD=Prepaids
PROJ=Contractor Terms
REV=Revenue Plan
TERM=Special Payment Terms

Default Value: HDR

6 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

Prompt Table: CA_DETAIL

7 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

Prompt Table: CA_BILL_PLAN

8 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

Prompt Table: CA_ACCTPLAN

9 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.

Prompt Table: CA_CHG_HDR

10 MS_SEQNUM Number(3,0) SMALLINT NOT NULL Milestone Number

Prompt Table: CA_MILESTONE

11 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

Prompt Table: CA_BONUS_PENLTY

12 EARLY_OUT_CD Character(4) VARCHAR2(4) NOT NULL Early Out Option Code

Prompt Table: CA_EARLY_OPTION

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

Prompt Table: CA_PGP_TERMS