SFA_FAUNTU_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_APPL_ID	Character(8)	VARCHAR2(8) NOT NULL	Application
3	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
4	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
7	SCCPS_POP_SEL	Character(1)	VARCHAR2(1) NOT NULL	Population Selection checkbox - used to incidate on run controls that pop selection was selected for use. Y/N Table Edit Default Value: Y
8	SCCPS_TOOL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Tool ID - the unique key for a pop select tool Prompt Table: SCCPS_TOOL_VW
9	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
10	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_VW
11	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
12	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
13	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
14	UNT_PRGRSS_FA	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Taken-Fin Aid Progress
15	SCC_POP_UPD_TOT	Number(6,0)	INTEGER NOT NULL	Pop Update Total Number of records read. I=Insert New EFFDT row ? U=Update Current EFFDT row?
16	SCC_POP_UPD_SUCC	Number(6,0)	INTEGER NOT NULL	Pop Update Total Number of records read.
17	SCC_POP_UPD_ERR	Number(6,0)	INTEGER NOT NULL	Pop Update Total Number of records read.
18	SCC_POP_UPD_SKP	Number(6,0)	INTEGER NOT NULL	Pop Update Total Number of records skipped