INQUIRYOPRIDDefault Value: OPR_DEF_TBL_FS.OPRID
Prompt Table: OPRIDDESC_VW
FO_SNDEMAIL_CRT(SQL Table) |
Index Back |
|---|---|
Sent Email Criteria RecSent Email Inquiry Criteria Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INQUIRY |
Character(10) | VARCHAR2(10) NOT NULL | Inquiry Name |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPRIDDESC_VW |
| 3 | FROM_DATE | Date(10) | DATE | From Date |
| 4 | TO_DATE | Date(10) | DATE | To Date |
| 5 | EMAIL_FROM | Character(254) | VARCHAR2(254) NOT NULL | Email From |
| 6 | EMAIL_TO | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_TO |
| 7 | EMAIL_CC | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_CC |
| 8 | EMAIL_BCC | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_BCC |
| 9 | FO_EMAIL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 10 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |