SFA_RUN_EDMSOVR

(SQL Table)
 Index Back

SFA Run User Edit Messages

Update, Insert or Delete Edit Messages using Pop Select.

  • Parent record: SFA_RUN_EDITMSG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

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

    Prompt Table: FA_EDIT_MSG_VW

    7 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: SFA_AY_TERM_VW

    8 FA_MSG_ACTION Character(1) VARCHAR2(1) NOT NULL Edit Message Action
    1=No Action Taken
    2=Resolved
    3=Action Pending

    Default Value: 1

    9 SFA_MSG_ACTION_TO Character(1) VARCHAR2(1) NOT NULL Edit Message Action
    1=No Action Taken
    2=Resolved
    3=Action Pending
    10 EDIT_PROCESS Character(8) VARCHAR2(8) NOT NULL User Edit Process
    11 COMMENTS Long Character CLOB Comment