GENLMTLEVLVWLNG

(SQL View)
 Index Back

General Material Evaluation VW

GENLMTLEVLVWLNG is the related language recordfor the record GENL_MTL_EVL_VW

SELECT D.EMPLID , D.EVALUATION_CODE , D.GENL_EVAL_NBR , A.GENL_MATL_GROUP , A.GENL_MATL_TYPE , A.GENL_MATL_NBR ,A.LANGUAGE_CD , A.DESCR_EXT_ORG FROM PS_GENLMATERIALLNG A , PS_GENL_MATL_EVAL D WHERE A.emplid = D.emplid AND A.Genl_Matl_Group = D.Genl_Matl_Group AND A.Genl_Matl_Type = D.Genl_Matl_Type AND A.Genl_Matl_Nbr = D.Genl_Matl_Nbr

  • Related Language Record for GENL_MTL_EVL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 EVALUATION_CODE Character(10) VARCHAR2(10) NOT NULL Evaluation Code
    3 GENL_EVAL_NBR Number(3,0) SMALLINT NOT NULL Evaluation Number
    4 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group

    Prompt Table: MATL_GRP_TBL

    5 GENL_MATL_TYPE Character(3) VARCHAR2(3) NOT NULL Material Type

    Prompt Table: MATL_TYPE_TBL

    6 GENL_MATL_NBR Number(3,0) SMALLINT NOT NULL Material Nbr
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR_EXT_ORG Character(30) VARCHAR2(30) NOT NULL Org Name