POQ_ASSESSMENT_QUALS
POQ_ASSESSMENT_QUALS contains all qualifications that are included in an assessment. The qualifications need to be in the same procurement business unit as the assessment. The qualification needs to be valid during the entire life of the assessment.
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
POQ_ASSESSMENT_QUALS_PK |
ASSESSMENT_QUAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ASSESSMENT_QUAL_ID | NUMBER | 18 | Yes | System-generated unique identifier. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| INITIATIVE_ID | NUMBER | 18 | The unique identifier associated with the initiative. | ||
| ASSESSMENT_ID | NUMBER | 18 | Yes | The unique identifier associated with the assessment. | |
| QUALIFICATION_ID | NUMBER | 18 | Yes | The unique identifier associated with the qualification. | |
| REUSED_FLAG | VARCHAR2 | 1 | Flag which specifies if the corresponding qualification was reused from an existing assessment. | ||
| EVALUATION_NOTE | VARCHAR2 | 1000 | Note added by the evaluation team member for each qualification in the assessment. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| POQ_ASSESSMENT_QUALS | poq_assessments | ASSESSMENT_ID |
| POQ_ASSESSMENT_QUALS | poq_initiatives | INITIATIVE_ID |
| POQ_ASSESSMENT_QUALS | poq_qualifications | QUALIFICATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POQ_ASSESSMENT_QUALS_N1 | Non Unique | Default | QUALIFICATION_ID |
| POQ_ASSESSMENT_QUALS_PK | Unique | FUSION_TS_TX_DATA | ASSESSMENT_QUAL_ID |
| POQ_ASSESSMENT_QUALS_U1 | Unique | FUSION_TS_TX_DATA | INITIATIVE_ID, ASSESSMENT_ID, QUALIFICATION_ID |