CA_S_GRP_ID

(SQL View)
Index Back

Sum Group Identifier Table

Summarization Group Identifier Table

SELECT SUM_GROUP_TYPE , SUM_GROUP_ID , DESCR , DESCRSHORT FROM PS_BI_S_GRP_ID_TBL WHERE STATUS_BI = 'A'

  • Related Language Record: BI_S_GRP_ID_LNG
  • # 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.

    Prompt Table: BI_SGRP_TYP_TBL

    2 SUM_GROUP_ID Character(16) VARCHAR2(16) NOT NULL This field is used to provide additional grouping criteria for billing summarization. It is to be used with SUM_GROUP_TYPE. User defines a set of Summarization Group IDs per Summarization Group Type.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description