DOCUMENT TYPE Table
Stores reference data defining document types used across systems. Each row represents a unique document type identifier and its associated description.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DOCUMENT_TYPE_DESCRIPTION |
Short descriptive name of the document type associated with the document type identifier. |
VARCHAR2 |
25 |
DOCUMENT_TYPE_ID |
Business identifier code representing the document type as defined by the source system. |
VARCHAR2 |
3 |
DOCUMENT_TYPE_KEY |
Primary key uniquely identifying the document type record within the warehouse. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse for auditing and data lineage purposes. |
DATE |