SFA_SLC_HEBSS_D

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SFA_SLC_HEI_CD	Character(4)	VARCHAR2(4) NOT NULL	HEI Code
2	SFA_SLC_ACAD_YR	Character(4)	VARCHAR2(4) NOT NULL	SLC Acad Year
3	SFA_FILE_NAME	Character(128)	VARCHAR2(128) NOT NULL	File Name
4	SFA_SLC_SSN	Character(13)	VARCHAR2(13) NOT NULL	Student Support Nbr
5	SFA_SLC_ISSUE_DT	Date(10)	DATE	Issue Date
6	SFA_SLC_LAST_NAME	Character(50)	VARCHAR2(50) NOT NULL	Last Name
7	SFA_SLC_FIRST_NAME	Character(50)	VARCHAR2(50) NOT NULL	First Name
8	SFA_SLC_ADDR_LINE1	Character(240)	VARCHAR2(240) NOT NULL	Address Line 1
9	SFA_SLC_ADDR_LINE2	Character(240)	VARCHAR2(240) NOT NULL	Address Line 2
10	SFA_SLC_ADDR_LINE3	Character(240)	VARCHAR2(240) NOT NULL	Address Line 3
11	SFA_SLC_CITY	Character(60)	VARCHAR2(60) NOT NULL	City
12	SFA_SLC_COUNTY	Character(60)	VARCHAR2(60) NOT NULL	County
13	SFA_SLC_POST_CD	Character(8)	VARCHAR2(8) NOT NULL	Post Code
14	SFA_SLC_BIRTHDATE	Date(10)	DATE	Date of Birth
15	SFA_SLC_SEX	Character(1)	VARCHAR2(1) NOT NULL	Sex F=Female M=Male
16	SFA_SLC_DOMICILE	Character(30)	VARCHAR2(30) NOT NULL	Domicile
17	SFA_SLC_ART_ID	Character(11)	VARCHAR2(11) NOT NULL	ART ID
18	SFA_SLC_UCAS_NBR	Character(9)	VARCHAR2(9) NOT NULL	UCAS Number
19	SFA_SLC_CRSE_TYPE	Character(11)	VARCHAR2(11) NOT NULL	Course Type
20	SFA_SLC_NBR_SPNSRS	Number(1,0)	SMALLINT NOT NULL	Number of Sponsors
21	SFA_SLC_NMTO_IND	Character(1)	VARCHAR2(1) NOT NULL	Non-Means Test
22	SFA_SLC_CCG_IND	Character(1)	VARCHAR2(1) NOT NULL	Childcare Grant
23	SFA_SLC_ADG_IND	Character(1)	VARCHAR2(1) NOT NULL	Adult Dependent Support
24	SFA_SLC_HSHLD_INC	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Household Income
25	SFA_SLC_HH_INC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Value is blank Y/N Table Edit Default Value: N
26	SFA_SLC_EARNER_INC	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Principle Earner Income
27	SFA_SLC_ELIG_SUPP	Character(12)	VARCHAR2(12) NOT NULL	Student Support Eligibility
28	SFA_SLC_EDIV_VERIF	Character(1)	VARCHAR2(1) NOT NULL	Evidence Verified
29	SFA_SLC_NHS_INC_I	Character(1)	VARCHAR2(1) NOT NULL	Income Assessed Funding
30	SFA_SLC_NHS_NINC_I	Character(1)	VARCHAR2(1) NOT NULL	Non-Income Assessed Funding
31	SFA_SLC_COMMNCE_YR	Character(4)	VARCHAR2(4) NOT NULL	Commencing Year of Study
32	SFA_SLC_CRSE_DESCR	Character(120)	VARCHAR2(120) NOT NULL	Course Name
33	SFA_SLC_COURSE_DT	Date(10)	DATE	Course Start Date
34	SFA_SLC_UCAS_CRSCD	Character(6)	VARCHAR2(6) NOT NULL	UCAS Course Code
35	SFA_SLC_COURSE_CD	Character(15)	VARCHAR2(15) NOT NULL	SLC Course Code
36	SFA_SLC_CRSE_QUAL	Character(8)	VARCHAR2(8) NOT NULL	Qualification
37	SFA_SLC_CAMPUS_CD	Character(1)	VARCHAR2(1) NOT NULL	Campus Code
38	SFA_SLC_MTHD_ATTND	Character(240)	VARCHAR2(240) NOT NULL	Method of Attendance
39	SFA_SLC_BANK_DTL	Character(1)	VARCHAR2(1) NOT NULL	Bank Details Held
40	SFA_SLC_AUTOAWDAMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Automated Award Total
41	SFA_SLC_MAN_AWDAMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Manual Award Total
42	SFA_SLC_OVR_AWDAMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Overall Award Total
43	SFA_SLC_NEW_STDNT	Character(1)	VARCHAR2(1) NOT NULL	New Student
44	SFA_SLC_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Processing Status K=Skip P=Processed S=Suspended U=Unprocessed Default Value: U
45	SFA_SLC_PROC_DTTM	DateTime(26)	TIMESTAMP	Processed Date/Time
46	SFA_SLC_SUSPND_RSN	Character(1)	VARCHAR2(1) NOT NULL	Suspense Reason 1=Student not found 2=Multiple student matches found 3=Match Option set to Suspend 4=SSN linked to another ID 5=ID linked to another SSN
47	MAX_MATCH_LEVEL	Number(3,0)	SMALLINT NOT NULL	Max Search Match Level
48	MATCH_NBR	Number(6,0)	INTEGER NOT NULL	Number of Matches
49	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
50	ID_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	ID Override N=No Y=Yes Y/N Table Edit Default Value: N
51	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
52	SFA_SLC_APPACAD_YR	Character(7)	VARCHAR2(7) NOT NULL	Application Academic Year
53	SFA_SLC_COHRT_YR	Character(20)	VARCHAR2(20) NOT NULL	Cohort Year
54	SFA_SLC_EVID_REQ	Character(3)	VARCHAR2(3) NOT NULL	Evidence Requirement Type CI=Current Year Income N=Full Evidence P=Provisional SC=Self Certified SFA=Single Financial Assessment
55	SFA_SLC_MAINT_GR	Character(1)	VARCHAR2(1) NOT NULL	Maintenance Grant Y/N Table Edit
56	SFA_SLC_SPECSUP_GR	Character(1)	VARCHAR2(1) NOT NULL	Special Support Grant Y/N Table Edit
57	SFA_SLC_PREV_APPD	Character(1)	VARCHAR2(1) NOT NULL	Previously Approved Y/N Table Edit
58	SFA_SLC_FEE_WVRAPR	Number(18,2)	DECIMAL(17,2) NOT NULL	Fee Waiver Approved
59	SFA_SLC_FEE_WVRPRC	Number(18,2)	DECIMAL(17,2) NOT NULL	Fee Waiver Processed
60	SFA_SLC_CARE_LEAVE	Character(1)	VARCHAR2(1) NOT NULL	Care Leaver
61	SFA_SLC_WITHDRAWN	Character(1)	VARCHAR2(1) NOT NULL	Withdrawn Y/N Table Edit
62	SFA_SLC_TRANSFER	Character(1)	VARCHAR2(1) NOT NULL	Transferred Y/N Table Edit
63	SFA_SLC_CANCELLED	Character(1)	VARCHAR2(1) NOT NULL	Cancelled Application Y/N Table Edit
64	SFA_SLC_DELETED	Character(1)	VARCHAR2(1) NOT NULL	Deleted Application Y/N Table Edit
65	SFA_SLC_INDEPNDT	Character(1)	VARCHAR2(1) NOT NULL	Independent Status Y/N Table Edit
66	SFA_SLC_APP_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Application Status
67	SFA_SLC_SPECSUP_EL	Character(1)	VARCHAR2(1) NOT NULL	Special Support Element
68	SFA_SLC_CREDIT_VAL	Number(4,0)	SMALLINT NOT NULL	Credit Value
69	SFA_SLC_INTENSITY	Number(4,0)	SMALLINT NOT NULL	Intensity
70	SFA_SLC_CRSE_YEAR	Number(2,0)	SMALLINT NOT NULL	Course Year