SCC_CHESSN_AUS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	SCC_CHESSN	Character(10)	VARCHAR2(10) NOT NULL	Commonwealth Higher Education Student Support Number (CHESSN)
4	SCC_CHESSN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	CHESSN Status A=Active C=Suspended P=Provisional
5	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
6	SCC_SLE_USAGE	Number(8,5)	DECIMAL(7,5) NOT NULL	Ordinary Student Learning Entitlement Usage
7	SCC_AT_DT_SLE	Date(10)	DATE	SLE As At Date
8	SCC_ORD_SLE_LIMIT	Number(8,5)	DECIMAL(7,5) NOT NULL	Ordinary SLE Limit
9	SCC_ORD_SLE_BAL	Number(8,5)	DECIMAL(7,5) NOT NULL	Ordinary SLE Balance
10	SCC_FEE_HELP_BAL	Number(10,2)	DECIMAL(9,2) NOT NULL	FEE-HELP Balance
11	SCC_AT_DT_FEE_HELP	Date(10)	DATE	FEE-HELP As At Date
12	SSF_ENTITLE_REQ	Character(1)	VARCHAR2(1) NOT NULL	Entitlement Request Y/N Table Edit Default Value: N
13	SCC_FEE_HELP_LIMIT	Number(10,2)	DECIMAL(9,2) NOT NULL	FEE-HELP Limit
14	SCC_FEE_HELP_USAGE	Number(10,2)	DECIMAL(9,2) NOT NULL	FEE-HELP Usage
15	SCC_AT_DT_OS_HELP	Date(10)	DATE	OS-HELP As At Date
16	SCC_OS_HELP_LIMIT	Number(4,0)	SMALLINT NOT NULL	OS-HELP Limit
17	SCC_OS_HELP_USAGE	Number(4,0)	SMALLINT NOT NULL	OS-HELP Usage
18	SCC_OS_HELP_BAL	Number(4,0)	SMALLINT NOT NULL	OS-HELP Balance
19	SCC_AT_DT_CMNWLTH	Date(10)	DATE	Commonwealth As At Date
20	SCC_ORDINARY_LIM	Number(4,0)	SMALLINT NOT NULL	Ordinary Limit
21	SCC_ORDINARY_USAGE	Number(4,0)	SMALLINT NOT NULL	Ordinary Usage
22	SCC_ORDINARY_BAL	Number(4,0)	SMALLINT NOT NULL	Ordinary Balance
23	SCC_ASSOCIATE_LIM	Number(4,0)	SMALLINT NOT NULL	Associate Limit
24	SCC_ASSOCIATE_USAG	Number(4,0)	SMALLINT NOT NULL	Associate Usage
25	SCC_ASSOCIATE_BAL	Number(4,0)	SMALLINT NOT NULL	Associate Balance
26	SCC_INDIGENOUS_LIM	Number(4,0)	SMALLINT NOT NULL	Indigenous Enabling Limit
27	SCC_INDIGENOUS_USG	Number(4,0)	SMALLINT NOT NULL	Indigenous Enabling Usage
28	SCC_INDIGENOUS_BAL	Number(4,0)	SMALLINT NOT NULL	Indigenous Enabling Balance
29	SCC_IND_SCHL_LIM	Number(4,0)	SMALLINT NOT NULL	ndigenous Access Scholarship Limit
30	SCC_IND_SCHL_USG	Number(4,0)	SMALLINT NOT NULL	Indigenous Access Scholarship Usage
31	SCC_IND_SCHL_BAL	Number(4,0)	SMALLINT NOT NULL	Indigenous Access Scholarship Balance
32	SCC_HELP_LN_USAGE	Number(10,2)	DECIMAL(9,2) NOT NULL	FEE-HELP Usage
33	SCC_HELP_LN_BAL	Number(10,2)	DECIMAL(9,2) NOT NULL	FEE-HELP Balance
34	SCC_HELP_LN_LIMIT	Number(10,2)	DECIMAL(9,2) NOT NULL	FEE-HELP Limit
35	SCC_AT_DT_HELP_LN	Date(10)	DATE	FEE-HELP As At Date