SFA_EDITMSG_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	SCCPS_TOOL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Tool ID - the unique key for a pop select tool
5	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection
6	SCCPS_CNTXT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Context ID - the unique key that identifies the pop selection context
7	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
8	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
9	SCCPS_RSLTS_TABLE	Character(15)	VARCHAR2(15) NOT NULL	Results table for population selection. This is the table that is populated with the results of the selection. This table is set on the Context.
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
12	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year
13	EDIT_MSG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Edit Message Type E=Error I=Informational W=Warning
14	EDIT_MSG_CD	Character(6)	VARCHAR2(6) NOT NULL	Edit Message Code Prompt Table: FA_EDIT_MSG_TBL
15	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_VAL_TBL
16	FA_MSG_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Edit Message Action 1=No Action Taken 2=Resolved 3=Action Pending Default Value: 1
17	SFA_MSG_ACTION_TO	Character(1)	VARCHAR2(1) NOT NULL	Edit Message Action 1=No Action Taken 2=Resolved 3=Action Pending
18	SFA_PROCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Update Messages D=Delete Messages I=Insert Messages U=Update Messages Default Value: I
19	SCC_POP_UPD_ERRRPT	Character(1)	VARCHAR2(1) NOT NULL	Pop Update Error Reporting level option. A=Report All Messages E=Report Error Messages N=Do Not Report Messages
20	EDIT_PROCESS	Character(8)	VARCHAR2(8) NOT NULL	User Edit Process
21	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
22	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
23	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?
24	SCC_POP_UPD_SUCC	Number(6,0)	INTEGER NOT NULL	Pop Update Total Number of records read.
25	SCC_POP_UPD_ERR	Number(6,0)	INTEGER NOT NULL	Pop Update Total Number of records read.
26	SFA_REC_SKIP	Number(9,0)	DECIMAL(9) NOT NULL	Records skipped
27	SFA_MSG_ACTION_LBL	Character(1)	VARCHAR2(1) NOT NULL	deleting
28	COMMENTS	Long Character	CLOB	Comment