GENL_MATL_VW

(SQL View)
 Index Back

General Materials View

This tables is a view of the General Materials table. It contains key data only.

select D.emplid, D.Genl_Eval_Nbr, D.Evaluation_Code, A.genl_matl_group, A.genl_matl_type, A.genl_matl_nbr, A.dt_recvd, A.dt_recorded, A.AUDITION_TYPE, A.PORTFOLIO_TYPE, A.ESSAY_TOPIC, A.GENL_INTVW_TYPE, A.RECOMM_TYPE, A.RECOMMENDER_ID, A.INTERVIEWER, A.COMMITTEE_ID, A.NAME, A.TITLE, A.EXT_ORG_ID, A.DESCR_EXT_ORG from PS_GENL_MATERIALS A, ps_genl_evaluation D where A.emplid = D.emplid and not exists ( select 'X' from ps_genl_matl_eval B where A.emplid = B.Emplid and B.Evaluation_Code = D.Evaluation_Code and B.Genl_Eval_Nbr = D.Genl_Eval_Nbr and A.genl_matl_group = B.genl_matl_group and A.genl_matl_type = B.genl_matl_type and A.genl_matl_nbr = B.genl_matl_nbr)

  • Related Language Record: GENL_MATL_VWLNG

    • # 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 GENL_EVAL_NBR Number(3,0) SMALLINT NOT NULL Evaluation Number
    3 EVALUATION_CODE Character(10) VARCHAR2(10) NOT NULL Evaluation Code
    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 DT_RECVD Date(10) DATE Date Received
    8 DT_RECORDED Date(10) DATE Date Recorded
    9 AUDITION_TYPE Character(3) VARCHAR2(3) NOT NULL Audition Type
    DRM=Drama
    MUS=Music
    10 PORTFOLIO_TYPE Character(3) VARCHAR2(3) NOT NULL Portfolio Type
    SCL=Art
    WRT=Writing
    11 ESSAY_TOPIC Character(3) VARCHAR2(3) NOT NULL Essay Topic
    PRS=Personal Statement
    12 GENL_INTVW_TYPE Character(3) VARCHAR2(3) NOT NULL Interview Type
    ALM=Alumni Interview
    STF=Staff Interview
    13 RECOMM_TYPE Character(3) VARCHAR2(3) NOT NULL Recommendation Type
    CNS=Counselor
    DNR=Dean's Report
    EMP=Employer
    FAC=Faculty
    TCH=Teacher
    14 RECOMMENDER_ID Character(11) VARCHAR2(11) NOT NULL Recommender ID
    15 INTERVIEWER Character(11) VARCHAR2(11) NOT NULL Interviewer
    16 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee
    17 NAME Character(50) VARCHAR2(50) NOT NULL Name
    18 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    19 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    20 DESCR_EXT_ORG Character(30) VARCHAR2(30) NOT NULL Org Name