EOAWEMC_PND_LIN (SQL Table)	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.

EOAWEMC_PND_LIN

(SQL Table)

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: EOAWEMC_PND_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier

2 EOAWHTMLFIELDNAME Character(100) VARCHAR2(100) NOT NULL HMTL Field Name

3 EOAW_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

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

6 EOAW_SENT_VALUE Long Character CLOB Sent Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GUID	Character(36)	VARCHAR2(36) NOT NULL	Unique Identifier
2	EOAWHTMLFIELDNAME	Character(100)	VARCHAR2(100) NOT NULL	HMTL Field Name
3	EOAW_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
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	EOAW_SENT_VALUE	Long Character	CLOB	Sent Value