OBJECTIDPSSUMMARYTBL(SQL Table) |
Index Back |
|---|---|
SUMMARY TABLEUsing in LongEditBox in version 8.0. Default table to store link file information, working with PSDETAILTBL to provide linked document information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJECTID |
Number(10,0) | DECIMAL(10) NOT NULL | Object ID |
| 2 | APP_TBL_NAME | Character(64) | VARCHAR2(64) NOT NULL | Application table name |
| 3 | REC_OBJ_ID | Character(32) | VARCHAR2(32) NOT NULL | record object id |
| 4 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 5 | FILE_SIZE | Number(10,0) | DECIMAL(10) NOT NULL | Physical File Size |
| 6 | COMPRESS_SIZE | Number(10,0) | DECIMAL(10) NOT NULL | Compress File Size |
| 7 | LAST_MODIFIED_DATE | DateTime(26) | TIMESTAMP | Last modified date |
| 8 | TEMP_DOC | Character(1) | VARCHAR2(1) NOT NULL | Temporary Document |