| # |
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 |
LI_MAP_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
what type of mapping is being defined?
01=Basic
02=Advanced
Default Value: 01
|
| 5 |
LI_MAPPING_SRC |
Character(2) |
VARCHAR2(2) NOT NULL |
from whence come values to be mapped?
01=Field
02=Constant
03=Concatenate
04=Translation Set
Default Value: 01
|
| 6 |
SOURCE_FIELD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Input File Source Field Input Number
|
| 7 |
LI_XLAT_SET_ID |
Character(31) |
VARCHAR2(31) NOT NULL |
Translate Set ID
|
| 8 |
LI_TEMPLATE_ID |
Character(31) |
VARCHAR2(31) NOT NULL |
template identifier
|
| 9 |
LI_TREE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
in what position is this tree element?
|
| 10 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 11 |
VALUE_DISPLAY |
Character(254) |
VARCHAR2(254) NOT NULL |
Value
|
| 12 |
LI_TEMPLATE_RULE |
Character(2) |
VARCHAR2(2) NOT NULL |
action to take for a field in a given template
01=Generate Standard Key
02=Generate Sequence Key
03=Reference Key
04=Required Input
05=Optional Input
06=Value
07=Value Reference
08=Lookup Value
09=Concatenation
10=Insert Null
11=Generate Id - Not Key
12=Generate Datetime Stamp
13=Fetch Text
14=Staged Default
15=Mandatory Value
16=First of Group
17=Write Contact Method
18=Cache Contact Method
19=Map Field Reference
20=Bas SysId
|
| 13 |
REQUIRED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 14 |
LI_ACTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Import Action
01=Import
02=Ignore
Default Value: 01
|
| 15 |
GROUP_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
|
| 16 |
LI_UNIQUE_ID |
Character(31) |
VARCHAR2(31) NOT NULL |
Unique_Id
|