ADM_APP_MATL_VW

(SQL View)
 Index Back

Admission App General Material

This record is a view of the Admission Applicants Material record and the Genl Evaluations record.. It will show data from Genl Materials where its keys match Applicant Material Table.

SELECT a.emplid , a.acad_career , a.stdnt_car_nbr , a.adm_appl_nbr , a.appl_prog_nbr , a.genl_matl_group , a.genl_matl_type , a.genl_matl_nbr , a.appl_matl_nbr , a.matl_indicator , a.matl_usage , b.dt_recvd , b.dt_recorded , b.audition_type , b.portfolio_type , b.essay_topic , b.genl_intvw_type , b.recomm_type , b.recommender_id , b.interviewer , b.committee_id , b.name , b.title , b.ext_org_id , b.org_location , b.descr_ext_org , b.country , b.address1 , b.address2 , b.address3 , b.address4 , b.city , b.num1 , b.num2 , b.house_type , b.addr_field1 , b.addr_field2 , b.addr_field3 , b.county , b.state , b.postal , b.geo_code , b.in_city_limit , b.country_code , b.phone FROM ps_adm_appl_matls A , PS_GENL_MATERIALS B WHERE A.emplid = B.emplid 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: ADMAPPMATLVWLNG

    • # 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 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
    6 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group
    7 GENL_MATL_TYPE Character(3) VARCHAR2(3) NOT NULL Material Type
    8 GENL_MATL_NBR Number(3,0) SMALLINT NOT NULL Material Nbr
    9 APPL_MATL_NBR Number(3,0) SMALLINT NOT NULL Appl Matl Nbr
    10 MATL_INDICATOR Character(1) VARCHAR2(1) NOT NULL Material Indicator
    11 MATL_USAGE Character(4) VARCHAR2(4) NOT NULL Material Usage
    BOTH=Both
    COMP=Completion
    EVAL=Evaluation
    12 DT_RECVD Date(10) DATE Date Received
    13 DT_RECORDED Date(10) DATE Date Recorded
    14 AUDITION_TYPE Character(3) VARCHAR2(3) NOT NULL Audition Type
    DRM=Drama
    MUS=Music
    15 PORTFOLIO_TYPE Character(3) VARCHAR2(3) NOT NULL Portfolio Type
    SCL=Art
    WRT=Writing
    16 ESSAY_TOPIC Character(3) VARCHAR2(3) NOT NULL Essay Topic
    PRS=Personal Statement
    17 GENL_INTVW_TYPE Character(3) VARCHAR2(3) NOT NULL Interview Type
    ALM=Alumni Interview
    STF=Staff Interview
    18 RECOMM_TYPE Character(3) VARCHAR2(3) NOT NULL Recommendation Type
    CNS=Counselor
    DNR=Dean's Report
    EMP=Employer
    FAC=Faculty
    TCH=Teacher
    19 RECOMMENDER_ID Character(11) VARCHAR2(11) NOT NULL Recommender ID
    20 INTERVIEWER Character(11) VARCHAR2(11) NOT NULL Interviewer
    21 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee
    22 NAME Character(50) VARCHAR2(50) NOT NULL Name
    23 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    24 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    25 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr
    26 DESCR_EXT_ORG Character(30) VARCHAR2(30) NOT NULL Org Name
    27 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    28 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    29 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    30 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    31 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    32 CITY Character(30) VARCHAR2(30) NOT NULL City
    33 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    34 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    35 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    36 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    37 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    38 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    39 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    40 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    41 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    42 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    43 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    44 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    45 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone