SSR_TRANS_IDSSR_CORRELATION_IDF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
2=Non-indigenous
3=Of Aboriginal but not Torres
4=Of Torres but not Aboriginal
5=Both Aboriginal and Torres
9=No information
SSR_HM_STUDENT(SQL Table) |
Index Back |
|---|---|
StudentStudent |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_TRANS_ID |
Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Transaction ID |
| 2 | SSR_CORRELATION_ID |
Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Correlation ID |
| 3 | SSR_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | SSR_MAP_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Map ID |
| 5 | SSR_MESSAGE_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Message ID |
| 6 | SSR_STDNT_ID_CODE | Character(10) | VARCHAR2(10) NOT NULL | Student ID |
| 7 | SSR_STDNT_BRTHDATE | Date(10) | DATE | Student Date of Birth |
| 8 | SSR_STDNT_FAM_NM | Character(40) | VARCHAR2(40) NOT NULL | Student Family Name |
| 9 | SSR_STDNT_GVN_NM_F | Character(40) | VARCHAR2(40) NOT NULL | Student First Given Name |
| 10 | SSR_STDNT_GVN_NM_O | Character(40) | VARCHAR2(40) NOT NULL | Student Other Given Names |
| 11 | SSR_STDNT_RES_ST | Character(254) | VARCHAR2(254) NOT NULL | Student Residential Address - Street |
| 12 | SSR_STDNT_RES_SUB | Character(48) | VARCHAR2(48) NOT NULL | Student Residential Address - Suburb |
| 13 | SSR_STDNT_RES_STAT | Character(3) | VARCHAR2(3) NOT NULL | Student Residential Address - State |
| 14 | SSR_STDNT_RES_CTRY | Character(4) | VARCHAR2(4) NOT NULL | Student Residential Address - Country |
| 15 | SSR_STDNT_RES_POST | Character(4) | VARCHAR2(4) NOT NULL | Student Residential Address - Postcode |
| 16 | SSR_STDNT_TFN | Character(9) | VARCHAR2(9) NOT NULL | Student Tax File Number |
| 17 | SSR_STDNT_CHESSN | Character(10) | VARCHAR2(10) NOT NULL | Commonwealth Higher Education Student Support Number (CHESSN) |
| 18 | SSR_STDNT_USI | Character(10) | VARCHAR2(10) NOT NULL | Unique Student Identifier (USI) |
| 19 | SSR_STDNT_GENDER | Character(1) | VARCHAR2(1) NOT NULL |
Student Gender Code
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 20 | SSR_STDNT_ATSI | Character(1) | VARCHAR2(1) NOT NULL |
Aboriginal and Torres Strait Islander Code (ATSI)
2=Non-indigenous 3=Of Aboriginal but not Torres 4=Of Torres but not Aboriginal 5=Both Aboriginal and Torres 9=No information |
| 21 | SSR_STDNT_BRTHCTRY | Character(4) | VARCHAR2(4) NOT NULL | Student Country of Birth |
| 22 | SSR_STDNT_YR_ARRIV | Character(4) | VARCHAR2(4) NOT NULL | Student Year of Arrival |
| 23 | SSR_STDNT_LNG_HOME | Character(4) | VARCHAR2(4) NOT NULL | Language Spoken at Home |
| 24 | SSR_STDNT_YR_LEFT | Character(4) | VARCHAR2(4) NOT NULL | Student Year Left School |
| 25 | SSR_STDNT_LVL_LEFT | Character(2) | VARCHAR2(2) NOT NULL | Student Level Left School |
| 26 | SSR_STDNT_HGH_EDU1 | Character(2) | VARCHAR2(2) NOT NULL | HIghest Education Attainment of Parent/Guardian 1 |
| 27 | SSR_STDNT_HGH_EDU2 | Character(2) | VARCHAR2(2) NOT NULL | HIghest Education Attainment of Parent/Guardian 2 |
| 28 | SSR_STDNT_TRM_CTRY | Character(4) | VARCHAR2(4) NOT NULL | Student Term Address - Country |
| 29 | SSR_STDNT_TRM_POST | Character(4) | VARCHAR2(4) NOT NULL | Student Term Address - Postcode |
| 30 | IB_RESTMETHOD | Character(10) | VARCHAR2(10) NOT NULL | REST Method |
| 31 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 32 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 33 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 34 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 35 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |