PJF_RBS_HEADERS_B
This table stores the identifier, effective dates and related information for a resource breakdown structure.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJF_RBS_HEADERS_B_PK |
RBS_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| RBS_HEADER_ID | NUMBER | 18 | Yes | Unique identifier of the RBS. | ||
| RBS_TYPE | VARCHAR2 | 30 | Yes | Type of the RBS. PLANNING, REPORTING or BILLING. ***** | ||
| CENTRALLY_CONTROL_FLAG | VARCHAR2 | 1 | Yes | Indicates if the Planning RBS can be shared across projects or not. For PLANNING RBS type, I (Internal) means None resource list. The flag is always Y for BILLING and REPORTING RBS types. ***** | ||
| PROJECT_UNIT_ID | NUMBER | 18 | Project Unit Identifier of the PLANNING RBS type. The column is Null for REPORTING and BILLING RBS types. ***** | |||
| PROJECT_ID | NUMBER | 18 | This column is only populated for PLANNING RBS specific for the projects. It is Null otherwise ***** | |||
| START_DATE_ACTIVE | DATE | Yes | The start date of the RBS. ***** | |||
| END_DATE_ACTIVE | DATE | The end date of the RBS. ***** | ||||
| LABOR_DISABLED_FLAG | VARCHAR2 | 1 | Option to choose whether the Labor Resource Class is disabled for the planning resource breakdown structure. | |||
| EQUIPMENT_DISABLED_FLAG | VARCHAR2 | 1 | Option to choose whether the Equipment Resource Class is disabled for the planning resource breakdown structure. | |||
| MATERIAL_DISABLED_FLAG | VARCHAR2 | 1 | Option to choose whether the Material Items Resource Class is disabled for the planning resource breakdown structure. | |||
| USE_FOR_ALLOC_FLAG | VARCHAR2 | 1 | Flag indicating whether the RBS can be used in allocations. An RBS can be used in allocations if there are no rule-based RBS elements in any of its versions. | |||
| USE_FOR_CMT_CTRL_FLAG | VARCHAR2 | 1 | Flag indicating whether the RBS can be used for commitment control. ***** | |||
| USE_FOR_IC_BILLING_FLAG | VARCHAR2 | 1 | Used for billing RBS. Indicates if the RBS can be used for creating billing controls on Intercompany contracts. ***** | |||
| SOURCE_RBS_HEADER_ID | NUMBER | 18 | RBS Header Id of the RBS, this RBS was copied from. ***** | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | 18 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_NUMBER2 | NUMBER | 18 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_NUMBER3 | NUMBER | 18 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_NUMBER4 | NUMBER | 18 | Descriptive Flexfield: segment of the user descriptive flexfield. | Resource Foundation Headers Descriptive Flex (PJF_RBS_HEADERS_DESC_FLEX) | ||
| ATTRIBUTE_NUMBER5 | NUMBER | 18 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| 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. | |||
| 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. | ||
| 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. | |||
| AUTO_ADD_RES_FLAG | VARCHAR2 | 1 | Option to add resources automatically to the planning resource breakdown structure that allows changes at the project level on summarization of actual amounts for such resources that weren't included in the planning resource breakdown structure originally. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pjf_rbs_headers_tl | pjf_rbs_headers_b | RBS_HEADER_ID |
| pjf_rbs_versions_b | pjf_rbs_headers_b | RBS_HEADER_ID |
| pjf_rbs_prj_assignments | pjf_rbs_headers_b | RBS_HEADER_ID |
| pjc_alloc_rules_all | pjf_rbs_headers_b | ALLOC_RBS_HEADER_ID |
| pjc_alloc_rules_all | pjf_rbs_headers_b | BASIS_RBS_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_RBS_HEADERS_B_U1 | Unique | Default | RBS_HEADER_ID, ORA_SEED_SET1 |
| PJF_RBS_HEADERS_B_U11 | Unique | Default | RBS_HEADER_ID, ORA_SEED_SET2 |