BI_S_GRP_TY_LVW(SQL View) |
Index Back |
---|---|
Active Sum Grp Types LangActive Summarization Group Types Related Language View |
SELECT A. SUM_GROUP_TYPE , B.LANGUAGE_CD , B.DESCR FROM PS_BI_SGRP_TYP_TBL A , PS_BI_SGRP_TYP_LNG B WHERE A.STATUS_BI = 'A' AND %Join(COMMON_KEYS, BI_SGRP_TYP_TBL A, BI_SGRP_TYP_LNG B) |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |