HRS_EMAIL_SETUP_IDMCF_EMAIL_IDHRS_EMAIL_RES_PARTHRS_ERESPART_PT(SQL View) |
Index Back |
|---|
| SELECT A.HRS_EMAIL_SETUP_ID , A.MCF_EMAIL_ID , B.MCF_EMAIL_PARTNO , B.MCF_FILENAME , B.MCF_CONTENT_TYPE FROM PS_HRS_AL_LOG_MAIL A , PS_MCFEM_MAIL_PART B WHERE A.MCF_EMAIL_ID=B.MCF_EMAIL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_EMAIL_SETUP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Email Setup ID |
| 2 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 3 | HRS_EMAIL_RES_PART |
Number(3,0) | SMALLINT NOT NULL | Resume Part |
| 4 | MCF_FILENAME | Character(80) | VARCHAR2(80) NOT NULL | Filename |
| 5 | MCF_CONTENT_TYPE | Character(254) | VARCHAR2(254) NOT NULL | Content Type |