SSR_DESTWRK_OS(SQL Table) |
Index Back |
---|---|
DEST OS HELP Work Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
|
2 | Character(4) | VARCHAR2(4) NOT NULL | Australia DEST Processing | |
3 | Character(1) | VARCHAR2(1) NOT NULL |
Australia DEST processing
1=First Half Year 2=Second Half Year |
|
4 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
|
5 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table: ACAD_PROG |
|
6 | Character(3) | VARCHAR2(3) NOT NULL | HECS Exempt Status | |
7 | Date(10) | DATE | Australia DEST processing | |
8 | SSF_OS_INCUR_DT | Date(10) | DATE | Revised Incurral Date |
9 | SCC_CHESSN | Character(10) | VARCHAR2(10) NOT NULL | Commonwealth Higher Education Student Support Number (CHESSN) |
10 | SSR_ELEM_307 | Character(10) | VARCHAR2(10) NOT NULL | DEST Element 307 |
11 | SSF_DEST_LOAN | Number(17,2) | DECIMAL(16,2) NOT NULL | Australia DEST processing |
12 | SSF_LOAN_FEE | Number(17,2) | DECIMAL(16,2) NOT NULL | Australia DEST processing |
13 | SSR_DEST_SUBMITTED | Date(10) | DATE | Australia DEST processing |
14 | SSF_OSHELP_CNTRY_P | Character(4) | VARCHAR2(4) NOT NULL | Primary Study Country |
15 | SSF_OSHELP_CNTRY_S | Character(4) | VARCHAR2(4) NOT NULL | Secondary Study Country |
16 | SSR_E582_AUS | Character(4) | VARCHAR2(4) NOT NULL | OS-HELP Language Code |
17 | SSR_E583_AUS | Date(10) | DATE | OS?HELP Language study commencement date |