VAR_DATA_AVIN

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

2 VAR_DATA_SEQ Number(4,0) SMALLINT NOT NULL Variable Data Sequence Number

3 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code
Prompt Table: AV_INITIATE_VW1

4 AUD_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates whether the population is being identified for Segmentation, Reporting, or Administration.
A=Administrative
R=Reporting
S=Segmentation

5 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
2	VAR_DATA_SEQ	Number(4,0)	SMALLINT NOT NULL	Variable Data Sequence Number
3	AV_AUDIENCE	Character(10)	VARCHAR2(10) NOT NULL	Audience Code Prompt Table: AV_INITIATE_VW1
4	AUD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether the population is being identified for Segmentation, Reporting, or Administration. A=Administrative R=Reporting S=Segmentation
5	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code