PTAI_ITEM_IDPTAI_ATTACH_IDF=File Attachment
PTAI_ATTACH(SQL Table) |
Index Back |
|---|---|
Action Item Attachments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAI_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 2 | PTAI_ATTACH_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Attachment ID |
| 3 | PTAI_ATTACH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Items - Attachment Type
F=File Attachment |
| 4 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 5 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 6 | PTAI_VERSIONID | Number(31,0) | DECIMAL(31) NOT NULL | Version |