SSR_DSTREV_PS_V

(SQL View)
 Index Back

DEEWR Revision PS View

DEEWR Revision PS View

SELECT A.EMPLID ,A.INSTITUTION ,A.ACAD_CAREER ,A.STDNT_CAR_NBR ,A.ACAD_PROG ,A.SSR_ELEM_307 ,A.SSR_SPECIALSATN_CD ,A.SSR_REF_YEAR ,A.SCC_CHESSN ,A.SEQ_NO ,A.SSR_DEST_SUBMITTED ,A.SSR_DEST_REV_TP_PS ,A.SSR_REV_BIRTHDATE ,A.SSR_REV_SEX_PS ,A.SSR_REV_E316_AUSPS ,A.SSR_REV_ELEM358_PS ,A.SSR_REV_E328_AUSPS ,A.SSR_REV_ATND_MD_PS ,A.SSR_REV_ACDLDAP_PS ,A.SSR_REV_CTY_DST_PS ,A.SSR_REV_YR_ARVL_PS ,A.SSR_REV_LNGCD_PS ,A.SSR_REV_EXMPT_E385 ,A.SSR_REV_DIS_E386PS ,A.SSR_REV_SCHO_TP_PS ,A.SSR_REV_E578_PS ,A.SSR_REV_E579_PS ,A.SSR_DEST_REV_TYPE ,A.SSR_THESIS_SUBM_DT ,A.SSR_RES_CMPL_DT FROM PS_SSR_DEST_REV_PS A WHERE A.SSR_DEST_SUBMITTED IS NOT NULL AND A.SSR_DEST_SUBMITTED = ( SELECT MAX(A1.SSR_DEST_SUBMITTED) FROM PS_SSR_DEST_REV_PS A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SSR_REF_YEAR = A.SSR_REF_YEAR AND A1.EMPLID = A.EMPLID AND A1.ACAD_PROG = A.ACAD_PROG AND A1.ACAD_CAREER = A.ACAD_CAREER AND A1.SSR_ELEM_307 = A.SSR_ELEM_307 AND A1.SSR_SPECIALSATN_CD = A.SSR_SPECIALSATN_CD AND A1.SCC_CHESSN = A.SCC_CHESSN AND A1.STDNT_CAR_NBR = A.STDNT_CAR_NBR ) AND A.SEQ_NO = ( SELECT MAX(A2.SEQ_NO) FROM PS_SSR_DEST_REV_PS A2 WHERE A2.INSTITUTION = A.INSTITUTION AND A2.SSR_REF_YEAR = A.SSR_REF_YEAR AND A2.EMPLID = A.EMPLID AND A2.ACAD_PROG = A.ACAD_PROG AND A2.ACAD_CAREER = A.ACAD_CAREER AND A2.SSR_ELEM_307 = A.SSR_ELEM_307 AND A2.SSR_SPECIALSATN_CD = A.SSR_SPECIALSATN_CD AND A2.SCC_CHESSN = A.SCC_CHESSN AND A2.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND A2.SSR_DEST_SUBMITTED = A.SSR_DEST_SUBMITTED)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SSR_DREV_PS_VW

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 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
4 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
6 SSR_ELEM_307 Character(10) VARCHAR2(10) NOT NULL DEST Element 307
7 SSR_SPECIALSATN_CD Character(8) VARCHAR2(8) NOT NULL Specialisation Code

Prompt Table: SSR_FOS_TBL

8 SSR_REF_YEAR Character(4) VARCHAR2(4) NOT NULL Australia DEST Processing

Prompt Table: SSR_DEST_SET_YR

9 SCC_CHESSN Character(10) VARCHAR2(10) NOT NULL Commonwealth Higher Education Student Support Number (CHESSN)
10 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
11 SSR_DEST_SUBMITTED Date(10) DATE Australia DEST processing
12 SSR_DEST_REV_TP_PS Character(1) VARCHAR2(1) NOT NULL This field contains the codes for revision type used in the DEST feature for PS.
2=Revision
4=Deletion
5=Addition
13 BIRTHDATE Date(10) DATE Date of Birth
14 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
15 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
16 SSR_ELEM_358 Character(1) VARCHAR2(1) NOT NULL DEST Citizen/Resident Code
17 SSR_E328_AUS Date(10) DATE Element E328 - Commencement Date
18 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
19 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
20 SSR_COUNTRY_DEST Character(4) VARCHAR2(4) NOT NULL DEST Country Code
21 SSR_YEAR_ARRIVAL Character(4) VARCHAR2(4) NOT NULL DEST Year Arrival Code
22 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.
23 SSR_EXMPT_E385 Number(2,0) SMALLINT NOT NULL Exemtion Granted
24 SSR_DIS_E386 Character(8) VARCHAR2(8) NOT NULL Element E386
25 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
26 SSR_E578_AUS Number(3,0) SMALLINT NOT NULL Element 578 Completion Percentage
27 SSR_E579_AUS Number(4,0) SMALLINT NOT NULL 579 Joint Degree Partner Higher Education Provider Code
28 SSR_DEST_REV_TYPE Character(1) VARCHAR2(1) NOT NULL Revision Type
1=Remisssion
2=Revision
4=Deletion
5=Addition
29 SSR_THESIS_SUBM_DT Date(10) DATE DEST Thesis Submission Date
30 SSR_RES_CMPL_DT Date(10) DATE DEST Research Completion Date