CA_BI_MGT_AI_V3

(SQL View)
 Index Back

ca_bi_mgt_ai_vw


SELECT F.CONTRACT_NUM , A.BILL_PLAN_ID , F.PROJECT_ID , F.FOREIGN_CURRENCY , D.BUSINESS_UNIT , D.BUSINESS_UNIT_BI , F.BUSINESS_UNIT_PC , D.BILL_TO_CUST_ID , A.BILL_PLAN_TYPE , A.BP_STATUS , D.CA_RQST_SRC , A.HOLD_FLAG , A.HOLD_DATE , DET.CA_FEE_TYPE FROM PS_CA_BILL_PLAN A , PS_CA_DETAIL_PROJ C , PS_CA_CONTR_HDR D , PS_CA_PROJ_SUMMARY F , PS_CA_DETAIL DET WHERE A.CONTRACT_NUM = D.CONTRACT_NUM AND A.CONTRACT_NUM = F.CONTRACT_NUM AND F.CONTRACT_NUM = C.CONTRACT_NUM AND F.BUSINESS_UNIT_PC = C.BUSINESS_UNIT_PC AND F.PROJECT_ID = C.PROJECT_ID AND F.ACTIVITY_ID = C.ACTIVITY_ID AND DET.CONTRACT_NUM = A.CONTRACT_NUM AND DET.BILL_PLAN_ID = A.BILL_PLAN_ID GROUP BY D.BUSINESS_UNIT, D.BUSINESS_UNIT_BI, F.BUSINESS_UNIT_PC, D.BILL_TO_CUST_ID, F.CONTRACT_NUM, A.BILL_PLAN_ID, A.BILL_PLAN_TYPE, A.BP_STATUS, A.HOLD_FLAG, A.HOLD_DATE, F.PROJECT_ID, F.FOREIGN_CURRENCY, D.CA_RQST_SRC, DET.CA_FEE_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
7 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
8 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
9 BILL_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Billing Method
01=As Incurred
02=Installment
03=Recurring
04=Milestone
05=Percent Complete
06=Immediate
07=Value Based
10 BP_STATUS Character(3) VARCHAR2(3) NOT NULL Billing Plan Status
CAN=Cancelled
DON=Completed
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
RIP=Reversal In Progress
RQD=Action Required
RRP=Recycled
RVS=Reversed
11 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
FED=Federal Reimbursable Agreement
GEN=Generic Application
GOV=Government
INT=Internal
OND=CRM Field Services On Demand
STD=Standard
12 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
13 HOLD_DATE Date(10) DATE Put On Hold Date
14 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