SSR_HM_SCHL_AMT

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_ALL

2 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

3 SSR_HM_AWARD_DT Date(10) DATE NOT NULL Award Date

4 SSR_HM_REPORT_YEAR Number(4,0) SMALLINT NOT NULL Reporting Year

5 SSR_HM_PERIOD Number(1,0) SMALLINT NOT NULL Period

6 SSR_HM_SCHAMT_E598 Number(11,2) DECIMAL(10,2) NOT NULL Scholarship Amount E598

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_ALL
2	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
3	SSR_HM_AWARD_DT	Date(10)	DATE NOT NULL	Award Date
4	SSR_HM_REPORT_YEAR	Number(4,0)	SMALLINT NOT NULL	Reporting Year
5	SSR_HM_PERIOD	Number(1,0)	SMALLINT NOT NULL	Period
6	SSR_HM_SCHAMT_E598	Number(11,2)	DECIMAL(10,2) NOT NULL	Scholarship Amount E598