SSR_DEST_REV_SS(SQL Table) |
Index Back |
---|---|
DEST Scholarship RevisionDEST 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 |