SSF_TP_ROLL_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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
6	TP_CONTRACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Third Party Contract Type C=Specific Course L=Specific Course List P=Specific Year or Period T=Specific Term
7	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
8	TO_TERM	Character(4)	VARCHAR2(4) NOT NULL	To Term
9	TP_CON_LAST_COR_DT	Date(10)	DATE	Last Date to Enter Corrections
10	TP_CON_AUTO_NUM_YN	Character(1)	VARCHAR2(1) NOT NULL	Use Auto Number for Contracts
11	SSF_TPC_STDCHG_DEF	Character(1)	VARCHAR2(1) NOT NULL	Use Cross Ref Student Charge
12	SSF_TPC_ASSIGN_STD	Character(1)	VARCHAR2(1) NOT NULL	Assign Students to Contract
13	SSF_TERM_ACT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Check Term Activation
14	SSF_TPC_COPY_REF	Character(1)	VARCHAR2(1) NOT NULL	Copy Reference Fields
15	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
16	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
17	LASTUPDDTTM	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.
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
20	SERVICE_IMPACT	Character(5)	VARCHAR2(5) NOT NULL	Service Impact
21	SSF_NBR_STU_PROC	Number(9,0)	DECIMAL(9) NOT NULL	Number of Students Processed
22	SSF_NBR_PROC	Number(9,0)	DECIMAL(9) NOT NULL	Number of Students Processed