PJF_PROJ_ELEM_VER_STRUCT
PA_PROJ_ELEM_VER_STRUCTURE stores the structure attributes which are versioned. - For future use
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_PROJ_ELEM_VER_STRUCT_PK |
PEV_STRUCTURE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PEV_STRUCTURE_ID | NUMBER | 18 | Yes | The unique identifier for the structure version attributes | |
| ELEMENT_VERSION_ID | NUMBER | 18 | Yes | The unique identifier for the element version | |
| VERSION_NUMBER | NUMBER | Yes | Auto-generated structure version number | ||
| VERSION_NAME | VARCHAR2 | 240 | Yes | User-defined name of the structure version ***** | |
| PROJECT_ID | NUMBER | 18 | Yes | The identifier of the project to which the structure version attributes belong | |
| PROJ_ELEMENT_ID | NUMBER | 18 | Yes | The identifier of the project element to which the structure version attributes belong | |
| 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. | |
| 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. | |
| DESCRIPTION | VARCHAR2 | 2000 | The description of the structure version | ||
| LOCK_STATUS_CODE | VARCHAR2 | 30 | The lock status of the structure version | ||
| LOCKED_BY_PERSON_ID | NUMBER | 18 | The identifier of the user who has locked the structure version | ||
| LOCKED_DATE | DATE | The date that the structure version was locked | |||
| STATUS_CODE | VARCHAR2 | 150 | The status of the structure version | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PM_SOURCE_CODE | VARCHAR2 | 30 | The identifier of the source system from which the element version was created | ||
| PM_SOURCE_REFERENCE | VARCHAR2 | 25 | The identifier of the element version in the source system from which the element version was imported | ||
| PROCESS_UPDATE_WBS_FLAG | VARCHAR2 | 1 | Indicates whether the work breakdown structure must be processed for changes to the structure. | ||
| TREE_FLATTENING_FLAG | VARCHAR2 | 1 | Indicates whether the tree Flattening ESS job must be processed for changes to the structure. | ||
| CONC_REQUEST_ID | NUMBER | 18 | The process ID for the Process Work Breakdown Structure Updates process. | ||
| PROCESS_CODE | VARCHAR2 | 30 | The status of the Process Work Breakdown Structure process. | ||
| PROJ_PLAN_UPDATED_FLAG | VARCHAR2 | 1 | Flag to indicate change in project plan amounts. The flag will be reset to `N' once the latest plan amounts for draft progress records are ***** | ||
| PRBS_CHANGE_FLAG | VARCHAR2 | 1 | Flag to indicate change in project plan PRBS. The change in PRBS on project will require to rerun project plan actuals mapping by kicking off summarization process from project plan page. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 240 | PROGRAM_NAME ***** | ||
| PROGRAM_APP_NAME | VARCHAR2 | 20 | PROGRAM_APP_NAME ***** |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJF_PROJ_ELEM_VER_STRUCT | pjf_projects_all_b | PROJECT_ID |
| PJF_PROJ_ELEM_VER_STRUCT | pjf_proj_elements_b | PROJ_ELEMENT_ID |
| PJF_PROJ_ELEM_VER_STRUCT | pjf_proj_element_version | ELEMENT_VERSION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_PROJ_ELEM_VER_STRUCT_N1 | Non Unique | Default | PROJECT_ID, ELEMENT_VERSION_ID |
| PJF_PROJ_ELEM_VER_STRUCT_U1 | Unique | Default | PEV_STRUCTURE_ID |
| PJF_PROJ_ELEM_VER_STRUCT_U2 | Unique | Default | PROJECT_ID, PROJ_ELEMENT_ID, VERSION_NAME |
| PJF_PROJ_ELEM_VER_STRUCT_U3 | Unique | Default | PROJECT_ID, PROJ_ELEMENT_ID, ELEMENT_VERSION_ID |