PJC_PRJ_ASSET_ASGS
PA_PROJECT_ASSET_ASSIGNMENTS stores information about the relationship between projects or tasks and assets. The data in this table controls the level (project, top task, or lowest level task) at which detailed cost transactions will be summarized into project asset lines. . Records in this table will have a task_id of 0 for project level asset assignments. Records will have an asset_id of 0 for common cost assignments.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJC_PRJ_ASSET_ASGS_PK |
ASSET_ASSIGNMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ASSET_ASSIGNMENT_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the asset assignment | |
| PROJECT_ASSET_ID | NUMBER | 18 | Yes | The identifier of the asset; value is 0 for common cost assignments | |
| TASK_ID | NUMBER | 18 | Yes | The identifier of the task; value is 0 on project-level assignments | |
| PROJECT_ID | NUMBER | 18 | Yes | The identifier of the project involved in the assignment | |
| 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. | ||
| 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. | ||
| 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 | Capture source that creates Asset Assignment |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_PRJ_ASSET_ASGS | pjf_projects_all_b | PROJECT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_PRJ_ASSET_ASGS_N1 | Non Unique | Default | PROJECT_ASSET_ID |
| PJC_PRJ_ASSET_ASGS_U1 | Unique | Default | PROJECT_ID, TASK_ID, PROJECT_ASSET_ID |
| PJC_PRJ_ASSET_ASGS_U2 | Unique | Default | ASSET_ASSIGNMENT_ID |