BI_SUMGRP_TY_VW (SQL View)	Index Back
Active Sum Group Types Active Summarization Group Types View

BI_SUMGRP_TY_VW

(SQL View)

Active Sum Group Types

Active Summarization Group Types View

SELECT SUM_GROUP_TYPE , DESCR FROM PS_BI_SGRP_TYP_TBL WHERE STATUS_BI = 'A'

Related Language Record: BI_S_GRP_TY_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUM_GROUP_TYPE Character(4) VARCHAR2(4) NOT NULL This field is used to provide additional grouping criteria for billing summarization. It is related to SUM_GROUP_ID. User defines a list of valid SUM_GROUP_IDs per SUM_GROUP_TYPE value.

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUM_GROUP_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is used to provide additional grouping criteria for billing summarization. It is related to SUM_GROUP_ID. User defines a list of valid SUM_GROUP_IDs per SUM_GROUP_TYPE value.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description