SF_ORGVAR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	ORG_LOCATION	Number(3,0)	SMALLINT NOT NULL	Location Nbr
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	ORG_CONTACT	Number(4,0)	SMALLINT NOT NULL	Contact Nbr
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor Set ID
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	SF_ADDR_EXIST_FLAG	Number(1,0)	SMALLINT NOT NULL	Address Exists Default Value: 0
10	ADDRESS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
11	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
12	EFFDT	Date(10)	DATE	Effective Date
13	ADDR_EFFDT	Date(10)	DATE	Address Effective Date
14	SSF_LOC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Location Audit Action
15	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address