| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAppraisal, Valuation, and Survey Tool |
| 1 | HRHAP | Appraisal Document | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 2 | HRHAP_ACT_LOG | Appraisal Document: Action Log - Additional Data | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 3 | HRHAP_APPEE | Appraisal Document: Appraisee Assignment | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 4 | HRHAP_APPER | Appraisal Document: Appraiser Assignment | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 5 | HRHAP_BASIC | Appraisal Document: Basic Element Data | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 6 | HRHAP_FINAL | Appraisal Document: Cell Values of Final Appraisal Column | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 7 | HRHAP_FURTHER | App. Document: Cell Values of Additional Particpnts' Column | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 8 | HRHAP_OBJECT | Appraisal Document: Cell Values of Objective Columns | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 9 | HRHAP_OFFLINE | Appraisal Document Offline Lock Table | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 10 | HRHAP_OTHERS | Appraisal Document: Additional Participant Assignment | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 11 | HRHAP_P | Appraisal Document: Reference Appraisal | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 12 | HRHAP_PART | Appraisal Document: Cell Values of Part Appraisal Columns | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 13 | HRHAP_PROCESS | Appraisal Document: Processed Appraisal Functions | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 14 | HRHAP_P_APPER | Appraisal Document: Part Appraiser Assignment | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 15 | HRHAP_P_D | Appraisal Document: Reference Appraisal (Structure) | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 16 | HRHAP_P_E | Appraisal Document: Reference Appraisal (Data) | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 17 | HRHAP_P_T | Reference Appraisal Names | 4 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 18 | HRHAP_T | Appraisal Document Name | 4 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 19 | HRHAP_TAB | Appraisal: WD Tab Configuration | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 20 | HRHAP_TAB_DATA | Appraisal: Layout Configuration Data | 3 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 21 | HRHAP_TAB_T | Appraisal: Tab Configuration Name | 4 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 22 | CACS_TGRIND_AES | Target Agreements: Individual Target Rules for AES | 9 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 23 | CACS_TGRULE_AES | Target Agreements: Generic Target Rules for AES | 7 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| TOPObjective Setting and Appraisals |
| 24 | HRHAP_GOAL_ERROR | Goals: An cascading error occurred in the existing document | 13 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| TOPTalent Management |
| 25 | HRT7408 | Potential | 4 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 26 | HRT7409 | Performance | 4 | APPRAISAL_ID | Appraisal Document ID | nvarchar | 32 | 0 | | |
| 27 | T5TMCMIGPERFPOT | Transferred Performance/Potential Data | 2 | APPRAISAL_ID | UUID in character form | nvarchar | 32 | 0 | | |
