SSR_DESTWRK2_PS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SSR_REF_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Australia DEST Processing Prompt Table: SSR_DEST_SET_YR
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	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
5	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr
6	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
7	SSR_ELEM_307	Character(10)	VARCHAR2(10) NOT NULL	DEST Element 307
8	SSR_SPECIALSATN_CD	Character(8)	VARCHAR2(8) NOT NULL	Specialisation Code Prompt Table: SSR_FOS_TBL
9	SCC_CHESSN	Character(10)	VARCHAR2(10) NOT NULL	Commonwealth Higher Education Student Support Number (CHESSN)
10	BIRTHDATE	Date(10)	DATE	Date of Birth
11	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
12	SSR_E316_AUS	Character(1)	VARCHAR2(1) NOT NULL	ATSI Code 2=Non Indigenous 3=Aboriginal 4=Torres Strait Islander 5=Aboriginal & Torres Strait Isl 9=No Information
13	SSR_ELEM_358	Character(1)	VARCHAR2(1) NOT NULL	DEST Citizen/Resident Code
14	SSR_E328_AUS	Date(10)	DATE	Element E328 - Commencement Date
15	SAD_ATTEND_MODE	Character(1)	VARCHAR2(1) NOT NULL	Mode of Attendance 1=Internal Mode of Attendance 2=External Mode of Attendance 3=Multi-modal Mode of Attendance 4=Completed Course through OUA 5=Submission of Original Work 6=Employer based 7=Completed Course except in OUA
16	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
17	SSR_COUNTRY_DEST	Character(4)	VARCHAR2(4) NOT NULL	DEST Country Code
18	SSR_YEAR_ARRIVAL	Character(4)	VARCHAR2(4) NOT NULL	DEST Year Arrival Code
19	SSR_LANG_CD_DEST	Character(4)	VARCHAR2(4) NOT NULL	This field holds the Language Codes specified by the Department of Education, Training and Youth Affairs in Australia.
20	SSR_EXMPT_E385	Number(2,0)	SMALLINT NOT NULL	Exemtion Granted
21	SSR_DIS_E386	Character(8)	VARCHAR2(8) NOT NULL	Element E386
22	SSR_SCHOL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Scholarship Type field is reported in DEST Liability Status file Element 487. 00=None/Not reported to DEST 01=Australian Postgraduate Award 02=Internatnl Postgrad Res Schol 03=Cmwlth Education Costs Schol 04=Cmwlth Accommodation Schol 05=Both CECS and CAS 06=Indigenous Staff Scholarship 07=APA and IPRS 09=RTP Fees Offset 10=RTP Stipend 11=RTP Allowance
23	SSR_E578_AUS	Number(3,0)	SMALLINT NOT NULL	Element 578 Completion Percentage
24	SSR_E579_AUS	Number(4,0)	SMALLINT NOT NULL	579 Joint Degree Partner Higher Education Provider Code
25	SSR_THESIS_SUBM_DT	Date(10)	DATE	DEST Thesis Submission Date
26	SSR_RES_CMPL_DT	Date(10)	DATE	DEST Research Completion Date