PJT_UP_REQUESTS
The Project User Provisioning Requests table contains attributes which provide information about the requests needed for user and role provisioning. This maps the information provided in the Role Requests and User Requests tables through a common Request Id.
Details
-
Schema: FUSION
-
Object owner: PJT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJT_UP_REQUESTS_PK |
ENTERPRISE_ID, UP_REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| LATEST_FLAG | VARCHAR2 | 30 | LATEST_FLAG | ||
| UP_REQUEST_ID | NUMBER | 18 | Yes | Unique identification number to identify the resource | |
| REQUEST_STATUS | VARCHAR2 | 50 | Yes | REQUEST_STATUS | |
| PERSON_ID | NUMBER | 18 | Yes | PERSON_ID | |
| RESOURCE_ID | NUMBER | 18 | Yes | Resource Name | |
| PER_LDAP_REQUEST_ID | NUMBER | 18 | Yes | PER_LDAP_REQUEST_ID | |
| SUBMIT_INSTANCE_ID | VARCHAR2 | 100 | Yes | SUBMIT_INSTANCE_ID | |
| POST_INSTANCE_ID | VARCHAR2 | 100 | Yes | POST_INSTANCE_ID | |
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pjt_up_user_requests | pjt_up_requests | ENTERPRISE_ID, UP_REQUEST_ID |
| pjt_up_role_requests | pjt_up_requests | ENTERPRISE_ID, UP_REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJT_UP_REQUESTS_N1 | Non Unique | Default | PER_LDAP_REQUEST_ID |
| PJT_UP_REQUESTS_U1 | Unique | Default | ENTERPRISE_ID, UP_REQUEST_ID |