STDNT_COM_DT_VW

(SQL View)
 Index Back

Student Aid/Communication View

This view selects students from the Communication Table who need an Award Letter.

SELECT DISTINCT a.emplid , b.seq_3c , b.comm_dttm , a.institution , a.aid_year , b.admin_function , b.comm_category , b.comm_context , b.SCC_letter_cd FROM PS_STUDENT_AID a , PS_COMMUNICATION b , PS_VAR_DATA_FINA c WHERE a.emplid = b.common_id AND a.institution = b.institution AND b.admin_function = 'FINA' AND b.completed_dt IS NULL AND b.completed_comm <> 'Y' AND b.common_id = c.common_id AND b.var_data_seq = c.var_data_seq AND c.aid_year = a.aid_year

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
    3 COMM_DTTM DateTime(26) TIMESTAMP Communication DateTime
    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    5 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    6 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
    7 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category
    8 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context
    9 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code