DIMREQTIER¶
This dimension table stores information about the requirements tiers/statuses.
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. |
ISOPEN |
NUMBER | An indication of whether the job requirement tier/status is open type or not. |
MODDATE |
TIMESTAMP_NTZ | The date and time when the job requirement tier/status was modified. |
REQSTATUS |
VARCHAR | The status of a job requirement. |
REQTIERASSOC |
NUMBER | Not used. |
REQTIERID |
NUMBER | The identifier for the job requirement tier/status. |
REQTIERKEY |
NUMBER | The identifier for the job requirement tier/status. |
REQTIERNAME |
VARCHAR | The name of the job requirement tier. |
REQTIERORDER |
NUMBER | The order of the job requirement tier/status. |
REQTIERTYPE |
VARCHAR | The job requirement tier type of open or closed. |
TIERTYPE |
VARCHAR | The type of the tier/status. |