INST_REPORT_VW

(SQL View)
Index Back

IM App Load Summary VW

This is a view which can be used for IM application load reporting.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.APP_SOURCE_CODE , B.NAME , C.NATIONAL_ID , A.DT_APP_RECEIVED , A.DT_APP_COMPLETED , A.SIGNED_BY_APPLICNT , A.SIGNED_BY_FATHER , A.SIGNED_BY_MOTHER , A.SIGNED_BY_SPOUSE , A.SPECIAL_PROCESSING , A.INAS_RFC_CALL , A.CSS_ID , A.CSS_SCHOOL_CODE , A.CPS_SCHOOL_CODE , A.CNAS_RFC_CALL , A.SIGNED_ELECTRONIC , A.DT_APP_LOADED , D.NUMBER_EXEMPTIONS , D.NUM_FAMILY_MEMBERS FROM PS_INST_CONTROL A , PS_HCR_PERSON_NM_I B , PS_HCR_PER_NID_I C , PS_INST_STUDENT D WHERE B.EMPLID = A.EMPLID AND C.EMPLID = B.EMPLID AND D.EMPLID = A.EMPLID AND D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR AND D.APP_SOURCE_CODE = A.APP_SOURCE_CODE

  • Parent record: STUDENT_AID
  • # 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: STUDENT_AID

    4 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Electronic Renewal Aplication
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    7 DT_APP_RECEIVED Date(10) DATE Date Application Received

    Default Value: %date

    8 DT_APP_COMPLETED Date(10) DATE Date Application Completed
    9 SIGNED_BY_APPLICNT Character(1) VARCHAR2(1) NOT NULL Student Signed
    1=Yes
    2=No
    10 SIGNED_BY_FATHER Character(1) VARCHAR2(1) NOT NULL Father Signed
    1=Yes
    11 SIGNED_BY_MOTHER Character(1) VARCHAR2(1) NOT NULL Mother Signed
    1=Yes
    12 SIGNED_BY_SPOUSE Character(1) VARCHAR2(1) NOT NULL Spouse Signed
    1=Yes
    13 SPECIAL_PROCESSING Character(1) VARCHAR2(1) NOT NULL Special Circumstances
    1=Yes
    N=No
    Y=Yes
    14 INAS_RFC_CALL Character(1) VARCHAR2(1) NOT NULL Calc EFC via Remote Call
    N=No
    Y=Yes
    15 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    16 CSS_SCHOOL_CODE Character(4) VARCHAR2(4) NOT NULL CSS School Code
    17 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    18 CNAS_RFC_CALL Character(1) VARCHAR2(1) NOT NULL Call CNAS via RFC
    19 SIGNED_ELECTRONIC Character(1) VARCHAR2(1) NOT NULL Electronic Signature
    1=Yes
    20 DT_APP_LOADED Date(10) DATE Date Application Loaded
    21 NUMBER_EXEMPTIONS Character(2) VARCHAR2(2) NOT NULL Nbr of Exemptions
    00=00
    01=01
    02=02
    03=03
    04=04
    05=05
    06=06
    07=07
    08=08
    09=09
    1=1
    10=10
    11=11
    12=12
    2=2
    3=3
    4=4
    5=5
    6=6
    7=7
    8=8
    9=9
    ?=?
    22 NUM_FAMILY_MEMBERS Character(2) VARCHAR2(2) NOT NULL Nbr in Family