FAN_SUMM_VW

(SQL View)
 Index Back

Student Aid/People Data View

STDNT_AID_SRCH is the main financial aid application search record. It provides the user with a list box of only students that are on the Student Aid table for the year selected. The list box will also provide identifying information from the Personal_Data table.

SELECT DISTINCT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,B.COMM_DTTM ,D.FORM_PROC_INST ,D.FORM_COLLATE_KEY ,D.FORM_GROUP_ID FROM PS_STUDENT_AID A , PS_COMMUNICATION B , PS_AID_YEAR_TBL AY , PS_VAR_DATA_FINA C , PS_FORM_COLLATEGRP D , PS_FORM_DATA E , PS_FORM_DATA F WHERE B.COMMON_ID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.ADMIN_FUNCTION = 'FINA' AND AY.INSTITUTION = A.INSTITUTION AND AY.AID_YEAR = A.AID_YEAR AND C.COMMON_ID = B.COMMON_ID AND C.VAR_DATA_SEQ = B.VAR_DATA_SEQ AND C.AID_YEAR = A.AID_YEAR AND D.FORM_INPUT_INST = B.PROCESS_INSTANCE AND E.FORM_PROC_INST = D.FORM_PROC_INST AND E.FORM_GROUP_SEQ = D.FORM_GROUP_SEQ AND E.FORM_FIELD_NAME = 'ID' AND E.FORM_FIELD_C040 = C.COMMON_ID AND F.FORM_PROC_INST = E.FORM_PROC_INST AND F.FORM_GROUP_SEQ = E.FORM_GROUP_SEQ AND F.FORM_GROUP_SUB_SEQ = E.FORM_GROUP_SUB_SEQ AND F.FORM_FIELD_NAME = 'AID_YEAR_DESCR' AND F.FORM_FIELD_C040 = AY.DESCR

  • 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: PEOPLE_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 COMM_DTTM DateTime(26) TIMESTAMP Communication DateTime
    5 FORM_PROC_INST Number(31,0) DECIMAL(31) NOT NULL Form Process Instance collects one or more input jobs (or process instances) into a single output collection for processing. Typically, one form process instance is one batch of output to be printed together.
    6 FORM_COLLATE_KEY Character(250) VARCHAR2(250) NOT NULL Form Collate Key is the overall sort order key for the output of a set of forms, typically within a single FORM_PROC_INST.
    7 FORM_GROUP_ID Character(18) VARCHAR2(18) NOT NULL Form Group ID groups forms together.