IMPORT_TEMPLATEBCITEMPARENTBCITEMNAMERB_IMP_TFLD_VW(SQL View) |
Index Back |
|---|---|
Import Template FieldCommon Import Template Field View |
| SELECT DISTINCT IMPORT_TEMPLATE , BCITEMPARENT , BCITEMNAME , ALT_LABEL , LONGNAME 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 | ALT_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Alternate Label |
| 5 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |