PJR_PROJ_RES_REQ_DET_INT
It is interface table of PJR_RESOURCE_REQUESTS_DETAILS
Details
-
Schema: FUSION
-
Object owner: PJR
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJR_PRJ_RES_REQ_DET_INT_PK |
XFACE_REC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RES_REQ_IMPORT_ID | NUMBER | 18 | Yes | Unique identifier of a project resource request while importing into the interface table. | |
| REQUEST_NAME | VARCHAR2 | 240 | Name of a project resource request. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| SECTION_ID | NUMBER | 18 | Section ID of the content section the qualification content item is associated with. Foreign Key to HRT_PROFILE_TYP_SECTIONS. | ||
| SECTION_NAME | VARCHAR2 | 240 | Section Name of the content section the qualification content item is associated with. | ||
| QUALIFICATION_ID | NUMBER | 18 | Identifier of a structured content item such as a competency, degree, or language skill that has a specific value and rating. | ||
| QUALIFICATION_NAME | VARCHAR2 | 700 | Name of a structured content item such as a competency, degree, or language skill that has a specific value and rating. | ||
| KEYWORD | VARCHAR2 | 200 | Unstructured words or phrases that appear as keywords on a project resource request. | ||
| RATING_LEVEL_ID | NUMBER | 18 | Identifier of the level of expertise or ability to perform a competency that is specified on a project resource request. | ||
| RATING_LEVEL_NAME | VARCHAR2 | 2000 | Level of expertise or ability to perform a competency that is specified on a project resource request. | ||
| READING_RATING_LEVEL_ID | NUMBER | 18 | Identifier of the level of expertise or ability to perform a competency that is specified on a project resource request. | ||
| READING_RATING_LEVEL_NAME | VARCHAR2 | 2000 | Identifier of the level of ability to read text in a specific language. | ||
| WRITING_RATING_LEVEL_ID | NUMBER | 18 | Identifier of the level of ability to write text in a specific language. | ||
| WRITING_RATING_LEVEL_NAME | VARCHAR2 | 2000 | Level of ability to write text in a specific language. | ||
| SPEAKING_RATING_LEVEL_ID | NUMBER | 18 | Identifier of the level of ability to speak a specific language. | ||
| SPEAKING_RATING_LEVEL_NAME | VARCHAR2 | 2000 | Level of ability to speak a specific language. | ||
| MANDATORY_FLAG | VARCHAR2 | 1 | Indicates if the qualification is mandatory for Search and Evaluate that will result in filtering out those resources who don't have this qualification.The 'Y' value of flag indicates that qualification is mandatory and 'N' or Null value indicates that it is optional. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Request Id of the ESS job that loads the interface table. | ||
| XFACE_REC_ID | NUMBER | 18 | Yes | Identifier for each row in this table. | |
| ENTERPRISE_ID | NUMBER | 18 | Enterprise identifier that uniquely identifies a tenant in multi-tenant environment. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJR_RES_REQ_DET_INT_U1 | Unique | Default | XFACE_REC_ID |