| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: NEXT
|
| 2 |
LI_IMPORT_ID |
Character(31) |
VARCHAR2(31) NOT NULL |
Import ID
Prompt Table:
RB_IMPT_ACT_VW
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
LI_SCHED_GEN_DATE |
Date(10) |
DATE |
Scheduled Generation Date
|
| 6 |
LI_SCHED_GEN_TIME |
Time(15) |
TIMESTAMP |
Scheduled Generation Time
|
| 7 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 8 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 9 |
LI_DELIMITER |
Character(1) |
VARCHAR2(1) NOT NULL |
Delimiter Import
0=Comma
1=Semicolon
2=Tab
Default Value: 0
|
| 10 |
LI_HEADER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
does the file have a header?
Y/N Table Edit
Default Value: Y
|
| 11 |
LI_SKIP_NUM_LINES |
Number(3,0) |
SMALLINT NOT NULL |
how many lines should we skip from the header?
|
| 12 |
LI_HEADER_ROW_NUM |
Number(3,0) |
SMALLINT NOT NULL |
what row contains the header?
|
| 13 |
LI_ERR_PROC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Should errors be processed?
Y/N Table Edit
|
| 14 |
LI_NUM_INSERTS |
Number(10,0) |
DECIMAL(10) NOT NULL |
the number of inserts during an import
|
| 15 |
LI_NUM_UPDATES |
Number(10,0) |
DECIMAL(10) NOT NULL |
the number of updates in a list import
|
| 16 |
LI_NUM_MATCHES |
Number(10,0) |
DECIMAL(10) NOT NULL |
the number of matches in a list import
|
| 17 |
LI_NUM_REJECTS |
Number(10,0) |
DECIMAL(10) NOT NULL |
the number of record rejections in a given file import run
|
| 18 |
ATTACHERRSYSFILE |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique System Error File Name
|
| 19 |
ATTACHERRUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Error file name that user sees.
|
| 20 |
RB_TRACKING_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Tracking status for list import
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Waiting
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
|
| 21 |
IS_TESTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Mode
Y/N Table Edit
Default Value: N
|
| 22 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table:
SP_SETID_NONVW
|
| 23 |
RA_LIST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Audience ID
Prompt Table:
RA_LIST_IMP_VW
|
| 24 |
RB_UPD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update upgrade flag and save
Y/N Table Edit
Default Value: Y
|
| 25 |
PRIMARY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a flag which takes yes or no values and indicates whether the row is primary.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 26 |
RB_REPL_PROFILE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag to indicate to replace profile or add
Y/N Table Edit
Default Value: N
|
| 27 |
CHARSET |
Character(40) |
VARCHAR2(40) NOT NULL |
Character Set
Prompt Table:
PSCHARSETS
|
| 28 |
RB_KEEP_STAGES |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag to indicate that we are to keep the stages tables and matching tables
Y/N Table Edit
Default Value: N
|
| 29 |
RB_REUSE_STAGES |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag to control if we are to reuse the stage tables
Y/N Table Edit
Default Value: N
|
| 30 |
RB_DELETE_STAGES |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag to control if we are to delete any old stage tables
Y/N Table Edit
|
| 31 |
SETID_CUR |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 32 |
RB_IMPT_PROC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process type for RBIMPORT
A=All Done
C=Complete Copy Stage
D=Done Stage Import
M=Multiple Import
N=Normal Data Import
S=Stage Only
W=Waiting for Stages
Default Value: N
|
| 33 |
RUNCNTLID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 34 |
FILE_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
File Number
|
| 35 |
ROW_CNT |
Number(18,0) |
DECIMAL(18) NOT NULL |
Audience Row Count
Default Value: 0
|
| 36 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Default Value: 0
|
| 37 |
APP_GROUP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Group ID
|
| 38 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
Default Value: 0
|