SF_EMPVAR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
6	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: ADDRESS_TYP_TBL
7	ADDRESS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number Default Value: 1
8	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
9	EFFDT	Date(10)	DATE	Effective Date
10	ADDR_EFFDT	Date(10)	DATE	Address Effective Date
11	SF_ADDR_EXIST_FLAG	Number(1,0)	SMALLINT NOT NULL	Address Exists Default Value: 0
12	SF_NAME_CHG_FLAG	Number(1,0)	SMALLINT NOT NULL	Track name changes within the AP Interface AE Program (SF_AP_INTFC). Default Value: 0
13	VNDR_NAME_SHRT_USR	Character(10)	VARCHAR2(10) NOT NULL	Short Vendor Name
14	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address