IMPORT_TEMPLATEBCITEMPARENTBCITEMNAMELANGUAGE_CDRB_IMP_TFL2L_VW(SQL View) |
Index Back |
|---|---|
Import Template FieldRelated Language table for common Import Template Field View |
| SELECT DISTINCT A.IMPORT_TEMPLATE , A.BCITEMPARENT , A.BCITEMNAME , A.LANGUAGE_CD , A.ALT_LABEL FROM PS_RB_IMP_TMP_FD_L A , PS_RB_IMP_TMPL_FLD B WHERE A.IMPORT_TEMPLATE = B.IMPORT_TEMPLATE AND A.BCITEMPARENT = B.BCITEMPARENT AND A.BCITEMNAME = B.BCITEMNAME AND B.INCLUDE = 'Y' AND A.ALT_LABEL <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IMPORT_TEMPLATE |
Character(30) | VARCHAR2(30) NOT NULL | Import Template Name |
| 2 | BCITEMPARENT |
Character(30) | VARCHAR2(30) NOT NULL | Parent Collection Name |
| 3 | BCITEMNAME |
Character(30) | VARCHAR2(30) NOT NULL | BC Item Logical Name |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |