SCC_CHSNAUS_STG

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