GUIDN=
Y=
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
PTAFEMC_PND_HDR(SQL Table) |
Index Back |
|---|---|
Pending Collaborative EmailsThis table keeps a record of collaborative emails that have been sent out and are awaiting a response. |
| # | 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 | PTAF_DATETIME_SENT | DateTime(26) | TIMESTAMP NOT NULL | Datetime Sent |
| 4 | PTAF_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 |
Activity Completed
N= Y= Y/N Table Edit Default Value: N |
| 7 | PTAFEMC_SENTTO_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Sent-to Security Check
Y/N Table Edit Default Value: N |