SSR_HM_TCSI_CWS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
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_REPORT_YEAR	Number(4,0)	SMALLINT NOT NULL	Reporting Year
4	SSR_HM_PERIOD	Number(1,0)	SMALLINT NOT NULL	Period
5	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
6	SSR_HM_AWARD_DT	Date(10)	DATE	Award Date
7	SSR_HM_SCHAMT_E598	Number(11,2)	DECIMAL(10,2) NOT NULL	Scholarship Amount E598
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_HM_END_DT	Date(10)	DATE	CS End Date
10	COMMENTS	Long Character	CLOB	Comment
11	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
12	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
13	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
14	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time