EOCC_TRKATT_H5(SQL Table) |
Index Back |
|---|---|
Archival RecordArchival Record for Attachment Cross Ref Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(18) | VARCHAR2(18) NOT NULL | Component Name | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Market | |
| 3 | Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value | |
| 4 | Character(65) | VARCHAR2(65) NOT NULL | Key 2 Value | |
| 5 | Character(65) | VARCHAR2(65) NOT NULL | Key 3 Value | |
| 6 | Character(65) | VARCHAR2(65) NOT NULL | Key 4 Value | |
| 7 | Character(65) | VARCHAR2(65) NOT NULL | Key 5 Value | |
| 8 | Character(65) | VARCHAR2(65) NOT NULL | Key 6 Value | |
| 9 | Character(65) | VARCHAR2(65) NOT NULL | Key 7 Value | |
| 10 | Character(65) | VARCHAR2(65) NOT NULL | Key 8 Value | |
| 11 | Character(65) | VARCHAR2(65) NOT NULL | Key 9 Value | |
| 12 | Character(65) | VARCHAR2(65) NOT NULL | Key 10 Value | |
| 13 | Character(65) | VARCHAR2(65) NOT NULL | Key 11 Value | |
| 14 | Character(65) | VARCHAR2(65) NOT NULL | Key 12 Value | |
| 15 | Number(31,0) | DECIMAL(31) NOT NULL | Change Tracking Sequence Number | |
| 16 | Character(100) | VARCHAR2(100) NOT NULL | Sequences | |
| 17 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 18 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 19 | EOCC_FILE_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description |
| 20 | EOCC_ATT_DTTM | DateTime(26) | TIMESTAMP | Date/Time Stamp |
| 21 | EOCC_ATT_OPR | Character(30) | VARCHAR2(30) NOT NULL | User |
| 22 | PSARCH_ID | Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 23 | PSARCH_BATCHNUM | Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |