| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAppraisal, Valuation, and Survey Tool |
1 | HRHAP_BASIC | Appraisal Document: Basic Element Data | 4 | ROW_IID | Internal Row ID (Fixed - Foreign Key for Cell Tables) | nvarchar | 4 | 0 | | |
2 | HRHAP_FINAL | Appraisal Document: Cell Values of Final Appraisal Column | 4 | ROW_IID | Internal Row ID (Fixed - Foreign Key for Cell Tables) | nvarchar | 4 | 0 | | |
3 | HRHAP_FURTHER | App. Document: Cell Values of Additional Particpnts' Column | 4 | ROW_IID | Internal Row ID (Fixed - Foreign Key for Cell Tables) | nvarchar | 4 | 0 | | |
4 | HRHAP_OBJECT | Appraisal Document: Cell Values of Objective Columns | 4 | ROW_IID | Internal Row ID (Fixed - Foreign Key for Cell Tables) | nvarchar | 4 | 0 | | |
5 | HRHAP_PART | Appraisal Document: Cell Values of Part Appraisal Columns | 4 | ROW_IID | Internal Row ID (Fixed - Foreign Key for Cell Tables) | nvarchar | 4 | 0 | | |
6 | HRHAP_P_D | Appraisal Document: Reference Appraisal (Structure) | 4 | ROW_IID | Internal Row ID (Fixed - Foreign Key for Cell Tables) | nvarchar | 4 | 0 | | |
7 | HRHAP_P_E | Appraisal Document: Reference Appraisal (Data) | 4 | ROW_IID | Internal Row ID (Fixed - Foreign Key for Cell Tables) | nvarchar | 4 | 0 | | |
8 | HRHAP_TAB_DATA | Appraisal: Layout Configuration Data | 4 | ROW_IID | Internal Row ID (Fixed - Foreign Key for Cell Tables) | nvarchar | 4 | 0 | | |