PJF_PROJECT_TYPES_B
Implementation defined project classifications that supply default information and drive some project processing
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_PROJECT_TYPES_B_PK |
PROJECT_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PROJECT_TYPE_ID | NUMBER | 18 | Yes | The system generated number that uniquely identifies the project type. | ||
| SET_ID | NUMBER | 18 | Yes | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. | ||
| START_DATE_ACTIVE | DATE | Yes | First effective date of the project type | |||
| END_DATE_ACTIVE | DATE | Last effective date of the project type | ||||
| WORK_TYPE_ID | NUMBER | 18 | Work Types are predefined types of work, for example, Vacation, Training, and Administration. | |||
| ENABLE_BILLING_FLAG | VARCHAR2 | 1 | Yes | Indicates the billable status of the project type. | ||
| ENABLE_CAPITALIZATION_FLAG | VARCHAR2 | 1 | Yes | Indicates the capitalization status of the project type. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Types Descriptive Flexfield (PJF_PROJECT_TYPES_DESC_FLEX) | ||
| BURDEN_COST_FLAG | VARCHAR2 | 1 | Yes | Indicates that burden costs will be calculated for projects classified with this project type. | ||
| COST_IND_RATE_SCH_ID | NUMBER | 18 | Costl Interest Rate Schedule Identifier. | |||
| COST_SCH_OVERRIDE_FLAG | VARCHAR2 | 1 | Yes | Allow cost burden schedule change for projects and tasks | ||
| BURDEN_AMT_DISPLAY_METHOD | VARCHAR2 | 1 | Indicates whether to display burdened amount on same transaction or as a separate transaction. | |||
| BURDEN_ACCOUNT_FLAG | VARCHAR2 | 1 | Yes | Indicates if burden amount is accounted on separate project and task. | ||
| BURDEN_SUM_DEST_PROJECT_ID | NUMBER | 18 | Indicates destination project id if burden amount is accounted on separate project and task. | |||
| BURDEN_SUM_DEST_TASK_ID | NUMBER | 18 | Indicates destination task id if burden amount is accounted on separate project and task. | |||
| BURDEN_COST_JOURNAL_FLAG | VARCHAR2 | 1 | Indicates that the system will create burden cost accounting journal entries for projects of this project type. Burden costs are costs of doing business that support raw costs and are not directly attributed to work performed. | |||
| TOTAL_BURDEN_FLAG | VARCHAR2 | 1 | Indicates that total burden will be calculated for projects classified with this project type. | |||
| CAPITAL_COST_TYPE_CODE | VARCHAR2 | 1 | Name of the cost type for projects of this project type. | |||
| INTERFACE_COMPLETE_ASSET_FLAG | VARCHAR2 | 1 | Yes | Indicates that for capital projects classified with this project type a complete asset definition is required. | ||
| OVERRIDE_ASSET_ASSIGNMENT_FLAG | VARCHAR2 | 1 | Yes | Indicates if the customer wants to override the asset assignment through client extension before asset lines generation. | ||
| ASSET_ALLOCATION_METHOD | VARCHAR2 | 30 | Yes | Methods by which project costs are allocated to the associated assets. | ||
| CAPITAL_EVENT_PROCESSING | VARCHAR2 | 30 | Yes | Name of the method for processing events of this project type if capitalization is enabled. | ||
| CIP_GROUPING_METHOD_CODE | VARCHAR2 | 30 | Name of the method for grouping asset lines on projects of this project type if capitalization is enabled. | |||
| VENDOR_INVOICE_GROUPING_CODE | VARCHAR2 | 1 | Yes | Indicates group, ungroup supplier invoices and interface them as NEW or MERGED mass additions | ||
| CINT_RATE_SCH_ID | NUMBER | 18 | Capital Interest Rate Schedule Identifier. | |||
| CINT_SCH_OVERRIDE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the interest rate schedule defined for the project type can be overridden at the Project level. | ||
| INTERFACE_ASSET_COST_CODE | VARCHAR2 | 1 | Indicates that for capital projects classified with this project type an asset definition is required. | |||
| 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. | ||
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| 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. | ||
| TOTAL_BURDENED_JOURNAL_FLAG | VARCHAR2 | 1 | Indicates that for projects classified with this project type, the system should generate total burdened cost distribution lines. | |||
| SPONSORED_FLAG | VARCHAR2 | 1 | Yes | Indicates that projects classified with this project type are sponsored projects. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pjf_project_types_tl | pjf_project_types_b | PROJECT_TYPE_ID |
| pjf_projects_all_b | pjf_project_types_b | PROJECT_TYPE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_PROJECT_TYPES_B_U1 | Unique | Default | PROJECT_TYPE_ID |