SSR_TSRSLT_AWRD

(SQL Table)
Index Back

Transcript Record

Student Awards - Scholarships and Grants

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr
2 REQUEST_SEQ_NBR Number(5,0) INTEGER NOT NULL Request Seq Nbr
3 REPORT_NUMBER Number(2,0) SMALLINT NOT NULL Report Number
4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
5 PRINT_AREA_CODE Character(2) VARCHAR2(2) NOT NULL Print Area Code
6 SSR_ROWTYPE Character(4) VARCHAR2(4) NOT NULL Transcript Result Row Type
7 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
8 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
9 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
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 DISBURSED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Disbursed Amount
12 ACCEPT_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Accept Amount
13 AWARD_AID_YEAR_PRT Character(1) VARCHAR2(1) NOT NULL Print Aid Year
14 AWARD_AMOUNT_PRT Character(1) VARCHAR2(1) NOT NULL Print Amount
A=Accepted Amount
D=Disbursed Amount