| FEDERAL PUBLIC SERVICE COMMISSION | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| FOR COMPETITIVE EXAMINATION (CSS) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| For post in BPS-17 under the Federal Government | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
NOTE:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(7) ";
OCIFreeStatement($rs_display);
$display_sql= "Select * from CSS_APP_LANGUAGE where CSS_APPLICANT_ID=$aid order by CSS_APPLICANT_LANGUAGE_ID desc";
//echo $display_sql;// exit;
$temp22.="Name the language in which you have any proficiency (mother tonge first) and grade your ability as (Excelent Good Fair)
(8) ";
OCIFreeStatement($rs_display);
$display_sql= "Select * from CSS_APP_EDUCATION where CSS_APPLICANT_ID=$aid order by CSS_DATE_RESULT desc";
//echo $display_sql;// exit;
$temp2.="(I) Write only academic qulification from Martriculation onward in ascending order. (II) Write result announcement date from result card/mark sheet. (III) Write three principal subjects other than compulsory.
(10) (Certificate, Diploma, Post-Graduate Diploma, on job training etc.) "; OCIFreeStatement($rs_display); $display_sql= "Select CSS_COURCE_TRANINING_ID,CSS_COURSE_NAME,CSS_INSTITUTION_NAME,CSS_INSTITUTE_LOCATION,CSS_GRADE, CSS_WEEK,CSS_FROM_DATE,CSS_TO_DATE from CSS_COURCE_TRAINING_DETAIL where CSS_APPLICANT_ID=$aid"; //echo $display_sql; $temp3.="
(11) ";
OCIFreeStatement($rs_display);
$display_sql= "select CSS_APPLICANT_ID,CSS_APP_EMPLOYMENT_IDS,CSS_POST_TITLE
,CSS_JOB_STATUS,CSS_ORGANIZATION_TYPE,CSS_BASIC_SCALE,to_char(CSS_FROM_DATE,'MM') as fm,
to_char(CSS_FROM_DATE,'DD') as fd,to_char(CSS_FROM_DATE,'YYYY') as fy,
to_char(CSS_TO_DATE,'MM') as tm,to_char(CSS_TO_DATE,'DD') as td,
to_char(CSS_TO_DATE,'YYYY') as ty from CSS_APP_EMPLOYMENT where CSS_APPLICANT_ID=$aid";
//echo $display_sql; exit;
$temp12.="(I) Start from first employment in ascending order. (II) Attach experience certificate for the post mentioned hereunder and experience of which is required for the post appled for.
(12) ";
OCIFreeStatement($rs_display);
$display_sql= "Select CSS_RESEARCH_ID,CSS_TITLE,CSS_CONFERENCE,CSS_PUBLISHER,
to_char(CSS_PUBLISHER_DATE,'MM') as ptm, to_char(CSS_PUBLISHER_DATE,'YYYY') as pty,to_char(CSS_PUBLISHER_DATE,'DD') as ptd,CSS_REQ_ADVERTISEMENT
from CSS_RESEARCH_PUB_DETAILS where CSS_APPLICANT_ID=$aid";
//echo $display_sql;
$temp4.="Mark 'R' in the last colum of the research report/paper/article/publication, if required in the advertisement.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
";
}
$temp.="";
return $temp;
}
function getUnviName($uId){
global $conn;
$role_sql ="select CSS_UNIVERSITY_ID, CSS_UNIVERSITY_NAME from CSS_board_university where CSS_UNIVERSITY_ID=$uId";
//echo $role_sql; echo "
"; $rs1 = OCIParse($conn, $role_sql); OCIExecute($rs1); OCIFetchInto($rs1, $row1, OCI_ASSOC); if($row1["CSS_UNIVERSITY_ID"]>0) { $uName =$row1["CSS_UNIVERSITY_NAME"] ; }else{ $uName = ''; } OCIFreeStatement($rs1); return $uName; } function returnfield($sql,$fieldname) { global $conn; $mysql=$sql; //cho $mysql; $rs1 = OCIParse($conn, $mysql); OCIExecute($rs1); OCIFetchInto($rs1, $row1, OCI_ASSOC); if(strlen($row1[$fieldname]) > 0) { $returnfield = $row1[$fieldname]; } OCIFreeStatement($rs1); return $returnfield; } function displayJobFormat($jobId){ global $conn; if ($jobId>0){ $jobs_sql="select CSS_JOB_ID,CSS_JOB_TITLE ,trim(to_char(CSS_JOB_POST_DATE,'YYYY')) as PYEAR from CSS_JOB_POST where CSS_JOB_ID=$jobId"; // echo $jobs_sql; $det_rs = OCIParse($conn, $jobs_sql); OCIExecute($det_rs); OCIFetchInto($det_rs,$det_row, OCI_ASSOC); if ($det_row["CSS_JOB_ID"]>0){ $CSS_JOB_TITLE="F4-".$det_row["CSS_JOB_ID"]."/".$det_row["PYEAR"]."-R"; }else{ $CSS_JOB_TITLE="No Job Found"; } return $CSS_JOB_TITLE; } } ?>
"; $rs1 = OCIParse($conn, $role_sql); OCIExecute($rs1); OCIFetchInto($rs1, $row1, OCI_ASSOC); if($row1["CSS_UNIVERSITY_ID"]>0) { $uName =$row1["CSS_UNIVERSITY_NAME"] ; }else{ $uName = ''; } OCIFreeStatement($rs1); return $uName; } function returnfield($sql,$fieldname) { global $conn; $mysql=$sql; //cho $mysql; $rs1 = OCIParse($conn, $mysql); OCIExecute($rs1); OCIFetchInto($rs1, $row1, OCI_ASSOC); if(strlen($row1[$fieldname]) > 0) { $returnfield = $row1[$fieldname]; } OCIFreeStatement($rs1); return $returnfield; } function displayJobFormat($jobId){ global $conn; if ($jobId>0){ $jobs_sql="select CSS_JOB_ID,CSS_JOB_TITLE ,trim(to_char(CSS_JOB_POST_DATE,'YYYY')) as PYEAR from CSS_JOB_POST where CSS_JOB_ID=$jobId"; // echo $jobs_sql; $det_rs = OCIParse($conn, $jobs_sql); OCIExecute($det_rs); OCIFetchInto($det_rs,$det_row, OCI_ASSOC); if ($det_row["CSS_JOB_ID"]>0){ $CSS_JOB_TITLE="F4-".$det_row["CSS_JOB_ID"]."/".$det_row["PYEAR"]."-R"; }else{ $CSS_JOB_TITLE="No Job Found"; } return $CSS_JOB_TITLE; } } ?>