SCC_AFL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	SCC_AFL_EVENT_NAME	Character(60)	VARCHAR2(60) NOT NULL	Affiliation Event Name
5	SCC_AFL_EVNT_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Affiliation Event description
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	SCC_AFL_CODE	Character(10)	VARCHAR2(10) NOT NULL	Affiliations Code
8	SCC_AFL_PROCESS_BY	Character(1)	VARCHAR2(1) NOT NULL	Affiliation Process By P=Population Selection S=Person ID
9	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
10	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Currency Exist
11	EXISTS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This Flag tells if we should use Exists, or Not Exists as a predicate prefixing the SubQuery. 0=Exists 1=Not Exists
12	SCCPS_TOOL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Tool ID - the unique key for a pop select tool Prompt Table: SCCPS_TOOL_DFN
13	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
14	SCCPS_CNTXT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Context ID - the unique key that identifies the pop selection context Prompt Table: SCCPS_CNTXT_DFN
15	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
16	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
17	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp