PTAFEMC_PND_LIN

 index back

Collaborative Emails Pending

This table tracks collaborative emails that have been sent out and are awaiting a response. It keeps a record of every field the implementing application put into the message definition, and it's associated HTML Field Name so that the data can be mapped back in when the response arrives.

  • Parent record: PTAFEMC_PND_HDR

    • PeopleSoft Field Name Field Type Column Type Description
    GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
    PTAFHTMLFIELDNAME Character(100) VARCHAR2(100) NOT NULL HMTL Field Name
    PTAF_ROW_PATH Character(254) VARCHAR2(254) NOT NULL Stored information in the format (N)[RECNAME(N)] which idenitfies the path through a rowset to a specific row
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    PTAF_SENT_VALUE Long Character CLOB Sent Value
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20