The following table shows the columns in the EGO_ITEM_PEOPLE_INTF database table. For more details about the columns in EGO_ITEM_PEOPLE_INTF, see EGO_ITEM_PEOPLE_INTF Details.
EGO_ITEM_PEOPLE_INTF table
| Column Name | Data Type | Required? |
|---|---|---|
| INVENTORY_ITEM_ID | NUMBER(15) | No |
| ORGANIZATION_ID | NUMBER(15) | No |
| GRANTEE_PARTY_ID | NUMBER(15) | No |
| INTERNAL_ROLE_ID | NUMBER(15) | No |
| INTERNAL_ROLE_NAME | VARCHAR2(30) | No |
| LAST_UPDATE_DATE | DATE | No |
| LAST_UPDATED_BY | No | |
| CREATION_DATE | DATE | No |
| CREATED_BY | NUMBER(15) | No |
| LAST_UPDATE_LOGIN | NUMBER(15) | No |
| REQUEST_ID | NUMBER(15) | No |
| PROGRAM_APPLICATION_ID | NUMBER(15) | No |
| PROGRAM_ID | NUMBER(15) | No |
| PROGRAM_UPDATE_DATE | DATE | No |
| ITEM NUMBER | VARCHAR2(81) | Yes |
| ORGANIZATION_CODE | VARCHAR2(3) | Yes |
| DISPLAY_ROLE_NAME | VARCHAR2(80) | Yes |
| GRANTEE_TYPE | VARCHAR2(8) | Yes |
| GRANTEE_NAME | VARCHAR2(360) | Yes |
| START_DATE | DATE | Yes |
| END_DATE | DATE | No |
| TRANSACTION_TYPE | VARCHAR2(10) | Yes |
| TRANSACTION_ID | NUMBER(15) | Yes |
| PROCESS_STATUS | NUMBER(15) | Yes |
| DATA_SET_ID | NUMBER(15) | Yes |