Myleave
From SPGC Document Wiki
auditlogs
| auditlogs | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| LOG_USER | double | 15,2 | No | No | No | |
| LOG_MODULE | varchar | 50 | No | No | No | |
| LOG_DATE | datetime | 0 | No | No | No | |
| LOG_TBL | varchar | 50 | No | No | No | |
| LOG_KEYREC | varchar | 50 | No | No | No | |
| LOG_FIELD | varchar | 25 | No | No | No | |
| LOG_OLDVAL | longtext | 0 | No | No | No | |
| LOG_NEWVAL | longtext | 0 | No | No | No | |
| LOG_CHANGE | varchar | 25 | No | No | No | |
| LOG_SQLEXEC | longtext | 0 | No | No | No | |
| LOG_IPADDR | varchar | 25 | No | No | No | |
| LOG_PRNT | varchar | 25 | No | No | No | |
ccback
| ccback | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| AHSNUMB | Varchar | 15 | No | No | No | |
| AHSGPAY | double | 15,2 | No | No | No | |
| AHSALLO | double | 15,2 | No | No | No | |
| AHS13MO | double | 15,2 | No | No | No | |
| AHSSLVL | double | 15,2 | No | No | No | |
| AHSSVLR | double | 15,2 | No | No | No | |
| AHSBONS | double | 15,2 | No | No | No | |
| AHSTAXD | double | 15,2 | No | No | No | |
| AHSTAXW | double | 15,2 | No | No | No | |
