SSF_INXAID_TMP

(SQL Table)
Index Back

Ant FA Temp Table

The Anticipated Financial Aid work table - used to print XMLP Invoices.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: STUDENT_AID

5 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: DISB_ID_TBL

6 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: ITEM_TYPE_FA

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 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan
9 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
10 ITEM_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Item Type Description
11 SSF_CAR_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Career Descr Short
12 DISB_EXPIRE_DT Date(10) DATE Disbursement Expire Date
13 FA_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
F=Federal
G=Government
I=Institutional
O=Other
P=Private
S=State
14 FA_SOURCE_DSCRSHRT Character(10) VARCHAR2(10) NOT NULL Fund Source
15 NET_AWARD_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Award Amount
16 TERM_DESCR Character(10) VARCHAR2(10) NOT NULL Term Descr