PTLT_BP_NAMEPTLT_BP_DTL_NAMELANGUAGE_CDPTLT_BP_DTL_LVW(SQL View) |
Index Back |
|---|---|
Rel Lang view for BusPrc - DtlRelated Language view for Business Process Definitions - Detail |
| SELECT A.PTLT_BP_NAME , A.PTLT_BP_DTL_NAME , A.LANGUAGE_CD , A.DESCR254_MIXED FROM %Table(PTLT_BUSPRC_DLN) 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |