PTLT_BP_VW(SQL View) |
Index Back |
---|---|
Business Process - DetailBusiness Process Definitions - Detail |
SELECT A.PTLT_BP_NAME , A.PTLT_BP_NAME_EXT , A.DESCR254_MIXED , A.OBJECTOWNERID FROM %Table(PTLT_BUSPRC) 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_NAME_EXT | Character(50) | VARCHAR2(50) NOT NULL | Internal business process name |
3 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
4 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |