P6_CNTRCT_VW

(SQL View)
Index Back

Contract Number prompt view

Contract Number Prompt view

SELECT DISTINCT BUSINESS_UNIT_PC , CONTRACT_NUM , PROJECT_ID FROM PS_CA_DETAIL_PROJ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField