R_FANLTR_STD_VW

(SQL View)
 Index Back

Work Table - FAN Student Data

View of R_FANLTR_STDNT, which stores data printed on the Financial Aid Award Notification letter.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.SCC_LETTER_CD , A.SEQ_NUM , A.DTTM_STAMP , A.ACAD_CAREER , A.AWARD_PERIOD , A.PARENTS_CONTRIB , A.STUDENTS_CONTRIB , A.TOTAL_EFC , A.AID_OFFERED , A.OTHER_RSRC , A.TOTAL_NEED , A.TOTAL_UNMET , A.RESIDENCY , A.PRINT_STATUS , A.UPDATE_STATUS , A.NAME FROM PS_R_FANLTR_STDNT A

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

4 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
6 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
8 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard
9 PARENTS_CONTRIB Signed Number(11,0) DECIMAL(10) NOT NULL Parents Contribution
10 STUDENTS_CONTRIB Signed Number(7,0) DECIMAL(6) NOT NULL Students Contribution
11 TOTAL_EFC Number(6,0) INTEGER NOT NULL Total Family Contribution
12 AID_OFFERED Number(12,2) DECIMAL(11,2) NOT NULL Total Aid Offered
13 OTHER_RSRC Number(9,2) DECIMAL(8,2) NOT NULL Other Resource
14 TOTAL_NEED Number(9,2) DECIMAL(8,2) NOT NULL Total Financial Need
15 TOTAL_UNMET Number(12,2) DECIMAL(11,2) NOT NULL Total Unmet Financial Need
16 RESIDENCY Character(5) VARCHAR2(5) NOT NULL Residency
17 PRINT_STATUS Character(1) VARCHAR2(1) NOT NULL Use for printing
N=Never Printed
P=Previously Printed
18 UPDATE_STATUS Character(1) VARCHAR2(1) NOT NULL Update Status
19 NAME Character(50) VARCHAR2(50) NOT NULL Name