PTLT_BP_NAMEPTLT_BP_DTL_NAMEPTLT_BP_DTL_VW(SQL View) |
Index Back |
|---|---|
Business Process - DetailBusiness Process Definitions - Detail |
| SELECT A.PTLT_BP_NAME , A.PTLT_BP_DTL_NAME , A.PTLT_BP_NAME_EXT , A.DESCR254_MIXED , A.OBJECTOWNERID FROM %Table(PTLT_BUSPRC_DTL) A , %Table(PTLT_INSTALL) B WHERE A.PTLT_BP_VERSION = B.PTLT_BP_VERSION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTLT_BP_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Business Process Name |
| 2 | PTLT_BP_DTL_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Detailed Business Process Name |
| 3 | PTLT_BP_NAME_EXT | Character(50) | VARCHAR2(50) NOT NULL | Internal business process name |
| 4 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 5 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |