PJR_RESOURCE_REQUEST_LINES
The PJR_RESOURCE_REQUEST_LINES table contains resource information that is associated to a resource request
Details
-
Schema: FUSION
-
Object owner: PJR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJR_RESOURCE_REQUEST_LINE_PK |
RESOURCE_REQUEST_SEQ_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_REQUEST_SEQ_NUMBER | NUMBER | 18 | Yes | Automatically-generated unique identifier for a resource associated to a project resource request/ | |
| RESOURCE_REQUEST_ID | NUMBER | 18 | Yes | Automatically-generated unique identifier for a resource associated to a project resource request. | |
| RESOURCE_ID | NUMBER | 18 | Unique identifier of the resource who is selected to fulfill the project resource request. | ||
| RESOURCE_STATUS | VARCHAR2 | 20 | Status of a resource for a project resource request. | ||
| PM_REQUESTED_RESOURCE_ID | NUMBER | 18 | PM_REQUESTED_RESOUCE_ID | ||
| RESOURCE_COST_RATE | NUMBER | Cost rate for the resource who is selected on the request. | |||
| RESOURCE_BILL_RATE | NUMBER | Bill rate for the resource who is selected on the request. | |||
| RESOURCE_COST_RATE_CURR_CODE | VARCHAR2 | 15 | Currency of the cost rate for the resource who is selected on the request. | ||
| RESOURCE_BILL_RATE_CURR_CODE | VARCHAR2 | 15 | Currency of the bill rate for the resource who is selected on the request. | ||
| RESOURCE_REJECT_REASON_CODE | VARCHAR2 | 30 | Code for the reason a proposed resource is rejected for a project resource assignment. | ||
| STAFFING_OWNER_ID | NUMBER | 18 | Identifier of the person who is creating the resource for the project resource request. | ||
| ASSIGN_ID | NUMBER | Identifier for the Assignment. | |||
| CURRENT_FLAG | VARCHAR2 | 1 | Indicates whether the project resource request is the most recent request for the assignment. A value of Y when the ASSIGN_ID column is blank indicates that the request is not fulfilled. A value of Y when the ASSIGN_ID column contains a value indicates that the request is the most recently-approved adjustment request for the assignment. A value of N indicates that there is a subsequent approved adjustment request for the assignment. | ||
| ORIG_ASSIGN_START_DATE | DATE | Assigned start date for resource for a project resource request when the request is originally fulfilled. | |||
| ORIG_ASSIGN_FINISH_DATE | DATE | Assigned finish date for resource for a project resource request when the request is originally fulfilled. | |||
| ORIG_ASSIGN_USE_CAL_FLAG | VARCHAR2 | 1 | Indicates the option the resources assigned hours are based on when the request is originally fulfilled: Y=Project calendar hours N=Specified hours in HOURS_PER_DAY column X=Variable hours in HOURS_PER_DAY1 - HOURS_PER_DAY7 W=Specified weekly hours in HOURS_PER_INTERVAL column | ||
| ORIG_ASSIGN_HOURS_PER_DAY | NUMBER | Original number of assignment hours per day on the project resource assignment, if different than the project calendar, when the request is originally fulfilled. | |||
| RESOURCE_PROPOSED_DATE | DATE | The date a resource is proposed to fulfill a project resource request. The status of the project resource request changes from Open to Resource Proposed. | |||
| FULFILLED_DATE | DATE | The date a resource is approved to fulfill a project resource request. If project manager approval is required, the fulfilled date is when the status of the request changes from Resource Proposed to Fulfilled. If approval is not required, the fulfilled date is when the status of the request changes from Open to Fulfilled. | |||
| TOTAL_HOURS | NUMBER | The total number of hours that are requested on a project resource request. The hours are based on the number of working days in the project calendar multiplied either by the number of hours in each working day in the project calendar or the number of hours per day on the project resource request. | |||
| NUMBER_OF_WORKING_DAYS | NUMBER | The total number of working days that are requested on a project resource request. The number of working days is based on the working days in the project calendar for the requested date range. | |||
| ASSIGNMENT_STATUS | VARCHAR2 | 30 | Status of a project resource assignment. | ||
| 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. | |
| CREATED_FROM_FLOW | VARCHAR2 | 30 | Indicates the source create interface flow code. | ||
| LAST_UPDATED_FROM_FLOW | VARCHAR2 | 30 | Indicates the source update interface flow code. | ||
| ORIG_ASSIGN_HOURS_PER_DAY1 | NUMBER | Hours per day value for every Sunday when the request is originally fulfilled if Variable Hours is selected, that is ORIG_ASSIGN_USE_CAL_FLAG = X. | |||
| ORIG_ASSIGN_HOURS_PER_DAY2 | NUMBER | Hours per day value for every Monday when the request is originally fulfilled if Variable Hours is selected, that is ORIG_ASSIGN_USE_CAL_FLAG = X. | |||
| ORIG_ASSIGN_HOURS_PER_DAY3 | NUMBER | Hours per day value for every Tuesday when the request is originally fulfilled if Variable Hours is selected, that is ORIG_ASSIGN_USE_CAL_FLAG = X. | |||
| ORIG_ASSIGN_HOURS_PER_DAY4 | NUMBER | Hours per day value for every Wednesday when the request is originally fulfilled if Variable Hours is selected, that is ORIG_ASSIGN_USE_CAL_FLAG = X. | |||
| ORIG_ASSIGN_HOURS_PER_DAY5 | NUMBER | Hours per day value for every Thursday when the request is originally fulfilled if Variable Hours is selected, that is ORIG_ASSIGN_USE_CAL_FLAG = X. | |||
| ORIG_ASSIGN_HOURS_PER_DAY6 | NUMBER | Hours per day value for every Friday when the request is originally fulfilled if Variable Hours is selected, that is ORIG_ASSIGN_USE_CAL_FLAG = X. | |||
| ORIG_ASSIGN_HOURS_PER_DAY7 | NUMBER | Hours per day value for every Saturday when the request is originally fulfilled if Variable Hours is selected, that is ORIG_ASSIGN_USE_CAL_FLAG = X. | |||
| ORIG_ASSIGN_HOURS_PER_INTERVAL | NUMBER | Hours to be spread over the time interval specified in USE_PROJ_CALENDAR_HOUR_FLAG when the request is originally fulfilled. For example, the column captures weekly hours when ORIG_ASSIGN_USE_CAL_FLAG=W. | |||
| RESOURCE_STATUS_BKP | VARCHAR2 | 20 | Back up of status of a resource for a project resource request. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJR_RESOURCE_REQUEST_LINES | pjr_resource_requests | RESOURCE_REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJR_REQUEST_LINES_N1 | Non Unique | Default | RESOURCE_REQUEST_ID |
| PJR_REQUEST_LINES_N2 | Non Unique | Default | ASSIGN_ID |
| PJR_RESOURCE_REQUEST_LINES_U1 | Unique | FUSION_TS_TX_DATA | RESOURCE_REQUEST_SEQ_NUMBER |