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)