PJT_PROJECT_RESOURCE_H
History Table that stores different versions of Project Resources - used to store the PRE and POST resource unification snapshot of the PJT_PROJECT_RESOURCE table.
Details
-
Schema: FUSION
-
Object owner: PJT
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PJT_PROJECT_RESOURCE_H_PK |
PROJ_RESOURCE_ID, UPG_CONTEXT |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PROJ_RESOURCE_ID | NUMBER | 18 | Yes | System-generated that uniquely identifies a resouce to project assignment | |
DEFAULT_STAFFING_OWNER_FLAG | NUMBER | 1 | DEFAULT_STAFFING_OWNER_FLAG | ||
EXPENSE_AMOUNT | NUMBER | Amount planned for a project resource assignment | |||
LABOR_EFFORT | NUMBER | Effort associated with the resource on a project | |||
LABOR_COST_RATE | NUMBER | Cost rate associated with the project resource | |||
LABOR_BILL_RATE | NUMBER | Bill rate associated with the project resource | |||
ALLOCATION | NUMBER | Allocation of a resource to a project | |||
RESOURCE_ID | NUMBER | 18 | Yes | The ID of the resource assigned to a specific project | |
BILLABLE_PERCENT_REASON_CODE | VARCHAR2 | 30 | Reason Code for the billable percentage of the project resource being less than 100%. | ||
BILLABLE_PERCENT | NUMBER | Percentage of the billable scheduled time of the project resource. | |||
ASSIGNMENT_TYPE | VARCHAR2 | 30 | Type of assignment of the project resource. Possible values are BILLABLE or NON-BILLABLE or null. | ||
PROJECT_ID | NUMBER | 18 | Project ID the resource is assigned to | ||
SCHEDULE_ID | NUMBER | 18 | Calendar ID of the resource to project assignment | ||
UNIT_OF_MEASURE | VARCHAR2 | 30 | used for local expenditure or local person | ||
CURRENCY_CODE | VARCHAR2 | 15 | currency code for USER_DEFINED resources | ||
RATE | NUMBER | 22 | Rate for USER_DEFINED resources | ||
PROJECT_ROLE_ID | NUMBER | 18 | FK to project role table | ||
START_DATE_ACTIVE | DATE | The date when the resource becomes active | |||
END_DATE_ACTIVE | DATE | The date when the resource becomes inactive | |||
PERSON_ID | NUMBER | 18 | FK to NAMED_PERSON type of resource defined in TCA | ||
PARTY_ID | NUMBER | 18 | FK to NAMED_PERSON type of resource defined in TCA | ||
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. | ||
RESOURCE_REQUEST_ID | NUMBER | 18 | Resource request identifier | ||
ENTERPRISE_ID | NUMBER | 18 | Yes | Enterprise ID | |
PROJECT_RESOURCE_REQUEST_ID | NUMBER | 18 | FK to PJR_RESOURCE_REQUESTS request ID | ||
ASSIGNMENT_STATUS_CODE | VARCHAR2 | 30 | Assignmet lookup status code | ||
TRACK_TIME_FLAG | VARCHAR2 | 1 | Flag to indicate whether the application must track missing time for the team member. Valid values are Y and N. | ||
UP_REQUEST_ID | NUMBER | 18 | To show the security assignment status on the PRS page for the user provisioning of the user based on his role in the PRS. | ||
UPG_CONTEXT | VARCHAR2 | 10 | Yes | This column will be used to save the upgrade sync up context like 'PRE' or 'POST'. The 'PRE' /'POST' context means the data is before/after running the upgrade sync up for Resource unification. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PJT_PROJECT_RESOURCE_H_U2 | Unique | Default | PROJ_RESOURCE_ID, UPG_CONTEXT |