| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CPD/D_PFP_PH | Plan Header | 6 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
2 | /CPD/PFP_HEADER | Database Table for Plan Header | 4 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
3 | /IAM/D_I_ROOT | Root node DB table | 76 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
4 | HRHAPCN_OBJ_LOG | Object Library: Action Log - Additional Data | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
5 | HRHAPCN_OBJ_MSG | Object Library: Additional Message | 3 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
TOPAppraisal, Valuation, and Survey Tool |
6 | HRHAP | Appraisal Document | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
7 | HRHAP_ACT_LOG | Appraisal Document: Action Log - Additional Data | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
8 | HRHAP_ANON | Appraisal Document: Anonymous Appraiser Assignments | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
9 | HRHAP_APPEE | Appraisal Document: Appraisee Assignment | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
10 | HRHAP_APPER | Appraisal Document: Appraiser Assignment | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
11 | HRHAP_BASIC | Appraisal Document: Basic Element Data | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
12 | HRHAP_EL_CONF | UI Configurations for an Appraisal Element | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
13 | HRHAP_FINAL | Appraisal Document: Cell Values of Final Appraisal Column | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
14 | HRHAP_FURTHER | App. Document: Cell Values of Additional Particpnts' Column | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
15 | HRHAP_OBJECT | Appraisal Document: Cell Values of Objective Columns | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
16 | HRHAP_OFFLINE | Appraisal Document Offline Lock Table | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
17 | HRHAP_OTHERS | Appraisal Document: Additional Participant Assignment | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
18 | HRHAP_P | Appraisal Document: Reference Appraisal | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
19 | HRHAP_PART | Appraisal Document: Cell Values of Part Appraisal Columns | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
20 | HRHAP_PROCESS | Appraisal Document: Processed Appraisal Functions | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
21 | HRHAP_P_APPER | Appraisal Document: Part Appraiser Assignment | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
22 | HRHAP_P_D | Appraisal Document: Reference Appraisal (Structure) | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
23 | HRHAP_P_E | Appraisal Document: Reference Appraisal (Data) | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
24 | HRHAP_P_T | Reference Appraisal Names | 3 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
25 | HRHAP_T | Appraisal Document Name | 3 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
26 | HRHAP_TAB | Appraisal: WD Tab Configuration | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
27 | HRHAP_TAB_DATA | Appraisal: Layout Configuration Data | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
28 | HRHAP_TAB_T | Appraisal: Tab Configuration Name | 3 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
29 | T77HAP_ASSIGN | External Objectes Assigned to Template Elements | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
TOPObjective Setting and Appraisals |
30 | HRHAP_GOAL_ERROR | Goals: An cascading error occurred in the existing document | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
31 | HRHAP_VA_CLL_USE | Sources and Targets for Reuse | 2 | PLAN_VERSION | Plan Version | nvarchar | 2 | 0 | | |
TOPTravel Planning |
32 | FTPT_PLANHISTORY | General Plan Data | 5 | PLAN_VERSION | Travel Plan Version Number (Sequential Number) | nvarchar | 2 | 0 | | |