SSR_CS_RVF_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
4	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine
5	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
6	SSR_CLSRCH_RECTYPE	Character(1)	VARCHAR2(1) NOT NULL	Class Search Recording Type F=Favorites R=Recently Viewed
7	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
8	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr
9	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
10	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
13	SSR_FAVORITES	Character(1)	VARCHAR2(1) NOT NULL	Include Favorites
14	SSR_RECENTLY_VWD	Character(1)	VARCHAR2(1) NOT NULL	Include Recently Viewed
15	SSR_REQUEST_DATE	Date(10)	DATE	CART REQUEST DATE
16	SSR_DATE	Date(10)	DATE	This field is used in the application engine program to process post enrollment requisite check reports and in other processes in student records.
17	SSR_TIME	Time(15)	TIMESTAMP	This field is used by the application engine process to process post enrollment requisite check reports and in other processes in student records.
18	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
19	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
20	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
21	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time
22	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
23	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
24	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
25	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
26	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
27	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
28	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name