| # |
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 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
PROGRAM_NAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Program Name
|
| 4 |
ORIG_SYSTEM |
Character(30) |
VARCHAR2(30) NOT NULL |
CDH INTERFACE TABLE FIELD - ORIG_SYSTEM
Prompt Table:
IMP_ORIG_SYS_VW
|
| 5 |
BATCH_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
CDH INTERFACE TABLE FIELD - BATCH_ID
Prompt Table:
IMP_ORIG_SYSTEM
|
| 6 |
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
|
| 7 |
SETID_CUR |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 8 |
SOURCE_IND |
Character(4) |
VARCHAR2(4) NOT NULL |
EIP Source Indicator
CRM=CRM
EBS=EBIZ Suite
EXT=External
HRMS=HCM
SCM=SCM
|
| 9 |
CREATE_DATE_FROM |
Date(10) |
DATE |
From date used in a range search.
|
| 10 |
CREATE_DATE_TO |
Date(10) |
DATE |
Date created, used in date range
|
| 11 |
LI_SCHED_GEN_DATE |
Date(10) |
DATE |
Scheduled Generation Date
|
| 12 |
LI_SCHED_GEN_TIME |
Time(15) |
TIMESTAMP |
Scheduled Generation Time
|
| 13 |
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
|
| 14 |
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
|
| 15 |
RUNCNTLID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 16 |
ROW_CNT |
Number(18,0) |
DECIMAL(18) NOT NULL |
Audience Row Count
Default Value: 0
|
| 17 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Default Value: 0
|
| 18 |
APP_GROUP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Group ID
|
| 19 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
Default Value: 0
|
| 20 |
BATCH_ID_PURGE |
Number(15,0) |
DECIMAL(15) NOT NULL |
CDH INTERFACE TABLE FIELD - BATCH_ID
Prompt Table:
IMP_PARTIES_VW
|
| 21 |
COMPANY_NAME |
Character(70) |
VARCHAR2(70) NOT NULL |
Company Name
|
| 22 |
COMPANYID_FROM |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique identifier for the From Company ID
|
| 23 |
COMPANYID_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique identifier for the From Company ID
|
| 24 |
SITE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Site Name
|
| 25 |
SITE_ID_FROM |
Character(15) |
VARCHAR2(15) NOT NULL |
SITE_ID_FROM - Unique identifier for from Site ID
|
| 26 |
SITE_ID_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
SITE_ID_FROM - Unique identifier for from Site ID
|
| 27 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 28 |
PERSON_ID_FROM |
Character(15) |
VARCHAR2(15) NOT NULL |
PERSON_ID_FROM - Unique identifier for from Person ID
|
| 29 |
PERSON_ID_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
PERSON_ID_TO - Unique identifier for To Person ID
|
| 30 |
IMP_MERGE_BATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
CDH INTERFACE TABLE FIELD - IMP_MERGE_ BATCH
|