SSR_RC_SDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
4	SSR_EXTRACT_DATE	Date(10)	DATE NOT NULL	Extract Date work field for SDR extract. Default Value: %Date
5	SSR_SDR_FILE_MODE	Character(1)	VARCHAR2(1) NOT NULL	File Mode F=Final R=Review Default Value: R
6	SSR_SDR_PERM_CD	Character(4)	VARCHAR2(4) NOT NULL	Permanent Post Code Prompt Table: ADDRESS_TYP_TBL
7	SSR_SDR_TERM_CD	Character(4)	VARCHAR2(4) NOT NULL	Term Post Code Prompt Table: ADDRESS_TYP_TBL
8	SSR_SDR_QUAL_COMP	Character(1)	VARCHAR2(1) NOT NULL	Qualification Completion File Y/N Table Edit Default Value: N
9	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
10	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
11	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
12	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
13	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
14	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
15	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
16	SSR_SDR_DIRECTORY	Character(254)	VARCHAR2(254) NOT NULL	Output file directory for the New Zealand Single Data Return.