SFA_LN_CROF_VW

(SQL View)
 Index Back

CROF data from loan table

select CROF data from loan table

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.ACAD_CAREER ,B.LN_APPL_ID ,D.SFA_COMMON_SCHL_ID ,A.LOAN_TYPE ,B.ITEM_TYPE ,A.DL_ORIG_FEE ,B.ACCEPT_AMOUNT ,E.LN_DISB_AMT ,E.LN_DISB_AMT_NET ,E.LN_FEE_AMT ,E.LN_REBATE_AMT ,E.LOAN_DISB_DATE FROM PS_LOAN_ORIGNATN A ,PS_LOAN_ORIG_DTL B ,PS_LN_TYPE_TBL C ,PS_SFA_LN_ATT_VW D ,PS_LOAN_DISBMNT E WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.LOAN_TYPE = B.LOAN_TYPE AND A.LN_APPL_SEQ = B.LN_APPL_SEQ AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR = A.AID_YEAR AND C.LOAN_TYPE = A.LOAN_TYPE AND C.LOAN_PROGRAM = 'D' AND C.LOAN_CATEGORY IN ('P', 'S', 'U') AND D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR AND D.ACAD_CAREER = A.ACAD_CAREER AND A.EMPLID = E.EMPLID AND A.INSTITUTION = E.INSTITUTION AND A.AID_YEAR = E.AID_YEAR AND A.ACAD_CAREER = E.ACAD_CAREER AND A.LOAN_TYPE = E.LOAN_TYPE AND A.LN_APPL_SEQ = E.LN_APPL_SEQ AND B.ITEM_TYPE = E.ITEM_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: STDNT_AID_SRCH

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

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

Prompt Table: AID_YEAR_TBL

4 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

Prompt Table: LN_INSTUTN_2_VW

5 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID
6 SFA_COMMON_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Common School ID for use with the Department of Education financial aid.
7 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd

Default Value: LOAN_ORIGNATN.LOAN_TYPE

Prompt Table: LN_TYPE_TBL

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

Prompt Table: LN_ITEM_TBL

9 DL_ORIG_FEE Number(6,3) DECIMAL(5,3) NOT NULL DL Origination Fee %
10 ACCEPT_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Accept Amount
11 LN_DISB_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Loan Disbursement Amt
12 LN_DISB_AMT_NET Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Loan Disbursement
13 LN_FEE_AMT Number(7,2) DECIMAL(6,2) NOT NULL Loan Fee Amount
14 LN_REBATE_AMT Number(7,2) DECIMAL(6,2) NOT NULL Loan Rebate Amt
15 LOAN_DISB_DATE Date(10) DATE Loan Request Dt

Default Value: DISB_ID_TBL.LOAN_DISB_DATE