DIMHIREDENDREASON¶
This dimension table stores information about the placement end reasons.
Columns¶
| Column | Data type | Description |
|---|---|---|
BUILDID |
NUMBER | Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows. |
CUSTOMERKEY |
NUMBER | A foreign key referencing the customer record in the DIMCUSTOMER table. |
ENDREASONID |
NUMBER | The identifier for the placement end reason. |
HIREDENDREASONKEY |
NUMBER | The primary key referring to the placement end reason. |
HIREDENDREASONNAME |
VARCHAR | The name of the placement end reason. |
HIREDENDTYPE |
VARCHAR | The type of the placement end reason. |
ISARCHIVE |
NUMBER | The indication of whether the placement end reason is archived or not. |