SSR_AOPRG_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	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: SCRTY_TBL_INST
5	SSR_REF_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Australia DEST Processing Prompt Table: SSR_DEEWR_RF_VW
6	SSR_DEEWR_REFYRTO	Character(4)	VARCHAR2(4) NOT NULL	Reference Year To Prompt Table: SSR_DEEWR_RF_VW
7	SSR_DEEWR_RPT_PRD	Number(2,0)	SMALLINT NOT NULL	Reporting Period Prompt Table: SSR_DEEWR_RP_VW
8	SSR_DEEWR_RPTPRDTO	Number(2,0)	SMALLINT NOT NULL	Reporing Period To Prompt Table: SSR_DEEWR_RP_VW
9	SSR_DEEWR_PROFILE	Character(10)	VARCHAR2(10) NOT NULL	Profile Prompt Table: SSR_DEEWR_PR_VW
10	SSR_DEEWR_REFDATE	Date(10)	DATE	Reference Date
11	SSR_DEEWR_REFDTTO	Date(10)	DATE	Reference Date To
12	SSR_DEEWR_REC_APP	Number(8,0)	INTEGER NOT NULL	Total Nbr of Records
13	SSR_DEEWR_REC_OFF	Number(8,0)	INTEGER NOT NULL	Total Nbr of Records
14	SSR_DEEWR_REC_PRE	Number(8,0)	INTEGER NOT NULL	Total Nbr of Records
15	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr
16	SSR_DEEWR_WHERE	Long Character	CLOB	Where Clause SQL