SSR_DEST_REV_SS

(SQL Table)
Index Back

DEST Scholarship Revision

DEST Scholarhip Revision 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: SSR_DREV_SS_VW

5 SSR_DEST_SUBMITTED Date(10) DATE Australia DEST processing
6 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
7 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
8 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
9 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
10 SCC_CHESSN Character(10) VARCHAR2(10) NOT NULL Commonwealth Higher Education Student Support Number (CHESSN)
11 SSR_DEST_REV_TP_SS Character(1) VARCHAR2(1) NOT NULL This field contains the codes for revision type used in the DEST feature.
2=Revision
4=Deletion
5=Addition

Default Value: 2

12 SSR_REV_545_CODE Character(1) VARCHAR2(1) NOT NULL Revision Codes for DEST reporting.
1=CECS Education Costs Schlr'shp
2=CAS Accomodation Scholorship
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
13 SSR_REV_538_TERM Character(1) VARCHAR2(1) NOT NULL Element 538 revision termination code for DEST reporting.
0=Scholarship Active
1=Course Complete
2=Full Period Consumed
3=Unsatisfactory Progress
4=No Longer Eligible
14 SSR_REV_526_STAT Character(1) VARCHAR2(1) NOT NULL Element 526 revision status code for DEST reporting
0=Not in Receipt of Scholarship
1=Current Scholarship
2=Deferred Scholarship
3=Terminated Scholarship
4=CAS Indigenous Payment Accept
5=CAS Indigenous Payment Confirm
6=CAS Indigenous Payment Failed
15 SSR_AUTH_OF_EMPLID Character(11) VARCHAR2(11) NOT NULL Authorizing Officer

Prompt Table: PEOPLE_SRCH