APP_TRNSCRPT_VW(SQL View) |
Index Back |
---|---|
Applicant Transcript ViewThis 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 |