| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
RA_LIST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Audience ID
Default Value: NEXT
|
| 3 |
RA_LIST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Audience / List Name
|
| 4 |
RA_LIST_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Audience / List Status
010=In Design
020=Designed
030=Scheduled
040=Processing
050=Generated
060=Approved
070=Committed
080=Archived
Default Value: 010
|
| 5 |
RA_INT_EXT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Internal/External Audience indicator
E=External Audience
I=Internal Audience
Default Value: I
|
| 6 |
RA_LIST_SOURCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Audience / List Source
CGRP=Control Group
COMP=Combine Audiences
CRIT=Audience Builder
EXT=External Audience
IMP=Import
QRY=PS Query
SEG=Segment
SRCH=Saved Search
TEST=Test Audience
Default Value: CRIT
Prompt Table:
RA_LIST_SRC_VW
|
| 7 |
RA_STAT_DYN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Fixed/Dynamic Audience indicator
D=Dynamic Audience
S=Fixed Audience
Default Value: S
|
| 8 |
QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
Prompt Table:
RA_QRYDEFN_SRCH
|
| 9 |
LIST_GENERATE_DTTM |
DateTime(26) |
TIMESTAMP |
Audience - date last generated
|
| 10 |
LIST_LAST_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Audience - Last Updated Date Time
Default Value: %DateTime
|
| 11 |
LIST_CURR_COUNT |
Number(18,0) |
DECIMAL(18) NOT NULL |
Audience current count
|
| 12 |
SCHED_GEN_DATE |
Date(10) |
DATE |
Audience - scheduled generation date
|
| 13 |
SCHED_GEN_TIME |
Time(15) |
TIMESTAMP |
Audience - scheduled generation time
|
| 14 |
LIST_GEN_LOG |
Long Character |
CLOB |
Audience - Generation Log
|
| 15 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 16 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 17 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 18 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 19 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 20 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 21 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 22 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 23 |
BO_ID_OWNER |
Number(31,0) |
DECIMAL(31) NOT NULL |
Financial Account Business Object ID
|
| 24 |
BO_ROLE_TYPE_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
BO_ROLE_TYPE_ID
|
| 25 |
RA_PARENT_LIST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Marketing Audience parent id field. Parent ID is used to tie the segment to a parent segment.
Prompt Table:
RA_SEG_PAR_PRMT
|
| 26 |
RA_SEGMENT_GRP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Marketing Segment Group Key ID field
Prompt Table:
RA_SEG_GRP_A_VW
|
| 27 |
RA_SEG_PUBLISH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Segment Publish Flag -- Y/N indicating if a segment is published.
N=No
Y=Yes
Default Value: N
|
| 28 |
RA_SQL_BUILD_DTTM |
DateTime(26) |
TIMESTAMP |
SQL Build Timestamp
|
| 29 |
LIST_GEN_EXEC_PI |
Number(10,0) |
DECIMAL(10) NOT NULL |
Execute process Instance - audience
|
| 30 |
RA_LIST_STATUS_P |
Character(4) |
VARCHAR2(4) NOT NULL |
Audience / List Status
010=In Design
020=Designed
030=Scheduled
040=Processing
050=Generated
060=Approved
070=Committed
080=Archived
Default Value: 010
|
| 31 |
RA_LIST_SECURE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Audience Security Flag
N=No
Y=Yes
Default Value: N
|
| 32 |
YES_NO |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator flag -- Yes (Y) or No (N)
N=No
Y=Yes
Default Value: N
|
| 33 |
RA_QAS_ISCONNECTED |
Character(4) |
VARCHAR2(4) NOT NULL |
Remote database query type field, storing value 'Y' is query is connected query or 'N' if query is not connected query.
|
| 34 |
RA_QAS_QRYOWNER |
Character(8) |
VARCHAR2(8) NOT NULL |
Remote database query owner, values are 'public' or 'private'
|
| 35 |
RA_QAS_QUERY_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name place holder for remote database defined queries.
|