HR LOOKUP Table
Stores generic lookup and reference values used across HR systems to standardize codes and their descriptions. Each row represents a single lookup code within a defined lookup type.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CODE |
Lookup code value within the lookup type; uniquely identifies the lookup entry. |
VARCHAR2 |
100 |
DESCRIPTION |
Human-readable description associated with the lookup code. |
VARCHAR2 |
100 |
LOOKUP_TYPE |
High-level lookup category that groups related lookup codes (e.g., status types, reason codes, category identifiers). |
VARCHAR2 |
6 |
TIMESTAMP |
Date and time the lookup record was created or last updated in the source system. |
DATE |