ADM_APP_TRNS_VW

(SQL View)
 Index Back

Admission App Transcripts

This record is a view of the Admission Applicants Material record. It will show key data that reflects External Academic Data records that have a transcript flag of "yes".

select emplid, acad_career, stdnt_car_nbr, adm_appl_nbr, appl_prog_nbr, genl_matl_group, genl_matl_type, genl_matl_nbr, appl_matl_nbr, matl_indicator, matl_usage, used_in_rating, ext_org_id, ext_career, ext_data_nbr from PS_ADM_APPL_MATLS where genl_matl_type = 'TRN'

# 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 USED_IN_RATING Character(1) VARCHAR2(1) NOT NULL Used to Determine Rating
13 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
14 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
15 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr