SSR_DEST_OS_TMP(SQL Table) |
Index Back |
---|---|
DEST OS HELP Work Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | SSR_REF_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Australia DEST Processing |
3 | SSR_REF_YR_HALF | Character(1) | VARCHAR2(1) NOT NULL |
Australia DEST processing
1=First Half Year 2=Second Half Year |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
5 | SSR_ELEM_307 | Character(10) | VARCHAR2(10) NOT NULL | DEST Element 307 |
6 | SSR_HECS_XMPT_STAT | Character(3) | VARCHAR2(3) NOT NULL | HECS Exempt Status |
7 | SSR_DU_OS_HELP | Character(1) | VARCHAR2(1) NOT NULL | Australia DEST processing |
8 | SCC_CHESSN | Character(10) | VARCHAR2(10) NOT NULL | Commonwealth Higher Education Student Support Number (CHESSN) |