SAD_APL_PRG_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
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
6	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: SAD_APL_DAT_STG.INSTITUTION Prompt Table: INST_CAR_SCTY
7	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Default Value: OPR_DEF_TBL_CS.ACAD_PROG Prompt Table: SAD_APP_PRG_VW
8	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
9	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
10	ACTION_DT	Date(10)	DATE	Action Date Default Value: %date
11	PROG_REASON	Character(4)	VARCHAR2(4) NOT NULL	Action Reason Prompt Table: PROG_RSN_TBL
12	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Admit Term Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: TERM_TBL
13	EXP_GRAD_TERM	Character(4)	VARCHAR2(4) NOT NULL	Expected Graduation Term Prompt Table: TERM_TBL
14	REQ_TERM	Character(4)	VARCHAR2(4) NOT NULL	Requirement Term Default Value: ACAD_PROG.ADMIT_TERM Prompt Table: TERM_TBL
15	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 Default Value: F
16	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus Prompt Table: %EDITTABLE
17	ACAD_PROG_DUAL	Character(5)	VARCHAR2(5) NOT NULL	Dual Academic Program Prompt Table: ACAD_PROG_TBL
18	JOINT_PROG_APPR	Character(1)	VARCHAR2(1) NOT NULL	Joint Program Approved Y/N Table Edit Default Value: N
19	SSR_RS_CANDIT_NBR	Character(12)	VARCHAR2(12) NOT NULL	Last Candidate Number
20	SSR_APT_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Academic Progress Tracker Instance Number
21	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 Default Value: 01
22	SSR_SHIFT	Character(12)	VARCHAR2(12) NOT NULL	Academic Shift Prompt Table: %EDITTABLE3
23	SSR_COHORT_ID	Character(12)	VARCHAR2(12) NOT NULL	Cohort Tag Prompt Table: SSR_COHORT_TBL
24	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
25	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
26	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
27	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time