SSR_DESTWRK_SS

(SQL Table)
Index Back

DEST SS Work Record

SS Work Record for DEST

# 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_545_CODE Character(1) VARCHAR2(1) NOT NULL Commonwealth Learning Scholarship code
1=CECS Education Costs Schol'shp
2=CAS Accommodation Scholarship
3=CECS Associate Degree
4=CAS Associate Degree
5=CECS Indigenous Enabling
6=CAS Indigenous Enabling
7=Indigenous Access
7=CAS Indigenous Payment
8=National Priority
9=National Accommodation
A=Indigenous Education
B=Indigenous Accommodation
C=Indigenous Reward
6 SSR_ELEM_526_STAT Character(1) VARCHAR2(1) NOT NULL Commonwealth Learning Scholarship status code
0=Not in receipt of CLS
0=Not in Receipt of Scholarship
1=Current CLS
1=Current Scholarship
2=Deferred Scholarship
2=Deferred CLS
3=Terminated Scholarship
3=Terminated CLS
4=CAS Indigenous Payment Accept
5=CAS Indigenous Payment Confirm
6=CAS Indigenous Payment Failed
7=Offered Scholarship
7 SCC_CHESSN Character(10) VARCHAR2(10) NOT NULL Commonwealth Higher Education Student Support Number (CHESSN)
8 SSR_ELEM_538_TERM Character(1) VARCHAR2(1) NOT NULL Commonwealth Learning Scholarship termination code
0=Scholarship Active
1=Course Complete
2=Full Period Consumed
3=Unsatisfactory Progress
4=No Longer Eligible
5=Failed to comply with Sch Cond
9 SSR_DEST_SUBMITTED Date(10) DATE Australia DEST processing