SSR_DEST_SETDTL(SQL Table) |
Index Back |
---|---|
DEST Setup - Year - Half YearDEST Setup - Year - Half Year |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: SSR_DEST_SETUP |
2 | SSR_REF_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Australia DEST Processing
Prompt Table: SSR_DEST_SET_YR |
3 | SSR_REF_YR_HALF | Character(1) | VARCHAR2(1) NOT NULL |
Australia DEST processing
1=First Half Year 2=Second Half Year |
4 | SSR_DEST_SUB | Number(5,0) | INTEGER NOT NULL |
Australia DEST processing
Default Value: 1 |
5 | SSR_DEST_SUB_SS | Number(5,0) | INTEGER NOT NULL |
This field contains the scholarship submission number used in DEST reporting.
Default Value: 1 |
6 | SSR_DEST_SUB_OS | Number(5,0) | INTEGER NOT NULL |
This field contains the DEST OS file help submission number used for DEST reporting.
Default Value: 1 |
7 | SSR_DEST_SUB_PS | Number(5,0) | INTEGER NOT NULL |
This field contains the DEEWR PS file help submission number used for DEEWR reporting.
Default Value: 1 |
8 | SSR_DEST_SUB_SA | Number(5,0) | INTEGER NOT NULL |
This field contains the DEEWR PS file help submission number used for DEEWR reporting.
Default Value: 1 |