ACAD_LEVEL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL
2	LEVEL_LOAD_RULE	Character(5)	VARCHAR2(5) NOT NULL	Academic Level Rule Prompt Table: LVL_LD_RULE_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	UNT_CUM_TOTAL	Number(9,3)	DECIMAL(8,3) NOT NULL	Cum Units/Terms
5	ACADEMIC_LEVEL	Character(3)	VARCHAR2(3) NOT NULL	Academic Level 00=Not Set 01=First Year 02=Second Year 03=Third Year 04=Fourth Year 05=Fifth Year 06=Sixth Year 10=Freshman 20=Sophomore 30=Junior 40=Senior 50=Post-Bacc Undergraduate GR=Graduate GRA=Graduate AUS HON=Honours IE=Industrial Experience MAS=Masters P1=Professional Year 1 P2=Professional Year 2 P3=Professional Year 3 P4=Professional Year 4 PHD=PhD
6	NSLDS_LOAN_YEAR	Character(1)	VARCHAR2(1) NOT NULL	NSLDS Loan Year 0=1st Year - Never Attended 1=1st Year - Previously Attended 2=2nd Year 3=3rd Year 4=4th Year 5=5th Year+ A=1st Year Graduate B=2nd Year Graduate C=3rd Year Graduate D=4th or more Graduate G=Graduate/Professional
7	DIR_LND_YR	Character(2)	VARCHAR2(2) NOT NULL	Direct Lending Year 01=First Year,never attended 02=First Year,previously attnd 03=Second Year 04=Third Year 05=Fourth Year 06=Fifth Year+ Undergrad 07=First Yr, Grad/Prof 08=Second Yr, Grad/Prof 09=Third Yr, Grad/Prof 10=Fourth Yr+,Grad/Prof
8	SSR_NSC_CRD_LVL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify the NSC Class Credential Level for the NSC report. A=Associate's Degree B=Bachelor's Degree C=Certificate - Undergraduate D=Doctoral Degree F=Freshman G=Unspecified-Grad/Professional J=Junior L=Professional M=Master's Degree N=Unspecified-Undergraduate P=Postdoctorate R=Senior S=Sophomore T=Post baccalaureate certificate Prompt Table: SSR_XLAT_NSC2VW