SSR_DEST_SETDTL

(SQL Table)
Index Back

DEST Setup - Year - Half Year

DEST 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