SELECT appno ,sysdate timestamp ,applicationdate ,sentdate ,runsent ,codedchangedate ,rescat ,feelevel ,apr ,countrybirth ,nationality ,withdrawn ,withdrawndate ,qualeng qualenglish ,qualmath qualmaths ,qualsci qualscience ,qual5 qual5point ,mainqual qualmain ,ninumber nationalinsurance ,earlieststart startdate ,nearinst nearestinst ,prefreg prefregion ,specialneeds ,status ,firmnow ,ukentrydate ,eas FROM igs_uc_istark_ints WHERE 1 = 2
SELECT APPNO
, SYSDATE TIMESTAMP
, APPLICATIONDATE
, SENTDATE
, RUNSENT
, CODEDCHANGEDATE
, RESCAT
, FEELEVEL
, APR
, COUNTRYBIRTH
, NATIONALITY
, WITHDRAWN
, WITHDRAWNDATE
, QUALENG QUALENGLISH
, QUALMATH QUALMATHS
, QUALSCI QUALSCIENCE
, QUAL5 QUAL5POINT
, MAINQUAL QUALMAIN
, NINUMBER NATIONALINSURANCE
, EARLIESTSTART STARTDATE
, NEARINST NEARESTINST
, PREFREG PREFREGION
, SPECIALNEEDS
, STATUS
, FIRMNOW
, UKENTRYDATE
, EAS
FROM IGS_UC_ISTARK_INTS
WHERE 1 = 2
|
|
|