APPL_MATL_VW(SQL View) |
Index Back |
---|---|
Applicant Material ViewThis table provides a view of all General Materials for a person that have not been linked to that persons Application. |
select D.Emplid, D.Acad_Career, D.Stdnt_Car_Nbr, D.Adm_Appl_Nbr, D.Appl_Prog_Nbr, 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_adm_app_car_seq D where A.Emplid = D.Emplid and Not Exists (select 'X' from ps_adm_appl_matls B where A.Emplid = B.Emplid and B.Acad_Career = D.Acad_Career and B.Stdnt_Car_Nbr = D.Stdnt_Car_Nbr and B.Adm_Appl_Nbr = D.Adm_Appl_Nbr and B.Appl_Prog_Nbr = D.Appl_Prog_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) |
# | 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 | DT_RECVD | Date(10) | DATE | Date Received |
10 | DT_RECORDED | Date(10) | DATE | Date Recorded |
11 | AUDITION_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Audition Type
DRM=Drama MUS=Music |
12 | PORTFOLIO_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Portfolio Type
SCL=Art WRT=Writing |
13 | ESSAY_TOPIC | Character(3) | VARCHAR2(3) NOT NULL |
Essay Topic
PRS=Personal Statement |
14 | GENL_INTVW_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Interview Type
ALM=Alumni Interview STF=Staff Interview |
15 | RECOMM_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Recommendation Type
CNS=Counselor DNR=Dean's Report EMP=Employer FAC=Faculty TCH=Teacher |
16 | RECOMMENDER_ID | Character(11) | VARCHAR2(11) NOT NULL | Recommender ID |
17 | INTERVIEWER | Character(11) | VARCHAR2(11) NOT NULL | Interviewer |
18 | COMMITTEE_ID | Character(6) | VARCHAR2(6) NOT NULL | Committee |
19 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
20 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
21 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
22 | DESCR_EXT_ORG | Character(30) | VARCHAR2(30) NOT NULL | Org Name |