RBC_RECP_LOG(SQL Table) |
Index Back |
|---|---|
Correspondence AttachmentsCorrespondence Request File Attachments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(36) | VARCHAR2(36) NOT NULL | Correspondence ID | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Correspondence Management Package Sequence Number | |
| 3 | Number(18,0) | DECIMAL(18) NOT NULL | Correspondence Management Package Sequence Number | |
| 4 | Number(9,0) | DECIMAL(9) NOT NULL | History Sequence Number to be used in the History Records | |
| 5 | RB_TEMPLATE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Template ID |
| 6 | CM_ERROR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Correspndence Log Error Type
1=Peoplecode Error 2=SQL Error 3=Token Error 4=FTP Error 5=Other Error 6=Template Error |
| 7 | DATETIME_LOG | DateTime(26) | TIMESTAMP | CM Log Datetime |
| 8 | DESCRLONG | Long Character | CLOB | Long Description |