ADM_APPL_PROGVW

(SQL View)
 Index Back

Admission Applicant Program

This Admission Applicant Program Table view is used to propagate changes made to the Student Records Academic Program stack to the Admissions Application stack. Changes are copied only if the Academic Program originated from the Admissions stack.

SELECT emplid , acad_career , stdnt_car_nbr , adm_appl_nbr , appl_prog_nbr , effdt , effseq , institution , acad_prog , prog_status , prog_action , action_dt , prog_reason , admit_term , exp_grad_term , req_term , acad_load_appr , campus , acad_prog_dual , joint_prog_appr , SSR_RS_CANDIT_NBR , SSR_APT_INSTANCE , SSR_YR_OF_PROG , SSR_SHIFT , SSR_COHORT_ID , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_ADM_APPL_PROG

# 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

Prompt Table: STDNT_CAREER

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

Prompt Table: ADM_APPL_DATA

5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

Prompt Table: ADM_APP_CAR_SEQ

6 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INST_CAR_SCTY

9 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Default Value: OPR_DEF_TBL_CS.ACAD_PROG

Prompt Table: ACAD_PROG_CARVW

10 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted
11 PROG_ACTION Character(4) VARCHAR2(4) NOT NULL Program Action
ACTV=Activate
ADMT=Admit
ADRV=Admission Revocation
APPL=Application
COMP=Completion of Program
COND=Conditional Admit
DATA=Data Change
DDEF=Defer Decision
DEFR=Defer Enrollment
DEIN=Intention to Matriculate
DENY=Deny
DISC=Discontinuation
DISM=Dismissal
LEAV=Leave of Absence
MATR=Matriculation
PLNC=Plan Change
PRGC=Program Change
RADM=Readmit
RAPP=Readmit Application
RECN=Reconsideration
REVK=Revoke Degree
RLOA=Return from Leave of Absence
SPND=Suspension
TRAN=Transfer to Other Career
VDIS=Voluntarily Discontinued
WADM=Administrative Withdrawal
WAIT=Waitlist
WAOF=Waitlist Offer
WAPP=Applicant Withdrawal

Prompt Table: ADM_ACTION_SCTY

12 ACTION_DT Date(10) DATE Action Date

Default Value: %date

13 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason

Prompt Table: PROG_RSN_TBL

14 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

Default Value: OPR_DEF_TBL_CS.STRM

Prompt Table: TERM_TBL

15 EXP_GRAD_TERM Character(4) VARCHAR2(4) NOT NULL Expected Graduation Term

Prompt Table: TERM_TBL

16 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term

Default Value: ACAD_PROG.ADMIT_TERM

Prompt Table: TERM_TBL

17 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
18 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

Default Value: OPR_DEF_TBL_CS.CAMPUS

Prompt Table: CAMPUS_TBL

19 ACAD_PROG_DUAL Character(5) VARCHAR2(5) NOT NULL Dual Academic Program

Prompt Table: ACAD_PROG_SCTY

20 JOINT_PROG_APPR Character(1) VARCHAR2(1) NOT NULL Joint Program Approved

Y/N Table Edit

Default Value: N

21 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number
22 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
23 SSR_YR_OF_PROG Character(4) VARCHAR2(4) NOT NULL Year of Program
00=Not Set
01=01 - First Year
02=02 - Second Year
03=03 - Third Year
04=04 - Fourth Year
05=05 - Fifth Year
06=06 - Sixth Year
24 SSR_SHIFT Character(12) VARCHAR2(12) NOT NULL Academic Shift
25 SSR_COHORT_ID Character(12) VARCHAR2(12) NOT NULL Cohort Tag
26 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
27 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
28 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
29 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time