This table requires activation of Advanced Collections functional area. Stores collector master attributes sourced from AR_COLLECTORS.
Module: Advanced Collections
COLLECTOR_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| COLLECTOR_ID | NUMBER | 38 | 0 | True | Unique identifier of the collector. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| NAME | VARCHAR2 | 32 | Name of the collector. | ||||
| DESCRIPTION | VARCHAR2 | 256 | Description of the collector. | ||||
| RESOURCE_ID | NUMBER | 38 | 0 | Resource identifier for the collector. | |||
| EMPLOYEE_ID | NUMBER | 38 | 0 | Employee assigned to the collector. | DW_PERSON_D | PERSON_ID = PERSON.PersonId | |
| STATUS | VARCHAR2 | 32 | Indicates whether the collector is active. | DW_AC_COLLECTOR_CODE_STATUS_TL | CODE_STATUS_CODE | ||
| SET_ID | NUMBER | 38 | 0 | Reference data set associated with the collector. | |||
| CREATION_DATE | TIMESTAMP | Creation timestamp of the collector record. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Last update timestamp of the collector record. |
Copyright © 2019, 2026, Oracle and/or its affiliates.