GUIDDATASEQNOLOGTYPE1=Request - Original
2=Request - Transformed
3=Response - Original
4=Response - Transformed
PSIBLOGDATAARCH(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 2 | DATASEQNO |
Signed Number(11,0) | DECIMAL(10) NOT NULL | Data Sequence Number |
| 3 | LOGTYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Used to identify which log type:
Request - Original
Request - Transformed
Response - Original
Response - Transformed
1=Request - Original 2=Request - Transformed 3=Response - Original 4=Response - Transformed |
| 4 | COMPDATALEN | Signed Number(11,0) | DECIMAL(10) NOT NULL | Publication Data Length |
| 5 | UNCOMPDATALEN | Signed Number(11,0) | DECIMAL(10) NOT NULL | Publication Data Length |
| 6 | PUBDATALONG | Image / Attachment | CLOB | Publication Data Chunk |