RA_TST_AUDN_AET

(SQL Table)
Index Back

Test Audience State Record

Test Audience State Record used in application engine processing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 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

3 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

Prompt Table: RA_LIST

4 RA_STAT_DYN_IND Character(1) VARCHAR2(1) NOT NULL Fixed/Dynamic Audience indicator
D=Dynamic Audience
S=Fixed Audience
5 LIST_CURR_COUNT Number(18,0) DECIMAL(18) NOT NULL Audience current count
6 NUM_TEST_AUDIENCES Number(3,0) SMALLINT NOT NULL Enter Number of Test Audiences
7 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
8 RA_LIST_NAME Character(30) VARCHAR2(30) NOT NULL Audience / List Name
9 ALLOC_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Allocation Percent
10 LIMIT_COUNT Number(9,0) DECIMAL(9) NOT NULL Limit
11 LIMIT_COUNT_FLG Character(1) VARCHAR2(1) NOT NULL Limit Entered?
12 TEST_AUDIENCE_ID Character(15) VARCHAR2(15) NOT NULL Test Audience ID
13 TOTAL_ALLOC_SO_FAR Number(6,2) DECIMAL(5,2) NOT NULL Total Percent Allocated So Far
14 LIST_REMAINING_CT Number(18,0) DECIMAL(18) NOT NULL Remaining Count
15 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section