SSR_DSTREV_SS_V (SQL View)	Index Back
DEST Revision SS View DEST Revision SS View

SSR_DSTREV_SS_V

(SQL View)

DEST Revision SS View

SELECT A.INSTITUTION , A.SSR_REF_YEAR , A.SSR_REF_YR_HALF , A.EMPLID , A.SSR_DEST_SUBMITTED , A.SEQ_NO , A.SSR_ELEM_545_CODE , A.SSR_ELEM_526_STAT , A.SSR_ELEM_538_TERM , A.SSR_DEST_REV_TP_SS , A.SSR_AUTH_OF_EMPLID FROM PS_SSR_DEST_REV_SS A WHERE A.SSR_DEST_SUBMITTED IS NOT NULL AND A.SSR_DEST_SUBMITTED = ( SELECT MAX(A1.SSR_DEST_SUBMITTED) FROM PS_SSR_DEST_REV_SS A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SSR_REF_YEAR = A.SSR_REF_YEAR AND A1.SSR_REF_YR_HALF = A.SSR_REF_YR_HALF AND A1.EMPLID = A.EMPLID AND A1.SSR_ELEM_545_CODE=A.SSR_ELEM_545_CODE AND A1.SSR_ELEM_526_STAT=A.SSR_ELEM_526_STAT AND A1.SSR_ELEM_538_TERM=A.SSR_ELEM_538_TERM) AND A.SEQ_NO = ( SELECT MAX(A2.SEQ_NO) FROM PS_SSR_DEST_REV_SS A2 WHERE A2.INSTITUTION = A.INSTITUTION AND A2.SSR_REF_YEAR = A.SSR_REF_YEAR AND A2.SSR_REF_YR_HALF = A.SSR_REF_YR_HALF AND A2.EMPLID = A.EMPLID AND A2.SSR_ELEM_545_CODE = A.SSR_ELEM_545_CODE AND A2.SSR_ELEM_526_STAT = A.SSR_ELEM_526_STAT AND A2.SSR_ELEM_538_TERM = A.SSR_ELEM_538_TERM AND A2.SSR_DEST_SUBMITTED = A.SSR_DEST_SUBMITTED)

# 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 NOT NULL Australia DEST processing

6 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
Default Value: 1

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 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

11 SSR_AUTH_OF_EMPLID Character(11) VARCHAR2(11) NOT NULL Authorizing Officer

#	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 NOT NULL	Australia DEST processing
6	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
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	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
11	SSR_AUTH_OF_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Authorizing Officer