PC_RPT_GRP_VW2

(SQL View)
 Index Back

PC Reporting Groups

Groups/buckets for PC Reporting - Contract Margin

SELECT FEATURE_CD , DISPLAY_ORDER , PC_GROUP_NAME , OPERATION , FROM_RANGE , TO_RANGE , GROUPING FROM PS_PC_RPT_GROUPS WHERE FEATURE_CD = 'PC_CA_MARG'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FEATURE_CD Character(10) VARCHAR2(10) NOT NULL Feature Code
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 OPERATION Character(3) VARCHAR2(3) NOT NULL Arithmetic Operation
<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
5 FROM_RANGE Signed Number(15,3) DECIMAL(13,3) NOT NULL From number
6 TO_RANGE Signed Number(15,3) DECIMAL(13,3) NOT NULL To number
7 GROUPING Character(40) VARCHAR2(40) NOT NULL An identifier for a grouping of rows.