PC_WC_FLT_VW

(SQL View)
 Index Back

Filter View Proj Resource WC

This filter view has been created for Proj Resource WorkCenter Exception.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.ANALYSIS_TYPE , A.TRANS_DT , A.ACCOUNTING_DT , CA.BUSINESS_UNIT , A.CONTRACT_NUM , CA.CONTRACT_TYPE , CA.GM_METHOD_PAYMENT , CB.BILL_CYCLE_ID , CA.BILL_TO_CUST_ID , CB.BILLING_SPECIALIST FROM PS_PROJ_RESOURCE A , PS_CA_CONTR_HDR CA , PS_CA_BILL_PLAN CB WHERE A.CONTRACT_NUM = CA.CONTRACT_NUM AND CA.CONTRACT_NUM = CB.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: PROJ_ACTIVITY.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

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

Default Value: PROJ_ACTIVITY.PROJECT_ID

Prompt Table: SP_PROJ_NONVW

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

Default Value: PROJ_ACTIVITY.ACTIVITY_ID

Prompt Table: PROJ_ACT_SRCH

4 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: PROJ_ANTYPE_TBL

5 TRANS_DT Date(10) DATE Transaction Date

Default Value: %date

6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

Default Value: %date

7 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

Prompt Table: SP_BU_CA_NONVW

8 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CONTRACT_VW

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

Prompt Table: CA_TYPE_TBL

10 GM_METHOD_PAYMENT Character(3) VARCHAR2(3) NOT NULL Method of Payment
CST=Cost Reimbursable
LOC=Letter of Credit
11 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier
12 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CA_BILL_TO_VW

13 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist

Prompt Table: BI_SPECIALST_VW
Set Control Field: BUSINESS_UNIT_BI