STDNT_FA_MSG_VW

(SQL View)
 Index Back

Stdnt Fin Aid Edit Msgs

STDNT_FA_MSG_VW is a view to STDNT_FA_MSGS used on the page SS_FA_AU_STATUS, View FA Status.

SELECT EMPLID ,INSTITUTION ,AID_YEAR ,EDIT_MSG_TYPE ,EDIT_MSG_CD ,FA_MSG_DTTIME ,STRM ,FA_MSG_ACTION ,EDIT_PROCESS ,COMPLETED_DT ,OPRID ,COMMENTS FROM PS_STDNT_FA_MSGS

  • 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: STUDENT_AID

    4 EDIT_MSG_TYPE Character(1) VARCHAR2(1) NOT NULL Edit Message Type
    E=Error
    I=Informational
    W=Warning
    5 EDIT_MSG_CD Character(6) VARCHAR2(6) NOT NULL Edit Message Code

    Prompt Table: FA_EDIT_MSG_TBL

    6 FA_MSG_DTTIME DateTime(26) TIMESTAMP NOT NULL FA Message Date/Time
    7 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    8 FA_MSG_ACTION Character(1) VARCHAR2(1) NOT NULL Edit Message Action
    1=No Action Taken
    2=Resolved
    3=Action Pending
    9 EDIT_PROCESS Character(8) VARCHAR2(8) NOT NULL User Edit Process
    10 COMPLETED_DT Date(10) DATE Date Activity Completed
    11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    12 COMMENTS Long Character CLOB Comment