INTEGRATION_IDENTITY_NAMELRM_OPA_INT_CVW(SQL View) |
Index Back |
|---|---|
OPA Mapping Calculated promptLRM/OPA Inetgration Mapping Prompt table for calculated records |
| SELECT DISTINCT INTEGRATION_ID , ENTITY_NAME , DESCR100 FROM PS_LRM_OPA_INT_HDR WHERE ENTITY_TYPE = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTEGRATION_ID |
Character(40) | VARCHAR2(40) NOT NULL | OPA Data Model ID |
| 2 | ENTITY_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Entity Name |
| 3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |