PJR_ENTERPRISE_IMPL_OPTION
Create and maintain PJR Implementation Options.
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJR_ENTERPRISE_IMPL_OPTION_PK |
ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | Enterprise identifier of implementation options that apply across Oracle Fusion Project Resource Management. | |
| SUBTRACT_PTO_ABS_FLAG | VARCHAR2 | 1 | Option that, when selected, will subtract absences and paid time off from total capacity in resource utilization calculations. | ||
| PROJ_RESOURCE_REQ_FLAG | VARCHAR2 | 1 | Option that, when selected, enables project resource request workflow to notify the staffing owner of a project resource request when the request is submitted for fulfillment. | ||
| PROJ_RESOURCE_REQ_CANCEL_FLAG | VARCHAR2 | 1 | Option that, when selected, enables project resource request workflow to notify the participants that a project resource request is canceled by the staffing owner. | ||
| PROJ_RESOURCE_PROP_FLAG | VARCHAR2 | 1 | Option that, when selected, enables project resource approval workflow to require requester approval when a resource is proposed to fulfill a project resource request. | ||
| PROJ_ASSIGN_NOTIFY_FLAG | VARCHAR2 | 1 | Option that, when selected, enables project resource approval workflow to send notification to the resource when a resource assignment is confirmed, updated or cancelled. | ||
| ENTERPRISE_PERCENTAGE | NUMBER | Yes | Percentage from 0 to 100 that defines the default target utilization percentage for the enterprise. | ||
| ALLOW_REQ_ASG_DTS_OUTSIDE_PRJ | VARCHAR2 | 1 | Yes | Indicates if project resource request or assignment is allowed to have start date before project start date and/or end date after project end date, basically allowing a project resource request or assignment to be outside of its project dates on either end. | |
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| SEC_RES_FLAG | VARCHAR2 | 1 | Option that when selected, secures resources from project resource pools across Oracle Fusion Project Resource Management. | ||
| ACT_HRS_SRC | VARCHAR2 | 64 | Source of actual hours. A value of 'ORA_PJR_PROJECT_COSTING' indicates that the source of actual hours is Oracle Fusion Project Costing Application.'ORA_PJR_SPREADSHEET_IMPORT' indicates that the source is a spreadsheet. | ||
| REQUEST_FULFILLMENT_MODE | VARCHAR2 | 5 | Implementation option that indicates how resource requests can be fulfilled. NP indicates that requests can be fulfilled either by nominating or proposing resources. N indicates that requests can only be fulfilled by nominating resources. | ||
| AVAILABILITY_SCORE_SOURCE | VARCHAR2 | 30 | Type of assignment data for calculating the availability score. The possible values are All assignments and nonproject event, Billable assignment only, and Billable assignments and nonproject events. | ||
| ALLOW_OVERBOOK_BILLABLE_ASSIGN | VARCHAR2 | 1 | Indicates if overbooking of billable assignments is allowed. | ||
| RESOURCE_REJECT_REASON_CODE | VARCHAR2 | 30 | Default Code for the reason a proposed resource is rejected for a project resource assignment. | ||
| STAFF_OWNER_FR_POOL_OWNER_MGR | VARCHAR2 | 1 | Option that, when selected, limits the list of values of staffing owners to pool owners and pool managers. | ||
| ALL_SECT_COMPETENCY_FLAG | VARCHAR2 | 1 | Indicates whether all content sections of Competencies content template are used for evaluating resources. | ||
| ALL_SECT_EDUCATION_FLAG | VARCHAR2 | 1 | Indicates whether all content sections of Education content template are used for evaluating resources. | ||
| ALL_SECT_HONOR_AWARD_FLAG | VARCHAR2 | 1 | Indicates whether all content sections of Honor and Award content template are used for evaluating resources. | ||
| ALL_SECT_LANGUAGE_FLAG | VARCHAR2 | 1 | Indicates whether all content sections of Language content template are used for evaluating resources. | ||
| ALL_SECT_LIC_CERT_FLAG | VARCHAR2 | 1 | Indicates whether all content sections of License and Certification content template are used for evaluating resources. | ||
| ALL_SECT_MEMBERSHIP_FLAG | VARCHAR2 | 1 | Indicates whether all content sections of Membership content template are used for evaluating resources. | ||
| WORK_PREF_SECTION_ID | NUMBER | 18 | Section ID of the work requirements content section that contains travel preferences applicable to Resource Management. If no value is set, there will be a warning in the Search Index process report stating that travel preferences were not included in the index. Foreign Key to HRT_PROFILE_TYP_SECTIONS. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJR_ENTERPRISE_IMPL_OPTION_U1 | Unique | FUSION_TS_TX_IDX | ENTERPRISE_ID, ORA_SEED_SET1 |
| PJR_ENTERPRISE_IMPL_OPTION_U11 | Unique | FUSION_TS_TX_IDX | ENTERPRISE_ID, ORA_SEED_SET2 |