POQ_INITIATIVES
POQ_INITIATIVES stores initiatives created in the context of a procurement business unit. Each row consists of an initiative owner, type of initiative such as assessment or qualification, initiative launch date, initiative completion date. It also stores qualification model in case of the assessment type of an initiative.
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
POQ_INITIATIVES_PK |
INITIATIVE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INITIATIVE_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. | |
| CREATION_SOURCE | VARCHAR2 | 30 | Indicates the creation source of the initiative. | ||
| INITIATIVE_NUMBER | VARCHAR2 | 30 | Yes | The number that is assigned to the initiative. | |
| TITLE | VARCHAR2 | 80 | Yes | The title that is assigned to the initiative. | |
| DESCRIPTION | VARCHAR2 | 250 | A description of the initiative. | ||
| STATUS | VARCHAR2 | 30 | Yes | Indicates the status of the initiative. | |
| TYPE | VARCHAR2 | 30 | Yes | Type of the Initiative (ASSESSMENT or QUALIFICATION). | |
| INITIATIVE_USAGE_CODE | VARCHAR2 | 30 | Identifies whether the initiative is of type Qualification or Checklist. Default is Qualification. Lookup type: ORA_POQ_ENTITY_USAGE. Possible values are ORA_QUALIFICATION and ORA_CHECKLIST. | ||
| PRC_BU_ID | NUMBER | 18 | Yes | Procurement business unit identifier associated with the initiative. | |
| OWNER_ID | NUMBER | 18 | Yes | Person id of the Initiative owner. | |
| INTERNAL_NOTE | VARCHAR2 | 4000 | Internal Notes for the Initiative. | ||
| QUAL_MODEL_ID | NUMBER | 18 | Qualification model id for the Assessment initiative. | ||
| ASSESSMENT_OWNER_ID | NUMBER | 18 | Person Id of the Assessment Owner. | ||
| ASSESSMENT_EVAL_DUE_DATE | DATE | Assessment Evaluation Due Date for the Assessment Initiative. | |||
| REUSE_ACTIVE_QUAL_FLAG | VARCHAR2 | 1 | Flag indicating whether existing qualifications, if any, can be reused for Assessment Initiative. | ||
| LAUNCH_DATE | TIMESTAMP | Date on which Initiative is launched. | |||
| COMPLETED_DATE | TIMESTAMP | Initiative process completed date. | |||
| COMPLETED_BY | NUMBER | 18 | The id of the user who completed the checklist. This field is applicable only for checklist. | ||
| CANCELED_DATE | TIMESTAMP | The date and time when the initiative was canceled. | |||
| CANCELED_BY | NUMBER | 18 | The id of the user who canceled the initiative. The initiative could be canceled directly or an action on a related entity led to the cancelation of the entity. | ||
| CANCELED_REASON_CODE | VARCHAR2 | 1000 | The reason for cancelation of the initiative. This is specified by the user if the initiative is canceled directly or a system populated reason if the initiative was canceled due to action on a related entity. | ||
| REOPEN_DATE | TIMESTAMP | The date and time when the checklist is opened. If a checklist is reopened multiple times, only the last date is recorded here. This field is applicable only for checklist. | |||
| REOPENED_BY | NUMBER | 18 | The id of the user who opened the checklist. If a checklist is reopened multiple times, only the last user detail is recorded here. This field is applicable only for checklist. | ||
| REOPEN_REASON | VARCHAR2 | 1000 | The reason specified by the user for opening of the checklist. If a checklist is reopened multiple times, only the last reason is recorded here. This field is applicable only for checklist. | ||
| AUTO_ACCEPT_RESPONSES_FLAG | VARCHAR2 | 1 | Specifies whether to accept questionnaire responses automatically. | ||
| AUTO_POPULATE_RESPONSES_FLAG | VARCHAR2 | 1 | Specifies whether to default responses from the response repository. | ||
| LAST_OVERDUE_REMINDER_DATE | TIMESTAMP | The last time a reminder notification was sent for an internal response which was overdue or pending for this initiative. | |||
| LAST_OVERDUE_RMNDR_DATE_SUP | TIMESTAMP | The last time a reminder notification was sent for an external response which was overdue or pending for this initiative. | |||
| INITIATIVE_SURVEY_FLAG | VARCHAR2 | 1 | Yes | This flag will determine whether this is a survey initiative or not. When selected, this will allow responses for multiple internal responders to be used for evaluation of the qualification. | |
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| POQ_INITIATIVES | poq_qual_models | QUAL_MODEL_ID |
| POQ_INITIATIVES | per_persons | OWNER_ID |
| poq_evaluation_team | poq_initiatives | INITIATIVE_ID |
| poq_initiative_suppliers | poq_initiatives | INITIATIVE_ID |
| poq_init_qual_areas | poq_initiatives | INITIATIVE_ID |
| poq_qualifications | poq_initiatives | INITIATIVE_ID |
| poq_questnaires | poq_initiatives | INITIATIVE_ID |
| poq_questnaire_resp_headers | poq_initiatives | INITIATIVE_ID |
| poq_assessments | poq_initiatives | INITIATIVE_ID |
| poq_questnaires_b | poq_initiatives | INITIATIVE_ID |
| poq_assessment_quals | poq_initiatives | INITIATIVE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| POQ_INITIATIVES_N1 | Non Unique | Default | UPPER("TITLE") | |
| POQ_INITIATIVES_N2 | Non Unique | Default | STATUS, OWNER_ID, PRC_BU_ID, LAUNCH_DATE | |
| POQ_INITIATIVES_N3 | Non Unique | Default | OWNER_ID | |
| POQ_INITIATIVES_N4 | Non Unique | Default | UPPER("INITIATIVE_NUMBER") | |
| POQ_INITIATIVES_N5 | Non Unique | Default | INITIATIVE_NUMBER, PRC_BU_ID, INITIATIVE_USAGE_CODE | |
| POQ_INITIATIVES_PK | Unique | Default | INITIATIVE_ID | |
| POQ_INITIATIVES_U1 | Unique | Default | INITIATIVE_NUMBER, PRC_BU_ID | Obsolete |