View Name:ccc_srun_v
View Number:5216
Group:Script Mgr
Description:Used to display form Script Report (11307) for script responses. The names used in the fields represent their text contents
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcurr_response(scr_response)objidCurrent response scr_response internal record number 3 (UNIQUE)
responsecurr_response(scr_response)responseCurrent response name 
questioncurr_response(scr_response)questionCurrent response script action 
seqnumcurr_response(scr_response)seq_numCurrent prompt sequence number 
scorecurr_response(scr_response)scoreCurrent response score 
r_objidorig_response(scrqstn_rspns)objidOriginal response internal record number 
r_responseorig_response(scrqstn_rspns)responsePredefined response to the question 
r_actionorig_response(scrqstn_rspns)actionPredefined response sequence number 
curr_srun_objidcurr_scr_run(scr_run)objidScript run instance internal record number 
curr_srun_titlecurr_scr_run(scr_run)titleName of the script that was run 
curr_srun_scorecurr_scr_run(scr_run)scoreTotal score attained during the run of the call script 
curr_srun_stimecurr_scr_run(scr_run)start_timeStarting date and time of the call script run 
curr_srun_etimecurr_scr_run(scr_run)end_timeEnding date and time of the call script run 
first_srun_objidfirst_scr_run(scr_run)objidFirst script that was run internal record number 
first_srun_titlefirst_scr_run(scr_run)titleName of the call script that was run first 
first_srun_scorefirst_scr_run(scr_run)scoreTotal score obtained from the first script that was run 
first_srun_stimefirst_scr_run(scr_run)start_timeStarting date and time of the first script that was run 
first_srun_etimefirst_scr_run(scr_run)end_timeEnding date and time of the first script that was run 

Joins:

Join FromJoin To
curr_response(scr_response).response2scr_runcurr_scr_run(scr_run).scr_run2scr_response
curr_response(scr_response).first_scr2scr_runfirst_scr_run(scr_run).all2scr_response
curr_response(scr_response).answ2scrqstn_rspnsOUTER orig_response(scrqstn_rspns).answer2scr_response
My Recent Objects
ccc_srun_v