LI_IMPORT_IDPrompt Table: RB_IMPORT_DEFN
EFFDTDefault Value: %date
SEQ_NUMCONCAT_SEQ_NUM01=Value
02=Field
Default Value: 01
Prompt Table: RB_IMP_FILESPEC
RB_MAP_CONCAT(SQL Table) |
Index Back |
|---|---|
concatenation detailsdetail record for concatenation list import function |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LI_IMPORT_ID |
Character(31) | VARCHAR2(31) NOT NULL |
Import ID
Prompt Table: RB_IMPORT_DEFN |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | CONCAT_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | LI_CONCAT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
type of concatenation operation
01=Value 02=Field Default Value: 01 |
| 6 | SOURCE_FIELD_NUM | Number(3,0) | SMALLINT NOT NULL |
Input File Source Field Input Number
Prompt Table: RB_IMP_FILESPEC |
| 7 | VALUE_DISPLAY | Character(254) | VARCHAR2(254) NOT NULL | Value |