EOAWEMC_PND_HDR

(SQL Table)
Index Back

Pending Collaborative Emails

This table keeps a record of collaborative emails that have been sent out and are awaiting a response.

  • Parent Record Of EOAWEMC_PND_LIN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
    2 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
    3 EOAW_DATETIME_SENT DateTime(26) TIMESTAMP NOT NULL Datetime Sent
    4 EOAW_SENT_TO Character(254) VARCHAR2(254) NOT NULL Sent to
    5 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    6 COMPLETE_FLAG Character(1) VARCHAR2(1) NOT NULL Complete Flag

    Y/N Table Edit

    Default Value: N

    7 EOAWEMC_SENTTO_CHK Character(1) VARCHAR2(1) NOT NULL Sent-to Security Check

    Y/N Table Edit

    Default Value: N