OEB_AP_EXP_REPORT_DISTS_ALL
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REPORT_HEADER_ID | BIGINT | 8 |
| 2 | REPORT_LINE_ID | BIGINT | 8 |
| 3 | REPORT_DISTRIBUTION_ID | BIGINT | 8 |
| 4 | ORG_ID | BIGINT | 8 |
| 5 | SEQUENCE_NUM | BIGINT | 8 |
| 6 | LAST_UPDATE_DATE | TIMESTAMP | 8 |
| 7 | LAST_UPDATED_BY | BIGINT | 8 |
| 8 | CREATION_DATE | TIMESTAMP | 8 |
| 9 | CREATED_BY | BIGINT | 8 |
| 10 | LAST_UPDATE_LOGIN | BIGINT | 8 |
| 11 | CODE_COMBINATION_ID | BIGINT | 8 |
| 12 | SEGMENT1 | CHARACTER VARYING(25) | 25 |
| 13 | SEGMENT2 | CHARACTER VARYING(25) | 25 |
| 14 | SEGMENT3 | CHARACTER VARYING(25) | 25 |
| 15 | SEGMENT4 | CHARACTER VARYING(25) | 25 |
| 16 | SEGMENT5 | CHARACTER VARYING(25) | 25 |
| 17 | SEGMENT6 | CHARACTER VARYING(25) | 25 |
| 18 | SEGMENT7 | CHARACTER VARYING(25) | 25 |
| 19 | SEGMENT8 | CHARACTER VARYING(25) | 25 |
| 20 | SEGMENT9 | CHARACTER VARYING(25) | 25 |
| 21 | SEGMENT10 | CHARACTER VARYING(25) | 25 |
| 22 | SEGMENT11 | CHARACTER VARYING(25) | 25 |
| 23 | SEGMENT12 | CHARACTER VARYING(25) | 25 |
| 24 | SEGMENT13 | CHARACTER VARYING(25) | 25 |
| 25 | SEGMENT14 | CHARACTER VARYING(25) | 25 |
| 26 | SEGMENT15 | CHARACTER VARYING(25) | 25 |
| 27 | SEGMENT16 | CHARACTER VARYING(25) | 25 |
| 28 | SEGMENT17 | CHARACTER VARYING(25) | 25 |
| 29 | SEGMENT18 | CHARACTER VARYING(25) | 25 |
| 30 | SEGMENT19 | CHARACTER VARYING(25) | 25 |
| 31 | SEGMENT20 | CHARACTER VARYING(25) | 25 |
| 32 | SEGMENT21 | CHARACTER VARYING(25) | 25 |
| 33 | SEGMENT22 | CHARACTER VARYING(25) | 25 |
| 34 | SEGMENT23 | CHARACTER VARYING(25) | 25 |
| 35 | SEGMENT24 | CHARACTER VARYING(25) | 25 |
| 36 | SEGMENT25 | CHARACTER VARYING(25) | 25 |
| 37 | SEGMENT26 | CHARACTER VARYING(25) | 25 |
| 38 | SEGMENT27 | CHARACTER VARYING(25) | 25 |
| 39 | SEGMENT28 | CHARACTER VARYING(25) | 25 |
| 40 | SEGMENT29 | CHARACTER VARYING(25) | 25 |
| 41 | SEGMENT30 | CHARACTER VARYING(25) | 25 |
| 42 | PREPARER_MODIFIED_FLAG | CHARACTER VARYING(1) | 1 |
| 43 | AMOUNT | NUMERIC(18,6) | 19 |
| 44 | PROJECT_ID | BIGINT | 8 |
| 45 | TASK_ID | BIGINT | 8 |
| 46 | AWARD_ID | BIGINT | 8 |
| 47 | EXPENDITURE_ORGANIZATION_ID | BIGINT | 8 |
| 48 | COST_CENTER | CHARACTER VARYING(25) | 25 |
| 49 | RECEIPT_CURRENCY_CODE | CHARACTER VARYING(15) | 15 |
| 50 | RECEIPT_CONVERSION_RATE | NUMERIC(18,6) | 19 |
| 51 | RECEIPT_CURRENCY_AMOUNT | NUMERIC(18,6) | 19 |
| 52 | WEB_PARAMETER_ID | BIGINT | 8 |
| 53 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 54 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 55 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 56 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |