SSR_DEST_CU_WRK

(SQL Table)
Index Back

Temp record for srdestcu.sqr

srdestcu.sqr is the Unit of Study Completions file sqr for DEST reporting. This temp record is used internally to the sqr only.

# 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
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 SSR_ELEM_307 Character(10) VARCHAR2(10) NOT NULL DEST Element 307
5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
6 CENSUS_DT Date(10) DATE Census Date
7 SCC_CHESSN Character(10) VARCHAR2(10) NOT NULL Commonwealth Higher Education Student Support Number (CHESSN)
8 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
9 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
10 STRM Character(4) VARCHAR2(4) NOT NULL Term