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 |