PC_CA_MARGN_VW2 (SQL View)	Index Back
Contract Profit Margin View for Homepage Tile.

PC_CA_MARGN_VW2

(SQL View)

Contract Profit Margin

View for Homepage Tile.

SELECT A.OPRID , A.DISPLAY_ORDER , A.PC_GROUP_NAME , COUNT(DISTINCT A.CONTRACT_NUM) FROM PS_PC_CA_MARGN_VW A WHERE (A.PC_ANLTC_ACT_COST <> 0 OR A.PC_ANLTC_ACT_REV <> 0) GROUP BY A.OPRID, A.DISPLAY_ORDER, A.PC_GROUP_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style

3 PC_GROUP_NAME Character(30) VARCHAR2(30) NOT NULL Analytics Grouping Name

4 PC_COUNT Number(8,0) INTEGER NOT NULL Copy/Update Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	DISPLAY_ORDER	Number(3,0)	SMALLINT NOT NULL	Display order for ordering items in a list - web style
3	PC_GROUP_NAME	Character(30)	VARCHAR2(30) NOT NULL	Analytics Grouping Name
4	PC_COUNT	Number(8,0)	INTEGER NOT NULL	Copy/Update Count