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 NameField TypeColumn TypeDescription
    GUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
    PTAFHTMLFIELDNAMECharacter(100)VARCHAR2(100) NOT NULLHMTL Field Name
    PTAF_ROW_PATHCharacter(254)VARCHAR2(254) NOT NULLStored information in the format (N)[RECNAME(N)] which idenitfies the path through a rowset to a specific row
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    PTAF_SENT_VALUELong CharacterCLOBSent Value
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19