| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
SSR_YEAR_ARRIVAL |
Character(4) |
VARCHAR2(4) NOT NULL |
DEST Year Arrival Code
|
| 3 |
SSR_PERM_RES_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
DEST Permanent Resident Code
0=Perm/Res status 0
1=Perm/Res status 1
2=Perm/Res status 2
3=Perm/Res status 3
7=Perm/Res status 7
Default Value: 0
|
| 4 |
SSR_PRI_PG_PROG |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Graduate Program
0=Not a commencing student
1=Never commenced
2=Commenced, not completed
3=Completed all requirements
9=No information
|
| 5 |
SSR_LANG_SPEAK_HME |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Spoken at Home
Prompt Table:
LANGUAGE_VW
|
| 6 |
SSR_PRI_PG_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Post Graduate Year
|
| 7 |
SSR_PRI_DEGR_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Degree Program
0=Not a commencing student
1=Never commenced
2=Commenced, not completed
3=Completed all requirements
9=No information
|
| 8 |
SSR_PRI_DP_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Prior Degree Program Year
|
| 9 |
SSR_PRI_NT_SD_PROG |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-TAFE Sub-Degree Program
0=Not a commencing student
1=Never commenced
2=Commenced, not completed
3=Completed all requirements
9=No information
|
| 10 |
SSR_PRI_NT_SD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Non-TAFE Sub-Degree Year
|
| 11 |
SSR_PRI_TAF_SD_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
TAFE Sub-Degree Program
0=Not a commencing student
1=Never Commenced
2=Commenced, not completed
3=Completed all requirements
9=No information
|
| 12 |
SSR_PRI_TAF_SD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
TAFE Sub-Degree Year
|
| 13 |
SSR_PRI_TAF_AWDPRG |
Character(1) |
VARCHAR2(1) NOT NULL |
TAFE Award Program
0=Not a commencing student
1=Never commenced
2=Commenced, not completed
3=Completed all requirements
9=No information
|
| 14 |
SSR_PRI_TAF_AWD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
TAFE Award Year
|
| 15 |
SSR_PRI_TAF_SECPRG |
Character(1) |
VARCHAR2(1) NOT NULL |
TAFE Secondary Program
0=Not a commencing student
1=Didn't begin/complete
2=Completed such a course
9=No information
|
| 16 |
SSR_PRI_TAF_SEC_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
TAFE Secondary Year
|
| 17 |
SSR_PRI_SCHSEC_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
School Secondary Program
0=Not a commencing student
1=Did not do final year
2=Completed final year
9=No information
|
| 18 |
SSR_PRI_SCH_SEC_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
School Secondary Year
|
| 19 |
SSR_PRI_OTHER_PROG |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Program
0=Not a commencing student
1=No other qualifications/certs
2=Other qualifications/certs
9=No information
|
| 20 |
SSR_PRI_OTHER_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Other Program Year
|
| 21 |
SSR_COMMENCE_E476 |
Character(5) |
VARCHAR2(5) NOT NULL |
Commencing Location
|
| 22 |
SSR_SUBURB_E486 |
Character(27) |
VARCHAR2(27) NOT NULL |
Name of Suburb/Town/Locality
|
| 23 |
SCC_ATTEND_YEAR12 |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator as to whether a person attended Year 12 at an Australian high school.
A=Attended Year 12
D=Did Not Attend Year 12
U=Unknown
|
| 24 |
SCC_ATTEND_PRV_HEP |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator as to whether a person attended a previous HEP (Higher Education Provider).
A=Attended Previous Hep
D=Did Not Attend Previous Hep
U=Unknown
|
| 25 |
SCC_CHESSN_CONSENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to show that student has given consent for personal data details to be sent to the Higher Education Information Management System to obtain a CHESSN.
N=Consent Denied
U=Consent not yet sought
Y=Consent Received
Default Value: U
|
| 26 |
SSR_GENDR_PARENT1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender Parent/Guardian 1
F=Female
M=Male
N=Not Applicable
|
| 27 |
SSR_HIGHST_EDU1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Edu Parent Guardian 1
Prompt Table:
SSR_DEEWR_E1_VW
|
| 28 |
SSR_GENDR_PARENT2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender Parent/Guardian 2
F=Female
M=Male
N=Not Applicable
|
| 29 |
SSR_HIGHST_EDU2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Edu Parent Guardian 2
Prompt Table:
SSR_DEEWR_E2_VW
|
| 30 |
SSR_LEVEL_LEFT_SCH |
Character(2) |
VARCHAR2(2) NOT NULL |
HEIMS E612
10=Year 10
11=Year 11
12=Year 12
9=Year 9
99=Highest level unknown
Default Value: 99
|
| 31 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 32 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 33 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 34 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|