MATL_GRP_VW

(SQL View)
 Index Back

Material Group View

This table will give a view of Material Groups that are general material Material Groups.

select DISTINCT a.institution, A.Genl_Matl_Group, a.effdt, a.eff_status, A.Descr from PS_MATL_GRP_TBL A, PS_MATL_GRPTYP_TBL B, PS_MATL_TYPE_TBL C where b.institution = a.institution and b.genl_matl_group = a.genl_matl_group and b.effdt = a.effdt and C.Genl_Matl_Type = B.Genl_Matl_Type and C.Genl_Matl_Chk = 'Y'

  • Related Language Record: MATL_GRP_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description