| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PIQDBAGR_ADDATTR | Appraisal - Add Attributes | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 2 | PIQDBAGR_APPEE | Appraisee | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 3 | PIQDBAGR_APPR | Appraisal | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 4 | PIQDBAGR_APPSER | Appraiser | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 5 | PIQDBAGR_ASSIGNM | Appraisal: Appraised Object | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 6 | PIQDBAGR_ELEMENT | Appraisal Element | 3 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 7 | PIQDBAGR_FOLL_UP | Appraisal Additional Data | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 8 | PIQDBAGR_GEN | DB Table for Appraisals | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 9 | PIQDBAGR_NOTE | Appraisal Notes | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 10 | PIQDBAGR_TEXT | Appraisal (Description) | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 11 | PIQDBAPPR_AUD1 | Audit: Result Folder for Sub(Requirement) | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 12 | PIQDBAPPR_AUD2 | Audit: Result Storage (Yes/No) | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 13 | PIQDBAPPR_AUD3 | (Sub)Requirement: Applicable Academic Work | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 14 | PIQDBAPPR_AUD4 | Audit: Result Storage (Yes/No) | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 15 | PIQDBAPPR_AUD5 | Audit: Result Folder for Calculation | 2 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 16 | PIQDBAUDR1 | Audit: Result Assignment | 4 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 17 | PIQDBAUDR2 | Audit: Result Assignment to Subrequirement | 5 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 18 | PIQDBCMPRRECORDS | Assessment Process | 20 | AGRID | Appraisal ID | nvarchar | 32 | 0 | ||
| 19 | PIQPROC_PG_MB | Activity Document: Module Booking | 19 | AGRID | Appraisal ID | nvarchar | 32 | 0 |