IMPORT_TEMPLATEBCITEMPARENTBCITEMNAMERB_IMP_TFLD2_VW(SQL View) |
Index Back |
|---|---|
Import Template FieldBase table for common Import Template Field |
| SELECT DISTINCT IMPORT_TEMPLATE , BCITEMPARENT , BCITEMNAME , ALT_LABEL FROM PS_RB_IMP_TMPL_FLD WHERE INCLUDE = 'Y' AND 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 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |