APP_TRNSCRPT_VW

(SQL View)
Index Back

Applicant Transcript View

This table provides a view of all the External Academic Records that have a transcript flag of 'Y' for a person that has not been linked to that persons Application.

SELECT A.Emplid , A.Acad_Career , A.Stdnt_Car_Nbr , A.Adm_Appl_Nbr , A.Appl_Prog_Nbr , D.Institution , D.Genl_Matl_Group , B.Ext_Org_Id , B.Ext_Career , B.Ext_Data_Nbr FROM ps_adm_app_car_seq A , PS_EXT_ACAD_DATA B , ps_matl_grp_tbl D WHERE A.Emplid = B.Emplid AND B.Transcript_Flag = 'R' AND NOT EXISTS ( SELECT 'X' FROM ps_adm_appl_matls C WHERE A.Emplid = C.Emplid AND A.Acad_Career = C.Acad_Career AND A.Stdnt_Car_Nbr = C.Stdnt_Car_Nbr AND A.Adm_Appl_Nbr = C.Adm_Appl_Nbr AND A.Appl_Prog_Nbr = C.Appl_Prog_Nbr AND D.Genl_Matl_Group = C.Genl_Matl_Group AND B.Emplid = C.Emplid AND B.Ext_Org_Id = C.Ext_Org_Id AND B.Ext_Career = C.Ext_Career AND B.Ext_Data_Nbr = C.Ext_Data_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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

7 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group
8 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
9 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
10 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr