SMS Job Scheduling
CMxxxxJ FCxxxxJ ISxxxxJ SDxxxxJ SMxxxxJ SRxxxxJ MGxxxx SGxxxx Other

Extract Student Followup Survey Sid File

This job runs Data Express, executing a catalogued procedure to extract SIDs from the Vocational Outcomes Student Followup File, creating the Student Followup Random Sample Survey SID File.
Special Instructions This job is for SBCCE use only. <R> The Data Express catalogued procedure that is run in this process must meet the following requirements: <R> --Use the DICTIONARY file definition SR4203D (KSAM) for the input Vocational Outcomes Student Followup File. <R> --The procedure must edit the name and location of the input file (file definition SR4203D). The filename is SFUyyyyD (enter the desired academic year for the 'yyyy'). The file group is DATA. <R> --The output of the procedure must be a file type 23 (MPE ASCII). <R> --The output file created with this procedure must contain the data elements: college(3 characters), SID (9 characters), and ethnic origin (1 character) (in order as given). <R> --The procedure must be catalogued with PROCEDURE ACCESS = '@'. <R> --The procedure must be catalogued with a password. <R> When creating this procedure, be sure to document the order in which you have specified the data elements to be used for run-time selection criteria. When scheduling this job, you will NOT see the data element names for which run- time selection criteria is to be entered. Instead, you are provided with up to 10 parameters (PARM01-PARM10) where you enter your selection criteria responses in the order you would enter them if you were to run the procedure online. <R> To verify the file contents of the file created in this process, a Data Express procedure can be run using the DICTIONARY file definition SR4230S. <R> An example Data Express session for creating this procedure is attached.
Frequency On-request
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status JOBFAIL
Job Groups None
Job Dependency Prior to running this job, the Data Express procedure specified in the PROC-NAME parameter must be catalogued into the Data Express catalog in the group.account specified in the CATALOG-GRP, CATALOG-ACCT parameters.
Operator Instructions None
Estimated Run Time 15 minutes
Recovery/Restart This job is restartable.


DX1-PROC-NAME Enter the name (1-10 char.) of the catalogued procedure to be run. (Required)
DX2-CATALOG-GRP Enter the name of the group (1-8 char.) of the Data Express catalogue from which the procedure is to be run. (Required)
DX3-CATALOG-ACCT Enter the name of the account (1-8 char.) of the Data Express catalog from which the procedure is to be run. (Required)
DX4-PROC-PASS Enter the password (1-8 char.) of the procedure to be run. (Optional). NOTE: If the procedure has been catalogued with a password, it must be entered.
Enter the responses necessary to provide selection criteria for the DATAX procedure. The responses must be entered in the exact order the DATAX procedure prompts for them. Review the procedure definition in DATAX to find the selection criteria sequence. Do not enter a response for selection criteria that have values imbedded in the procedure. For a 'SELECT ALL' response enter '@' rather than leaving it blank. A blank response will be ignored rather than being interpreted as 'SELECT ALL'. NOTE: You will not see the "SELECTED BY" data element names when scheduling this job.
SR4230-FILEGRP Enter the group where the output file is to be written. Valid values are GEN or RUN.
SR4230-FILENAME Enter the filename of the output file (from 1 to 8 characters, the first character must be alpha).

Distribution: SMS P999
Created: WED, JAN 04, 2012, 07:38 AM