PJR_ASSIGNMENT_INT
It is the interface table of PJR_ASSIGNMENT
Details
-
Schema: FUSION
-
Object owner: PJR
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJR_ASSIGNMENT_INT_PK |
XFACE_REC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_ID | NUMBER | 18 | The unique id of the resource associated with this assignment. | ||
| RESOURCE_HCM_PERSON_ID | NUMBER | 18 | Identifier of the HCM person associated with the assignment. A project enterprise labor resource must exist for this HCM person. | ||
| RESOURCE_DISPLAY_NAME | VARCHAR2 | 240 | Name of the resource associated with this assignment. | ||
| RESOURCE_EMAIL | VARCHAR2 | 240 | E-mail of the resource associated with this assignment. | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project for which a resource is requested. | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | Number of the project for which a resource is requested. | ||
| PROJECT_NAME | VARCHAR2 | 240 | Name of the project for which a resource is requested. | ||
| ASSIGNMENT_STATUS_CODE | VARCHAR2 | 30 | Status code of the assignment to be created. | ||
| ASSIGNMENT_STATUS_NAME | VARCHAR2 | 80 | Status of the assignment to be created. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | The unique id of the project role associated with this assignment. | ||
| PROJECT_ROLE_NAME | VARCHAR2 | 240 | Name of the project role associated with this assignment. | ||
| LOCATION | VARCHAR2 | 240 | Assignment location for the work specified on the project resource request. | ||
| ASSIGNMENT_START_DATE | DATE | The start date that the resource (RESROURCE_ID) is engaged on this project (PROJECT_ID). | |||
| ASSIGNMENT_FINISH_DATE | DATE | The last date that this resource (RESOURCE_ID) is engaged on this project (PROJECT_ID). | |||
| USE_PROJECT_CALENDAR_FLAG | VARCHAR2 | 1 | Indicates the option the resources assigned hour are based on: Y – Project calendar hours N – Specified daily hours in HOURS_PER_DAY column W – Specified weekly hours in HOURS_PER_DAY column | ||
| REQUESTED_HOURS_PER_DAY | NUMBER | Hours to be assigned to the resource assignment: When the USE_PROJECT_CALENDAR_FLAG=N, these are the number of hours to be used for each day. When the USE_PROJECT_CALENDAR_FLAG=W, these are the number of hours to be spread over a week time interval. | |||
| XFACE_REC_ID | NUMBER | 18 | Yes | Identifier for each row in this table. | |
| BILL_RATE | NUMBER | Bill rate for the assigned resource. | |||
| BILL_RATE_CURRENCY | VARCHAR2 | 15 | Currency of the bill rate for the assigned resource. | ||
| COMMENTS | VARCHAR2 | 2000 | Additional details of the project resource assignment. | ||
| REQUESTER_ID | NUMBER | 18 | Identifier of the person who requested the resource. | ||
| REQUESTER_PERSON_ID | NUMBER | 18 | Identifier of the HCM person who requested the resource. A project enterprise labor resource must exist for this HCM person. | ||
| REQUESTER_NAME | VARCHAR2 | 240 | Name of the person who requested the resource. | ||
| REQUESTER_EMAIL | VARCHAR2 | 240 | E-mail of the person who requested the resource. | ||
| STAFFING_OWNER_ID | NUMBER | 18 | Identifier of the person who created the request. | ||
| STAFFING_OWNER_PERSON_ID | NUMBER | 18 | Identifier of the HCM person who created the request. A project enterprise labor resource must exist for this HCM person. | ||
| STAFFING_OWNER_NAME | VARCHAR2 | 240 | Name of the person who created the request. | ||
| STAFFING_OWNER_EMAIL | VARCHAR2 | 240 | E-mail of the person who created the request. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Request Id of the ESS job that loads the interface table. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| LOAD_STATUS | VARCHAR2 | 10 | Status for this row of the data load to the interface tables. | ||
| ASSIGNMENT_EXTERNAL_REF | VARCHAR2 | 100 | Identifier of the assignment in the external application. | ||
| OPERATION | VARCHAR2 | 30 | Operation that should be performed on the assignment. | ||
| ADJUSTMENT_REASON | VARCHAR2 | 240 | Additional details of the project resource assignment adjustment | ||
| COST_RATE | NUMBER | Cost rate for the assigned resource. | |||
| 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. | ||
| 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. | |
| RESERVATION_REASON_CODE | VARCHAR2 | 30 | Reason for reserving a resource on a project resource assignment. | ||
| RESERVATION_REASON | VARCHAR2 | 80 | Reason for reserving a resource on a project resource assignment. | ||
| RESERVATION_EXPIRATION_DATE | DATE | Date until which the resource should be reserved on the project. On this date the user should either confirm the assignment or cancel the reservation. | |||
| ASSIGNMENT_TYPE | VARCHAR2 | 30 | Type of assignment code of the resource requested. Possible values are BILLABLE and NON-BILLABLE. | ||
| ASSIGNMENT_TYPE_NAME | VARCHAR2 | 80 | Type of assignment of the resource requested. Possible values are Billable and Non-Billable. | ||
| BILLABLE_PERCENT | NUMBER | Percentage of the billable scheduled time of the requested assignment. | |||
| BILLABLE_PERCENT_REASON_CODE | VARCHAR2 | 30 | Reason code for the billable percentage of the project resource assignment being less than 100%. | ||
| BILLABLE_PERCENT_REASON_NAME | VARCHAR2 | 80 | Reason for the billable percentage of the project resource assignment being less than 100%. | ||
| USE_VARIABLE_HOURS_FLAG | VARCHAR2 | 1 | Indicator that the number of assignment hours per day in the weekly pattern are variable. Valid values are Y or N. | ||
| HOURS_PER_DAY1 | NUMBER | Hours per day value for every Sunday when Variable Hours is selected, that is USE_VARIABLE_HOURS_FLAG = Y. | |||
| HOURS_PER_DAY2 | NUMBER | Hours per day value for every Monday when Variable Hours is selected, that is USE_VARIABLE_HOURS_FLAG = Y. | |||
| HOURS_PER_DAY3 | NUMBER | Hours per day value for every Tuesday when Variable Hours is selected, that is USE_VARIABLE_HOURS_FLAG = Y. | |||
| HOURS_PER_DAY4 | NUMBER | Hours per day value for every Wednesday when Variable Hours is selected, that is USE_VARIABLE_HOURS_FLAG = Y. | |||
| HOURS_PER_DAY5 | NUMBER | Hours per day value for every Thursday when Variable Hours is selected, that is USE_VARIABLE_HOURS_FLAG = Y. | |||
| HOURS_PER_DAY6 | NUMBER | Hours per day value for every Friday when Variable Hours is selected, that is USE_VARIABLE_HOURS_FLAG = Y. | |||
| HOURS_PER_DAY7 | NUMBER | Hours per day value for every Saturday when Variable Hours is selected, that is USE_VARIABLE_HOURS_FLAG = Y. | |||
| ASSIGNMENT_NAME | VARCHAR2 | 240 | Name of a project resource assignment. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJR_ASSIGNMENT_INT_U1 | Unique | FUSION_TS_TX_DATA | XFACE_REC_ID |